WorksheetsMOAC Excel 2016 Lesson 08
Total questions: 10
Worksheet time: 7mins
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
