WorksheetsReview Excel 2016 Block 3 Final Exam (2024)
Total questions: 30
Worksheet time: 15mins
An Excel ____ allows data to be summarized and charted easily.
Worksheet
workflow
document
presentation
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
outer
offset
rasterized
Combining two or more selected cells into one cell is called ____ cells.
merging
mixing
combining
spanning
The person or persons requesting the worksheet should supply their requirements in a ____ document.
blank
test issues
requirements
certified
The range of cells receiving copied content is called the ____ area.
fill
range
location
paste
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
save
format
clear
A thin red border indicates the active cell.
True
False
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.
True
False
A ____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
placement
operations
positioning
selections
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formulas in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing; =G15 is an invalid formula
The ____ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
DIVSUM
RANGEAVG
AVERAGE
MAX
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the $ to the far left with spaces between it and the first digit in the cell.
Comma style format
Accounting number format
Percent style format
Currency style format
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Normal
Page Layout
Page Break Preview
Full Screen
The most common error when entering a formula is to reference the wrong cell in the formula.
True
False
Cell references in a formula are called ____.
assumptions
comments
numbers
content
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.
Ribbon
Clipboard
Folder
File
Using the mouse to move or copy cells is called ____.
drop and drag
drag and drop
drag and copy
drag and paste
Which of the following formulas contains an absolute cell reference?
=$B4
=B$4
=$B$4
=B4
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
NOW
AND
OR
Charts can either be embedded in a worksheet or placed in a separate ____.
worksheet
dialog box
chart sheet
range
Excel includes four types of sparkline charts: line, column, win/loss, and stock.
True
False
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#NULL!
#DIV/0!
#N/A
#REF!
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
dialog box
amortization schedule
formula checker
data table
____ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protection
Range Finder
The formula checker
A data table
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The Range Finder
The formula checker
A data table
An amortization schedule
Which of the following is the maximum number of active data tables per worksheet?
5
20
50
As many as you want
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
locked
indexed
unprotected
hybrid
The date stamp shows the date a workbook, report, or other document was created or the time period it represents.
True
False
