Microsoft Excel Test For Beginners! Quiz

10 Questions | Total Attempts: 346

SettingsSettingsSettings
Please wait...
Microsoft Excel Test For Beginners! Quiz

.


Questions and Answers
  • 1. 
    Which of the choices demonstrates the correct way to reference a range of values?
    • A. 

      A1-A5

    • B. 

      A1A5

    • C. 

      A1:A5

    • D. 

      A1,A5

  • 2. 
    CTRL + V is the shortcut combination for PASTE.     
    • A. 

      True

    • B. 

      False

  • 3. 
    Pressing ENTER on a cell will move the typing selection down a row.  
    • A. 

      True

    • B. 

      False

  • 4. 
    Every formula in Excel starts with _____
    • A. 

      Numbers

    • B. 

      An equal sign

    • C. 

      A dash

    • D. 

      Letters

  • 5. 
    Which part of this math problem will Excel calculate first: =30/5*3?
    • A. 

      Divide 30/5

    • B. 

      Multiply 5*3

  • 6. 
    If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell references in the formula (=C1+C2) instead of just writing the formula like this: =93+14?
    • A. 

      The formula is more professional looking

    • B. 

      The formula will be more accurate

    • C. 

      The formula result will automatically update when cell values change

  • 7. 
    Which button allows you to copy cell formats from one cell to another?
    • A. 

      Enter

    • B. 

      Autofit

    • C. 

      Format painter

    • D. 

      Esc

  • 8. 
    To select a column the easiest method is to:
    • A. 

      Double-click any cell in the column

    • B. 

      Drag from the top cell in the last cell in the column

    • C. 

      Click the column heading

    • D. 

      Click the column label

  • 9. 
    If you press____, the cell accepts your typing as its contents, but the focus stays in the cell.
    • A. 

      ENTER

    • B. 

      CTRL + ENTER

    • C. 

      TAB

    • D. 

      INSERT

  • 10. 
    To add multiple cells together, your formula would be as follows:
    • A. 

      Cell 1 + Cell 2 + Cell 3

    • B. 

      A1:A3

    • C. 

      SUM(A1:A3)

    • D. 

      A1,A2,A3

Back to Top Back to top