Post Test: Spreadsheets and Databases

How are cells in a spreadsheet named?

• based on the header of the row they are in

• based on the header of the column they are in

• based on the row and column they are in

• by right-clicking them and giving them a name

Which THREE of the following are spreadsheets typically used for?

• budgeting

• scientific analysis

• creating presentations

• number formatting

• computer programming

What do you call the element where data and formulas can be entered?

• cell

• worksheet

• row

• column

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

• analyze and store

• analyze

• store

• calculate

Which formula below will return the same result as the formula =SUM(B1:B5)?

• =B1+B5

• =B1+B2+B3+B4+B5

• =B1,B2,B3,B4,B5

• =B1,B5

• =#B1:#B5

Kawika is a math teacher. His students recently took a test. He has recorded their scores in a spreadsheet, using functions to analyze the scores. Which functions should he use to determine the top and mean scores? Kawika can use the function to find the top score and the function to find the mean score.

• MAX and AVERAGE

• MINIMUM AND AVERAGE

• SUM

• MAXIMUM

tells you how many numbers are present in a set of numbers or cell range

• COUNT

• ROUND

• MIN

• MAX

Walden is looking at his company’s regional sales numbers. He needs a quick estimate of the total sales across regions. The numbers are confusing to read because of the trailing decimals. What function can Walden use to round the numbers to the nearest whole number?

• =ROUND(number)

• =ROUND(0)

• =ROUND(number, 0)

• =ROUND(1)

• =ROUND(number, 1)

Dina created a database related to essential oils and their uses. For every oil, she wants to enter a unique code number. Which data type would be suitable for entering this data?

• Boolean

• autonumber

• BLOB

• memo

• null

In the table below, identify the data type that would be most suitable for the second field.

• binary

• Boolean

• autonumber

• text

• number