1.Which of the following procedures is not a way to delete a worksheet from a workbook?

a.Right-click a worksheet tab and click Delete.

b.Press Ctrl + A to select all cells in the worksheet and press Delete.

c.Click the down-arrow next to Delete on the Home menu tab and click Delete Sheet.

d.Create a group of worksheets, right-click the group, and click Delete.

2.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.

3.Why would you need to copy a worksheet within a workbook?

a.Its the easiest way to make a backup before making changes.

b.It lets you repeat formats and working formulas into 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.

4.To render twice the normal amount of worksheet for any given area of the screen, what would you change the Zoom to?

a.200%

b.120%

c.75%

d.50%

5.How do you change the color of a worksheet tab?

a.On the PAGE LAYOUT tab, select Colors in the Themes group.

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.

6.Which of the following steps is required for hiding a worksheet window?

a.Click Hide on the View menu tab.

b.Select the visible area of the worksheet.

c.Right-click the worksheets tab and click Hide.

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

7.Which of the following steps is not part of inserting a worksheet into a workbook?

a.Right-click the tab to the right of the spot where you want to insert a worksheet, and then click Insert.

b.Click Insert on the Home menu tab, and then click Insert Sheet.

c.Click Worksheet on the Insert menu tab.

d.Click Worksheet in the Insert dialog box, and then click OK.

8.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-blank.

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

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

9.You just created a copy of a worksheet named August. What name does Excel gives it?

a.September

b.August (2)

c.Sheet2

d.July

10.When you click the + button (New Sheet) 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