Spreadsheet Terminology

10 Questions  I  By Ledwards
Please take the quiz to rate it.

Medical Quizzes & Trivia
Understanding Spreadsheet Terminology.

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 1. 
    What is the name of the square or box in a spreadsheet called?
    • A. 

      Block

    • B. 

      Cell

    • C. 

      Brick

    • D. 

      Wall

    • E. 

      Cement


  • 2. 
    What is the name of a cell that has a thick black line around it?
    • A. 

      Formula

    • B. 

      Active Cell

    • C. 

      Addition

    • D. 

      Cell Reference

    • E. 

      Range


  • 3. 
    What is a combination of column letter and a row number?
    • A. 

      Cell Name

    • B. 

      Rows

    • C. 

      Columns

    • D. 

      A Meeting Place

    • E. 

      All of the above


  • 4. 
    What is the correct way to start a formula?
    • A. 

      +

    • B. 

      -

    • C. 

      =

    • D. 

      /

    • E. 

      (


  • 5. 
    What is the correct formulae for adding 2 cells together?
    • A. 

      A1+A2

    • B. 

      +A1/A2

    • C. 

      =A1+A2

    • D. 

      (A1+A2)

    • E. 

      A1-A2


  • 6. 
    What does autofill do?
    • A. 

      Fills up the cells with colour

    • B. 

      Adds figures in a row or column

    • C. 

      Formats the data to currency

    • D. 

      Calculates the remaining rows or columns

    • E. 

      Copies cells


  • 7. 
    How do you create an absolute cell reference?
    • A. 

      Put a fence around it

    • B. 

      Use the Format menu

    • C. 

      Use a formula

    • D. 

      Add £ signs before the cell

    • E. 

      Add $ signs to the cell reference


  • 8. 
    Put this formula in the correct order (sumA1:A5=)
    • A. 

      (=sum)A1:A5

    • B. 

      Sum=(A1:A5)

    • C. 

      (A1:A5)sum=

    • D. 

      =sum(A1:A5)

    • E. 

      =(A1:A5)sum


  • 9. 
    What is the name of the cell in column G row 20?
    • A. 

      02G0

    • B. 

      20G

    • C. 

      G20

    • D. 

      0G2

    • E. 

      CG20


  • 10. 
    Spreadsheets can be used to see different scenarios to see what might happen.  What is this called?
    • A. 

      Testing

    • B. 

      Working Out

    • C. 

      Estimating

    • D. 

      Planning

    • E. 

      Modelling


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.