Beginners Excel Test

10 Questions | Total Attempts: 155

Settings
Please wait...
Beginners Excel Test

The simplest thing we can use Microsoft excel for is the listing of things and data. However, simple arithmetic also falls into this category. The beginners excel test below has more insight on the subject.


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.  True or False?   
    • A. 

      True

    • B. 

      False

  • 3. 
    Pressing ENTER on a cell will move the typing selection down a row.  True or false?
    • 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. 
    If you press____, the cell accepts your typing as its contents, but the focus stays in the cell. Select as many as you'd like:
    • A. 

      ENTER

    • B. 

      CTRL + ENTER

    • C. 

      TAB

    • D. 

      INSERT

  • 9. 
    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

  • 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