Excel Final1
You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.
Alignment
F2
Alternate to double-clicking the cell to edit it.
Which of the following is the maximum number of active data tables per worksheet?
As many as you want
Which of the following is the maximum number off active data tables per worksheet?
As many as you want
The ______ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting
Auto Fill Options
Which of the following Option buttons fives options for filling cells following a fill operation? Autofill options Auto Correct options Insert Options Paste Options
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
Auto calculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Auto correct
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto fill options
The ___ feature works behind the scenes, fixing spelling and grammar
AutoCorrect
_______ corrects two initial capital letters by changin the second letter to lowercase
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
When you first create a table, Excel automatically enables ____.
AutoFilter
The date you change a file is an example of a(n) ____ property.
Automatically Updated
Function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
Average
Error messages begin with the ____ symbol
#
Error messages begin with the ____ symbol.
#
____ refers to cells not wide enough to display the entire entry
#####
____ refers to cells not wide enough to display the entire entry.
#####
Indicates a cell is using a name Excel does not recognize
#NAME?
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
#REF!
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.
#REF!
What is the path to the What-If Analysis button?
(DATA tab | Data Tools group)
Which of the following is the path to the Goal Seek button?
(DATA tab | Data Tools group)
Which of the following is the path to the Name Manager button?
(FORMULAS tab | Defined Names group)
Which of the following is the path to the 'Lookup & Reference' button?
(FORMULAS tab | Function Library group)
Which of the following is the path to the Financial button and the PMT function?
(FORMULAS tab | Function Library group)
Which of the following is the path to the Increase or Decrease Indent button?
(HOME tab | Alignment group)
Which of the following is the path to the Insert Cells arrow?
(HOME tab | Cells group)
The path to the Format Painter button is ____.
(HOME tab | Clipboard group)
Which of the following is the path to the Copy and Paste buttons?
(HOME tab | Clipboard group)
Which of the following is the path to the 'Sort & Filter' button?
(HOME tab | Editing group)
Which of the following is the path to the Fill button?
(HOME tab | Editing group)
Which of the following is the path to the Sum arrow?
(HOME tab | Editing group)
Which of the following is the path to the Borders button?
(HOME tab | Font group)
Which of the following is the path to the Comma Style button?
(HOME tab | Number group)
Which of the following is the path to the Cell Styles button?
(HOME tab | Styles group)
Which of the following is the path to the Conditional Formatting button?
(HOME tab | Styles group)
Which of the following is the path to the Format as Table button?
(HOME tab | Styles group)
Which of the following is the Ribbon path to the Cell Styles button?
(HOME tab/ Styles Group)
Which of the following is the path to the Protect Sheet button?
(REVIEW tab | Changes group)
Which of the following is the path to the Spelling button?
(REVIEW tab | Proofing group)
Which of the following is the path to the Total Row check box?
(TABLE TOOLS DESIGN tab | Table Style Options group)
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
(VIEW tab | Window group)
Which of the following is the path to the Zoom button?
(VIEW tab | Zoom group)
Which of the following is the path to the Copy and Paste buttons? (home tab/ Copy group) (home tab/ paste group) (home tab/ Clipboard group) (home tab/Formulas group)
(home tab/ Clipboard group)
When you decrease the row height to ____, the row is hidden.
0
When you decrease the row height to ______ the row is hidden. 0 1 2 3
0
When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell
0
When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.
0
While creating an Excel worksheet, several decisions will determine the appearance and characteristics of the finished worksheet. List some guidelines
1. Select titles and subtitles for the worksheet 2. Determine the contents for rows and columns. 3. Determine the calculations that are needed. 4. Determine where to save the worksheet 5. Identify how to format various elements of the worksheet. 6.Decide on the type of chart needed. 7.Establish where to position and how to format the chart. 8. Choose a name for the worksheet. 9.Determine the best method for distributing the workbook.
how many charts does Microsoft offer
10
Excel remembers the last ____ actions you have colmpeted
100
Excel remembers the last ___
100 actions
Excel offers ____ chart types
11
Excel includes ____ database functions that allow you to evaluate numeric data in a table.
12
Use no more than ____ font types
2
When you enter a two digit year that is less than 30, Excel changes the year to______ A. 20xx B. 30xx C. 18xx D. 19xx
20xx
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
When Excel follows the order of operations, the formula, 8*3+2, equals _____?
26
When excel follows the order of operations the formul, 8*3+2 equals_______ 40 26 48 13
26
The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.
3, 4, 5
Which of the following patterns extends the fill series to 575, 550, 525
625, 600
Which of the following patterns extends the fill series to 575, 550, 525?
625, 600
To enter a number such as 6,000,000,000,000,000 you can type it out or enter_____
6E15
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.
8.43
If you do not assign a format to a cell or cells in a column, the column width will remain ______ characters. 8.43 7.52 11.65 9.43
8.43
Which comparison operator means "not equal to"
<>
Which comparison operator means "not equal to"?
<>
Which of the following formulas contains an absolute cell reference?
=$B$4
Which of the following formulas contains and absolute cell reference
=$B$4
Which of the following calculations multiplies 23 by 0.01?
=23%
Which of the following calculations multiplies 23 by 0.01? =23% =23 =23+.01 =24-.01
=23%
The general form of the VLOOKUP function is ____.
=VLOOKUP(lookup_value, lookup_table, col_index_num)
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
All of the following are valid Excel arithmetic operators except______ A. ^ B. * C. % D. >
>
To start a new line in a cell, press the ____ keys A. CTRL+ENTER B. TAB+ENTER C. ALT+ENTER D. SHIFT + ENTER
ALT+ENTER
To start a new line in a cell, press the ____ keys.
ALT+ENTER
Selects the cell one worksheet window to the right
ALT+PAGE DOWN
Selects the adjacent cell in the direction of the arrow on the key
ARROW
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.
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. MIN SUM AVERAGE MAX
AVERAGE
Displays cell contents with two decimal places that align vertically
Accounting Number format
button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number Format
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
Like the AutoFilter query technique, the ____ command displays a subset of the table.
Advanced Filter
The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.
Rules Manager
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
SHIFT
Highlights one or more adjacent characters to the right
SHIFT + RIGHT ARROW
Not used to clear a cell
SPACEBAR
The most common subtotal uses the ____ function.
SUM
Excel's ______, which adds all of the numbers in a range of cells, provides a way to calculate a total
SUM function
The ____ function is useful when you want to add values in a range only if they meet criteria.
SUMIF
CTRL+HOME
Selects A1
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
Sheet
Fill handle
Small black square located in lower right corner of active cell
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell
Sparkline
___ properties are associated with all Microsoft office doc and include author title and subject
Standard
_____ are/is used to add worksheet, column, and row titles on worksheet
Text
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The formula checker
Receiving range
The range of cells receiving the copy
A company or department may standardize with a specific ______ so that all of their documents have a similar appearance.
Theme
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Thursday, Saturday, Monday
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.
Trace Error button
(True or False) Cooler colors tend to pull away from the reader.
True
(True or False) Point mode allows you to select cells for use in a formula by using your finger or the pointer.
True
(True or False) To Sum button menu allows you to enter one of five often-used functions easily into a cell.
True
(True or False) Excel has more than 400 functions that preform just about every type of calculation you can imagine.
True
(True or False) Moving from left to right, the first calculation in the order of operations is negation (-).
True
(True or False) The AVERAGE function requires that the argument be included within parenthesis following the function name.
True
A cell name often is created from column and row titles.
True
A column border is an unused column with a significantly reduced width.
True
A date stamp show the date a workbook, report, or other document was created or the period it represents
True
A nested IF function is one in which the action to be taken for the true or false case includes yet another If function
True
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area
True
An amortization schedule summarizes loan information over the life of the loan.
True
Assigning names to a cell or range of cells allows you to select them quickly.
True
Changing the order of sheets in a workbook allows you to position the most important worksheets first
True
Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.
True
If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME
True
If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.
True
Im the accompanying figure, the formula in cell B14 (=B13+(1-$B$4)) contains an absolute reference
True
In the accompanying figure, worksheet titles are frozen above and to the left of cell B13
True
Many Ribbon commands, galleries, and shortcut keys function as toggles or switches
True
Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.
True
Rotated text also allows you to fit more text into a smaller column width
True
Studies have shown that more than 25 percent of all business worksheets have errors
True
The <= comparison operator means less than or equal to
True
The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.
True
The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it
True
The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.
True
The equal sign (=) precedes a formula.
True
The most common error when entering a formula is to reference the wrong cell in the formula.
True
The path to the Logical button is (Formulas tab / Function Library group)
True
To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.
True
Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.
True
When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.
True
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
True
When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value
True
When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.
True
When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item
True
With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize
True
You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.
True
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow
True
The ____ function is used when a table direction is vertical.
VLOOKUP
Which of the following is the path to the Zoom button
View tab / Zoom group
To hide an entire workbook on an unattended computer, click the Hide button on the ___.
View tab | Window group
Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____ colors.
Warmer
you can use a _____ to view an XPS file
XPS Viewer
After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.
Zoom
Range
a series of two or more adjacent cells in a column or row.
Names are ___ cell references.
absolute
Names are ____ cell references.
absolute
Keeps a cell reference constant when copying a formula or function
absolute cell referencing
The ________ displays numbers with a fixed dollar sing to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. comma style accounting number percent style currnecy style
accounting
An excell entry can contain___
all characters
in excel a number can contain the characters
all the above
Replace options
allows you to choose whether you want to copy the values from the source area to destination area with formatting
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.
amortization schedule
An ___ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.
amortization schedule
A(n) ____________________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.
annuity
To enter number as text precede it with _____
apostrophe
For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.
arguments
The left column values in a table array are called table ____.
arguments
Use the _____ to complete a entry and move to the next cell
arrow
Data is in ____ sequence if it is in order from lowest to highest.
ascending
Cell references in a formula are called ____
assumptions
Cell references in a formula are called ____.
assumptions
You can click the ______ button to undo an automatic correction. auto Fill options autocorrect options Paste options Trace err0r
autocorrect options
In a process called ___, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
A ____ cell in Excel has numerical value of zero. blank formatted copied filled
blank
The most popular background color is_____ blue white red yellow
blue
Cell ___ help to set off sections of a worksheet.
borders
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
The arguments in ____ in the ScreenTip for a function are optional.
brackets
All of the following are valid Excel arithmetic operators except... a. * b. ! c. > d. %
c. >
In a table, a column that contains formulas or functions is called a(n) ____.
calculated column
To enter data in cell, you must first select or activate the ____
cell
___ ensures that users do not change the values inadvertently that are critical to the worksheet.
cell protection
Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.
cells
A ____ conveys a visual representation of data
chart
A(n) ____ is a separate sheet in a workbook that contains only a chart
chart sheet
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
AutoCalculate area
displays common calculations
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ___ in the upper-left corner of the cell assigned the formula.
green triangle
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.
green triangle
A ____ is text and graphics that print at the top of each page.
header
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ___ on the shortcut menu.
hide
Which of the following is the path to the Comma style button? Hometab/ Alignment tab Hometab/ Fontgroup Hometab/ Cells group Hometab/ number group
hometab/ number group
Which of the following is the path to the Conditional Formatting button? Hometab/Editinggroup Stylestab/Formattinggroup Formatting group/ Styles group Hometab/ styles group
hometab/ styles group
Which of the following is the path to the Sum button? editing tab/home group home tab/Editing group Hometab/ Clipboard group Calculation tab/ editing group
hometab/editing group
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
The ____ option button lists formatting options following an insertion of cells, row, or columns autocorrect insert auto fill paste
insert
clicking the _____ opends the Insert Function dialog box shown int eh accompanying figure. Insert function box on the formula bar function dialog box launcher Function button Functions and formulas button on the status bar
insert function box on the formula bar
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
The _____ is a blinking line
insertion point
In the accompanying figure, the split double arrow mouse pointer ____
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
The ____ identifies the colors assigned to each bar in the chart on a worksheet
legend
A ____ chart often is used to illustrate changes in data over time
line
In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.
major sort key
combining two or more selected cells into one cell called ____ cells
merging
The easiest way to select a cell is to select it with a
mouse pointer
A cell ___ often is created from column or row titles.
name
A cell ____ often is created from column or row titles.
name
Rather than manually setting a print area each time you want to print a range, you can ____ the range.
name
Rather than setting a print are each time you want to print a range, you can ___ the range.
name
You can select a cell or range by typing it's ___ in the Name Box and pressing the Enter key.
name
You can select any cell by entering its cell reference in the
name box
To print individual sections of a worksheet, ___ these sections then print them by ___.
name, name
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function
nested
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
With a ___ data table you can vary the value in one cell.
one-input
With a(n) ____ data table you can vary the value in one cell.
one-input
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra. placement positioning operations selections
operations
You can select a worksheet so that it will fit on one page with an option on the ___ tab in the Page Setup dialog box.
page
_____ allows you to create or modigy a worksheet while viewing how it will look in printed format. normal page layout page break preview full screen
page layout
You should create a ___ when you want to keep others from changing the worksheet from protected to unprotected
password
You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.
password
Shows the relationship or proportion of parts to a whole
pie chart
Careful _____ can reduce your efforts in making a worksheet
planning
You can delete a data table by selecting the data table and then ____.
pressing the DELETE key
You can delete a data table by selecting the data table and then ___.
pressing the Delete key
To pring a range of cells in teh actinve worksheet, click _______ in the Settings area in the Print gallery, as shown in the accompanying figure. print active sheets print selection print entire workbook none of the above
print selection
When building a worksheet for novice users, you should ___ the cells in that worksheet that you do not want changed, such as cells that contain text or formulas.
protect
When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.
protect
Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.
protection
The process of filtering activity based on one or more filter criteria is called a ____.
query
____ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protection
____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
Conditional
To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.
Convert to Range
What is the path to the What-If Analysis button?
Data Table | Data Tools group
Which of the following is the path to the Goal Seek button
Data tab / Data Tools group
____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.
Data tables
The Chart tools contextual tabs include the___ tabs
Design Format Layout
The range of cells receiving the content of copied cells is called the
Destination area
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____
Dialog Box Launcher
To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.
Dialog Box Launcher
What effect does theAccounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
The / arithmetic operator indicates ______.
Division
____ the Format Painter button and the drag through the non adjacent ranges to paint the formats to the ranges
Double-click
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Double-click or double-tap
A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.
Draft quality
Moves insertion point to end of data in cell
END
Moves the insertion point to the end of data in a cell
END
An alternative to clicking the Paste button is to press the ____ key
ENTER
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
ENTER
Clicking the ____ completes an entry
ENTER key
Pressing the ____ key(s) removes the marquee from the source area
ESC
To cancel an entry before entering in the cell , press _____
ESC
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ESC
The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
Equal Sign (=)
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
If you click a 3-D Pie chart so that all the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded
False
If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series
False
Spreadsheet specialists usually format a worksheet before they enter any data.
False
The NETWORKDAYS function check a formula for correctness
False
The PMT function has two arguments: rate and payment.
False
The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.
False
The range of entries that determines the size of the slices in a Pie chart is called category names
False
The syntax of the IF function if IF(logical_test), value_if_false, value_if_true)
False
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns
False
You can add only a maximum of five conditional formats to a range.
False
You can select nonadjacent ranges using the SHIFT key
False
You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.
False
You cannot use column and row titles within formulas when you want to refer to the related data by name.
False
You should create worksheets as if you are going to use them only once.
False
Fills a destinations area using the format source area; no content copied
Fill Formatting Only
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled
Fill Formatting Only
Which of the following Auto Fill Options menu options is the same as the Fill Series option?
Fill Months
Copies the format and contents
Fill Series
The small black square located in the lower-right corner of the heavy border around the active cell.
Fill handle
____ indicates how text characters are emphasized
Font style
Is text and graphics that print at the bottom of every page.
Footer
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
Format Cells
One of reasons Excel is such a valuable tool is that you can assign a ______ to a cell, and Excel will calculate the result.
Formula
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.
Formulas
Which of the following is the path to the Name Manager button?
Formulas tab | Defined Names group
Which of the following is the path to the Financial button and the PMT function?
Formulas tab | Function Library group
A prewritten formula that is built into Excel.
Function
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
____ seeking assumes you can change the value of only one sell referenced directly or indirectly to reach a specific goal for another cell
Goal
The ____ function is used when the table direction is horizontal.
HLOOKUP
Moves insertion point to beginning of data in cell
HOME
Selects the cell at the beginning of the row that contains the active cell.
HOME
Which of the following is the path to the Comma Style button?
HOME tab/ Number Group
Which of the following is the path to the Conditional Formatting button?
HOME tab/ Styles Group
Is text and graphics that print at the top of each page.
Header
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
Hide
____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.
Hiding
Which of the following keys moves the insertion point to the beginning of data in a cell?
Home
Which of the following is the Ribbon path to the Cell Styles button?
Home Tab: styles group
Which of the following is the path to the Increase or Decrease Indent button
Home tab / Alignment group
Which of the following is the path to the Insert button
Home tab / Cells group
The path to the Format Painter button is ____
Home tab / Clipboard group
Which of the following is the path to the Fill button?
Home tab | Editing group
Which of the following is the path to the Cells Styles button?
Home tab | Styles group
Which of the following is the path to the borders button?
Home tab | font group
The ____ function is useful when you want to assign a value to a cell based on a logical test
IF
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
Assigns a value to a cell based on a logical test
IF function
The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.
INDEX
Toggles between INsert and Overtype mode
INSERT
Which of the following keys toggles between Insert mode and overtype mode?
INSERT
When assigned to a cell, the ____ function returns a number that corresponds to the system data and time beginning with December 31, 1899
NOW
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
Returns a number that corresponds to the system date and time beginning with December 31, 1899
NOW function
The default view in Excel is called ...
Normal
The default view in Excel is called ____ view.
Normal
Which of the cell contents is extended to Qtr3, Qtr4, Qtr1 by dragging the fill handle?
Qtr2
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
Pressing the ____ key completes an entry, and goes to next cell
RIGHT ARROW
To prevent round-off errors, use the ____ function.
ROUND
A ____ is a series of two or more adjacent cells in a column or row or a rectangular
Range
To check which cells are referenced in the formula assigned to the active cell.
Range Finder
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
You can ensure correctness in your formulas by carefully checking them using ____
Range finder
The ____ is the small black square located in the lowerright corner of the heavy border around the active cell.
fill handle
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign. fixed formatted floating none of the above
fixed
An increase_____gives more impact to the text in a cell
font size
A ____ is text and graphics that print at the bottom of every page.
footer
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
You can add and format a range border by right-clicking the selected range and clicking ___ on the shortcut menu.
format cells
The _______ Autocomplete list contains those functions that alphabetically match the letter you type following the equal sign. function formula equal calculate
formula
As you type, Excel displays the entry in the _____ and also displays the Cancel box and the Enter box on the formula bar
formula bar
Similar to the spell checker, Excel has a ___ that check formulas in a worksheet for rule violations.
formula checker
You can choose which rules you want Excel to use by enabling and disabling them in the ___area in the Excel Options dialog box, as shown in the accompanying figure.
formulas
you can use the ____ to check which cells are referenced int he formula assigned to the active cell. formula finder range finder calculation finder function finder
Range finder
A ____ is a prewritten formula that is built into Excel.
function
A ____ reference is an adjusted cell reference in a copied and pasted formula.
Relative
The adjusted cell references in a copied and pasted formula are called ____ cell references.
Relative
The person or persons requesting the worksheet should supply their requirements in a ____ document.
Requirments
____ text often provides a strong visual appeal
Rotated
____ text often provides a strong visual appeal.
Rotated
Which of the following is NOT a type of conditional formatting?
Row Banding
A ________ is a prewritten formula that is built into Excel. A. function B.feature C. task D. calculation
function
Names are ___ to the workbook.
global
Names are ____ to the workbook.
global
Determines the value of a cell on which the formula depends
goal seeking
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell
goal seeking
A ____ total sums all of the data in a row or column.
grand
____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.
Row banding
With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.
quotation marks
In the accompanying figure, the Print area box accepts a name or a ___ to print.
range
In the accompanying figure, the Print area box accepts a name or a ____ to print.
range
In a table, or database, the data related to each person or item is called a ____.
record
A ____ reference is an adjusted cell reference in a copied and pasted formula
relative
The adjusted cell references in a copid and pasted formula are called _____ references. related relative pasted alternative
relative
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
The automatically adjusted cell reference in a pasted formula is called _______
relative reference
You should supply requirements for worksheets in a _____ document
requirements
Which of the following is the path to the Spelling button? Hometab/ Progging group Proofing tab/ spelling group Review tab/ Proofing group Reiveiw tab/ checking group
review tab/ proofing group
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
right arrow
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
Excel automatically appends the _______ to complete the AVERAGE function when you click the Enter box or press the ENTER key. left parentesis right bracket right parenthesis left bracket
right parenthesis
To prevent round-off errors, use the ___ functinon.
round
Point mode allows you to ____, as shown in the accompanying figure.
select cells for use in a formula using the mouse pointer
Point mode allows you to _____ select cells for use in a formula using the keyboard select a function from the Sum button list select cells for use in a formula using the mouse pointeredit cell contents directly in the cell
select cells for use in a formula using the mouse pointer
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it
three
Format a worksheet
to emphasize certain entries and make it easier to read
You can insert a ____ at the bottom of a table.
total row
The ______ options button lists error checkingoptions following the assignment of an invalid formula to a cell. find error explain error fix error trace error
trace error
If you click the ___, Excel displays a menu; the first item int he menu identifies the error and the remainder of the menu contains commands you can click.
trace error button
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
two
When working with a large worksheet, you can split the window into ____ panes
two or four
When working with a large worksheet, you can split the window into ____ panes.
two or four
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
To ensure you create an effective worksheet you should _____
understand what is required
The ____ button allows you to erase recent cell entries.
undo
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
unprotected
When considering which cells another worksheet user should be able to manipulate, leave the cells ___.
unprotected
Data tables must be built in a(n) ____ area of a worksheet.
unused
Data tables must be built in an ___ area of a worksheet.
unused
With a solid understanding of the requirements document, an understanding of necessary decisions, and a sketch of the worksheet, the next step is to ____
use Excel to create the worksheet
Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
violations
Allows data to be easily summarized and charted
worksheet
An Excel ____ allows data to be summarized and charted easily.
worksheet
To enter data in a cell, you must first select the ____.
Cell
Deletes characters to the left of the insertion point
BACKSPACE
While typing in a cell, you can press the _____ key to delete all the characters back to and including the incorrect character you just typed
BACKSPACE
Why is the VLOOKUP function used more often than other lookup functions?
Because most tables are vertical
Means that the width of a column will be increased or decreased so the widest entry will fit in the column.
Best Fit
Colors jump out a dark background and are easiest to see.
Bright
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
CTRL
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL+1
You can open the Format Cells dialog box by pressing the ______ keys. SHIFT+TAB CTRL+1 ALT+1 SHIFT+F1
CTRL+1
You can press the ____ keys to open the Format Cells dialog box
CTRL+1
You can press the ____ keys to open the Format Cells dialog box.
CTRL+1
press ___ to select the entire work sheet
CTRL+A
Apply Bold font style
CTRL+B
you can apply the bold font by pressing _______
CTRL+B
To copy cell contents you can select teh cell and then press the _____ keys. CTRL+V CTRL+X CTRL+B CTRL+C
CTRL+C
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL+C
Displays the Find dialog box
CTRL+F
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
selects cell A1
CTRL+HOME
To paste copied cell contents you can press the _____ keys. CTRL+C CTRL+P CTRL+V CTRL+X
CTRL+V
To paste copied cell contents, you can press the ____ keys.
CTRL+V
A formula in a cell that contains a reference back to itself.
Circular reference
The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory
Clipboard
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
You should use a ____ chart to compare values side by side, broken down by category.
Clustered Column
You can enter the correct range in a function by typing the beginning and ending cell references separated by _____
Colon
you can enter the correct range in a function by typing the beginning and ending cell references separated by a
Colon (:)
Merging
Combining two or more selected cells
Displays cell contents with two decimal places and commas as thousands seperators
Comma style
Which of the following happens when you enter the formula =G15 into a cell? Excel recalculates all formuals 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
Excel assigns the value in cell G15 to the active cell
MC: A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
Exploded
____ records allows you to pull data from a table so that you can analyze or manipulate the data further.
Extracting
You can select a range using the keyboard by pressing the ____ key and the and ARROW key F2 f4 F6 F8
F8
(True or False) Best fit means that the width of the column will be increased or decreased by a percentage you specify.
False
(True or False) The range automatically selected by Excel is always correct.
False
(True or False) An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
False
(True or False) As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.
False
(True or False) The Accounting number format assigns a floating dollar sign.
False
(True or False) You cannot format an entire column at once.
False
A name cannot be assigned to two or more nonadjacent ranges.
False
An alternative to a one-input data table is a three-input data table.
False
Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock
False
Excel is case sensitive with respect to names of cells.
False
Reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
Indirect
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
Which of the following keys toggles between Insert mode and Overtype mode?
Insert
Clicking the ____ opens the Insert Function dialog box.
Insert Function box in the formula bar
Clicking the ______ opens the Inserts Function Dialog Box.
Insert Function box in the formula bar
Pastes the contents and format of the source area
Keep Source Formatting
Text is ___ aligned in cell
Left
By default text is ____ in a cell
Left aligned
Undo Button
Located on Quick Access Toolbar,
The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.
MATCH
Function displays the highest value in a range.
MAX
The ____ function displays the highest value in a range.
MAX
The ______ function displays the highest value in a range. MIN SUM MAX AVERAGE
MAX
Determines the lowest number in a range
MIN
The ____ function determines the lowest number in a range.
MIN
The ______ function determines the lowest number in a range MAX AVERAGE SUM MIN
MIN
Are those portions of a printed page outside the main body of the printed document and always are blank when printed.
Margins
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
Operations
If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.
Orientation
____ is extremely useful for making large tables more manageable in size and appearance.
Outlining
The ___ function returns the present value of an annuity.
PV
The ____ function returns the present value of an annuity.
PV
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
Page
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
view shows the worksheet divided into pages as well as the header/footer information.
Page Layout View
view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page layout view
The range of cells receiving copied content is called the ____ area.
Paste
You should use a ____ chart to show the relationship or proportion of parts to a whole
Pie
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
Worksheet _____ typically contain descriptive information about items in rows or columns information that helps to group the data in the worksheet
columns
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values
constant
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.
criteria
If you deselect an item from the filter menu, it is called the filter ____.
criterion
In a clustered column chart, the names of each column are part of the ____ series.
data
You use a ___ to automate data analyses.
data table
You use a(n) ____ to automate data analyses.
data table
Which of the following is a suggested decision to make when you plan a workbook?
determine the necessary functions and formulas needed
You should _____ a function name in the Formula AutoComplete list to select the function. doubleclick click right click none of the above
double click
You should ____ a function name in the Formula AutoComplete list to select the function.
double-click or double-tap
A check mark in the ___ check box speeds up printing by ignoring formatting and not printing most graphics.
draft quality
Using the mouse to move or copy cells is called ____
drag and drop
Using the mouse to move or copy cells is called ____.
drag and drop
An ____ chart is drawn on the same worksheet as the data
embedded
Which of the following keys moves the insertion point to the end of data in a cell?
end
By clicking the _____ box completes an entry
enter
The data ___ section of a worksheet includes data items entered by a user of a worksheet.
entry
A Pie chart with one or more slices offset is called a(n) ____
exploded Pie chart
Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.
field
If you wish to sign out of your Microsoft account tap or click ______ on the ribbon to open the backstage view and then tap or click that account tab to display the account gallery, and then tap or click sign out
file
Which of the following is not a valid format symbol
semi-colon
Which of the following is not a valid format symbol?
semi-colon (;)
You can set up a worksheet to print in black and white with an option on the ___ tab in the Page Setup dialog box.
sheet
You click the _____ tab of the worksheet you want to view in the Excel window
sheet
You can deselect multiple selected sheets beginning with the Sheet 1 tab by pressing the ___ key and clicking the Sheet1 tab.
shift
The field or fields selected for sorting records are called ____ keys.
sort
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
____ Properties are associated with all Microsoft Office files and include author, title, and subject
standard
You can click the ____ button arrow to view a list of often used functions
sum
A ____ should be formatted so that the records are easily distinguished.
table
A worksheet's row-and-column structure can be used to organize and store a ____.
table
The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.
table array
____ is/are used to place worksheet, column, and row tiles on a worksheet
text
___ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
the formula checker
A ________ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects. scheme gallery theme style
theme
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
