Year 7 Spreadsheet Homework 2 - Quiz.

Which symbol is used for multiplication in spreadsheets?

• /

• *

• +

• -

What function is used to calculate the total cost in the spreadsheet?

• =SUM(E3:E8)

• =MAX(E3:E8)

• =MIN(E3:E8)

• =AVERAGE(E3:E8)

Which of the following is an example of a cell reference?

• 123

• B1

• SUM

• +

What is required for a formula in a spreadsheet?

• Automatic input

• Manual input

• Predefined input

• Random input

Which of the following uses cell references in a formula?

• =5+10

• =A1+B1

• SUM

• Typing 10

What is a characteristic of a spreadsheet formula?

• Uses only numbers

• Uses cell references

• Uses only text

• Uses only symbols

What is an incorrect use of a formula?

• =A1+B1

• =F4*G9

• 5+10

• =H3-N6

What is the purpose of creating charts and graphs ?

• To make data more difficult to understand

• To provide a visual representation and make data easier to understand

• To hide data from viewers

• To increase the amount of data

What is the main purpose of a bar chart?

• To compare things that aren’t directly related

• To show a timeline of events

• To display geographical data

• To calculate averages

What is the main purpose of a scatter graph?

• To find the average of a dataset

• To look for a pattern or link between two sets of data

• To display data in a circular format

• To show data in a tabular form