+
Related Flashcards
Cards In This Set
| Front | Back |
|
A cell's location is determined by the intersection of?
|
A column letter and a row number
|
|
Pressing Control+~ does what?
|
It displays cell formulas
|
|
Which cell becomes active when you press the "Enter" key?
|
The next cell down
|
|
A "Range"
|
Refers to a group of adjacent or contiguous cells
|
|
The input values that an Excel function uses to perform operations are called?
|
Arguments
|
|
Which Excel function would be used to find the middle value in a list of test scores?
|
MEDIAN
|
|
Excel assigns a serial number to each date entered, which allows dates to be treated the same as other numbers in the worksheet. True or False?
|
True
|
|
What function would provide the correct date?
|
=TODAY()
|
|
What does the IF function do?
|
It evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
|
|
If you want to balance a title over several columns, what do you do?
|
Merge and center the data over all of the columns
|
|
To copy of formula or number patter down a column or across a row which of the following methods could you use?
|
Auto Fill
|
|
If you want to see a preview of how a worksheet will appear when printed, what do you do?
|
Click the File tab, and then click Print
|
|
What function is NOT a basic statistical function?
|
LOOKUP
|
|
When does a circular reference occur?
|
When a formula directly or indirectly refers to the cell containing the formula
|
|
Define a bar chart.
|
It compares values across categories using horizontal bars
|
