MOAC Excel 2016 Lesson 08

How many worksheets does Excel create by default in a new workbook?

• 1

• 2

• 3

• 5

What should you do if there is a worksheet that needs to remain in the workbook but does not need to be viewed by everyone who has access to the workbook.

• Delete the worksheet

• Move the worksheet to the end of the workbook

• Hide the worksheet

• Click the undisplay command

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

• It's the easiest way to make a backup before making changes.

• It lets you reuse formats and formulas in a new sheet.

• It helps Excel learn where your data ranges are located.

• You should keep one worksheet hidden in case of an error.

Which of the following will return your worksheet to 100% with one click?

• A

• B

• C

• D

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.

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?

• On the View tab, in the Window group, click Hide.

• Select the visible area of the worksheet.

• Right-click the worksheet's tab and click Hide.

• Enter the name of the worksheet in the Hide dialog box.

Which cell would you click to freeze Rows 1-5 and Column A?

• A5

• B5

• A6

• B6

In order for you to freeze the first column of a worksheet into a frozen pane:

• The entire contents of the column must be visible.

• The first row of the column must be non-blank.

• Duplicate worksheets must also be able to have their first columns frozen.

• You can click Freeze First Column in the Freeze Panes menu.

When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?

• September

• August (2)

• Sheet2

• July

When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted?

• At the beginning of the tabs sequence

• Before the active worksheet

• After the active worksheet

• At the end of the tabs sequence