Spreadsheets Quiz: Can You Pass This Test?

5 Questions | Total Attempts: 187

SettingsSettingsSettings
Spreadsheets Quiz: Can You Pass This Test? - Quiz

Below is a Spreadsheets Quiz Can You Pass This Test? Most people do not know how to create a spreadsheet but before they do that it is important to know the parts of one and how you can use it. Take up the quiz below id you think you know the basics surrounding this computer application and how high you will score.


Questions and Answers
  • 1. 
    1. What is a spreadsheet?
    • A. 

      A word processing piece of software

    • B. 

      A sheet of paper spread over a surface

    • C. 

      A piece of software which is used to work out calculations

    • D. 

      A database

  • 2. 
    In the answer box, type the number and then the word, like so: 2. spreadsheet. A 1. _ _ _ _ _ _ _ is used to do every single calculation in the spreadsheet. A formula can be as simple as adding up two numbers in different  2. _ _ _ _ _ or it can be as complex as working out a statistical result from millions of pieces of data collected over months. The reason that formulae are so important is that once you have set them up, they will track any changes that you make in the 3. _ _ _ _ _ _ _ _ _ _ _. A spreadsheet formula must start with an 4. _ _ _ _ _ _ sign (=). It is the trigger to tell the spreadsheet that a calculation is needed.
  • 3. 
    Which of the following isn’t a part of a spreadsheet?
    • A. 

      Column number

    • B. 

      Row Number

    • C. 

      Column Letter

    • D. 

      Cell Address

  • 4. 
     Which of the following isn’t a part of a spreadsheet?
    • A. 

      Decimal

    • B. 

      Fractions

    • C. 

      Booleans

    • D. 

      Functions

  • 5. 
    The placement of information within a cell at the left edge, right edge, or centered is :
    • A. 

      Alignment

    • B. 

      Indentation

    • C. 

      Placement

    • D. 

      Identification

Back to Top Back to top