How can we help?

You can also find more resources in our Help Center.

Excel Chapter 3

STUDY
PLAY
(View tab|Zoom group)
Which of the following is the path to the Zoom button?
625, 600
Which of the following patterns extends the fill series to 575, 550, 525?
use Excel to creathe 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______.
Range Finder
You can ensure correctness in your formulas by carefully checking them using _______.
CTRL+1
You can press the ______ keys to open the Format Cells dialog box.
pie
You should use a ______ chart to show the realationship or proportion of parts to a whole.
True
A data stamp shows the date a workbook, report, or other document was created or the period it represents.
True
A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
True
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
True
Changing the order of sheets in a workbook allows you to postition the most important worksheet first.
False
Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.
True
If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.
False
If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.
False
If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.
True
In the accompanying figure, the formula in cell B14 contains an absolute reference.
True
In the accompanying figure, worksheet titles are frozen above and to the left of cell B13.
True
Many Ribbon commands, galleries, and shortcut keys function together as toggles or switches.
True
Rotated text also allows you to fit more text into a smaller column width.
True
Studies have shown that more than 25 percent of all business worksheets have errors.
True
The <= comparison operator means less than or equal to.
True
The Increase Indent Button indents the contents of a cell to the right by three spaces each time you click it.
False
The NETWORKDAYS function checks a formula for correctness.
True
The path to the Logical button is (Formulas tab| Function Library Group).
False
The range of entries that determines the size of the slices in a Pie chart is called the category names.
False
The syntax of the IF function is IF(logical_test(, vale_if_false, value_if_true).
True
When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.
False
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.
True
When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.
True
With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.
True
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.
False
You can select nonadjacent cells using the SHIFT key.