WorksheetsUnit 5: Post Test: Spreadsheets and Databases
Total questions: 25
Worksheet time: 25mins
Name
Class
Date
1.
True or False:
A cell is where data and formulas can be entered.
a)
True
b)
False
2.
A grid of rows and columns is called a
a)
cell
b)
worksheet
c)
row
d)
column
3.
Two of the most common uses of spreadsheets are to
a)
create new and classify data
b)
search for and download data
c)
store available and sort data
4.
Formatting a cell can refer to
a)
unhiding formatting and moving the data to a separate row or column
b)
highlighting formatting and changing the font size in the cells that contain the data
c)
inserting formulas in formatting and creating a header for the row in which the data appears
5.
How are cells in a spreadsheet named?
a)
based on the row and column they are in
b)
based on the header of the row they are in
c)
based on the header of the column they are in
6.
True or False:
Two of the most common uses of spreadsheets are to store available and sort data.
a)
True
b)
False
7.
Which THREE of the following are spreadsheets typically used for?
a)
budgeting
b)
scientific analysis
c)
creating presentations
d)
number formatting
8.
True or False:
Rows run left to right (horizontally) and Columns run up and down (vertically).
a)
True
b)
False
9.
Which functions should he use to determine the top and mean scores?
a)
top score is MAX function and mean score is AVERAGE function
b)
top score is MIN function and mean score is SUM function
c)
top score is AVERAGE function and mean score is MIN function
10.
A function takes values in the form of
a)
math operators, performs a calculation, and returns a cell reference
b)
keywords, performs a calculation, and returns a formula
c)
arguments, performs a calculation, and returns a result.
11.
Which formula below will return the same result as the formula =SUM(B1:B5)?
a)
=B1+B5
b)
=B1+B2+B3+B4+B5
c)
=B1,B2,B3,B4,B5
12.
True or False:
The function MAX tells you the lowest value in a set of numbers.
The function MIN tells you the highest value in a set of numbers.
a)
True
b)
False
13.
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?
a)
=ROUND(number)
b)
=ROUND(0)
c)
=ROUND(number, 0)
14.
True or False:
Indexing helps return search results faster in a database.
If the number of results is large, sorting can help display the results in ascending order.
a)
True
b)
False
15.
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?
a)
Boolean
b)
autonumber
c)
memo
d)
null
16.
True or False:
Cells in a spreadsheet are named based on the row and column they are in.
a)
True
b)
False
17.
Sarah has created a database for her online clothing store. Which TWO are the steps in the process of initially creating a database?
a)
assigning users to the database
b)
connecting the database to a Web server
c)
identifying field names in tables
d)
defining data types for field names
18.
True or False:
Queries can contain filters and are used to retrieve information from a database.
a)
True
b)
False
19.
In the table below, identify the data type that would be most suitable for the second field.
a)
binary
b)
number
c)
Boolean
d)
autonumber
20.
The function COUNT
a)
tells you the highest value in a set of numbers
b)
tells you how many numbers are present in a set of numbers or cell range
c)
tells you the lowest value in a set of numbers
21.
True or False:
Reports can be in the form of a table or a graph as well as be generated by running a query.
a)
True
b)
False
22.
These contain information related to a specific person or other entity as well as appear horizontally in a table.
a)
record
b)
report
c)
query
23.
True or False:
Formatting a cell can refer to highlighting formatting and changing the font size in the cells that contain the data.
a)
True
b)
False
24.
The function ROUND
a)
trims numbers with trailing decimal digits to display only a specified number of those decimals
b)
tells you the lowest value in a set of numbers
c)
tells you how many numbers are present in a set of numbers or cell range
25.
True or False:
The function used to determine the top score would be MAX and the function used to determine the mean would be AVERAGE.
a)
True
b)
False
100 %
