Year 7 - Spreadsheet Knowledge Quiz

In a spreadsheet, what are the vertical sections labelled with letters (A, B, C, etc.) called?

• Rows

• Columns

• Cells

• Sheets

What are the horizontal sections labelled with numbers (1, 2, 3, etc.) in a spreadsheet called?

• Rows

• Columns

• Charts

• Formulas

What do we call the intersection of a row and a column in a spreadsheet?

• Chart

• Table

• Cell

• Formula

Which formula would you use to add the numbers in cells A1, A2, and A3?

• =ADD(A1+A2+A3)

• =SUM(A1+A2+A3)

• =TOTAL(A1:A3)

• =SUM(A1:A3)

Which feature would you use to change the text colour in a cell?

• Font Colour

• Bold

• Merge

• Chart

What happens when you sort a column in ascending order?

• The smallest values are listed first.

• The largest values are listed first.

• The column becomes blank.

• The column is deleted.

Which type of chart would best show changes over time?

• Bar Chart

• Pie Chart

• Line Chart

• Scatter Plot

What does the cell reference "C3" mean?

• Column 3, Row C

• Column C, Row 3

• Row 3, Column C

• Both b and c

What is the purpose of the AutoFill feature in spreadsheets?

• To copy data or formulas into adjacent cells

• To sort data automatically

• To create a chart

• To add colors to cells

In what format should you save a spreadsheet to ensure it can be opened in most spreadsheet programs?

• .doc

• .ppt

• .xlsx

• .pdf