Unit 5: Post Test: Spreadsheets and Databases

True or False: A cell is where data and formulas can be entered.

• True
• False

A grid of rows and columns is called a

• cell
• worksheet
• row
• column

Two of the most common uses of spreadsheets are to

• create new and classify data
• search for and download data
• store available and sort data

Formatting a cell can refer to

• unhiding formatting and moving the data to a separate row or column
• highlighting formatting and changing the font size in the cells that contain the data
• inserting formulas in formatting and creating a header for the row in which the data appears

How are cells in a spreadsheet named?

• based on the row and column they are in
• based on the header of the row they are in
• based on the header of the column they are in

True or False: Two of the most common uses of spreadsheets are to store available and sort data.

• True
• False

Which THREE of the following are spreadsheets typically used for?

• budgeting
• scientific analysis
• creating presentations
• number formatting

True or False: Rows run left to right (horizontally) and Columns run up and down (vertically).

• True
• False

Which functions should he use to determine the top and mean scores?

• top score is MAX function and mean score is AVERAGE function
• top score is MIN function and mean score is SUM function
• top score is AVERAGE function and mean score is MIN function

A function takes values in the form of

• math operators, performs a calculation, and returns a cell reference
• keywords, performs a calculation, and returns a formula
• arguments, performs a calculation, and returns a result.