Multiple Choice Questions

Which of the following is not an aggregate function that can be applied in a totalrow?
  • =[Purchase_Price]-[Down_Payment]
  • VLOOKUP
  • *, ?
  • Between
Which Conditional Formatting rule is best suited to apply formatting to the top 5values in a range of values?
  • Change the print order page
  • Between
  • Top 10 Items
  • VLOOKUP
Which of the following characters are wildcards in Excel?
  • Between
  • =[Purchase_Price]-[Down_Payment]
  • *, ?
  • VLOOKUP
What should you do to ensure records in a table are unique?
  • Use a formula to determine which cells to format
  • =[Purchase_Price]-[Down_Payment]
  • Leave one blank row between records in the table.
  • Use the Remove Duplicates command.
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?
  • Freeze Panes command
  • Leave one blank row between records in the table.
  • Use the Remove Duplicates command.
  • Use a formula to determine which cells to format
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0