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?
answer
Change the print order page
question
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?
answer
Freeze Panes command
question
Which statement is NOT a recommended guideline for designing and creating an
Excel table?
answer
Leave one blank row between records in the table.
question
Which of the following characters are wildcards in Excel?
answer
*, ?
question
What should you do to ensure records in a table are unique?
answer
Use the Remove Duplicates command.
question
Which Conditional Formatting rule is best suited to apply formatting to the top 5
values in a range of values?
answer
Top 10 Items
question
Which date filter option enables you to restrict the view to only dates that occur in
March of 2018.
answer
Between
question
Which of the following is an unqualified structured reference?
answer
=[Purchase_Price]-[Down_Payment]
question
Which of the following is not an aggregate function that can be applied in a total
row?
answer
VLOOKUP
question
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?
answer
Use a formula to determine which cells to format
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy