Correct Answer: See explanation below.

Explanation:

1.

On the “Customers” worksheet, click the Select All button OR press Ctrl+A.

2.

Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule.

3.

Click Select a Rule Type in the New Formatting Rule dialog box, then select Use a formula to determine which cells to format.

4.

In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.

5.

Click on Format.

6.

Click the Fill tab from the Format Cells dialog box.

7.

Select the desired shade background and then click OK, you are able to view how the background would look in the Preview window in the New Formatting Rule dialog box.

8.

Once satisfied, apply the formatting to the cells by clicking OK.

References: https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-202542F6-9099-5DE09C05E880

Correct Answer: See explanation below.

Explanation:

1. Click Find and Select from the Home tab then click on Go To. OR

1.

Press Ctrl+G on the keyboard.

2.

Double-click the name range you want, in this case “Oregon”.

3.

Delete the contents in the selected cells by pressing Delete on your keyboard. References:

https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

Correct Answer: See explanation below.

Explanation:

1. Select the plus icon at the bottom of the screen. OR

1. Select Insert from the Home tab, then click Insert Sheet. References:

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422d1f43f1faaf2

Correct Answer: See explanation below.

Explanation:

1. Select Format from the Home tab then choose Hide and Unhide then select Unhide. OR

1.

Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose the Unhide option in the right menu.

2.

Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last worksheet tab, then choose the Unhide option.

OR

1.

From the View tab, click Custom Views in the Workbook Views group.

2.

Click the “Summary” view which is hidden, then click Show. References:

https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/

Correct Answer: See explanation below.

Explanation:

1. On the “Summer Bookings” worksheet, click Header and Footer from the Text group situation on the

Insert tab.

2.

Click Click to add footer which would display the Header and Footer tools which gets added to the Design tab.

3.

Specify where the page number should be by selecting the Center section box.

4.

On the Design tab in the Header and Footer Elements group, click Page Number.

5.

The placeholder and[Page] will appear in the selected section, to add the total number of pages type the word of followed by the space in the Header and Footer Elements group after clicking Number of Pages, then the placeholder and[Page] of and[Pages] appear.

6.

Click anywhere outside the header or footer area to display the page numbers in Page Layout View.

7.

Once you are done working in the Page Layout View, click Normal in the Workbook Views group situated on the View tab. OR You can also click Normal on the status bar.

References:

https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7BF957C6CE29C