Excel 2016 Certification Review Quiz

What is the first step to format the table on the 'Customers' worksheet so that every other row is shaded?

• Click on 'Orders' worksheet and click on the table.

• Click on 'Customers' worksheet and click on the table.

• Click on 'Sales' worksheet and click on the table.

On the 'Customers' worksheet, to sort the table by 'Country' field, which country should be listed first?

• A) Canada

• B) United States

• C) Mexico

What formatting method should be used on the 'Orders' worksheet to highlight cells in the 'Sales' column with above-average values?

• Red Fill with Dark Red Text

• Green Fill with Dark Green Text

• Blue Fill with Dark Blue Text

• Yellow Fill with Dark Yellow Text

In Task 6, which Excel function is used to find the highest 'Sales' value?

• A) MIN

• B) SUM

• C) MAX

• D) AVERAGE

On the 'Orders' worksheet, use an Excel data tool to remove all records with duplicate 'Customer ID' values. Which option should be checked?

• Order Date

• Customer ID

• Sales

• Product ID

What is the first step to modify the range of cells from A1:G1 into one cell on the 'Customers' worksheet without changing the alignment of the text?

• Highlight cells A1:G1

• Select the 'Customers' worksheet

• Click on Merge & Center

• Select Merge Across

On the 'Customers' worksheet, to adjust all column widths A:G to automatically fit the largest entry, which menu option should you select after highlighting the columns?

• Format

• Insert

• Data

• Review

To insert the header 'Confidential' on the right side of each page on the 'Customers' worksheet, you need to insert a header and then type 'Confidential'. What is the first step?

• Insert menu - Header & Footer

• Select the 'Customers' worksheet

• Type 'Confidential'

• Close the header

In cell A4 of the 'Customers' worksheet, create a hyperlink to cell A2 on the 'Orders' worksheet. What should you type in the cell reference section?

• 'A1'

• 'A2'

• 'B1'

• 'B2'

To modify the print settings for the 'Customers' worksheet to print all columns on a single page in landscape orientation, which section should you select after choosing 'Print'?

• Scaling

• Orientation

• Margins

• Layout