Microsoft Office Final Exam
In a formula, which symbol specifies fixed columns or rows?
$
You can use a named range instead of a cell address in a formula (T or F)
true
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging (T or F)
true
The Excel operator for division is _____
/
Possible paper orientations for printing a worksheet are landscape and _____
portrait
The Excel function that returns the arithmetic mean of its arguments
AVERAGE
The default Accounting number format adds dollar signs and _____ decimal places to the data
Two
A named range may begin a letter or number (T or F)
false
According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last (T or F)
false
An Excel workbook has the file extension .xml (T or F)
false
An absolute cell reference changes the cell references when the formula is copied to a new location (T or F)
false
Arguments are Excel's built-in formulas (T or F)
false
Formatting can change the actual data of a cell
false
In an electronic spreadsheet, you need to manually recalculate when you change the entries (T or F)
false
The COUNT function in Excel returns the number of all cells in a range that contain any type of data (T or F)
false
The Format Painter button copies both the cell's content and formatting
false
The Increase Decimal button automatically adds dollar signs and two decimal places to your data
false
Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5) (T or F)
false
When you insert a new column, the contents of the worksheet shift to the left from the point of the new column
false
You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells
false
To continue a sequence in adjacent cells, such as months of the year, use the _____ feature of Excel
fill handle
The _____ size is the physical size of the text
font
The name for a collection of characters (letters, numerals,symbols, and punctuation marks) with a similar, specific design
font
The _____ of a cell determines how the labels and values look
format
The COUNTA function is used to count the number of cells in a range that contain which type of data?
formulas, text and numbers
You can edit the contents of the active cell by _______
just starting to type
What type of cell reference is D$23?
mixed
______ operators perform mathematical calculations such as adding and subtracting
Arithmetic
A dark rectangle that outlines the cell in which you are working
cell pointer
Work done in a virtual environmment
cloud computing
You can use the ______ slider on the status bar to enlarge your view of specific areas of your worksheet
Zoom
Which key to you press to copy while dragging and dropping selected cells?
[Ctrl]
To quickly jump to the last cell in a worksheet press ______
[Ctrl][End]
To quickly jump to the first cell in a worksheet press _____
[Ctrl][Home]
Which key do you press to convert a relative cell reference to an absolute cell reference?
[F4]
The Excel operator for exponent is _____
^
Which type of cell reference preserves the exact cell address in a formula?
absolute
You can change the ____ of labels and values in cells to be left, right, or center
alignment
Excel templates include which of these categories?
all of the above
You can use the ______ key(s) on the keyboard to navigate a worksheet
arrow
Cells and ranges in a worksheet can be formatted ______.
before and after data is entered
Identified by the coordinates of the intersecting column and row
cell address
###### in a cell means that the ________.
column is too narrow to display the value completely
The formatting due to _____ formatting is automatically updated if you change data in the worksheet
conditional
You can use a spreadsheet to _____ by using variable values to investigate and sample different outcomes
creat what-if data scenarios
Excel templates make creating a professional looking spreadsheet easier by including all of the following except _______ in the template
data
A type of conditional formatting that visually illustrates differences among values
data bar
Allows the user to move or copy data from one cell to another without using the Clipboard
drag-and-drop method
You can change, or ______, the contents of an active cell at any time
edit
All Excel formulas begin with the _____
equal sign (=)
You can apply formatting before and after you enter data in a cell or range
true
You can change the font and font size of any cell or range using the Mini toolbar
true
The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paster formulas only,"
Paste Preview
Has a default value of 8.43 characters, a little less than one inch
column width
A(n) ______ is a built-in formula that uses arguments to calculate information
function
In Excel, MAX and AVERAGE are examples of ______
functions
Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes
true
Predefined formulas in Excel are called functions and can be accessed using the Insert Function button (T or F)
true
T or F. Page Layout View focuses on how the worksheet will look when printed
true
Which formula contains a mixed cell reference?
=($A6+$A$7)*0.20
A ______ is an individual media file, such as art, sound, animation, or a movie
Clip
In Excel, the electronic spreadsheet you work in is called a _____
worksheet
How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?
=(C12+C13)*F4
All functions begin with the formula prefix ____
=(equals sign)
Absolute cell reference
$G$6
Mixed cell reference
$G6
In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?
(G15-G14)
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?
100
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
5
Double-clicking the column line to the right of a column activates the ____ feature for the column
AutoFit
In the formula =D1+C1/F3, which calculation will be performed first?
C1/F3
The Excel function that returns the number of cells in a range containing numeric data
COUNT
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
Cell references are automatically adjusted
You can apply attributes and alignment options using the ______ dialog box
Format Cells
You can apply attributes and alignment options using the _____ tab of the Ribbon
Home
A(n) _____ is an entry in a cell that contain text such as "2011 Sales" or "Travel Expenses"
Label
Displays the active cell address
Name box
To prevent round-off errors, use the ______ function
ROUND
To format a cell or range, first you select it, and then you apply the formatting using the _____ or a keyboard shortcut
Ribbon
The ______ option helps fit the data on a single page without making changes to individual margins.
Scale to Fit
You can use ______ to move around in a document that is too large to fit on the screen at once.
Scroll bars
_______ below the worksheet grid let you switch from sheet to sheet in a workbook.
Sheet tabs
Provides a brief description of the active command or task in progress
Status bar
In Excel, a worksheet is contained in a file called a ______.
Workbook
Equal to 1/72 of an inch
point
An Excel user should use a relative cell reference when it is important to ______
preserve the relationship to the formula location
This type of cell reference used to preserve the relationship to the formula location
relative
The Spelling button is found in the Proofing group on the ______ tab on the Ribbon
review
An electronic _____ is an application you use to perform numeric calculations and to analyze and present numeric data
spreadsheet
Predesigned workbook files that contain labels, values, formulas, and formatting
template
You can use predesigned, formatted files called ____ to create new worksheets quickly
templates
When cells are copied using Excel's copy function, what happens to the data in the copied cells?
the data remains in its original location
In the formula =ROUND(D4:F4,0), what does the zero indicate?
the number of decimal places in the rounded number
An Excel user may paste a range of cells in which of the following locations
the same worksheet where the cells were copied and a different worksheet
A predefined set of attributes that gives your Excel worksheet a professional look
theme
Charts are updated automatically in Excel whenever data changes (T or F)
true
In page layout view, the dotted line indicates the print area (T or F)
true
Using the CUT command completely removes data from its original location, whole the COPY command leaves information in its original location (T or F)
true
Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells (T or F)
true
You can add words to the dictionary of the spelling checker
true
