Biology |

Chemistry |

Computer |

English |

Geography |

History & Civics |

Mathematics |

Physics |

Politics |

Economics |

Problem Solving Assessment(PSA) |

## Topics |
---|

1. What is an excel?

Excel is a software program capable of creating and editing spreadsheets that are saved with a .xls file extension. For example, with a spreadsheet you could create your own payroll, balance your check book, organize a large amount of data in an easy to read format, and much more. This is done by adding, subtracting, multiplying, and dividing the values in the spreadsheet to view overall totals and create graphs based on that data.

2. What is a spreadsheet?

Alternatively referred to as a worksheet, a spreadsheet is a data file made up of rows and columns that are used to sort data and allow user to manipulate and arrange data easily, commonly numerical data. What makes a spreadsheet software program most unique is its ability to calculate values using mathematical formulas and the data in the cells. A good example of how a spreadsheet may be used is creating an overview of your bank's balance.

3. How will you Perform Mathematical Calculations in excel?

In Microsoft Excel, we can enter numbers and mathematical formulas into cells. Whether we enter a number or a formula, can reference the cell when we perform mathematical calculations such as addition, subtraction, multiplication, or division. When entering a mathematical formula, precede the formula with an equal sign. Use the following to indicate the type of calculation wish to perform:

+ Addition

- Subtraction

* Multiplication

/ Division

^ Exponential

4. Write about Auto fill feature in Excel.

A very handy feature in Excel is Auto Fill, which allows y us to automatically fill cells with preset data. If we need to add the months of the year or the days of the week to our spreadsheets, we can do so using AutoFill.

It is also possible to customize the lists of data that work with Auto Fill so that easily add data that is used frequently. If regularly adds the same department names or part numbers to a spreadsheets one can add these names to the Auto Fill feature making it easier to enter them when needed.

5. What is a workbook?

A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.

The term spreadsheet is often used to refer to a workbook, when in actual fact; spreadsheet refers to the computer program, such as Excel. So, when we open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.

6. Give a short details on Microsoft excel?

Excel is an Microsoft office application. Excel is mainly used for making calculations and mathematical works. Microsoft excel is a spread sheet application in which no of sheets we can add as per our requirements. In a single sheet, it consists of rows and columns and cells. Every cell has different address. In excel sum, product, subtraction, division and many mathematical, logical functions are available with this application. Other features tables, charts, clip art etc. you can find with Excel. It basically used for payroll, accounts, mathematical and for other business purposes.

7. Define the Features of Excel.

i. Hyperlink:-We can link one file to another file or page with the use of Excel.

ii. Clip art:- In this we can add images and also audio, video clips can be added here.

iii. Charts:- With charts, we can clearly shown products evaluation to the clients.

iv. Tables:- Tables are created with different fields eg -name, age, address, roll no

so we add a table to fill these values.

v. Functions:- MATHEMATICAL: Add, subtract, div, multiply.

LOGICAL: average, sum, mod, product

vi.Images and Backgrounds:- In this we add images and backgrounds in sheet.

vii. Macros: - Macros are used for recording events for further use.

viii. Database: - We can add database from other sources with data feature.

ix. Sorting and Filter: - In sorting we can sort our data and also filter our data so

that repetitions will be removed.

x. Data Validations:- In data tools there are data validations consolidate etc are

used.

xi. Grouping:- In this we can use group, ungroup subtotal etc.

xii. Page layout:- In this themes, colors, sheets, margins, size, backgrounds, breaks,

print, titles, sheets height, width, scaling, gridness, headings, views, bring to

front of font or back alignment etc will be used.

8. What are Excel Headers and Footers?

In Microsoft Excel, headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers. They are used to add information to a spreadsheet that is being printed.

→ Excel has several preset headers and footers that you can use.

→ These standard options include the sheet name, date, time, page number, and file name.

→ There is also an option for creating your own custom headers or footers that can include text, graphics, or other spreadsheet data.

9. What is the difference between a worksheet and a workbook in Excel?

A worksheet is a single spreadsheet page and a workbook is a collection of all the worksheets in a single file. A workbook contains worksheets, in the same way that a book contains pages. A workbook consists of one or more worksheets.

For example, if you had one sheet that was a table with information and another sheet with a pie chart, you would have a workbook. On the other hand, a worksheet is one spreadsheet in Excel that you are working on.

10. What is a pie chart?

A pie chart is a type of graph shown as a circle divided up into segments of different sizes. Each segment of a pie chart is a percentage of the whole. Added together, the segments of the graph equal 100 percent. All of the segments of a pie chart are components of a larger thing. For example, one month of a household's expenses (the whole) may be broken into components, two of which would be groceries and utilities.

11. Define Range.

A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border. Normally there is only one cell in the worksheet with a black outline. This is the active cell. Whatever command is executed by Excel affects the active cell. Using the mouse, keyboard or Name Box, more than one cell can be selected to create a range, and commands executed by Excel will affect the entire range.

12. What is Auto sum and how will you use it?

The Auto SUM button, located on the Standard Toolbar in Excel 2003, is a shortcut provided for using the SUM function. When you click on the Auto SUM button, the SUM function is entered into the active cell.

To use the Auto SUM button

i. Click on the cell where you want the answer to appear.

ii. Click on the Auto SUM button.

iii. The function will auto select the closest range of data cells. The selected cells are surrounded by the marching ants.

iv. Check to make sure that the selected range for the function is correct.

v. If it is correct, press Enter on the keyboard.

vi. If it is incorrect, drag select with the mouse the correct range and then press Enter on the keyboard

13. What is a formulae?

Formulas in spreadsheet programs such as Excel are used to perform calculations.

Formulas can range from basic mathematical operations - such as addition and subtraction - to complex engineering and statistical calculations.In programs such as Excel, Open Office Calc, and Google Docs Spreadsheets, formulas begin with an equal ( = ) sign and, for the most part, they are entered into to the worksheet cell(s) where we want the results or answer to appear.

14. Define formula bar.

The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function, or data in a cell.

Examples: The active cell displayed the answer to the formula. The actual formula for the active cell was displayed in the formula bar.

15. Give some details about Date Functions in Excel

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week.: =TODAY() and =NOW()

Like all functions in Excel, entering date functions is very straightforward - just type in the function in the cell where you want the date or time to appear.

16. Give steps to activate =Now in Date function.

This function returns both the current date and time. To change the display to show just the date, follow the steps .

To change the display to show just the time:

i. Click on Format > Cells in the menus to bring up the Format Cells dialog box.

ii. Click on the Number tab.

iii. Select Time in the Category window.

iv. Pick from the available formats in the Type window.

17. How will you Change Column Widths Using the Mouse?

To change the width of column A

i. Place the mouse pointer on the line between columns A and B in the column header.

ii. The pointer will change to a double - headed arrow.

iii. Click with the left mouse button and drag the double - headed arrow to the right to widen column A or to the left to make it narrower.

iv. these same steps applies to change the width of other columns.

18. What is a Status Bar in MS-Excel?

The Status bar is at the bottom of the Excel spreadsheet and provides useful information from the Excel software or issued from a running macro. It displays, on the left side various modes like Ready Or Edit mode. It also shows status of num lock, caps lock and scroll lock keys on the keyboard on the right side. If missing it can be restored on Tools --> View. The status bar provides a convenient method of summing a range of cells (SUM not included for a single cell). SUM will not be shown unless at least one of the cells is numeric and at least a second cell has content (not ISBLANK). Some of the other indications are for keys depressed. It also do some math’s function like min, max, count, avg etc.

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Paid Users Only!

Std 9

CBSE