Spreadsheet Quiz--Year 8

Identify the spreadsheet program.

• Word

• Microtype

• Notepad

• Excel

A worksheet in EXCEL contains data in cells. A cell is the intersection of a column and a row.

• True

• False

This is formed where a column and a row cross.

• Cell

• Worksheet

• Something Else

Choose the correct statement.

• Columns are identified by letters that run horizontally (up & down) & rows are identified by numbers that run vertically.

• Rows are identified by letters that run horizontally (up & down) & columns are identified by numbers that run vertically.

These are equations that perform calculations in a worksheet.

• Cells

• Charts

• Formulas

Which formula was used in column I to add up the numbers in column I?

• SUM

• AVERAGE

• MINIMUM

• MAXIMUM

Which formula was used on row 14 to calculate the numbers 3.8, 1.9, 2.3, 4.1, 1.6, & 3.15?

• SUM

• AVERAGE

• MINIMUM

• MAXIMUM

Which formula was used on row 15 to calculate the numbers 1, 0, 0, 1, 0, & 1?

• SUM

• AVERAGE

• MINIMUM

• MAXIMUM

What type of chart is in the picture?

• Line

• Pie

• Bar

What type of chart is in the picture?

• Line

• Pie

• Bar