Shared Flashcard Set

Details

Excel Test
intro to computers
13
Business
11/18/2008

Additional Business Flashcards

 


 

Cards

Term
If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
Definition
C. decrement, increment
Term
Copying, deleting, inserting, and moving ranges of cells have the potential to ____.
Definition
D. render a worksheet useless
Term
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.
Definition
B. what-if analysis
Term
If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.
Definition
C. goal seeking
Term
The number of worksheets that a workbook can contain is __________.
Definition
B. limited by computer memory
Term
A Pie chart with one or more slices offset is called a(n) ____.

Definition
B. exploded pie chart
Term
What effect does the Accounting Number Format have on the selected cells?
Definition
A. causes cells with two decimal places to align vertically correctly
Term
Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.
Definition
B. recalculates all
Term
Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas
Definition
B. recalculates all
Term
All of the following are valid Excel arithmetic operators except ____.
Definition
C. >
Term
Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box
Definition
B. New Rule
Term
To instruct Excel to display a hidden column, position the mouse pointer to the ____.
Definition
B. right of the column heading boundary where the hidden column is located and then drag to the right
Term
If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width.
Definition
B. Column Width