EXCEL Chapter 8 Test

_____a worksheet does not make it confidential because all worksheets are easy to unhide. ____ simply gets stuff out of your way, just as filing something away in a desk drawer keeps it out of sight.

• Hide

• Unhide

• Pane

• Freeze

Match the following

• Looks for something specific

• Freeze

• Insert or Corrects

• Replace Command

• Divide the window

• Pane

• A portion of the screen stays still

• Find Command

• Magnify

• Zoom

Which of the following statements describes how to change the color of a worksheet tab?

• On the Page Layout tab, in the Themes group, select Colors.

•  Right-click the tab and select Tab Color.

• Use the Fill Color tool on the Home tab.

• You cannot change the color of a worksheet tab.

Match the following shortcuts

Ctrl + ____

• find

• A

• select all

• P

• cut

• F

• bold

• B

• print

• X

Which of the following statements about hidden and unhidden worksheets is correct?

• Unhidden worksheets cannot contain formulas that refer to hidden worksheets.

• When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.

• A hidden worksheet cannot be inadvertently deleted

• Excel creates a minimized window for each hidden worksheet

Can you name multiple worksheets by the same name?

• F

• T

Which of the following procedures is not a way to delete one or more worksheets from a workbook?

• Right-click a worksheet tab and click Delete.

• Press Ctrl+A to select all cells in the worksheet and then press Delete

•  Click the Delete drop-down arrow on the Home tab and click Delete Sheet.

• Select a group of worksheets, right-click the group, and click Delete

Match the following shortcuts

Ctrl + ____

• Create a new worksheet

• N

• Paste

• I

• Italic

• V

• Copy

• S

• Save

• C

You can adjust or ____ this display magnification at any time to make contents easier for you to read, or to fit more contents onto the screen at one time, without impacting the size of the worksheet when you print it.

• Hide

• Unhide

• Zoom

• Pane

Which of the following steps is not a method for inserting a worksheet into a workbook?

• Click the New sheet (+) button to the right of the worksheet tabs

• On the Home tab, click Insert and then click Insert Sheet.

• On the Insert tab, click Worksheet

• . Right-click a worksheet tab and click Insert, then click Worksheet and click OK.