Spreadsheet Quiz

star goldstar goldstar gold greystar greystar greyFemaleMale
10 Questions - Developed by: Mr Murphy - The quiz is developed on: - 34.464 taken - User Rating: 2.61 of 5.0 - 79 Votes

Short quiz designed to test your knowledge of spreadsheets

  • 1
    What do we use Excel for?
    Spreadsheets
    Videos
    Databases
  • 2
    Which of the following will add two cells together?
    A1+B1
    =A1-B1
    =A1+B1
  • 3
    What should all formulas start with in Excel?
    =
    +
    If
  • 4
    What should a professional spreadsheet look like?
    No colour
    A little colour to make it easier to read
    Lots of colour
  • 5
    Which describes absolute cell referencing?
    Always reference the cell to the left
    Always reference the same cell
    Never reference the same cell
  • 6
    Which is an example of absolute cell referencing?
    =A1-B1
    =$A$1-B1
    =A1-B1
  • 7
    If we change a cell format to currency what can we do?
    Make it show the time
    Make it show colour
    Make it display money
  • 8
    Which best describe conditional cell formatting?
    The results change depending on the colour
    The colour changes depending on the results.
    The colour stays the same in cells
  • 9
    Which formula will add up lots of cells?
    =A1(G1)
    =A1: G1
    =A1++G1
  • 10
    Which data below could NOT be put into a chart?
    A,1, c,5, g, blue, monkey, seven,3
    0.3,0.4,0.5,0.5,0.2,0.9
    2,5,1,4,3,7,9,6,4,5,3,2,1