15. When you copy a formula
16. Excel doesn’t adjust relative cell references
17MS Excel uniquely identifies cells within a worksheet with a cell name that consists of --
A. Cell names B. Column numbers and row letters C. Column letters and row numbers D. Cell locator coordinates
18. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value B. Cell comments
C. Formatting options D. The resulting values of a formula instead of the actual formula
19. You can select a single range of cells by
A. clicking the lower right cell in a group of cells B. Pressing the Ctrl key while dragging over the desired cells C. Pressing the Shift key and an arrow key D. Dragging over the desired cells
20. When you enter a formula in a cell and the cell displays #REF!? It means –
A. Excel does not recognize text contained in the Formula B. Invalid Column
C. Contents cannot be displayed correctly as the column is narrow D. A cell reference is invalid
21. When a label is too long to fit within a MS Excel Worksheet cell, you typically must
A. Shorten the label B. Increase the column width C. Decrease the column width
D. Adjust the row height
22.Each Excel file is called a workbook because
A. It can contain text and data B. It can be modified C. It can contain many sheets including worksheets and chart sheets D. You have to work hard to create it
23. A worksheet can have a maximum of__________ number of rows
A. 256 B. 1024 C. 1048576 D. 32000
24. Which of the following formula has not been entered correctly?
A. =10+50 B. =B7*B1 C. =B7+14 D. 10+50
25. Which of the following symbol is used before a number to make it a label?
A. “(quote) B. = (equal) C. _ (underscore) D. ‘(apostrophe)
26. The default numeric data aligned within a cell of MS Excel Worksheet is –
A. Left B. Right C. Centre D. Justify
27. There are three types of data found in a spreadsheet. These are –
A. data, words, numbers B. numbers, formulas, labels C. equations, data, numbers D. words, numbers, labels
28. Each time you start the MS Excel program, by default, it displays a new blank workbook containing _________ blank worksheets.
A. Two B. Three C. Four D. Five
29. 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
30. If you press ___________, the cell accepts whatever you have typed as its contents.
A. Enter B. Ctrl+Enter C. Tab D. Insert
31. In an MS Excel worksheet the active cell is indicated by …
A. A dark wide boarder B. A dotted border C. A blinking border D. None of above
32. The Paste Special command lets you copy and paste:
A. The resulting values of a formula instead of the actual formula
B. Cell comments C.Formatting options D. All of the above
33. You can select a single range of cells by—
A. clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. pressing the Shift key and an arrow key.
C. dragging over the desired cells.
D. doing any of the above.
34. The default text data aligned within a cell of MS Excel Worksheet is –
A. Left B. Right C. Centre D. Justify
A.Excel erases the original copy of the formula
B.Excel adjusts cell references in the newly copied
formula √
C.Excel adjusts absolute cell references
D.Excel doesn’t adjust relative cell references
16. Excel doesn’t adjust relative cell references
!A!1 b.$A$1
√ c.#a#1 d.1
17MS Excel uniquely identifies cells within a worksheet with a cell name that consists of --
A. Cell names B. Column numbers and row letters C. Column letters and row numbers D. Cell locator coordinates
18. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value B. Cell comments
C. Formatting options D. The resulting values of a formula instead of the actual formula
19. You can select a single range of cells by
A. clicking the lower right cell in a group of cells B. Pressing the Ctrl key while dragging over the desired cells C. Pressing the Shift key and an arrow key D. Dragging over the desired cells
20. When you enter a formula in a cell and the cell displays #REF!? It means –
A. Excel does not recognize text contained in the Formula B. Invalid Column
C. Contents cannot be displayed correctly as the column is narrow D. A cell reference is invalid
21. When a label is too long to fit within a MS Excel Worksheet cell, you typically must
A. Shorten the label B. Increase the column width C. Decrease the column width
D. Adjust the row height
22.Each Excel file is called a workbook because
A. It can contain text and data B. It can be modified C. It can contain many sheets including worksheets and chart sheets D. You have to work hard to create it
23. A worksheet can have a maximum of__________ number of rows
A. 256 B. 1024 C. 1048576 D. 32000
24. Which of the following formula has not been entered correctly?
A. =10+50 B. =B7*B1 C. =B7+14 D. 10+50
25. Which of the following symbol is used before a number to make it a label?
A. “(quote) B. = (equal) C. _ (underscore) D. ‘(apostrophe)
26. The default numeric data aligned within a cell of MS Excel Worksheet is –
A. Left B. Right C. Centre D. Justify
27. There are three types of data found in a spreadsheet. These are –
A. data, words, numbers B. numbers, formulas, labels C. equations, data, numbers D. words, numbers, labels
28. Each time you start the MS Excel program, by default, it displays a new blank workbook containing _________ blank worksheets.
A. Two B. Three C. Four D. Five
29. 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
30. If you press ___________, the cell accepts whatever you have typed as its contents.
A. Enter B. Ctrl+Enter C. Tab D. Insert
31. In an MS Excel worksheet the active cell is indicated by …
A. A dark wide boarder B. A dotted border C. A blinking border D. None of above
32. The Paste Special command lets you copy and paste:
A. The resulting values of a formula instead of the actual formula
B. Cell comments C.Formatting options D. All of the above
33. You can select a single range of cells by—
A. clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. pressing the Shift key and an arrow key.
C. dragging over the desired cells.
D. doing any of the above.
34. The default text data aligned within a cell of MS Excel Worksheet is –
A. Left B. Right C. Centre D. Justify
Tags
Fundamental