Introduction to spreadsheets

Which of these statements are true about spreadsheets? (Tick all that apply)

• When using formulas with cell references, changing one cell can change another

• Calculations can be used on any data type in a spreadsheet

• Data can be calculated using different operations within the spreadsheet

• Charts can be produced using the data held in spreadsheets

Below is an example section of a spreadsheet. How much does one kiwi cost?

• £3

• £9.50

• £0.80

• £2.40

Which of the following is the correct cell reference for the subtotal of grapefruit?

• D5

• A5

• £1.00

• D1

Which formula is the correct formula to calculate the subtotal for bananas? 

• =B3xC3

• =B3*C3

• =C3*D3

• =C3xD3

What does this operator mean in a spreadsheet  /  ?

• Divide

• Multiply

• Add

• Subtract

Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)

• Cost

• £4.62

• Apples

• Item

Which number format has been applied to this piece of data?  

12:05:00

• Date

• Italics

• Duration

• Currency

What does this SUM function calculate?

=SUM(A1:A4)

• The total cost of items

• The total of A1, A2, A3, and A4

• The total of A1 and A4

• A data heading

The subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to alter the value shown in D2?

• A2

• B2

• £8.00

• D1