Unit 5: Post Test: Spreadsheets and Databases

Front

A cell is where data and formulas can be entered.

Back

True

Front

A grid of rows and columns is called a

Back

worksheet

Front

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.

Back

store available and sort data

Front

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

Back

highlighting formatting and changing the font size in the cells that contain the data

Front

How are cells in a spreadsheet named? Options: 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

Back

based on the row and column they are in

Front

Two of the most common uses of spreadsheets are to store available and sort data.

Back

True

Front

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

Back

True

Front

Which functions should he use to determine the top and mean scores? Options: 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

Back

top score is MAX function and mean score is AVERAGE function

Front

A function takes values in the form of: keywords, performs a calculation, and returns a formula; math operators, performs a calculation, and returns a cell reference; or arguments, performs a calculation, and returns a result.

Back

arguments, performs a calculation, and returns a result.

Front

Which formula below will return the same result as the formula =SUM(B1:B5)? Options: =B1+B5, =B1+B2+B3+B4+B5, =B1,B2,B3,B4,B5

Back

=B1+B2+B3+B4+B5