Excel Lesson 8 Quiz

d.you can click freeze first column in the freeze pans menu

In order for you to freeze the first column of a worksheet into a frozen pane: a. the entire contents of the column must be visible b. the first row of the column must be non-bank c. duplicate worksheets must also be able to have their first column frozen d. you can click freeze first column in the freeze pans menu

a. 200%

To 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%

c. after the active worksheet

When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted? a. at the beginning of the tabs sequence b. before the active worksheet c. after the active worksheet d. at the end of the tabs sequence

b. august (2)

When you create a copy of a worksheet named August, excel gives that worksheet which of the following names? a. September b. august (2) c. sheet 2 d. July

b. press ctrl+a to select all cells in the worksheet and then press delete

Which 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

Which 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

Which 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

b. right-click the tab and select tab color

Which 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 b. right-click the tab and select tab color c. use the fill color tool on the home tab d. you cannot change the color of a worksheet tab

d. in the insert dialog box , click worksheet and then click ok`

Which of the following steps in not a method for inserting a worksheet into a workbook? a. click the insert sheet (+) button to the right of the worksheet tabs b. on the home tab, click insert and then click insert sheet c. on the insert tab, click worksheet d. in the insert dialog box , click worksheet and then click ok

c. right-click the worksheet's tab and click hide

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook? a. on the view tab, in the window group , click hide b. select the visible area of the worksheet c. right-click the worksheet's tab and click hide d. enter the name of the worksheet in the hide dialog box