Microsoft Excel Review
What represents the Currency Style?
$
You can create an absolute cell reference by placing a _____ in front of both the column letter and the row number of the cell address.
$
In the formula,=G15-G15)*$M$3/4, which mathematical operation is performed first?
(G15-G14)
Excel recognizes an entry as a value if it is a number or begins with _____.
+, =, or $
The default file extention of Excel 2013 workbook is ___.
.xlsx .xlxt is an Excel template
The Excel operator for division is ___
/
The Undo button allows you to reverse up to ____ previous actions, one at a time.
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
All Excel formulas begin with the____.
= Equal sign
In a worksheet, the ____ is called the formula prefix.
= Equal sign
All functions begin with the formula prefix ___.
= equal sign
Which is a complex formula?
=(B4/B8)*10 (complex formulas use more than one arithmetic operator)
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
Which formula is a mixed cell reference?
? =($A$6+$A$&)*0.20
You can change the ____ of labels and vaues in the cells to be right, left or center.
Alignment
______ operators perform mathematical calculations such as adding and subtracting.
Arithmetic
Double-clicking the column line to the right of a column activates the _____feature for the column.
AutoFit
Cells and ranges in a worksheet can be formatted ____.
Before and after data is entered
In the formula, =D1+C1/F3 which calculation will be performed first?
C1/F3
The ______ is the active cell with a bold border around it.
Cell Pointer
A_____is an individual media file, such as art, sound, animation or a movie.
Clip
The Format Painter button is found in the ____ group on the HOME tab of the Ribbon.
Clipboard
##### in a cell means that the _____.
Column is too narrow to display the value correctly
_____Formatting is automatically updated if you change data in the worksheet.
Conditional
The ____ size is the physical size of the text.
Font
You can apply font styles and alignment options using the ____ dialog lox.
Format Cells
You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the _____ dialog box.
Format Cells
The Find & Select button is found in the editing group on the _____ tab on the Ribbon.
HOME
To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells.
HOME
You can apply font styles and alignment options using the ____ tab on the Ribbon.
HOME
You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.
HOME
Which tab and group will allow insertion of rows and columns in a worksheet?
HOME tab, cells group
In the _____window you can search for online pictures (or Clip ASrt) in Office.com through the Bing search engine, or on your SkyDrive.
Insert Pictures
The default format for cells that meet a condition with conditional formatting is ____.
Light Red Fill with Dark Red Text
____shows you how a fill color will look before you apply it.
Live Preview
A theme can be applied using the Themes button in the Themes group on the ____tab on the Ribbon.
PAGE LAYOUT
The Spelling button is found in the Proofing group on the _____ tab of the Ribbon.
REVIEW
You can insert a comment in a worksheet by using the ____ tab on the Ribbon.
REVIEW
To format a cell or range, first you select it, and then you apply the formatting using the _____, the Mini toolbar, or a keyboard shortcut.
Ribbon
If you create a conditional formatting rule you can modify it using the Conditional Formatting _____.
Rules Manager
The ____option helps fit the data on a single page without making changes to individual margins.
Scale to Fit
_____ below the worksheet grid let you switch from sheet to sheet in a workbook.
Sheet tabs
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
Spreadsheet
Cell ____are predesigned combinations of formats.
Styles
Font _____are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.
Styles
To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery.
Styles
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
The clipboard automatically deletes the oldest item on the clipboard
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
When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.
True/False False
With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.
True/False False
You can change header and footer information using the Margins Design tab that opens on the Ribbon.
True/False False
An named range can begin with a letter or a number.
True/False False: A letter or an underscore
A cell reference that does not change when it is copies is called a(n)relative cell reference.
True/False False: Absolute
After you use the fill handle to copy cell contents, the [Quick Copy Options] button appears, which can be used to fill the fill the cells with only specific elements of the copied cell, if you wish.
True/False False: Auto Fill Options
To insert the AVERAGE function in a cell, click the cell,, click the [Function Options] list arrow in the Editing group on the HOME tab and then click Average.
True/False False: AutoSum
COUNT function in Excel returns the number of cells in a range that contain any type of data.
True/False False: COUNT returns numeric data COUNTA returns any data
[Reference] operators compare values for the purpose of True/False results.
True/False False: comparison
According to the order of precedence for arithmatic operators, operations contained within parenthesis are performed [last].
True/False False: first
Using the order of precedence for arithmetic operators, these two formulas will calculate the same result. =22/2*5 =22/(2*5)
True/False False: first one gives 55 second one gives 2.2
An absolute cell reference changes the cell references when the formula is copied to a new location.
True/False False: it does not change
When the paper orientation is [portrait], the contents will print across the length of the page instead of across the width.
True/False False: landscape
When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the [lower-right] cell of the range where you want to paste the selection.
True/False False: top-left
[Labels] are numbers, formulas,and functions that can be used in calculations.
True/False False: values
=D8+E8*0.5 is a complex formula.
True/False True
According to the order of precedence, the formula =(25*2)/5 would calculate for the result of 10.
True/False True
An excel complex formula uses more than one arithmetic operator
True/False True
Excel includes a(n) [Scenario Manager] where you can name and save different what-if versions of your worksheet.
True/False True
One of the ways to change your view of the worksheet window is by using the VIEW tab on the [Ribbon].
True/False True
Predefined formulas is Excel are called functions and can be accessed using the Insert function.
True/False True
Printing gridlines makes data easier to read.
True/False True
Using the CUt command completely removes data from its original location, while the Copy command leaves information in its original location.
True/False True
You can use a named range instead of a cell address in a formula.
True/False True
in this formula, =(A6*A8)+$D1$, cell reference (A6*A8) are [relative] cell references.
True/False True
Clicking the [Minimize] button minimizes the Function Arguments dialog box so you can select cells in a worksheet.
True/False false: collapse
A(n) mixed cell reference means that either the column or row reference in the formula is absolute, but not both.
True/False true
You can [close] the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group.
True/False true
It is acceptable for dates to have a currency format
True/False False
The Format Painter button copies both the cell's content and formatting.
True/False False
The Increase Decimal button automatically adds dollar signs and two decimal places to your data.
True/False False
you must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.
True/False False
To ad an image to a worksheet, click Pictures in the Illustrations group ont the [HOME] tab.
True/False False: INSERT
When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.
True/False False: The new column is inserted to the left
The font size is measured in units called [pixels].
True/False False: points
Cell [templates] are sets of cell formats based on themes; they are automatically updated if you change a theme.
True/False False: styles
After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain [relative] references.
True/False True
Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.
True/False True
To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.
True/False True
Using the mouse, you can drag or double-click the right edge of a column heading to change the column [width].
True/False True
With Excel, you can adjust the width of one or more columns by using the mouse.
True/False True
You can add words to the dictionary of the spelling checker.
True/False True
You can apply formatting before or after you enter data in a cell or range.
True/False True
You can change the font and font size of any cell or range using the Mini Toolbar.
True/False True
To move one screen to the left press _____.
[Alt][page Up]
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 keyboard shortcut turns on Edit mode?
[F2]
Which function key on the keyboard allows the Excel user to cycle through all the possible combinations of relative, mixed and absolute cell references for a formula?
[F4]
You can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding _____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the cells group on the HOME tab, then clicking Insert Sheet.
[Shift]
Which type of reference preserves the exact cell address in a formula?
absolute
You can use the ___ key(s) on the keyboard to navigate a worksheet.
arrow
Excel templates include which of these common documents?
budgets, balance sheets, and time cards
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
call references are automatically adjusted
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
create What-if scenarios
Excel templates make creating a professional looking spreadsheet easier by including all of the following except ____ in the template.
data (it does include formulas, formatting and labels)
You can change, or ____the contents of an active cell at any time.
edit
The ____ of a cell determines how the labels and values look.
format
=SUM(B5:B15) is an example of a _____.
formula
A(n) ____ is a built-in formula that uses arguments to calculate information.
function
In Excel MAX and AVERAGE are examples of ___.
functions
A(n) ____ is an entry in a cell that contains text such as "2013 Sales"or "Travel Expenses".
label
Which method of entering a function requires the user to know the name and initial characters of a function?
manually typing the function
The COUNTA function is used to count the number of cells in a range that contain which type of data?
numbers, text or formulas. (any data at all)
Which of the following is NOT a Paste list arrow option?
pasting cell selectors
Possible paper orientation for printing a worksheet are landscape and ____.
portrait
An Excel user should use a relative cell reference when it is important to ____.
preserve the relationship to the formula location
A small, ____triangle appears in the upper-right corner of a cell containing a comment.
red
A(n) ____cell reference tells Excel to substitute new cell references within the copied formulas as necessary.
relative
You can use ____ to move around in a document that is too large to fit on the screen at once.
scroll bars
You can use predesigned, formatted files called ____ to create new worksheets quickly.
templates
Which of the following removes only the contents of a selected row or column?
the Delete key
In the formula, ROUND(D4:F4,0), what does the zero indicate"
the number of decimal places in the rounded number
The default Accounting number format adds dollar signs and ____ decimal places to the data.
two
Functions can be entered for formulas by using all of the following methods except ___.
typing the function argument
In Excel, a worksheet is contained in a file called a ___.
workbook
In Excel, a electronic spreadsheet you work in is called a _____.
worksheet