ALL OF LEVEL ONE Flashcards
1
Q
when the mouse pointer displays as a white plus sign, it is referred to as the…
A
cell pointer
2
Q
when you click the AutoSum button, Excel looks first for a range of cells containing numbers _____ the active cell, and then _____ the active cell.
A
above
left of
3
Q
display the Open backstage area by clicking the FILE tab and then clicking the Open option, or by pressing…
A
CRTL + O
4
Q
pressing Ctrl + Home will take you to the…
A
first cell of the worksheet
5
Q
clicking the Quick Print button will…
A
send the workbook directly to the printer
6
Q
to select all cells from the active cell to the beginning of the row, press…
A
shift + home
7
Q
which keyboard command closes Excel?
A
Alt + F4
8
Q
which keyboard shortcut displays the Go To dialog box?
A
CRTL + G
9
Q
which of the following is not a valid name for an Excel workbook?
A
MyBudget/version2.xlsx
10
Q
by default, numbers in a cell are aligned at the _____ and decimals and commas _____ display.
A
right
will not
11
Q
to select specific characters within a cell (rather than the whole cell), begin by…
A
double clicking in the desired cell
12
Q
Which element of an Excel worksheet displays the active cell address or name assigned to the active cell?
A
name box
13
Q
The AutoCorrect feature in Excel automatically corrects…
A
common typing errors
14
Q
What happens if you enter text into a cell and it is too long to fit in the cell?
A
The text overlaps into the cell to the right, but it is not stored in that cell.
15
Q
What is another name for the cell address?
A
cell reference
16
Q
You can select nonadjacent cells with your mouse by
A
holding down the Ctrl key while clicking the desired cells
17
Q
How many buttons display to the left of the search text box in the Excel Help window?
A
5
18
Q
The area of the worksheet that contains tabs with commands and buttons is called the…
A
ribbon
19
Q
When applied to an amount, this button adds a dollar sign, any necessary commas, and a decimal point followed by two decimal digits…?
A
accounting number format
20
Q
Positioning your mouse pointer on the gray boundary line between columns in the column header is the first step toward…
A
changing column width
21
Q
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?
A
pressing Home
22
Q
To merge cells and center text, use the Merge & Center button located in the _____ group on the _____ tab.
A
alignment
home
23
Q
What is the keyboard shortcut to display the Excel Help window?
A
F1
24
Q
An Excel workbook consists of an individual “page” represented by a tab at the bottom of the Excel window. This is called a…
A
worksheet or sheet
25
The keyboard shortcut Alt + = inserts _____ into the active cell.
the SUM function
26
In addition to in its worksheet cell, where else is a data value displayed in Excel?
in the formula bar
27
Where in the worksheet area will you find the Name box?
upper left corner
28
To print a workbook, begin by clicking the _____ tab.
FILE
29
When a cell containing data is active, anything you type will...
take the place of the existing data
30
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
31
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
32
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
33
A workbook name can contain up to _____ characters.
255
34
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
35
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
36
You can make a cell active by left-clicking in it, or you can use...
the Go To feature
37
You can copy a formula to other cells quickly by using...
autofill(?)
37
To enter data in a cell, the cell must be...
active
38
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
39
The horizontal and vertical scroll bars...
shift the display of cells, but do not change the active cell
40
If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle.
ALT
41
When the Trace Error button appears, what is displayed in the upper left corner of the active cell?
a small, dark green triangle
42
What type of cell values will the AVERAGE function ignore and not use in its calculation?
blank cells
43
When writing a formula by pointing, this displays at the left side of the Status bar.
Point
44
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
45
What symbol is used to indicate an absolute cell reference?
$
46
Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?
F4
47
What will happen if you press Ctrl + ` (grave accent)?
the worksheet will display formulas instead of results
48
What does the error code #N/A mean?
an argument parameter has been left out of a function
49
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
50
Which of the following is not one of the categories of functions offered by Excel?
scientific
51
What does the MIN function return?
the minimum function in a range
52
A built-in formula, such as =SUM, is called a(n)...?
function
53
The process of calculating a formula and inserting the value in a cell is referred to as...
returning the result
54
Which of the following formulas shows an example of a mixed cell reference?
=$A$3+B$3
55
Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called...
arguments
56
What does the COUNT function count?
the number of numeric values in a range
57
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
58
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
59
Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
editing
HOME
60
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
61
Use this keyboard command to display the Insert Function dialog box.
Shift + F3
62
An Insert Function button can be found on the FORMULAS tab and...
the formula bar
63
When writing your own formulas, you must begin each formula with...
an equals sign =
64
The Trace Error button is a type of...
smart tag
65
Excel’s functions are grouped into _____ categories.
13
66
Use this function key to update a NOW or TODAY function.
F9
67
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
68
How many functions can Excel perform?
more than 300
69
Which of the following is not one of the types of cell references discussed in Chapter 2?
dynamic
70
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)
71
The function that returns the arithmetic mean of the arguments is called...
average
72
The multiple layers of parentheses in a formula are called...
nested parentheses
73
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
74
At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.
Number1
75
In the Insert Function dialog box, what displays in the Select a function list box?
the most recently used functions
76
An absolute cell reference _____ change when copied to another cell.
does not
77
If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?
MAX
78
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
79
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)
80
Use this keyboard command to display formulas in a worksheet.
Ctrl + `
81
In Excel’s order of operations, which type of operation happens first?
negations
82
This function returns the current date in a date format.
=TODAY()
83
In terms of an Excel formula, what is a constant?
a value entered directly into a formula
84
Indicate what the following formula will do: =B2/C2.
it will divide the contents of cell B2 by the contents of cell C2
85
What error code will display in a cell when a function name is not entered correctly into a formula?
#NAME?
86
Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.
formula auditing
FORMULAS
87
After typing a formula into a cell, you can finish by pressing any of the following keys except...
spacebar
88
The Trace Error button allows you to do each of the following except...
delete the formula containing the error
89
When writing a formula by pointing, how do you end the formula?
press the enter key
90
The Increase Decimal and Decrease Decimal buttons change decimal places for...
existing numbers only
91
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
92
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
93
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
94
Which of the following is not one of the options at the Merge & Center button’s drop-down list?
Merge Workbooks
95
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
96
By default, numbers typed in a cell are formatted to...
right-align, with no decimals or commas unless they are typed in the cell
97
If you enter the value $45.50 into a cell with default formatting, Excel automatically...
applies currency formatting to the number
98
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
99
Which button do you click to display the Column Width dialog box?
Format
100
You can use your mouse to change the height of multiple rows at the same time if the rows are...
adjacent to one another
101
The name of this button in the Font group changes depending on the most recent option it was used to apply.
boarders
102
To give your worksheet a professional look, you can apply a predefined set of colors, fonts, lines and fill effects by...
applying a theme
103
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
104
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
105
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
106
Which of the following changes in text format can you not make on the Font tab of the Format Cells dialog box?
Orientation
107
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
108
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
109
To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position.
Select All button
110
When you insert rows into a worksheet, all references affected by the insertion...
are automatically adjusted
111
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
112
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
113
You can specify the formatting for numbers in a cell...
(?)
114
What does the Orientation button in the Alignment group do?
rotates data in a cell
115
If you enter numbers into a cell, they will be automatically aligned...
at the right side of the cell
116
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
117
What happens if you select multiple columns and then drag one of the selected column boundaries?
all selected column widths change
118
To add a background color to a selected cell, use the _____ button in the Font group on the HOME tab.
fill color
119
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
120
Which component of a theme consists of a set of line and fill effects?
effects theme
121
On which tab in the Format Cells dialog box can you choose the degrees to rotate text?
alignment
122
Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column?
accounting
123
The gridlines that display in a worksheet..
do not print by default
124
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
125
Using the Delete key to delete cells...
only deletes the cell contents
126
You can see how a theme will affect your worksheet before you apply it by using the _____ feature.
live preview
127
Approximately how many points are contained in a vertical inch?
72
128
When a row height is being changed, the row height number that displays represents a measurement in...
points
129
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.
130
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
131
Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats.
Number Format
132
You can adjust a column width to fit the longest entry in the column by double-clicking...
on the column boundary line
133
Excel measures row height in _____ and column width in _____.
points; characters
134
Right-clicking in a cell will display the...
mini toolbar
135
Which of these formatting options is not found in the Font group on the HOME tab?
superscript
136
By default, all columns in a worksheet...
are all the same width
137
In which number category can you specify the formatting for Zip codes?
Special
138
This number category in the Format Cells dialog box is used for very large or very small numbers.
Scientific
139
To delete a row, select the row and then click the Delete button in the _____ group on the _____ tab.
Cells; HOME
140
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
141
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
142
What generally displays in the Sort By option box at the Sort dialog box?
the title of the first column of selected cells
143
Using the _____ dialog box to sort data in a column maintains the relationship among the data.
sort
144
Which of the following is not one of the paper sizes for an Excel worksheet at the Size button drop-down list?
landscape
145
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
146
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
147
A restriction placed temporarily on data in a worksheet to isolate specific data is called a(n)...
filter
148
What are the two options for page orientation in the Page Setup group on the Page Layout tab?
portrait and landscape
149
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
150
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.
151
Use this keyboard shortcut to redo an action.
CRTL + Y
152
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
153
Excel’s spelling check feature reviews the worksheet from _____ to _____.
the active cell; the last cell in the worksheet that contains data
154
Use the Search option at the expanded Find and Replace dialog box to search by _____ or _____.
rows; columns
155
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
156
Page breaks display as _____ along cell borders in a worksheet.
dashed lines
157
To use Excel’s spelling check feature, click the Spelling button in the _____ group on the_____ tab.
Proofing; Review
158
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
159
Use the Print Area button in the Page Setup group on the Page Layout tab to...
print specific areas of a worksheet.
160
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
161
When you click the Sort & Filter button on the Home tab, data will be sorted in...
selected cells
162
When you filter data, the filter arrow in the column header turns into a(n) _____ icon.
funnel
163
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.
164
Which of the following buttons is not found on the Header & Footer Tools Design tab?
background
165
What are the default left/right and top/bottom margins of an Excel worksheet?
0.7 inch and 0.75 inch
166
You can preview headers and footers before printing the worksheet...
at the Print backstage area
167
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.
168
Filter options are available in the _____ group on the _____ tab.
Editing; Home
169
You can adjust the printed output of a worksheet by a percentage using an option in the _____ group.
Scale to Fit
170
You can use the Undo button to...
reverse a command
171
If you specify multiple print areas in a worksheet, how will they print?
The areas will print on separate pages
172
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
173
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
174
Clicking the filter arrow in a heading will display a list of options to do all the following except...
sort all the records
175
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
176
Which of the following is not a sort option at the Sort & Filter button drop-down list?
Sort Even/Odd
177
Click the Page Break Preview button to view worksheet pages and page breaks and to change which of the following?
worksheet page breaks
178
To remove formatting at the Find and Replace dialog box, click the Clear Find Format option at the _____ button drop-down list.
Find
179
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
180
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
181
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
182
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
183
When you click the Header & Footer button, the worksheet displays in _____view.
Page Layout
184
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
185
Excel is primarily a spreadsheet program, but it also contains some basic _____ functions, such as sorting data.
database
186
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
187
When data is sorted using the Sort & Filter button, it is sorted by which column?
the first selected column
188
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
189
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
190
When you use the Filter feature, a(n) _____ appears with each column label in the worksheet.
arrow
191
Insert and customize headers and footers with options at the _____ dialog box with the Header/Footer tab selected.
Page Setup
192
When would you use the Then by option at the Sort dialog box?
to sort by more than one column
193
Specify how cells are pasted in a worksheet with options at which of the following?
the Paste Options button drop-down list
194
Display a shortcut menu with options for managing worksheets by...
right-clicking a worksheet tab
195
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
196
One method of moving to a range of cells is by using options at the _____ dialog box.
Go To
197
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
198
The moving dashed line border that surrounds cells after you have selected them and clicked the Copy button is called a...
marquee
199
A group of selected cells is referred to as a...
range
200
You can move to a different worksheet in a workbook by...
clicking the desired worksheet tab
201
The Define Name button is in the Defined Names group on the _____ tab.
Formulas
202
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
203
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
204
Where are the tab scroll buttons that allow you to navigate the worksheet tabs?
left of the sheet tabs
205
To see which workbooks are open, hover the mouse pointer over the _____ to display thumbnails of the workbooks.
Excel button on the taskbar
206
By clicking the Hide button in the Window group on the View tab, you can...
hide the active workbook
207
Which of the following is not a formatting option when pasting Excel data in a Word document?
embed text
208
Excel allows linking data between which of the following?
worksheets in the same or different workbooks
209
Arrange the display of _____ at the Arrange Windows dialog box.
multiple workbooks that are open at the same time
210
Excel’s split window feature is useful for displaying...
all the cells in a worksheet at one time
211
To link data between worksheets, begin by doing which of the following?
making active the cell(s) containing the data to be linked
212
The _____ button provides a variety of options for pasting data in a worksheet, another workbook, or a document created in another program.
Paste Options
213
Use _____ to collect and paste multiple items.
the Clipboard task pane
214
In a workbook with multiple worksheets, which worksheet will Excel print by default?
the worksheet that is currently displayed
215
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
216
Which of the following is not one of the options at the Arrange Windows dialog box?
Diagonal
217
When a worksheet window is split, each section is referred to as a...
pane
218
Use keyboard command Ctrl + _____ to copy selected data.
C
219
A range of cells cannot be...
given a name containing a space
220
You can copy and paste data between Excel and...
Word
221
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
222
When data in Excel is linked, the worksheet that contains the original data is referred to as the _____ worksheet.
source
223
Which of the following tasks cannot be performed at the sheet tab shortcut menu?
format a worksheet
224
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
225
You can name a range by selecting the cells and then typing a name into...
the Name box
226
Split lines display in a worksheet as....
thick light grey lines
227
When you move a worksheet by dragging it, what icon appears next to the mouse pointer?
a page icon
228
What happens when you select cells in a worksheet and then click the Copy button?
a moving dashed line border appears around the cells
229
A new Excel workbook contains _____ worksheet(s) by default, but additional worksheets can be added.
one
230
What should you do first to copy cells?
Select the cells to be copied
231
Use the Delete button in the _____ group on the _____ tab to delete a worksheet.
Cells; Home
232
How do you display the Clipboard task pane?
Click the Clipboard group task pane launcher in the Clipboard group on the Home tab
233
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
234
You can print multiple worksheets in a workbook with options...
at the Print backstage area
235
A worksheet window can be split in which of the following ways?
horizontally and vertically
236
What happens when you freeze the window panes?
Only one active cell is displayed when you cross a pane boundary
237
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
238
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
239
To modify a cell style, begin by clicking the Cell Styles button in the _____ group on the _____ tab.
Styles; Home
240
What happens when you clear the contents of the Recent option list?
The list is emptied, except for pinned workbooks
241
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
242
When moving a worksheet to another workbook, start by performing which of the following steps?
Open both the source and destination workbooks
243
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
244
You can insert a hyperlink in a workbook for each of the following purposes except...
to copy data from another workbook
245
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
246
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
247
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
248
The _____ function finds the payment for a loan based on constant payments and a constant interest rate.
PMT
249
You can apply a style from the _____ button drop-down gallery or create a new style.
(?)
NOT Styles
250
To display installed templates, click the _____ tab and then click the _____.
File; New option
251
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
252
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
253
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
254
You can copy styles from one workbook to another at the...
Merge Styles dialog box.
255
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
256
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
257
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
258
You can “unpin” a workbook from the Recent option list by _____ the workbook name and then clicking the Unpin from list option.
right-clicking
259
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
260
What displays when you hover the mouse pointer over a hyperlink?
a ScreenTip with the address of the hyperlinked location
261
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
262
How do you create a hyperlink with a graphic?
Select the graphic, click the Insert tab, and then click the Link button
263
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
264
To define a custom style without first applying formatting, begin by displaying the _____ dialog box.
Style
265
Which of the following arguments is the present value of an investment, expressed in a lump sum?
PV
266
Excel provides a number of financial _____, such as PMT, that can be used in formulas.
Functions
267
The styles you define in a workbook are available...
only in that workbook
268
To copy a worksheet from one workbook to another, begin by opening...
both the source and the destination workbooks
269
The _____ function calculates the future value of a series of equal payments or an annuity.
FV
270
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
271
Close the Comments task pane by clicking the _____ button in the task pane or by clicking the _____ button.
Close; Show Comments
272
A predefined set of formatting attributes (such as font size, alignment, borders, and so forth) is called a...
cell style
273
Generally, the names of the _____ most recently opened workbooks display in the Recent option list.
50
274
A _____ is a pop-up box that is attached to a cell and contains text pertaining to the contents of the cell.
comment
275
When you “pin” a workbook in Excel, what are you pinning it to?
the Recent option list
276
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
277
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
278
To delete all the comments in a thread, click the _____ button and then click Delete thread at the drop-down list.
Thread options
279
A list of the most recently opened workbooks is available in several places but not at...
the Print backstage area
280
When you click the Recover Unsaved Workbooks button, the _____ dialog box displays with the names of the workbooks that Excel has saved automatically.
(?)
281
What happens if you delete the Normal cell style?
The Normal style cannot be deleted
282
To modify a hyperlink, begin by _____ the hyperlink.
right-clicking
283
By default, the automatic formatting of hyperlinks is turned on; you can turn this off at the _____ dialog box.
AutoCorrect
284
To insert a hyperlink, begin by clicking the _____ tab and then click the Link button in the _____ group.
Insert; Links
285
Insert and manage comments with buttons in the _____ group on the _____ tab.
Comments; Review
286
Where do you edit the text of a hyperlink you have already inserted?
in the cell
287
A chart is a picture of numeric data and is sometimes referred to as a...
Graph
288
Shapes can be formatted with options on the _____ tab.
Drawing Tools Format
289
The left side of a column chart created by Excel is referred to as the...
vertical axis
290
Use an IF function to create a logical test that performs different actions if the answer is _____ or _____.
true; false
291
What is the first step in creating a chart?
Select the cells that contain the data to be charted
292
Options for inserting shapes into a chart are provided in which of the following?
the Insert Shapes group on the Chart Tools Format tab
293
A question that can be answered true or false is considered a...
logical test
294
A(n) _____ chart emphasizes the magnitude of change rather than the rate of change.
area
295
A(n) _____ chart displays values in vertical bars and is useful for comparing items or showing how values vary over time.
column
296
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
297
Selecting a chart and then pressing the Delete key will delete which of the following?
only the chart
298
To increase the height and width of a chart at the same time, drag _____ sizing handles.
the corner
299
Click the _____ button to return the formatting of a chart element back to the original style.
Reset to Match Style
300
To include text in an IF statement, you must do which of the following?
Put quotation marks around the text
301
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
302
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
303
To change the data for a chart, edit the data in the specific cells and the corresponding sections of the chart will _____ automatically.
update
304
A _____ is a type of chart that provides a hierarchical view of data and compares proportions within the hierarchy.
treemap
305
You can delete a chart element by _____ it and then clicking Delete at the shortcut menu.
right-clicking
306
The condition and the action in an IF function are separated by which of the following?
comma
307
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
308
Excel’s _____ feature provides in one location buttons and options for inserting charts, sparklines, and conditional formatting plus common formulas.
Quick Analysis
309
Which of the following types of charts is useful in comparing values and showing categories across geographical regions?
map
310
Which of the following is not one of the options on the Quick Analysis Toolbar?
Photos
311
In a column chart created by Excel, the horizontal axis runs along the _____ of the chart.
bottom
312
What appears around a chart when it is selected?
boarder with sizing handles
313
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
314
Which of the following options is not provided at the Function Arguments dialog box when creating an IF function?
Value_test
315
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
316
When a chart on Sheet1 is moved to a new sheet, the default name for that new sheet is...
Chart1
317
Which of these keyboard shortcuts will create a chart from the selected cells?
Alt + F1
318
If a worksheet contains rows or columns of data that you do not want to chart, Chapter 7 suggests that you _____ them.
hide
319
How can you delete a chart element?
Click the element and then press the Delete key
320
To write a formula with an IF function, type the _____ followed by what is evaluated in the Logical_test text box.
(?)
NOT Function
321
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
322
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
323
Which of the following is not one of the chart formatting buttons that displays at the right of a chart border?
Change Chart
324
Two options for changing the chart location are provided in the Move Chart dialog box: _____ and _____.
New sheet; Object in
325
By default, Excel creates the legend for a chart using the...
column headings
326
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
327
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
328
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
329
The _____ tab provides options for applying WordArt formatting to data in a chart.
Chart Tools Format
330
When a shape has been selected for insertion into a chart, the mouse pointer turns into a...
thin black plus symbol (crosshairs)
331
A _____ chart shows overall change over time at even intervals and emphasizes the rate of change rather than the magnitude of change.
line
332
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)
333
You can change the format of numbers with buttons in the _____ group on the _____ tab.
Number; HOME
334
Use this keyboard shortcut to cut selected data.
CTRL + X
335
How do you delete a SmartArt graphic?`
Select it and then press the Delete key
336
To restore the default layout and color to a SmartArt graphic, click the _____ button.
Reset Graphic
337
Which of these Excel features is useful for creating company logos and headings?
WordArt
338
Which of the following tasks cannot be completed with options and buttons on the SmartArt Tools Design tab?
resizing the diagram
339
Generally, when adding images to a worksheet, you would use a _____ to represent text and a _____ to represent numbers.
SmartArt graphic; chart
340
What happens when you double-click a symbol at the Symbol dialog box?
The symbol is inserted in the worksheet
341
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
342
Which of the following steps is not performed to insert an online image into a worksheet?
Link the image
343
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
344
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
345
Use the _____ that appears with transformed WordArt text to change the slant of the text.
small yellow circle
346
When you apply a transform shape to WordArt text, a small _____ displays below the text.
yellow circle
347
You can customize many characteristics of WordArt text, including colors, lines, and size, at the _____ tab.
Drawing Tools Format
348
To insert WordArt in an Excel worksheet, begin by clicking the _____ tab.
Insert
349
Click the _____ button to remove unwanted parts of an image.
Crop
350
Use the middle sizing handles around a SmartArt graphic to increase or decrease its _____ or _____.
height; width
351
You can resize an inserted image by selecting the image and then...
dragging the sizing handles
352
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
353
The SmartArt button is in the _____ group on the _____ tab.
Illustrations; Insert
354
When you click the Shapes button and then click a shape, the mouse pointer displays as...
crosshairs
355
To make an image taller or shorter, use the _____ sizing handles at the _____ of the image.
middle; top and bottom
356
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
357
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
358
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
359
Insert symbols and special characters in a worksheet by clicking the _____ button in the Symbols group on the Insert tab.
Symbol
360
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
361
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
362
The _____ button is useful for capturing information from a web page or from a file in another program.
Screenshot
363
When you click a text box to select it, a _____ border and sizing handles display around it.
dashed
364
Can the Symbol dialog box be resized? If so, how?
Yes, by dragging a corner of the dialog box with the mouse
365
Change the formatting of a SmartArt graphic with options...
on the SmartArt Tools Format tab
366
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
367
What does the Compress Pictures button do?
It reduces the size of the image file to save space on the storage medium
368
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
369
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
370
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
371
To change the height and width of WordArt text, use the...
white sizing handles
372
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
373
Where is the Screenshot button?
in the Illustrations group on the Insert tab
374
What appears when an image is inserted in a worksheet?
the Picture Tools Format tab
375
When a text box is selected, the _____ tab displays with options for customizing the text box.
Drawing Tools Format
376
You can copy a shape to another location in the worksheet by dragging the shape while pressing and holding down the _____ key.
CTRL
377
To insert an image found online, click the image and then click the _____ button or double-click the image.
Insert
378
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
379
Use the _____ feature to distort or modify text so it conforms to a variety of shapes.
WordArt
380
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
381
Use the Bing Image Search feature to search for _____ online.
Images
382
When the New sheet option is selected in the Move Chart dialog box, where will the chart be placed?
in a new worksheet
383
You can display the _____ task pane by right-clicking a chart or chart element and then clicking a format option at the shortcut menu.
(?)
384
When you click the Text Box button in the Text group on the Insert tab, the mouse pointer displays as
(?)
NOT crosshairs
crosslike pointer?
385
You can enter text directly into a SmartArt graphic shape or display a _____ and then type the text there.
text pane
386
When a shape is inserted in a worksheet, the _____ tab becomes active.
Drawing Tools Format
387
Use this keyboard shortcut to insert a new worksheet in a workbook.
Shift + F11
388
To hide a worksheet, start by clicking the _____ button in the Cells group on the Home tab.
Format
389
This button displays when you fill cells with the fill handle.
Auto Fill Options Button
390
Which Excel feature helps you insert a series in a row or column of cells?
AutoFill
391
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
392
Clicking the Online Pictures button displays which of the following?
the Online Pictures window
393
You can select adjacent cells with your mouse by
clicking and dragging over the desired cells
394
Which of the following is not one of the types of charts you can create using the buttons provided in Excel?
(?)
NOT surface
