Excel I GRADE A Q&A
16. To print more than one copy of your worksheet, which tab would you go to? -
(correct answer)File
41. To view a worksheet without headers, margins, and rulers, use Page Layout view. -
(correct answer)Normal
79. Where do you rename a workbook and adjust its save location? - (correct
answer)Save As dialog box
18. To select a single worksheet cell so you can work with it, which of the following
would you do? - (correct answer)Click the cell.
53. Which of the following is true about moving cell contents? - (correct answer)You can
move cells using the drag-and-drop feature.
36. Sam wants to count the number of cells between B1 and B20 that contain numbers
in them. Which of the following formula should he use to do so? - (correct
answer)=COUNT(B1:B20)
23. Your worksheet is too wide to fit on one portrait page. What is the best way to fix this
problem? - (correct answer)Change the page orientation to landscape.
87. Which of the following methods copies an existing worksheet within the same
workbook? - (correct answer)Press and hold CTRL and drag its sheet tab to a new
location.
35. You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means
that row 4 is _____. - (correct answer)hidden
, 74. Carol wants to unhide a workbook window she had hidden earlier. Which of these
series of clicks can she press to do so? - (correct answer)View tab > Window group >
Unhide
93. Rukha has created two custom views of a worksheet. In one view, all rows and
columns can be seen whereas in the other, specific rows and columns are hidden. What
can she do to be able to see the view that she needs to at a given point in time? -
(correct answer)Click Custom Views and double-click on the display settings she wants
to see.
10. In the formula =SUM(A6:A9), which of the following best describes A6? - (correct
answer)argument
77. Which of the following would you use to print only one page of a multipage
worksheet? - (correct answer)Backstage view
98. Which of the following will you select as X in the following series of clicks to convert
a table to range: Table > Table Tools > Design > X > Convert to Range? - (correct
answer)Tools group
15. To see a preview of how a pasted value will look, which of the following would you
use? - (correct answer)Paste List arrow
19. Which of the following functions inserts the total of a range? - (correct answer)SUM
72. To select nonadjacent cells or ranges on a worksheet, you can press and hold
_____ while selecting each one. - (correct answer)CTRL
86. A worksheet named Income (2) is most likely which of the following? - (correct
answer)a copy of another worksheet named Income
16. To print more than one copy of your worksheet, which tab would you go to? -
(correct answer)File
41. To view a worksheet without headers, margins, and rulers, use Page Layout view. -
(correct answer)Normal
79. Where do you rename a workbook and adjust its save location? - (correct
answer)Save As dialog box
18. To select a single worksheet cell so you can work with it, which of the following
would you do? - (correct answer)Click the cell.
53. Which of the following is true about moving cell contents? - (correct answer)You can
move cells using the drag-and-drop feature.
36. Sam wants to count the number of cells between B1 and B20 that contain numbers
in them. Which of the following formula should he use to do so? - (correct
answer)=COUNT(B1:B20)
23. Your worksheet is too wide to fit on one portrait page. What is the best way to fix this
problem? - (correct answer)Change the page orientation to landscape.
87. Which of the following methods copies an existing worksheet within the same
workbook? - (correct answer)Press and hold CTRL and drag its sheet tab to a new
location.
35. You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means
that row 4 is _____. - (correct answer)hidden
, 74. Carol wants to unhide a workbook window she had hidden earlier. Which of these
series of clicks can she press to do so? - (correct answer)View tab > Window group >
Unhide
93. Rukha has created two custom views of a worksheet. In one view, all rows and
columns can be seen whereas in the other, specific rows and columns are hidden. What
can she do to be able to see the view that she needs to at a given point in time? -
(correct answer)Click Custom Views and double-click on the display settings she wants
to see.
10. In the formula =SUM(A6:A9), which of the following best describes A6? - (correct
answer)argument
77. Which of the following would you use to print only one page of a multipage
worksheet? - (correct answer)Backstage view
98. Which of the following will you select as X in the following series of clicks to convert
a table to range: Table > Table Tools > Design > X > Convert to Range? - (correct
answer)Tools group
15. To see a preview of how a pasted value will look, which of the following would you
use? - (correct answer)Paste List arrow
19. Which of the following functions inserts the total of a range? - (correct answer)SUM
72. To select nonadjacent cells or ranges on a worksheet, you can press and hold
_____ while selecting each one. - (correct answer)CTRL
86. A worksheet named Income (2) is most likely which of the following? - (correct
answer)a copy of another worksheet named Income
