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 task?

(a) Set a print area.

(b) Print titles.

(c) Adjust page breaks.

(d) Change the print page order.

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?

(a) Freeze Panes command

(b) Hide Rows command

(c) New Window command and cascade the windows

(d) Split Rows command

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

(a) Avoid naming two fields with the same name.

(b) Ensure that no blank columns separate data columns within the table.

(c) Leave one blank row between records in the table.

(d) Include field names on the first row of the table.

Which of the following characters are wildcards in Excel? (Check all that apply.)

(a) *

(a) #

(a) &

(a) $

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

(a) Do nothing; a logical reason probably exists to keep identical records.

(b) Use the Remove Duplicates command.

(c) Look at each row yourself and manually delete duplicate records.

(d) Filter the data to show only unique records.

Which Conditional Formatting rule is best suited to highlight sales value greater than $5,000?

(a) Equals

(b) Between

(c) Greater Than

(d) Less Than

Which date filter option enables you to restrict the view to only dates between April 1, 2021, and April 30, 2021?

(a) Equals

(a) Before

(a) After

(a) Between

Which of the following is a fully qualified structured reference?

(a) =[Purchase_Price]-[Down_Payment]

(b) =Sales[@Purchase_Price]-Sales[@Down_Payment]

(c) =Purchase_Price-Down_Payment

(d) =[Sales]Purchase_Price-[Sales]Down_Payment

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

(a) MAX

(b) AVERAGE

(c) COUNT

(d) VLOOKUP

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?

(a) Format all cells based on their values.

(b) Format only cells that contain.

(c) Use a formula to determine which cells to format.

(d) Format only values that are above or below average.