Tour Of Excel: Formulas, Formatting, Sort, Filter Quiz

20 Questions | Total Attempts: 354

SettingsSettingsSettings
Please wait...
Microsoft Quizzes & Trivia

Please answer the questions honestly and to the best of your ability. If you have no idea what the answer is, choose the "not sure" answer. Please do not leave the answer blank or "wild guess" any of the questions. Remember, the purpose of this assessment is to obtain accurate information on your skill level, and provide personally tailored training based on your scores.


Questions and Answers
  • 1. 
    By default, how many worksheets are in a workbook?
    • A. 

      2

    • B. 

      3

    • C. 

      6

    • D. 

      5

  • 2. 
    If you see this sign within a cell ####### what does it mean?
    • A. 

      You have an error with numbers and text

    • B. 

      The cell is not formatted

    • C. 

      There is not enough room in the cell to accommodate the data

    • D. 

      You have an error within the formula

  • 3. 
    What does a range of cells mean?
    • A. 

      A column

    • B. 

      A Row

    • C. 

      A Spreadsheet

    • D. 

      A number of cells

  • 4. 
    Why would you put a filter on your spreadsheet?
    • A. 

      To view the top row at all times

    • B. 

      To view specific criteria in your spreadsheet

    • C. 

      To help with formulas

    • D. 

      In order to freeze the columns

  • 5. 
    A Relative formula is....?
    • A. 

      The same formula but different cell reference

    • B. 

      Anchors the cell reference

    • C. 

      Anchors one cell

    • D. 

      A function

  • 6. 
    What must all formulas start with?
    • A. 

      +

    • B. 

      =

    • C. 

      Sum

    • D. 

      ##

  • 7. 
    What is an absolute Formula?
    • A. 

      One cell reference remains anchored when dragged down for copying

    • B. 

      The cell reference changes as it is being dragged down for copying

    • C. 

      A filter

    • D. 

      A function

  • 8. 
    What does the CountA function do?
    • A. 

      Counts Text

    • B. 

      Counts numbers

    • C. 

      Counts anything

    • D. 

      Counts blanks rows

  • 9. 
    Which one would you choose to add more commands to the ribbon?
    • A. 

      File, Options, Formulas

    • B. 

      File, advanced

    • C. 

      File add-ins

    • D. 

      File,options customise ribbon

  • 10. 
    What command would you use to put decimal places on the amounts?
    • A. 

      Format

    • B. 

      File

    • C. 

      Edit

    • D. 

      Copy

  • 11. 
    Which one is not a logical operator?
    • A. 

      +

    • B. 

      /

    • C. 

      *

    • D. 

      #

  • 12. 
    What does the colon do between the formula?
    • A. 

      A formula which can be copied to adjacent cells

    • B. 

      A function

    • C. 

      A Condition

    • D. 

      It adds both outside cells references and anything inbetween

  • 13. 
    What does the countif function do?
    • A. 

      Counts the no of cells in a range that contains numbers

    • B. 

      CountIf counts the no of cells in a given range that meets a condition

    • C. 

      Counts the blank rows

    • D. 

      Counts rows which contain numbers and blanks

  • 14. 
    What is a validation check?
    • A. 

      It is put on to eliminate mistakes

    • B. 

      It is a function

    • C. 

      A formula

    • D. 

      A condition

  • 15. 
    The developer tab helps you to create macro and forms etc.  How would you add the developer tab to the ribbon?
    • A. 

      Edit, add developer tab

    • B. 

      File, Options customise ribbon

    • C. 

      File Advanced

    • D. 

      Edit, insert

  • 16. 
    What is conditional format?
    • A. 

      A Format of colour etc applied to cells to make them stand out

    • B. 

      A list in which you can choose from various options

    • C. 

      A pattern which you need to set-up and drag to cells

    • D. 

      A built in pattern

  • 17. 
    If you entered the following number in a cell; £12032.50 but chose no decimal places - what would appear in the cell?
    • A. 

      £12,032

    • B. 

      £12,033

    • C. 

      £1232.0

    • D. 

      £12,031

  • 18. 
    What is the difference between a worksheet and a workbook?
    • A. 

      A worksheet is a workbook within a workbook

    • B. 

      A worksheet is a sheet within a workbook

    • C. 

      A worksheet has to be inserted into a workbook

    • D. 

      A worksheet is part of the cells in a workbook

  • 19. 
    What is BODMAS
    • A. 

      It is a specific order of calculations Excel follows

    • B. 

      Percentage

    • C. 

      Date

    • D. 

      Conditional Format

  • 20. 
    What is the sole purpose of an IF statement?
    • A. 

      It returns the largest value in a set

    • B. 

      If a condition is met it returns a true/false value

    • C. 

      Returns the largest number in a set of values

    • D. 

      Returns the absolute value of a number

Back to Top Back to top