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