BCIS: Excel Study Guide
____ text often provides a strong visual appeal.
Rotated
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
In general, use no more than ____ font types in a worksheet.
two
When working with a large worksheet, you can split the window into ____ panes.
two or four
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____.
6E15
All of the following are valid Excel arithmetic operators except: ^ * % >
>
To start a new line in a cell, press the ____ keys.
ALT + ENTER
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation: Auto Fill Options, AutoCorrect Options, Insert Options, Paste Options.
Auto Fill Options
The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
Clicking the ____ opens the Insert Function dialog box shown in the accompanying figure.
Insert Function box on the formula bar
The ____ function displays the highest value in a range.
MAX
The ____ function determines the lowest number in a range.
MIN
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
You should use a ____ chart to show the relationship or proportion of parts to a whole.
Pie
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.
Print Selection
____ is/are used to add worksheet, column, and row titles on a worksheet.
Text
The ____ button is located on the Quick Access Toolbar, as shown in the accompanying figure.
Undo
A(n) ____ chart is drawn on the same worksheet as the data.
embedded
A Pie chart with one or more slices offset is called a(n) ____.
exploded Pie chart
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
A(n) ____ is a separate sheet in a workbook that contains only a chart.
chart sheet
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____.
use Excel to create the worksheet
The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory.
Clipboard
Clicking the ____ box completes an entry.
Enter
When you decrease the row height to ____, the row is hidden.
0
In Excel, a number can contain the characters ____.
0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
Excel remembers the last ____ actions you have completed.
100
How many chart types does Excel offer?
11
The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
The adjusted cell references in a copied and pasted formula are called ____ references.
relative
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
theme
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
three
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
When Excel follows the order of operations, the formula, 8 * 3 + @, equals ____.
26
Which of the following patterns extends the fill series to 575, 550, 525?
625, 600
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which comparison operator means "not equal to"?
< >
Which of the following calculations multiplies 23 by 0.01: =23%, =23, =23 + .01, =24 - .01
=23%
____ refers to cells not wide enough to display the entire entry.
# # # # #
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#REF!
Which of the following is the path to the Goal Seek button?
(Data tab | Data Tools group)
Which of the following is the path to the Increase or Decrease Indent button?
(Home tab | Alignment group)
Which of the following is the path to the Insert button?
(Home tab | Cells group)
The path to the Format Painter button is ____.
(Home tab | Clipboard group)
Which of the following is the path to the Copy and Paste buttons?
(Home tab | Clipboard group)
Which of the following is the path to the Sum button?
(Home tab | Editing group)
Which of the following is the path to the Comma Style button?
(Home tab | Number group)
Which of the following is the path to the Conditional Formatting button?
(Home tab | Styles group)
Which of the following is the path to the Spelling button?
(Review tab | Proofing group)
Which of the following is the path to the Zoom button?
(View tab | Zoom group)
The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Accounting number format
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
AutoCalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL + 1
You can press the ____ keys to open the Format Cells dialog box.
CTRL + 1
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL + B
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL + C
To paste copied cell contents, you can press the ____ keys.
CTRL + V
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____.
Dialog Box Launcher
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number format have on the selected cells?
Displays cell contents with two decimal places that align vertically
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Double-click
Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE?
END
An alternative to clicking the Paste button is to press the ____ key.
ENTER
To cancel an entire entry before entering it into the cell, press the ____ key.
ESC
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
You can ensure correctness in your formulas by carefully checking them using ____.
Range Finder
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
Sparkline
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
Standard
A ____ cell in Excel has a numerical value of zero.
blank
The most popular background color is _____.
blue
To enter data in a cell, you must first select or activate the ____.
cell
To remove an embedded chart, you should ____ it and press the DELETE key.
click
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ____.
destination area (or paste area)
Which of the following is a suggested decision to make when you plan a workbook?
determine the necessary functions and formulas needed
You should ____ a function name in the Formula AutoComplete list to select the function.
double-click
Using the mouse to move or copy cells is called ____.
drag and drop
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ____ dollar sign.
fixed
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
In the accompanying figure, the split double arrow mouse pointer ____.
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.
legend
Combining two or more selected cells into one cell is called ____ cells.
merging
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
range
A ____ reference is an adjusted cell reference in a copied and pasted formula.
relative
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
Point mode allows you to ____, as shown in the accompanying figure below.
select cells for use in a formula using the mouse pointer
Which of the following is not a valid format symbol: semi colon (;), percent sign (%), dollar sign ($), comma (,).
semi-colon (;)
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
An Excel ____ allows data easily to be summarized and charted.
worksheet