Excel Lesson 8 Quiz Questions with
Verified Answers
b. press ctrl+a to select all cells in the worksheet and then press delete -
ANSWERSWhich of the following procedures is not a way to delete one or more
worksheets from a workbook?
a. right-click a worksheet tab and click delete
b. press ctrl+a to select all cells in the worksheet and then press delete
c. click the delete down arrow on the home tab and click delete sheet
d. select a group of worksheets, right-click the group , and click delete
d. excel creates a minimized window for each hidden worksheet - ANSWERSWhich of
the following statements about hidden and unhidden worksheets is correct?
a. unhidden worksheets cannot contain formulas that refer to hidden worksheets
b.when you click find all, the find and replace dialog box will show matched contents
within hidden worksheets as well as unhidden ones
c. a hidden worksheet cannot be inadvertently deleted
d. excel creates a minimized window for each hidden worksheet
b. it lets you reuse formats and formulas in a new sheet - ANSWERSWhich of the
following statements describes a reason as to why you would need to copy a worksheet
within a worksheet?
a. it's the easiest way to make a backup before making changes
b. it lets you reuse formats and formulas in a new sheet
c. it helps excel learn where your data ranges are located
d. you should keep one worksheet hidden in case of an error
a. 200% - ANSWERSTo render twice the normal amount of worksheet displayed for any
given area of the screen, which of the following setting would you need to change the
zoom to ?
a. 200%
b. 120%
c.75%
d.50%
b. right-click the tab and select tab color - ANSWERSWhich of the following statements
describes how to change the color of a worksheet tab?
a. on the page layout tab, in the themes group , select colors
Verified Answers
b. press ctrl+a to select all cells in the worksheet and then press delete -
ANSWERSWhich of the following procedures is not a way to delete one or more
worksheets from a workbook?
a. right-click a worksheet tab and click delete
b. press ctrl+a to select all cells in the worksheet and then press delete
c. click the delete down arrow on the home tab and click delete sheet
d. select a group of worksheets, right-click the group , and click delete
d. excel creates a minimized window for each hidden worksheet - ANSWERSWhich of
the following statements about hidden and unhidden worksheets is correct?
a. unhidden worksheets cannot contain formulas that refer to hidden worksheets
b.when you click find all, the find and replace dialog box will show matched contents
within hidden worksheets as well as unhidden ones
c. a hidden worksheet cannot be inadvertently deleted
d. excel creates a minimized window for each hidden worksheet
b. it lets you reuse formats and formulas in a new sheet - ANSWERSWhich of the
following statements describes a reason as to why you would need to copy a worksheet
within a worksheet?
a. it's the easiest way to make a backup before making changes
b. it lets you reuse formats and formulas in a new sheet
c. it helps excel learn where your data ranges are located
d. you should keep one worksheet hidden in case of an error
a. 200% - ANSWERSTo render twice the normal amount of worksheet displayed for any
given area of the screen, which of the following setting would you need to change the
zoom to ?
a. 200%
b. 120%
c.75%
d.50%
b. right-click the tab and select tab color - ANSWERSWhich of the following statements
describes how to change the color of a worksheet tab?
a. on the page layout tab, in the themes group , select colors
