How can we help?

You can also find more resources in our Help Center.

38 terms

Excel Ch. 3

STUDY
PLAY
assumptions
Cell references in a formula are called ________.
constant
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ________ values.
Range Finder
You can ensure correctness in your formulas by carefully checking them using ________.
determine the necessary functions and formulas needed
Suggested decision to make when you plan a workbook
use Excel to create the worksheet
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 ________.
Rotated
________ text often provides a strong visual appeal.
Dialog Box Launcher
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ________.
0
When you first enter a text, its angle is ________ degrees, and it reads from left to right in a cell.
Fill Formatting Only
The ________ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Qtr2
Extended to Qtr3, Qtr4, and Qtr 1 by dragging the fill handle
625,600
Extends the fill series to 575,550,525
(Home tab | Alignment group)
Path to the Increase or Decrease Indent button
three
The Increase Indent button indents the contents of a cell to the right by ________ spaces each time you click it.
Clipboard
The Copy button copies the contents and format of the source area to the Office ________, a reserved place in the computer's memory.
ESC
Pressing the ________ key(s) removes the marquee from the source area.
ENTER
An alternative to clicking the Paste button is to press the ________ key.
drag and drop
Using the mouse to move or copy cells is called ________.
(Home tab | Cells group)
Path to the Insert button
semi-colon
Not a valid format symbol
#REF!
In 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.
NOW
When assigned to a cell, the ________ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
=$B$4
Contains an absolute cell reference
IF
The ________ function is useful when you want to assign a value to a cell based on a logical test.
<>
Means "not equal to"
#####
________ refers to cells not wide enough to display the entire entry.
#
Error messages begin with the ________ symbol.
nested
A(n) ________ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
Sparkline
A(n) ________ chart provides a simple way to show trends and variations in a range of data within a single cell.
CTRL+!
You can press the ________ keys to open the Format Cells dialog Box.
(Home tab | Clipboard group)
Path to the Format Painter button
Double-click
________ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Pie
You should use a ________ chart to show the relationship or proportion of parts to a whole.
chart sheet
A(n) ________ is a separate sheet in a workbook that contains only a chart.
exploded Pie chart
A pie chart with one of more slices offset is called a(n) _______.
(View tab | Zoom group)
Path to the Zoom button
two or four
When working with a large worksheet, you can split the window into ________ panes.
(Data tab | Data Tools group)
Path to the Goal Seek button
Goal
________ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.