Microsoft Excel Basic Skills Test! Trivia Knowledge Quiz

10 Questions | Total Attempts: 125

SettingsSettingsSettings
Please wait...
Microsoft Excel Basic Skills Test! Trivia Knowledge Quiz

There are a lot of people who cannot pass a Microsoft excel basic skills test. This is because Excel is seen as the most complex package that Microsoft has to offer. Do you know how to use every feature on excel to get the fastest and perfect data sheets? The question trivia quiz below is perfectly designed for those who need help with the application basics. Do give it a shot and see what you might learn.


Questions and Answers
  • 1. 
    What function in Excel do you use to select a group of cells to color as in the example below so that if you change a cell the format will automatically update?
    • A. 

      Conditional Formatting

    • B. 

      Sum

    • C. 

      @Choose

    • D. 

      Paste as values

  • 2. 
    How are the following column values sorted?
    • A. 

      1) Imps Contracted: Largest to Smallest 2) Imps Delivered: Smallest to Largest

    • B. 

      1) Imps Contracted: Largest to Smallest 2) Imps Delivered: Largest to Smallest

    • C. 

      1) Imps Delivered: Largest to smallest 2) Imps Contracted: Largest to smallest

    • D. 

      1) Imps Delivered: Largest to smallest 2) Imps Contracted: Smallest to Largest

  • 3. 
    How can you insert a line or a column?
    • A. 

      Right Click on the line Line/Column and select insert

    • B. 

      On the home tab, click "insert" and select insert row/column

    • C. 

      With your mouse, highlight the row/column and type Control+I

  • 4. 
    Which of the following formulas should you NOT use in cell A7?
    • A. 

      =SUM(A2:A6)

    • B. 

      =A2+A3+A4+A5+A6

    • C. 

      =1+2+3+4+5

    • D. 

      =SUM($A$2:$A$6)

  • 5. 
    If the formula is cell A5 is "=SUM(A2:A4)" and you copy it to cell A6 without changing anything else, what will the result of the formula in A6 be?
    • A. 

      11

    • B. 

      12

    • C. 

      6

    • D. 

      10

  • 6. 
    What option is used to unify cells for proper headers (as shown in the image below)?
    • A. 

      Wrap Text

    • B. 

      Format as table

    • C. 

      Merge cells

    • D. 

      Shrink-to-fit

  • 7. 
    If you want to make column A look just like column B which of the following should you select when pasting Column B to Column A?
    • A. 

      Formulas

    • B. 

      Values

    • C. 

      Formats

    • D. 

      Comments

    • E. 

      Validation

  • 8. 
    The table below is badly formatted.   Which of the following should you use to fix the problem?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

    • E. 

      5

  • 9. 
    What does the formula =IF(A1=2,1,A4*A3-A2) equal to?
    • A. 

      10

    • B. 

      21

    • C. 

      20

    • D. 

      12

  • 10. 
    To make cell A1 look the same as B1, which of the following will NOT work?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      Highlighting A1 and pressing "Control+1"

    • E. 

      Right clicking on A1

Back to Top Back to top