Cell references in a formula are called ________.
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ________ values.
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 ________.
________ 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 ________.
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.
Extended to Qtr3, Qtr4, and Qtr 1 by dragging the fill handle
Extends the fill series to 575,550,525
(Home tab | Alignment group)
Path to the Increase or Decrease Indent button
The Increase Indent button indents the contents of a cell to the right by ________ spaces each time you click it.
The Copy button copies the contents and format of the source area to the Office ________, a reserved place in the computer's memory.
Pressing the ________ key(s) removes the marquee from the source area.
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
Not a valid format symbol
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.
When assigned to a cell, the ________ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
Contains an absolute cell reference
The ________ function is useful when you want to assign a value to a cell based on a logical test.
________ refers to cells not wide enough to display the entire entry.
Error messages begin with the ________ symbol.
A(n) ________ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
A(n) ________ chart provides a simple way to show trends and variations in a range of data within a single cell.
You can press the ________ keys to open the Format Cells dialog Box.
(Home tab | Clipboard group)
Path to the Format Painter button
________ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
You should use a ________ chart to show the relationship or proportion of parts to a whole.
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
________ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.