Solved Exercise
Unit-9 Electronic Spreadsheet
Chapter-1 Learning to use MS Excel -Part-I
A. Multiple Choice Questions. Tick the correct answer.
1. What is the extension for an MS Excel 2007 file?
a. .doc b. txt c. .xlsx d. .ess
Answer: .xlsx
2. How many rows are there in a single Excel 2007 worksheet?
a. 10000 b. 1048576 c. 85631 d. none of the above
Answer: 1048576
3. How many columns are there in an Excel sheet?
a. 15000 b. 16384 c. 20000 d. none of the above
Answer: 16384
4. What is the shortcut key combination to save the changes made to the worksheet you are currently working in?
a. Ctrl+A b. Alt+S c. Ctrl+S d. Ctrl+W
Answer: Ctrl+S
5. What is the shortcut key for editing the current cell you have selected?
a. F5 b. F2 c. F9 d. F12
Answer: F2
6. How many worksheets by default are there in an Excel 2007 workbook?
a. One b. Two c. Three d. Four
Answer: Three
7. What shortcut key combination will help you to select the entire worksheet?
a. Ctrl+S b. Ctrl+A c. Ctrl+F1 d. Ctrl+O
Answer: Ctrl+A
8. In Excel, the default workbook opens with
a. Three worksheets b. four worksheet c. Five worksheets d. Six worksheets
Answer: Three worksheets
9. In Excel, this is created by the intersection of a row and a column.
a. Area b. Pane c. Cell d. Chart
Answer: Cell
10. What combination of keys is required to come back to the top of the worksheet?
a. pageUP b. Alt+PageUp c. Ctrl+Home d. Ctrl+left arrow
Answer: Ctrl+Home
11. What key is used to select multiple ranges of cells?
a. Shift key b. Ctrl key c. Alt key d. Tab key
Answer: Shift key
12. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
a. B1-G10 b. B1.G10 c. B1;G10 d. B1:G10
Answer: B1:G10
13. The advantage of using a spreadsheet is:
a. calculations can be done automatically b. changing data, automatically updates calculations c. graphical representation becomes easy d. all of the above
Answer: All of the above
14. To select a column the easiest method is to ......
a. Double click any cell in the column b. Drag from the top cell in the column to the last cell in the column c. Click the column heading d. click middle of the column
Answer: click the column heading
15. The cell labeled as F15 refers to
a. row F column 15 b. column F row 15 c. function available in cells d. function key F15
Answer: column F row 15
16. Which of the following displays the contents of the active cell?
a. cell pointer b. formula bar c. menu bar d. name box
Answer: Name box
17. The drag and drop method of copying or moving
a. can be used between worksheets but not workbooks
b. can be used between workbooks but not worksheets
c. a and b d. none
Answer: can be used between worksheets but not workbooks
18. ______ symbol is used to enter a formula or a function in a cell.
a. & (ampersand) b. = (equal sign) c. space d. ' (single quote sign)
Answer: =(equal sign)
19. What's a quick way to fill a series of numbers in a column or row?
a. enter the starting two numbers of the series select both cells drag the autofill handle over the range of cells you want.
b. select the range you want, including both cells, point to fill on the edit menu, and then click down or right.
c. copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the paste button image button, and then click paste special.
d. none of these
Answer: enter the starting two numbers of the series select both cells drag the autofill handle over the range of cells you want.
20. A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
a. go to file-save as- save as type -excel 4.0 work sheet
b. right click on the worksheet tab and select Delete
c. right click on the worksheet and select Insert-Entire column
d. All of the above
Answer: right click on the worksheet tab and select Delete
21. The formula that will add the value of cell D4 to the value of c2 and then multiply by the value in B2 is ____.
a. (D4+C2)*B2 b. D4+C2*B2 c. =(D4+C2)*b2 d. =(B2*(D4+C2)
Answer: =(D4+C2)*b2
22. Cell A4 =2 and A5=4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are_______.
a. 8,16,32 b. 2,4,2 c. 2,2,2 d. 6,8,10
Answer: 6,8,10
23. Which of these cell addresses is an example of absolute referencing?
a. $C$3 b. $C3 c. C$3 d. C$3$
Answer: $C$3
24. Which of these cell addresses is an example of mixed referencing?
a. $A$12 b. $D12 c. $F$15 d. none of these
Answer: $D12
II. Fill in the blanks to complete the following sentences:
1. The ______ box displays the address of the active cell at any given time.
Answer: Name
2. The default number of worksheets in a workbook are ______.
Answer: 3
3. In an Excel worksheet there are _______ columns and _______rows.
Answer: 16384, 1048576
4. Three types of data that can be entered in a cell are _____, _______ and _____.
Answer: number, text, alphanumeric
5. ________ is the extension of excel files.
Answer: .xlsx
6. _______ is the shortcut key to go to next worksheet.
Answer: Ctrl+PageUp
7. The _______ option in the office button menu is used to open an existing workbook.
Answer: Open
8. To navigate from one sheet to another _____shortcut key is used.
Answer: Ctrl+PageUp
9. The ______ in a formula are automatically updated when it is copied to other cells in a spreadsheet.
Answer: F2 key
10. The _____ cell references in a formula always refer to the same cell or cell range in a formula.
Answer: Absolute
11. The ______ symbol is used to designate an absolute cell reference.
Answer: $
12. A ____ is a pre-defined formula that helps perform common mathematical functions.
Answer: Function
13. The _______ function finds maximum value in a range passed to it as an argument.
Answer: MAX
14. Text are_______ aligned and numbers are _____ aligned in excel.
Answer: Left, right
15. To show a number in scientific notation we need to select scientific category in the number tab of the ______ dialog box.
Answer: format cells
C. State whether the statement given below are true or false.
1. The black border around the selected cell is called the cell pointer.
Answer: T
2. The shift key is used to select multiple ranges of cells.
Answer: T
3. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is B1:G10.
Answer: T
4. To select a column the easiest method is to click the column heading.
Answer: T
5. The cell labeled F5 refers to row F column 5.
Answer: F
6. The formula bar displays the contents of the active cell.
Answer: T
7. A worksheet can be moved to another workbook.
Answer: T
8. There are three worksheets in a workbook by default.
Answer: T
9. A range of cells in a worksheet cannot be linked to another worksheet.
Answer: T
10. Ctrl+P keyboard shortcut to print a worksheet.
Answer: T
11. We can print selective cells of a worksheet.
Answer: T
Some Other Links:
No comments:
Post a Comment