ALL OF LEVEL ONE Flashcards
when the mouse pointer displays as a white plus sign, it is referred to as the…
cell pointer
when you click the AutoSum button, Excel looks first for a range of cells containing numbers _____ the active cell, and then _____ the active cell.
above
left of
display the Open backstage area by clicking the FILE tab and then clicking the Open option, or by pressing…
CRTL + O
pressing Ctrl + Home will take you to the…
first cell of the worksheet
clicking the Quick Print button will…
send the workbook directly to the printer
to select all cells from the active cell to the beginning of the row, press…
shift + home
which keyboard command closes Excel?
Alt + F4
which keyboard shortcut displays the Go To dialog box?
CRTL + G
which of the following is not a valid name for an Excel workbook?
MyBudget/version2.xlsx
by default, numbers in a cell are aligned at the _____ and decimals and commas _____ display.
right
will not
to select specific characters within a cell (rather than the whole cell), begin by…
double clicking in the desired cell
Which element of an Excel worksheet displays the active cell address or name assigned to the active cell?
name box
The AutoCorrect feature in Excel automatically corrects…
common typing errors
What happens if you enter text into a cell and it is too long to fit in the cell?
The text overlaps into the cell to the right, but it is not stored in that cell.
What is another name for the cell address?
cell reference
You can select nonadjacent cells with your mouse by
holding down the Ctrl key while clicking the desired cells
How many buttons display to the left of the search text box in the Excel Help window?
5
The area of the worksheet that contains tabs with commands and buttons is called the…
ribbon
When applied to an amount, this button adds a dollar sign, any necessary commas, and a decimal point followed by two decimal digits…?
accounting number format
Positioning your mouse pointer on the gray boundary line between columns in the column header is the first step toward…
changing column width
When you have finished editing the data in a cell, you must get out of Edit mode. Which of the following will not accomplish this?
pressing Home
To merge cells and center text, use the Merge & Center button located in the _____ group on the _____ tab.
alignment
home
What is the keyboard shortcut to display the Excel Help window?
F1
An Excel workbook consists of an individual “page” represented by a tab at the bottom of the Excel window. This is called a…
worksheet or sheet
The keyboard shortcut Alt + = inserts _____ into the active cell.
the SUM function
In addition to in its worksheet cell, where else is a data value displayed in Excel?
in the formula bar
Where in the worksheet area will you find the Name box?
upper left corner
To print a workbook, begin by clicking the _____ tab.
FILE
When a cell containing data is active, anything you type will…
take the place of the existing data
If numeric data in a number is too long to display in the cell, what does Excel do?
it displays number symbols (###) to indicate that the numeric value is too long to display
What is the name of the area at the bottom of the Excel screen that shows the Zoom level, the viewing mode, and the current mode?
status bar
Using the keyboard, you can select an entire column of cells by pressing…
- Shift + Home.
- Alt + Home.
- Ctrl + Shift + spacebar in the desired column.
- Ctrl + spacebar in the desired column
CRTL + spacebar in the desired column
A workbook name can contain up to _____ characters.
255
The individual cells in the Excel worksheet area are identified by a letter and number combination, such as A2, known as the…
cell address or cell reference
There are several ways to save an Excel workbook. Which of the following is not one of them?
- double-clicking the FILE tab on the ribbon
- clicking the Save button on the Quick Access toolbar
- pressing F12 and then clicking the Save button at the Save As dialog box
- pressing Ctrl + S
double-clicking the FILE tab on the ribbon
You can make a cell active by left-clicking in it, or you can use…
the Go To feature
You can copy a formula to other cells quickly by using…
autofill(?)
To enter data in a cell, the cell must be…
active
One of the features Excel offers to help with data entry is the AutoComplete feature, which automatically…
inserts data in a cell that begins the same as a previous entry
The horizontal and vertical scroll bars…
shift the display of cells, but do not change the active cell
If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle.
ALT
When the Trace Error button appears, what is displayed in the upper left corner of the active cell?
a small, dark green triangle
What type of cell values will the AVERAGE function ignore and not use in its calculation?
blank cells
When writing a formula by pointing, this displays at the left side of the Status bar.
Point
To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a…
thin black cross
What symbol is used to indicate an absolute cell reference?
$
Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?
F4
What will happen if you press Ctrl + ` (grave accent)?
the worksheet will display formulas instead of results
What does the error code #N/A mean?
an argument parameter has been left out of a function
Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box…?
insert function
Which of the following is not one of the categories of functions offered by Excel?
scientific
What does the MIN function return?
the minimum function in a range
A built-in formula, such as =SUM, is called a(n)…?
function
The process of calculating a formula and inserting the value in a cell is referred to as…
returning the result
Which of the following formulas shows an example of a mixed cell reference?
=$A$3+B$3
Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called…
arguments
What does the COUNT function count?
the number of numeric values in a range
Which of the following is not a common mistake made while inputting data in a formula?
writing a formula by pointing rather than typing the formula
If one of the cells in a range of cells you use as an argument for an AVERAGE function contains text instead of numbers, what will Excel do?
ignore the text and calculate the average
Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
editing
HOME
What does it mean for a formula to have a mixed cell reference?
it has a cell reference in which one component (row or column) is relative, while the other is absolute
Use this keyboard command to display the Insert Function dialog box.
Shift + F3
An Insert Function button can be found on the FORMULAS tab and…
the formula bar
When writing your own formulas, you must begin each formula with…
an equals sign =
The Trace Error button is a type of…
smart tag
Excel’s functions are grouped into _____ categories.
13
Use this function key to update a NOW or TODAY function.
F9
If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.
parentheses
How many functions can Excel perform?
more than 300
Which of the following is not one of the types of cell references discussed in Chapter 2?
dynamic
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?
the formula will change to =SUM(A3:C3)
The function that returns the arithmetic mean of the arguments is called…
average
The multiple layers of parentheses in a formula are called…
nested parentheses
What does it mean for a formula to have relative cell references?
the cell references change when the formula is copied to a new cell
At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.
Number1
In the Insert Function dialog box, what displays in the Select a function list box?
the most recently used functions
An absolute cell reference _____ change when copied to another cell.
does not
If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?
MAX
When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?
a temporary moving border is placed around the cell
What happens to formulas with relative cell references when they are copied using the fill handle?
a relative version of the formula is copied into the selected cell(s)
Use this keyboard command to display formulas in a worksheet.
Ctrl + `
In Excel’s order of operations, which type of operation happens first?
negations
This function returns the current date in a date format.
=TODAY()
In terms of an Excel formula, what is a constant?
a value entered directly into a formula
Indicate what the following formula will do: =B2/C2.
it will divide the contents of cell B2 by the contents of cell C2
What error code will display in a cell when a function name is not entered correctly into a formula?
NAME?
Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.
formula auditing
FORMULAS
After typing a formula into a cell, you can finish by pressing any of the following keys except…
spacebar
The Trace Error button allows you to do each of the following except…
delete the formula containing the error
When writing a formula by pointing, how do you end the formula?
press the enter key
The Increase Decimal and Decrease Decimal buttons change decimal places for…
existing numbers only
To insert a new row in a worksheet, select _____ and then click the Insert button.
the row below where the row is to be inserted
If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by…
pressing ALT + ENTER
What does the Merge & Center button in the Alignment group on the HOME tab do?
merges the selected cells and centers the data within the merged cells
Which of the following is not one of the options at the Merge & Center button’s drop-down list?
Merge Workbooks
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
By default, numbers typed in a cell are formatted to…
right-align, with no decimals or commas unless they are typed in the cell
If you enter the value $45.50 into a cell with default formatting, Excel automatically…
applies currency formatting to the number
The column width number in the Column Width dialog box represents…
the average number of characters in the standard font that will fit in a cell
Which button do you click to display the Column Width dialog box?
Format
You can use your mouse to change the height of multiple rows at the same time if the rows are…
adjacent to one another
The name of this button in the Font group changes depending on the most recent option it was used to apply.
boarders
To give your worksheet a professional look, you can apply a predefined set of colors, fonts, lines and fill effects by…
applying a theme
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
What happens if you select three columns in a worksheet, click the Insert button arrow, and then click Insert Sheet Columns?
Three columns are inserted immediately to the left of the selected columns
By default, when inserting a column in a worksheet, the new column is placed…
immediately to the left of the column containing the active cell
Which of the following changes in text format can you not make on the Font tab of the Format Cells dialog box?
Orientation
When text is too long to fit in a cell, it normally overlaps into the next cell to the right. If you want data to remain in a cell and wrap to the next line within the same cell, select the _____ option at the Format Cells dialog box.
Wrap text
How is clearing cell contents different from deleting cells?
Clearing cell contents gives you the option of removing both contents and formatting from a cell
To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position.
Select All button
When you insert rows into a worksheet, all references affected by the insertion…
are automatically adjusted
The Clipboard group on the HOME tab contains the _____ button, which can be used to copy formatting to different locations in the worksheet.
format printer
You can insert a new row in a worksheet by clicking the Insert button arrow, clicking Insert Cells, and then clicking this at the Insert dialog box.
entire row
You can specify the formatting for numbers in a cell…
(?)
What does the Orientation button in the Alignment group do?
rotates data in a cell
If you enter numbers into a cell, they will be automatically aligned…
at the right side of the cell
If you want to copy formatting to several different locations in a worksheet, select the cell that contains the desired formatting and then _____ the Format Painter button.
double click
What happens if you select multiple columns and then drag one of the selected column boundaries?
all selected column widths change
To add a background color to a selected cell, use the _____ button in the Font group on the HOME tab.
fill color
To reduce the size of the text font so that all selected data fits within a column, click the _____ option on the Alignment tab in the Format Cells dialog box.
shrink to fit
Which component of a theme consists of a set of line and fill effects?
effects theme
On which tab in the Format Cells dialog box can you choose the degrees to rotate text?
alignment
Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column?
accounting
The gridlines that display in a worksheet..
do not print by default
To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a _____, then drag the boundary to the desired height.
double headed arrow pointing up and down
Using the Delete key to delete cells…
only deletes the cell contents
You can see how a theme will affect your worksheet before you apply it by using the _____ feature.
live preview
Approximately how many points are contained in a vertical inch?
72
When a row height is being changed, the row height number that displays represents a measurement in…
points
What happens if you select and merge a block of cells that contain data?
Only the data in the upper left cell of the block will be retained.
Select the rows or columns you do not want to display on the screen and point to Hide & Unhide…
(?) in the drop-down menu of the Format button in the Cells group on the HOME tab
Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats.
Number Format
You can adjust a column width to fit the longest entry in the column by double-clicking…
on the column boundary line
Excel measures row height in _____ and column width in _____.
points; characters
Right-clicking in a cell will display the…
mini toolbar
Which of these formatting options is not found in the Font group on the HOME tab?
superscript
By default, all columns in a worksheet…
are all the same width
In which number category can you specify the formatting for Zip codes?
Special
This number category in the Format Cells dialog box is used for very large or very small numbers.
Scientific
To delete a row, select the row and then click the Delete button in the _____ group on the _____ tab.
Cells; HOME
When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?
You specify the range in the Rows to repeat at top text box in the Page Setup dialog box
At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?
to print row and column titles on multipage worksheets
What generally displays in the Sort By option box at the Sort dialog box?
the title of the first column of selected cells
Using the _____ dialog box to sort data in a column maintains the relationship among the data.
sort
Which of the following is not one of the paper sizes for an Excel worksheet at the Size button drop-down list?
landscape
If you undo an action with the Undo button on the Quick Access Toolbar and then decide that you want to reinstate the action, what should you do?
Press the Redo button
Use the Background button in the Page Setup group on the Page Layout tab to do which of the following?
Insert into the worksheet a background picture that displays behind the data
A restriction placed temporarily on data in a worksheet to isolate specific data is called a(n)…
filter
What are the two options for page orientation in the Page Setup group on the Page Layout tab?
portrait and landscape
You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and
in the Sheet Options group on the Page Layout tab
Do the worksheet gridlines appear by default when printed? If not, can you instruct Excel to print them? How?
No, the gridlines do not print by default, but you can print them by checking the Print check box in the Sheet Options group on the Page Layout tab.
Use this keyboard shortcut to redo an action.
CRTL + Y
Using options at the Page Setup dialog box with the Margins tab selected, you can center a worksheet…
both vertically and horizontally on a page
Excel’s spelling check feature reviews the worksheet from _____ to _____.
the active cell; the last cell in the worksheet that contains data
Use the Search option at the expanded Find and Replace dialog box to search by _____ or _____.
rows; columns
To sort data by a column other than the default column, which of the following methods should you use?
Click the Sort & Filter button and then click Custom Sort
Page breaks display as _____ along cell borders in a worksheet.
dashed lines
To use Excel’s spelling check feature, click the Spelling button in the _____ group on the_____ tab.
Proofing; Review
To fit all the data in a worksheet on one page when printed, you should use the _____ on the Page Layout tab.
buttons in the Scale to Fit group
Use the Print Area button in the Page Setup group on the Page Layout tab to…
print specific areas of a worksheet.
You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and…
in the Sheet Options group on the Page Layout tab
When you click the Sort & Filter button on the Home tab, data will be sorted in…
selected cells
When you filter data, the filter arrow in the column header turns into a(n) _____ icon.
funnel
How do you display the Find and Replace dialog box?
Click the Find & Select button in the Editing group on the Home tab and then click Find.
Which of the following buttons is not found on the Header & Footer Tools Design tab?
background
What are the default left/right and top/bottom margins of an Excel worksheet?
0.7 inch and 0.75 inch
You can preview headers and footers before printing the worksheet…
at the Print backstage area
When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?
You specify the range in the Rows to repeat at top text box in the Page Setup dialog box.
Filter options are available in the _____ group on the _____ tab.
Editing; Home
You can adjust the printed output of a worksheet by a percentage using an option in the _____ group.
Scale to Fit
You can use the Undo button to…
reverse a command
If you specify multiple print areas in a worksheet, how will they print?
The areas will print on separate pages
At the Page Setup dialog box with the Margins tab selected, you can set margins and…
adjust the distance between the header or footer and the top or bottom of the page
When creating different odd and even page headers, clicking the Different odd and even pages check box and then clicking the Custom Header button at the Page Setup dialog box with the Header/Footer tab selected will display the _____ dialog box with the _____ tab selected.
Header; Odd Page Header
Clicking the filter arrow in a heading will display a list of options to do all the following except…
sort all the records
To perform a find and replace operation across an entire workbook, you should change the _____ option to Workbook at the Find and Replace dialog box.
Within
Which of the following is not a sort option at the Sort & Filter button drop-down list?
Sort Even/Odd
Click the Page Break Preview button to view worksheet pages and page breaks and to change which of the following?
worksheet page breaks
To remove formatting at the Find and Replace dialog box, click the Clear Find Format option at the _____ button drop-down list.
Find
At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?
to print row and column titles on multipage worksheets
If the selected cells contain dates, what sort options will be provided at the Sort & Filter button drop-down list?
Sort Oldest to Newest and Sort Newest to Oldest
You can use headers and footers to print which of the following?
text, such as page numbers, at the top and bottom of each page
At the Page Setup dialog box with the Margins tab selected, the value in the Header measurements box is which of the following?
the distance from the top of the page to the header
When you click the Header & Footer button, the worksheet displays in _____view.
Page Layout
What happens if you select a column in a worksheet and then click Insert Page Break on the Breaks button?
A page break is inserted left of the column
Excel is primarily a spreadsheet program, but it also contains some basic _____ functions, such as sorting data.
database
Can you specify more than one print area? If so, how?
Yes, by selecting the first print area, clicking the Print Area button, clicking Set Print Area, selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area
When data is sorted using the Sort & Filter button, it is sorted by which column?
the first selected column
At the expanded Find and Replace dialog box, you can do which of the following?
Search for specific cell formatting and replace it with other formatting
Which of these tasks cannot be accomplished using options on the Header & Footer Tools Design tab?
displaying selected rows of data in the header on every page
When you use the Filter feature, a(n) _____ appears with each column label in the worksheet.
arrow
Insert and customize headers and footers with options at the _____ dialog box with the Header/Footer tab selected.
Page Setup
When would you use the Then by option at the Sort dialog box?
to sort by more than one column
Specify how cells are pasted in a worksheet with options at which of the following?
the Paste Options button drop-down list
Display a shortcut menu with options for managing worksheets by…
right-clicking a worksheet tab
Instead of using the sheet tab shortcut menu, you can copy a worksheet by doing which of the following?
pressing and holding down the Ctrl key while dragging the worksheet tab from one location to another
One method of moving to a range of cells is by using options at the _____ dialog box.
Go To
After selecting cells to be moved and clicking the Cut button, how do you move them to their new location?
Click the cell where the first selected cell should be inserted and then click the Paste button
The moving dashed line border that surrounds cells after you have selected them and clicked the Copy button is called a…
marquee
A group of selected cells is referred to as a…
range
You can move to a different worksheet in a workbook by…
clicking the desired worksheet tab
The Define Name button is in the Defined Names group on the _____ tab.
Formulas
When pasting cells that contain a value and a formula, you can use options at the Paste Option button drop-down list to insert all the following except…
the formula as a value
Use the _____ and _____ buttons in the upper right corner of the active workbook to change the size of the active workbook in the screen.
Maximize; Minimize
Where are the tab scroll buttons that allow you to navigate the worksheet tabs?
left of the sheet tabs
To see which workbooks are open, hover the mouse pointer over the _____ to display thumbnails of the workbooks.
Excel button on the taskbar
By clicking the Hide button in the Window group on the View tab, you can…
hide the active workbook
Which of the following is not a formatting option when pasting Excel data in a Word document?
embed text
Excel allows linking data between which of the following?
worksheets in the same or different workbooks
Arrange the display of _____ at the Arrange Windows dialog box.
multiple workbooks that are open at the same time
Excel’s split window feature is useful for displaying…
all the cells in a worksheet at one time
To link data between worksheets, begin by doing which of the following?
making active the cell(s) containing the data to be linked
The _____ button provides a variety of options for pasting data in a worksheet, another workbook, or a document created in another program.
Paste Options
Use _____ to collect and paste multiple items.
the Clipboard task pane
In a workbook with multiple worksheets, which worksheet will Excel print by default?
the worksheet that is currently displayed
How can you see a list of what workbooks are currently open?
by clicking the View tab and then clicking the Switch Windows button in the Window group
Which of the following is not one of the options at the Arrange Windows dialog box?
Diagonal
When a worksheet window is split, each section is referred to as a…
pane
Use keyboard command Ctrl + _____ to copy selected data.
C
A range of cells cannot be…
given a name containing a space
You can copy and paste data between Excel and…
Word
Which of the following is not one of the options for moving data from one section of a worksheet to another?
the Format Cells button in the Cells group on the Home tab
When data in Excel is linked, the worksheet that contains the original data is referred to as the _____ worksheet.
source
Which of the following tasks cannot be performed at the sheet tab shortcut menu?
format a worksheet
Select nonadjacent worksheet tabs by clicking the first sheet tab, pressing and holding down the _____ key, and then clicking other tabs to be selected.
CTRL
You can name a range by selecting the cells and then typing a name into…
the Name box
Split lines display in a worksheet as….
thick light grey lines
When you move a worksheet by dragging it, what icon appears next to the mouse pointer?
a page icon
What happens when you select cells in a worksheet and then click the Copy button?
a moving dashed line border appears around the cells
A new Excel workbook contains _____ worksheet(s) by default, but additional worksheets can be added.
one
What should you do first to copy cells?
Select the cells to be copied
Use the Delete button in the _____ group on the _____ tab to delete a worksheet.
Cells; Home
How do you display the Clipboard task pane?
Click the Clipboard group task pane launcher in the Clipboard group on the Home tab
You can open nonadjacent workbooks at one time at the Open dialog box by clicking the name of the first workbook, pressing and holding down the _____ key, and then clicking the names of the other workbooks.
CTRL
You can print multiple worksheets in a workbook with options…
at the Print backstage area
A worksheet window can be split in which of the following ways?
horizontally and vertically
What happens when you freeze the window panes?
Only one active cell is displayed when you cross a pane boundary
The combining of data from files created by two or more programs (e.g., Excel and Word) into one file is referred to as…
integration
Will moving a worksheet from one workbook to another affect formulas in the source workbook that are not on the sheet that is moved?
Yes, if the formulas depend on the contents of cells in the sheet that was moved
To modify a cell style, begin by clicking the Cell Styles button in the _____ group on the _____ tab.
Styles; Home
What happens when you clear the contents of the Recent option list?
The list is emptied, except for pinned workbooks
If you are creating a hyperlink to a cell within the same worksheet, what do you enter in the Type the cell reference text box at the Insert Hyperlink dialog box?
the cell name being linked to
When moving a worksheet to another workbook, start by performing which of the following steps?
Open both the source and destination workbooks
To remove a style from cells, select the cells, click the Cell Styles button, and then click the _____ style at the drop-down gallery.
Normal
You can insert a hyperlink in a workbook for each of the following purposes except…
to copy data from another workbook
How do you make the Edit button appear in a comment?
Click in the cell and then position the mouse pointer inside the comment box
From the New backstage area, click a template to preview it, and click the _____ button to open a new document based on the template.
Create
To define a style with existing formatting, select the cell or cells containing the formatting and then perform which of the following steps?
Click the Cell Styles button in the Styles group on the Home tab and then click the New Cell Style option at the drop-down gallery
The _____ function finds the payment for a loan based on constant payments and a constant interest rate.
PMT
You can apply a style from the _____ button drop-down gallery or create a new style.
(?)
NOT Styles
To display installed templates, click the _____ tab and then click the _____.
File; New option
To apply a style, select the cell(s) to which the style will be applied, click the Cell Styles button in the Styles group and then…
pick a style from the drop-down gallery
To link an Excel workbook to a workbook or file in another application, display the Insert Hyperlink dialog box and then click the _____ or _____ button in the Link to section.
Existing File; Web Page
To enter information in placeholders in a worksheet, move the insertion point by pressing _____ to make the next cell active and _____ to make the previous cell active.
the Tab key; Shift + Tab
You can copy styles from one workbook to another at the…
Merge Styles dialog box.
To insert a comment in a cell using the shortcut menu, right-click the cell and then click the _____ option at the shortcut menu.
New Comment
If you delete a style from the Cell Styles gallery, what will happen?
Formatting applied by the deleted style will be removed from all the cells in the worksheet
When copying a worksheet from one workbook to another, which of the following steps is not performed at the Move or Copy dialog box?
Select the name of the source workbook
You can “unpin” a workbook from the Recent option list by _____ the workbook name and then clicking the Unpin from list option.
right-clicking
Which of the following is not one of the advantages of using a style to apply formatting to cells?
Doing so allows you to apply formatting attributes that are not available without a style
What displays when you hover the mouse pointer over a hyperlink?
a ScreenTip with the address of the hyperlinked location
To create a hyperlink to an email address, click the E-mail Address button in the _____ section of the Insert Hyperlink dialog box.
Link to
How do you create a hyperlink with a graphic?
Select the graphic, click the Insert tab, and then click the Link button
To view all comments at a glance, open the _____ by clicking the Show Comments button in the Comments group on the Review tab.
Comments task pane
To define a custom style without first applying formatting, begin by displaying the _____ dialog box.
Style
Which of the following arguments is the present value of an investment, expressed in a lump sum?
PV
Excel provides a number of financial _____, such as PMT, that can be used in formulas.
Functions
The styles you define in a workbook are available…
only in that workbook
To copy a worksheet from one workbook to another, begin by opening…
both the source and the destination workbooks
The _____ function calculates the future value of a series of equal payments or an annuity.
FV
Hover the mouse pointer over a style in the _____ button drop-down gallery and the cell or selected cells display with the formatting applied.
Cell Styles
Close the Comments task pane by clicking the _____ button in the task pane or by clicking the _____ button.
Close; Show Comments
A predefined set of formatting attributes (such as font size, alignment, borders, and so forth) is called a…
cell style
Generally, the names of the _____ most recently opened workbooks display in the Recent option list.
50
A _____ is a pop-up box that is attached to a cell and contains text pertaining to the contents of the cell.
comment
When you “pin” a workbook in Excel, what are you pinning it to?
the Recent option list
If a worksheet contains the annual percentage rate (APR), enter the cell reference in the function argument and specify that it should be divided by…
12 months
What is a template worksheet form?
a form preformatted for specific uses (balance sheet, sales invoice, etc.) that can be used when creating a new workbook
To delete all the comments in a thread, click the _____ button and then click Delete thread at the drop-down list.
Thread options
A list of the most recently opened workbooks is available in several places but not at…
the Print backstage area
When you click the Recover Unsaved Workbooks button, the _____ dialog box displays with the names of the workbooks that Excel has saved automatically.
(?)
What happens if you delete the Normal cell style?
The Normal style cannot be deleted
To modify a hyperlink, begin by _____ the hyperlink.
right-clicking
By default, the automatic formatting of hyperlinks is turned on; you can turn this off at the _____ dialog box.
AutoCorrect
To insert a hyperlink, begin by clicking the _____ tab and then click the Link button in the _____ group.
Insert; Links
Insert and manage comments with buttons in the _____ group on the _____ tab.
Comments; Review
Where do you edit the text of a hyperlink you have already inserted?
in the cell
A chart is a picture of numeric data and is sometimes referred to as a…
Graph
Shapes can be formatted with options on the _____ tab.
Drawing Tools Format
The left side of a column chart created by Excel is referred to as the…
vertical axis
Use an IF function to create a logical test that performs different actions if the answer is _____ or _____.
true; false
What is the first step in creating a chart?
Select the cells that contain the data to be charted
Options for inserting shapes into a chart are provided in which of the following?
the Insert Shapes group on the Chart Tools Format tab
A question that can be answered true or false is considered a…
logical test
A(n) _____ chart emphasizes the magnitude of change rather than the rate of change.
area
A(n) _____ chart displays values in vertical bars and is useful for comparing items or showing how values vary over time.
column
To move a chart created in an existing worksheet, first select the chart and then perform which of the following steps?
Position the mouse pointer on a border until it becomes a four-headed arrow and then click and drag the chart to the location
Selecting a chart and then pressing the Delete key will delete which of the following?
only the chart
To increase the height and width of a chart at the same time, drag _____ sizing handles.
the corner
Click the _____ button to return the formatting of a chart element back to the original style.
Reset to Match Style
To include text in an IF statement, you must do which of the following?
Put quotation marks around the text
Display the Function Arguments dialog box by clicking the Logical button in the Function Library group on the _____ tab and then clicking IF at the drop-down list.
Formulas
To move a chart element, select it, _____, click and hold down the left mouse button, and then drag the element to the desired location.
move the mouse pointer over the border until it turns into a four-headed arrow
To change the data for a chart, edit the data in the specific cells and the corresponding sections of the chart will _____ automatically.
update
A _____ is a type of chart that provides a hierarchical view of data and compares proportions within the hierarchy.
treemap
You can delete a chart element by _____ it and then clicking Delete at the shortcut menu.
right-clicking
The condition and the action in an IF function are separated by which of the following?
comma
When a chart has been created in the same worksheet as its data cells, you can change the size of the chart using the _____ on the chart’s border.
white circles
Excel’s _____ feature provides in one location buttons and options for inserting charts, sparklines, and conditional formatting plus common formulas.
Quick Analysis
Which of the following types of charts is useful in comparing values and showing categories across geographical regions?
map
Which of the following is not one of the options on the Quick Analysis Toolbar?
Photos
In a column chart created by Excel, the horizontal axis runs along the _____ of the chart.
bottom
What appears around a chart when it is selected?
boarder with sizing handles
To change how data are grouped along the bottom and left side of a chart, make the chart active and then click the _____ button in the Data group on the Chart Tools Design tab.
Switch Row/Column
Which of the following options is not provided at the Function Arguments dialog box when creating an IF function?
Value_test
Suppose that you are writing a formula with an IF statement using the Function Arguments dialog box. If you type YES in the Value_if_true text box and then press the Enter key, what will happen to the word YES?
Quotation marks will be added around it
When a chart on Sheet1 is moved to a new sheet, the default name for that new sheet is…
Chart1
Which of these keyboard shortcuts will create a chart from the selected cells?
Alt + F1
If a worksheet contains rows or columns of data that you do not want to chart, Chapter 7 suggests that you _____ them.
hide
How can you delete a chart element?
Click the element and then press the Delete key
To write a formula with an IF function, type the _____ followed by what is evaluated in the Logical_test text box.
(?)
NOT Function
When you select a chart and then display the Print backstage area, the first gallery in the Settings category is automatically changed to…
Print Selected Chart
You can change the chart type of an existing chart by selecting the chart and using buttons and options…
on the Chart Tools Design tab
Which of the following is not one of the chart formatting buttons that displays at the right of a chart border?
Change Chart
Two options for changing the chart location are provided in the Move Chart dialog box: _____ and _____.
New sheet; Object in
By default, Excel creates the legend for a chart using the…
column headings
To insert a new chart in a separate worksheet, not the same worksheet that contains the chart’s data, you should press which of the following?
the F11 function key
A variety of formatting changes can be made to a chart or chart element with options on the Chart Tools Format tab. Which of the following is not one of them?
changing the data range
To print only the chart in a worksheet (not also the data in cells), first _____ and then display the Print backstage area.
click the chart to select it
The _____ tab provides options for applying WordArt formatting to data in a chart.
Chart Tools Format
When a shape has been selected for insertion into a chart, the mouse pointer turns into a…
thin black plus symbol (crosshairs)
A _____ chart shows overall change over time at even intervals and emphasizes the rate of change rather than the magnitude of change.
line
Which of the following types of charts plots the interception points between x and y values and is commonly used for scientific data?
XY (scatter)
You can change the format of numbers with buttons in the _____ group on the _____ tab.
Number; HOME
Use this keyboard shortcut to cut selected data.
CTRL + X
How do you delete a SmartArt graphic?`
Select it and then press the Delete key
To restore the default layout and color to a SmartArt graphic, click the _____ button.
Reset Graphic
Which of these Excel features is useful for creating company logos and headings?
WordArt
Which of the following tasks cannot be completed with options and buttons on the SmartArt Tools Design tab?
resizing the diagram
Generally, when adding images to a worksheet, you would use a _____ to represent text and a _____ to represent numbers.
SmartArt graphic; chart
What happens when you double-click a symbol at the Symbol dialog box?
The symbol is inserted in the worksheet
Click the _____ group task pane launcher or the Size group task pane launcher and the Format Picture task pane displays at the right of the screen.
Picture Styles
Which of the following steps is not performed to insert an online image into a worksheet?
Link the image
To maintain the proportions of an image while resizing it with the sizing handles, press and hold down the _____ key while dragging a sizing handle.
Shift
Click a graphic in the middle panel of the SmartArt Graphic dialog box and the name of the graphic type and a description of it display in the _____ panel.
right
Use the _____ that appears with transformed WordArt text to change the slant of the text.
small yellow circle
When you apply a transform shape to WordArt text, a small _____ displays below the text.
yellow circle
You can customize many characteristics of WordArt text, including colors, lines, and size, at the _____ tab.
Drawing Tools Format
To insert WordArt in an Excel worksheet, begin by clicking the _____ tab.
Insert
Click the _____ button to remove unwanted parts of an image.
Crop
Use the middle sizing handles around a SmartArt graphic to increase or decrease its _____ or _____.
height; width
You can resize an inserted image by selecting the image and then…
dragging the sizing handles
Shapes from the Lines section of the Shapes button drop-down list are considered line drawings, whereas shapes from other sections of the list are considered…
enclosed objects
The SmartArt button is in the _____ group on the _____ tab.
Illustrations; Insert
When you click the Shapes button and then click a shape, the mouse pointer displays as…
crosshairs
To make an image taller or shorter, use the _____ sizing handles at the _____ of the image.
middle; top and bottom
Which of the following is not one of the options provided by buttons in the Adjust group on the Picture Tools Format tab?
(?)
NOT Change the brightness and contrast of an image
To change both the height and width of an inserted image at the same time, use the sizing handles _____ of the image.
at the corners
In addition to the icon, two other icons are available in the Format Picture task pane: the Fill & Line icon and the _____ icon.
(?)
NOT Formatting
Insert symbols and special characters in a worksheet by clicking the _____ button in the Symbols group on the Insert tab.
Symbol
When you click an option at the WordArt button drop-down list, the text _____ is inserted in the worksheet and formatted in the option you selected at the list.
Your text here
When using the Shapes button to draw a shape in a worksheet, what is the final step after dragging to create the shape?
Release the mouse button
The _____ button is useful for capturing information from a web page or from a file in another program.
Screenshot
When you click a text box to select it, a _____ border and sizing handles display around it.
dashed
Can the Symbol dialog box be resized? If so, how?
Yes, by dragging a corner of the dialog box with the mouse
Change the formatting of a SmartArt graphic with options…
on the SmartArt Tools Format tab
In addition to the Effects icon and the Size & Properties icon, two other icons are available in the Format Picture task pane: the Fill & Line icon and the _____ icon.
(?)
NOT Formatting
NOT Custom
What does the Compress Pictures button do?
It reduces the size of the image file to save space on the storage medium
What happens after you have selected the Screen Clipping option at the Screenshot button drop-down list?
The open web page, file, or Windows desktop displays in a dimmed manner and the mouse pointer displays as crosshairs
Text can be typed in a(n) _____ and then formatted using buttons in the WordArt Styles group or options on the Home tab.
line drawing
To remove a WordArt style from text but retain the text, click the More WordArt Styles button in the WordArt Styles group on the _____ tab and then click Clear WordArt.
Drawing Tools Format
To change the height and width of WordArt text, use the…
white sizing handles
Which of the following will display if you do not have a web page or file open when using the Screenshot feature?
the Windows desktop
Where is the Screenshot button?
in the Illustrations group on the Insert tab
What appears when an image is inserted in a worksheet?
the Picture Tools Format tab
When a text box is selected, the _____ tab displays with options for customizing the text box.
Drawing Tools Format
You can copy a shape to another location in the worksheet by dragging the shape while pressing and holding down the _____ key.
CTRL
To insert an image found online, click the image and then click the _____ button or double-click the image.
Insert
Double-click one of the predesigned graphics in the middle panel of the _____ dialog box with All selected and the graphic is inserted in the worksheet.
SmartArt
Use the _____ feature to distort or modify text so it conforms to a variety of shapes.
WordArt
When drawing an enclosed object, maintain the proportions of the shape by pressing and holding down the _____ key(s) while dragging with the mouse.
Shift
Use the Bing Image Search feature to search for _____ online.
Images
When the New sheet option is selected in the Move Chart dialog box, where will the chart be placed?
in a new worksheet
You can display the _____ task pane by right-clicking a chart or chart element and then clicking a format option at the shortcut menu.
(?)
When you click the Text Box button in the Text group on the Insert tab, the mouse pointer displays as
(?)
NOT crosshairs
crosslike pointer?
You can enter text directly into a SmartArt graphic shape or display a _____ and then type the text there.
text pane
When a shape is inserted in a worksheet, the _____ tab becomes active.
Drawing Tools Format
Use this keyboard shortcut to insert a new worksheet in a workbook.
Shift + F11
To hide a worksheet, start by clicking the _____ button in the Cells group on the Home tab.
Format
This button displays when you fill cells with the fill handle.
Auto Fill Options Button
Which Excel feature helps you insert a series in a row or column of cells?
AutoFill
When writing the PMT function, where will you find options for inserting cell designations for Rate, Nper, and Pv?
at the Function Arguments dialog box
Clicking the Online Pictures button displays which of the following?
the Online Pictures window
You can select adjacent cells with your mouse by
clicking and dragging over the desired cells
Which of the following is not one of the types of charts you can create using the buttons provided in Excel?
(?)
NOT surface
