Subject :- ICT Std :- VII
Extra Question .
Lesson :- 4. More Functions in MS Excel
_____________________________________________________
Fill in the blanks with given hints :
1. If a cell has D8 cell address, D refers to column number.
2. MIN( ) function is used to find minimum value.
3. Σ is the sign of sum button.
4. Referencing are of three types; Absolute, Relative and Mixed.
5. By default, a workbook contains three worksheets.
6. The formula bar shows the data and formulas entered in an active cell.
7. A worksheet becomes active by clicking on the sheet tab.
8. Name box s present above the column headings.
9. The tab scrolling buttons to the left of sheets tabs let you move through the worksheets quickly
Write True or False :
1. A formula starts with @ sign. False
2. A formula cannot be copied from one workbook to another. True
3. A formula can be set only for column values and not for row values. False
4. Microsoft Excel is the most suited program for documentation. False
5. A workbook can contain any number of worksheets according to user’s need. True
6. The Row headings are denoted by the letters, A to Z and AA to ZZ. False
7. Status bar shows the name of the currently selected command or current activity. True
8. Data cannot be entered in an active cell. False
9. Arrow buttons present on the worksheet tab allow the user to switch between worksheets.True
--------------------------------------------------------------------------------------------------------
Match the following :
1. SUM( ) ————– Function
2. Use Formula ——- For calculations
3. Ctrl + C ————- Copy a cell
4. Ctrl + Z ————- To undo last action
5. A1 : D36 ———— Range
--------------------------------------------------------------------------------------------------------
Answer the following :
1. What is a formula ?
Answer - A formula is an equation that can perform calculations, return information, manipulate the contents of other cells, test conditions and more. It consists of cell address, number, mathematical operations and letters.
2. What is a function ?
Answer - A function is a pre-defined formula that performs calculations by using specific values, called arguments, in a particular order or structure. It can do simple as well as complex calculations.
3. What is a cell?
Answer - A cell is an intersection of a column and row in a worksheet. Each cell is denoted by a cell address.
--------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment