Excel Chapter 8 Knowledge Assessment

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Name *

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

1 point

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.

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

1 point

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.

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

1 point

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.

To zoom out of the worksheet and display twice the amount of worksheet data for anygiven area of the screen, which of the following Zoom settings should you choose? *

1 point

200%

120%

75%

50%

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

1 point

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-sheetworkbook? *

1 point

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 of the following steps is not a method for inserting a worksheet into a workbook? *

1 point

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.

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

1 point

All data in 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 an existing worksheet named August, Excel gives thatworksheet which of the following names? *

1 point

September

August (2)

Sheet2

July

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

1 point

At the beginning of the tabs sequence

Before the active worksheet

After the active worksheet

At the end of the tabs sequence

Submit

Clear form

Never submit passwords through Google Forms.

This form was created inside of Grace School District #148.

Does this form look suspicious? Report

Forms