Spreadsheet and Data Analysis Flashcard

Front

What is the purpose of using formulas in a spreadsheet?

Back

To perform calculations on data

Front

Which function would you use to calculate the "mean" of a range of numbers? Options: SUM, COUNT, AVERAGE

Back

AVERAGE

Front

What type of data might students record in a sales spreadsheet?

Back

Number of products

Front

A spreadsheet can be used to calculate the __________ of numbers by using the appropriate formula

Back

total

Front

The function used to find the __________ value in a data set is called MIN.

Back

lowest

Front

The function used to find the __________ value in a data set is called MAX.

Back

highest

Front

To save their work in Excel, students need to use the "__________ as" option.

Back

save

Front

A graph can be created in Excel to visually display the __________ of students in a class.

Back

number

Front

Formula

Back

A calculation or instruction in a spreadsheet

Front

Spreadsheet

Back

A grid used to organize data and perform calculations