Multiple Choice, Chapter 4

You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options EXCEPT which one to accomplish this?

You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?

Which statement is NOT a recommended guideline for designing and creating an Excel table?

Which of the following characters are wildcards in Excel?

What should you do to ensure records in a table are unique?

Which Conditional Formatting rule is best suited to apply formatting to the top 5 values in a range of values?

Which date filter option enables you to restrict the view to only dates that occur in March of 2018.

Which of the following is an unqualified structured reference?

Which of the following is not an aggregate function that can be applied in a total row?

If you would like to set a conditional formatting rule based on the function =AND(G6="Finance", H7<7000) which formatting rule type is needed?