Excel Exam Flashcards
1
Q
You ____ an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.
A
Bold
2
Q
To erase recent cell entries, use the ____ command on the Quick Access Toolbar..
A
Undo
3
Q
____ computing involves reducing the environmental waste generated when using a computer.
A
Green
4
Q
____ in a worksheet typically contain information that is similar to items in a list.
A
Rows
5
Q
The range of cells receiving a copy is called the ____ area.
A
Destination
6
Q
The cell being copied is called the ____ area.
A
Source
7
Q
The ____ command in the AutoCalculate area displays the number of non blank cells in the selected range.
A
Count
8
Q
The AutoCorrect feature works behind the scenes correcting which of the following mistakes?
A: Two initial capital letters
B: Capitalizes the names of the days
C: Replaces commonly misspelled words with their correct spelling
D: All of the above
A
D: All of the above
9
Q
A ____ is a collection of fonts and color schemes.
A
Theme
10
Q
In ____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
A
Insert
11
Q
Which of the following document properties include title, author, and subject?
A
Standard
12
Q
Which of the following is not a valid entry into a cell that requires numbers?
A
#
13
Q
Excel’s ____ function allows you to add all of the numbers in a range of cells.
A
Sum
14
Q
To toggle between Insert mode and Overtype mode press the ____ key(s).
A
Insert
15
Q
A printed version of a worksheet is called a ____.
A
Hard copy
16
Q
By default, Excel positions text in a cell ____.
A
Left-aligned
17
Q
A(n) ____ chart is drawn on the same worksheet as its data.
A
Embedded
18
Q
To split a merged cell, select the cell and click the ____ button.
A
Merge & Center
19
Q
____ can include information such as the project author, title, subject, and keywords.
A
Metadata
20
Q
____ allow data easily to be summarized and charted.
A
Worksheets
21
Q
The ____ contains areas where you can view and enter document properties.
A
Document Information Panel
22
Q
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
A
Format
23
Q
A ____ chart is used to illustrate changes in data over time.
A
Line
24
Q
In a worksheet, Excel automatically ____ numeric data.
A
Right-aligns
25
If automatic recalculation is disabled, press ____ to redraw charts.
F9
26
You know a cell is active when ____.
a heavy border surrounds the cell
27
```
The font face defines the appearance and shape of which of the following?
A: Letters
B: Numbers
C: Special characters
D: All of the above
```
D: All of the above
28
A(n) ____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for a worksheet.
Requirements
29
The ____ command in the AutoCalculate area displays the highest value in the selected range.
Maximum
30
The vertical axis of a chart is called the ____ axis.
Value
31
To enter a number as text, start the entry with a(n) ____.
Apostrophe
32
The ____ is a blinking vertical line that indicates where the next typed character will appear.
Insertion point
33
____ are the details about a file.
Document properties
34
The ____ feature of Excel works behind the scenes, correcting common mistakes.
AutoCorrect
35
A ____ is a word or phrase that further describes a document.
Keyword
36
____ mode is when Excel replaces the character to the right of the insertion point with what you are currently typing.
Overtype
37
You can select any cell by entering its cell reference in the ____ box on the left side of the formula bar.
Name
38
____ cells involves creating a single cell by combining two or more selected cells.
Merging
39
In Excel, any set of characters containing a letter, hyphen, or space is considered ____.
Text
40
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
Range
41
____ in a worksheet typically contain descriptive information about items in rows.
Columns
42
The ____ on a Worksheet is one in which you can enter data.
Active Cell
43
____ properties include file system properties, such as the date you change or create a file, and statistics, such as the file size.
Automatically updated
44
The opposite of merging cells is ____ cells.
Splitting
45
The procedure of editing a cell contents directly in the cell is called ____.
in-cell editing
46
To do in-cell editing, select the cell, then press the ____ key
F2
47
You can easily obtain a total, an average, or other information about the numbers in a cell by using the ____ area on the status bar.
AutoCalculate
48
A ____ is a word or phrase that further describes a document.
Keyword
49
The small black square located in the lower-right corner of the heavy border around the active cell is called the ____.
Fill Handle
50
The ____ is the order in which arithmetic operators are calculated.
Order of operations
51
____ colors tend to pull away from your worksheet's reader.
Cooler
52
____ allows you to select cells for use in a formula by using the mouse.
Point Mode
53
To verify that a formula contains the intended cell references, use Excel's ____.
Range Finder
54
Use the ____ function to determine the lowest number in a range.
MIN
55
To display your worksheet in formula view, press ____.
CTRL + ACCENT MARK
56
The ____ function displays the highest value in a range
MAX
57
The ____ version of a worksheet shows the actual formulas.
Formulas
58
When you decrease a column width to ____, the column is hidden.
0
59
The process of finding and correcting errors in a worksheet is called ____.
Debugging
60
A blank cell in Excel has a numerical value of ____.
Zero
61
____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.
Best Fit
62
Excel displays which of the following for an invalid reference?
#REF!
63
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
Greater than
64
To override the order of operations, use ____.
Parentheses
65
A ____ is made up of two values and a relational operator.
Condition
66
In the formula: = A4 / B4 + C5 - D5 * E6 the ____ operation is performed first.
Multiplication
67
The Percent style button is used to display a value determined by multiplying the cell by ____, rounding the result to the nearest percent, and adding a percent sign.
100
68
The arithmetic operator for multiplication is ____.
*
69
The ____ dollar sign displays to the far left in a cell.
Fixed
70
To determine the average of a range of numbers, click the ____ in the formula bar, then click AVERAGE.
Insert Function Box
71
To select a range using the keyboard, press the ____ key and then use the arrow keys.
F8
72
To apply a Percent style format to a cell using shortcut keys, press ____.
CTRL+SHIFT+%
73
The ____ version of a worksheet shows the results of formulas.
Values
74
A formula in a cell that contains a reference back to itself is called a ____ reference.
Circular
75
Pressing the ____ key instructs Excel to recalculate all formulas.
F9
76
The ____ button gives options for how to fill cells following a fill operation.
Auto Fill Options
77
____ allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout View
78
To display additional decimal places in a cell, click the ____ button on the Ribbon.
Increase Decimal
79
____ cells is a technique you can use to hide data that might be sensitive or not relevant to a report.
Hiding
80
You can assign a ____ to a cell and Excel will calculate the result.
Formula
81
Every time you enter a value into a cell in the worksheet, Excel ____ all formulas.
Recalculates
82
The ____ box allows you to specify the percentage of reduction or enlargement in the printout of a worksheet.
Adjust to
83
The ____ button lists formatting options following an insert of cells, rows, or columns.
Insert Options
84
You can apply ____ formatting that appears only when the value in a cell meets conditions that you specify.
Conditional
85
A(n) ____ is a prewritten formula that is built into Excel.
Function
86
To ensure that Excel interprets year values the way you intend, use ____.
Four-digit years
87
To determine the highest number in a range of numbers, click Insert Function box in the formula bar to display the Insert Function dialog box, then select ____ from the Select a function dialog box.
MAX
88
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
89
Excel has a ____ you can use to check the worksheet for spelling errors.
Spell Checker
90
The default view for a worksheet is ____.
Normal View
91
The ____ alerts Excel that you are entering a formula or function and not text.
Equal Sign
92
A(n) ____ is common content that prints on every page of a worksheet.
Header
93
The formula ____ multiples the contents of cell B4 by 18.5.
18.5*B4
94
The process of finding and correcting errors in a worksheet is called ____.
Debugging
95
____ colors tend to reach towards your worksheet's reader.
Warmer
96
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Tracer Error
97
The values that you use with a function are called ____.
Arguments
98
A dot on the screen that contains color is called a ____.
Pixel
99
The arithmetic operator for division is ____.
/
100
When working with a large worksheet, you can split the window into two or four ____ to view different parts of the worksheet at the same time.
Panes
101
To quit Excel, click the ____ button on the title bar.
Close
102
When first entering text in Excel, its angle is ____ degrees.
0
103
The ____ is a reserved place in a computer's memory that allows you to collect text and graphic items from an Office document and then place them into any Office document.
Office Clipboard
104
When you use the ____ command, the item is copied to the Office Clipboard but is not removed from the worksheet until you click the Paste button.
Cut
105
You can insert a row by right-clicking the row below where you want to insert, then click the ____ command on the shortcut menu.
Insert
106
Excel displays the error message ____ in cells to indicate a cell reference error.
#REF!
107
Displaying ##### in a cell refers to which of the following?
Cells are not wide enough to display the entire entry
108
Excel uses which of the following as the default date and time format?
mm/dd/yyyy hh:mm
109
The general form of the IF function is ____.
D: IF(logical_test, value_if_true, value_if_false)
110
A(n) ____ chart is used to show the relationship of the parts to a whole.
pie
111
A formula using a(n) ____ reference instructs Excel to adjust the cell reference as it copies it to a destination area.
Relative cell
112
Which of the following comparison operator means greater than or equal to?
>=
113
Using the ____ you can format a cell quickly by copying a cell's format to another cell or range of cells.
Format Painter
114
Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____.
Format Chart Area dialog box
115
You can emphasize a slice of a pie chart by ____ it from the rest of the slices so it stands out.
Offsetting
116
When creating panes in a worksheet, the bar going up and down the middle of the window is called the ____.
Vertical split bar
117
Click the ____ button in the Goal Seek Status dialog box to redisplay the original values in the worksheet.
Cancel
118
After you insert a row using the Insert command on the shortcut menu, you can repeatedly press ____ to continue inserting rows.
F4
119
Text in a cell can be rotated counterclockwise by entering a number between 1º and ____ in the Alignment sheet in the Format Cells dialog box.
90º
120
To select nonadjacent ranges, select the first range, hold down the ____ key and drag through the nonadjacent ranges.
CTRL
121
The ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
122
The underline format will underline ____.
only the characters in the cell
123
A cell reference with only one dollar sign before either the column or the row is called a(n) ____.
Mixed cell reference
124
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.
What-if analysis
125
To copy a word, such as Monday, which Excel might interpret as the start of a series, hold down the ____ key while you drag the fill handle to a destination area.
CTRL
126
An Excel ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
Sparkline
127
When you insert a row, the new row automatically ____ the format from the row above.
Inherits
128
A(n) ____ instructs the paste operation to keep the same cell reference as it copies a formula from one cell to another.
Absolute Reference
129
The ____ command removes selected cells from the worksheet and shifts the remaining rows up or shifts the remaining columns to the left.
Delete
130
```
Which of the following is an absolute cell reference?
A: B20
B: $B$20
C: $B20
D: B$20
```
B: $B$20
131
The ____ on the status bar can be used to change the size of entries to make them more readable.
Zoom slider
132
If you select all the slices of a 3-D pie chart, you can explode ____ of the slices.
all
133
Which of the following is not considered a format symbol?
+ (plus sign)
134
Excel displays the error message ____ in cells to indicate a divide by zero error.
#DIV/0!
135
An alternative to clicking the Paste button is to ____.
press the ENTER key
136
When creating panes in a worksheet, the bar going across the middle of the window is called the ____.
Horizontal Split Bar
137
The worksheet entries that determine the size of the slices in a pie chart are called the ____.
Data series
138
If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which a formula depends.
Goal seeking
139
Using the mouse to move or copy cells is called ____.
Drag and Drop
140
To specify an absolute cell reference, enter a(n) ____ before the letter and number of a cell reference.
Dollar Sign
141
The entries that will identify the slices of a pie chart are called ____.
Category names
142
A pie chart with one or more slices offset from the main portion is called a(n) ____ pie chart.
Exploded
143
A ____ shows the date a workbook, report, or other document was created or the period it represents.
Date Stamp
144
A ____ function is one in which the action taken for the true or false case includes yet another IF function.
Nested IF
145
When you cut cells using the Cut button, Excel copies the cells to the Office Clipboard, but does not remove the cells until you paste the cells in the destination area by clicking the ____ button.
Paste
146
You can use the Zoom in or Zoom out buttons on the status bar to zoom from ____ to reduce or enlarge the display of a worksheet.
10% to 400%
147
The ____ argument of the IF function is made up of two expressions and a comparison operator.
Logical_test
148
```
You can use the fill handle to ____.
A: copy a cell
B: copy a range of cells
C: create a series of numbers
D: all of the above
```
D: all of the above
149
Use the ____ button on the View tab to freeze worksheet titles so they display on the screen no matter how far you scroll.
Freeze Panes
