10 Questions  I  By Ledwards

Changes are done, please start the quiz.

 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
 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
 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
Take Another Quiz