NEW
Font size
S
M
L
XL
WorksheetsChapter 11 Review
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
Which formula correctly calculates the total of cells B2, B3, B4, and B5?
a)
=SUM(B2-B5)
b)
=(B2+B5)SUM
c)
SUM=(B2:B5)
d)
=SUM(B2:B5)
2.
Where a can a list of available functions be found in Microsoft Excel?
a)
Function library
b)
Help
c)
Equations
d)
Function look up
3.
Which of the following is true about equations and functions?
a)
None can calculate cell ranges.
b)
They all start with an equals sign.
c)
None can be updated once created.
d)
They all require absolute cell addresses.
4.
Choose the logical function.
a)
SUM
b)
MIN
c)
OR
d)
MAX
5.
Choose the correct function for displaying the current date.
a)
A. =TODAYmmddyyyy
b)
=”TODAY”
c)
=TODAY()
d)
=TODAY
6.
Which function calculates the minimum value of cells G1 through G14?
a)
=MIN(G1:G14)
b)
A. =MINIMUM(G1:G14)
c)
=MIN(G1,G14)
d)
=MINIMUM(G1,G14)
7.
If a cell is formatted as a percentage, how will a data entry of .77 appear?
a)
.77
b)
77%
c)
7700%
d)
.77%
8.
You are creating a spreadsheet that contains tech support call goals. Column A lists the number of tech support calls. Based on the value in column A, column B indicates if the tech support call goal of 500 calls was met. Choose the formula that will calculate if the goal was achieved.
a)
=IF(A1>=500, “Yes”,”No”)
b)
=IF(A1>=500,[Yes],[No])
c)
=IF(A1>=500,(Yes),(No))
d)
=IF[A1>=500,Yes,No]
9.
What chart would be used to demonstrate the percentage of technicians who have hardware and software certifications?
a)
Bar chart
b)
Pie chart
c)
Line chart
d)
Table
10.
A __________________ file contains data with commas to denote the beginning and end of each datum in a row.
a)
Comma-included (CI)
b)
Comma-separated values(CSV)
c)
Comma-organized table (COT)
d)
Comma-established values (CEV)
11.
When merging cells in Excel, how are the merged cells automatically aligned?
a)
Justified
b)
Center
c)
Right
d)
Left
12.
Where are equations entered in Microsoft Excel?
a)
Equation station
b)
Function input
c)
Formula bar
d)
Browser bar
13.
Logical functions are similar to which computer programming data type?
a)
Integers
b)
Floating point numbers
c)
Date
d)
Boolean
14.
What is the best method of predicting a specific outcome in Excel?
a)
Selecting the PREDICT function
b)
Copying, pasting, and editing the formula
c)
Performing a what-if analysis
d)
Selecting the ESTIMATE function.
15.
If a cell that contains an absolute cell address is moved, what happens to the formula?
a)
The cell reference will be updated based on where the cell is moved.
b)
The formula will be deleted.
c)
Nothing, the formula remains unaltered.
d)
A cell reference error will appear.
16.
Changes the appearance of a cell’s value bases on parameters set by the user.
a)
pie chart
b)
embedded
c)
Conditional formatting
d)
Logical function
17.
Needed for PMT function; how long it will take to repay a loan.
a)
Comma-separated values (CSV) file
b)
Term
c)
Function
d)
AVERAGE
18.
Best for comparing individual values.
a)
Bar chart
b)
Pie chart
c)
MIN
d)
embedded
19.
Pictures that display numerical data in a graphical format.
a)
Function
b)
Argument
c)
Linking
d)
Chart
20.
Used to share spreadsheet data with other software that cannot read the native file format of the spreadsheet software.
a)
Function
b)
Arguement
c)
Term
d)
Comma-separated values (CSV)
21.
Used to display trends over time.
a)
Line chart
b)
Bar chart
c)
Conditional formatting
d)
Term
22.
Displays the relative size of each fractional part of a whole.
a)
Bar chart
b)
conditional formatting
c)
PIE chart
d)
AVERAGE
23.
Form of copying and pasting in which a connection is maintained between the copy and the original.
a)
Embedding
b)
Linking
c)
Function
d)
Conditional formatting
24.
Calculates the average value of the selected arguments.
a)
AVERAGE
b)
MIN
c)
Conditional formatting
d)
Argument
25.
Form of copying and pasting in which the source document is copied into the destination document.
a)
Term
b)
Embedding
c)
Linking
d)
Bar graph
26.
Needed for PMT function amount of a loan.
a)
Principal
b)
Embedding
c)
Linking
d)
Chart
27.
Can be used to add an element of decision making to the spreadsheet.
a)
AVERAGE
b)
Line chart
c)
MIN
d)
Logical function
28.
Value a function needs for the calculation.
a)
Arguement
b)
Imbedding
c)
MIN
d)
Logical function
29.
Preprogrammed formula in spreadsheet software.
a)
line chart
b)
AVERAGE
c)
function
d)
conditional formatting
30.
Returns the lowest value of a range.
a)
MIN
b)
AVERAGE
c)
Imbedding
d)
Principal
Reset
