Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
33 Cards in this Set
- Front
- Back
|
As shown in the accompanying figure, item ____ points to the cell pointer, which outlines the active cell. |
2 |
|
|
In the accompanying figure, the entry in cell B5 is a ____. |
value |
|
|
A(n) ____ is an entry in a cell that contains text such as “2013 Sales” or “Travel Expenses.” |
lable |
|
|
you can use predesigned, formatted files called ____ to create new worksheets quickly. |
templates |
|
|
Labels are numbers, formulas, and functions that can be used in calculations. |
false |
|
|
Reference operators compare values for the purpose of true/false results |
false |
|
|
Which method of entering a function requires the user to know the name and initial characters of a function? |
manually typing the function ` |
|
|
Which keyboard shortcut turns on Edit mode? |
f2 |
|
|
The default file extension for an Excel 2013 workbook is ____. |
.xlsx |
|
|
How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs? |
=(C12+C13)*F4 |
|
|
Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5). |
false |
|
|
After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references. |
true |
|
|
To show how individual volume changes over time in relation to total volume, use a(n) ____ |
area chart |
|
|
An example of a(n) ____ chart is a column chart with a line chart. |
combination |
|
|
You can change a column chart to a clustered bar chart using the ____ dialog box. |
Change Chart Type |
|
|
On a chart created in Excel, the horizontal axis is also called the ____. |
x-axis |
|
|
The z-axis of 3-D charts is used for comparing data across both categories and values. |
true |
|
|
One way to display formulas is by pressing this key combination. |
[CTRL][`] |
|
|
Which error code will display if a value in a formula is not available? |
#NA |
|
|
Which error code will display if a number is used invalidly in a cell? |
#NUM! |
|
|
What is the calculated result of the formula =PROPER(“john smith”)? |
John Smith |
|
|
Which Excel function counts the number of cells in a range? |
COUNTIF |
|
|
To name a range, select the range and then click the Define Name button in the Defined Names group. |
true |
|
|
Which of the following can users search for to help them locate a workbook? |
keywords |
|
|
The print title prints at the top of every ____. |
page |
|
|
When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify any series of characters |
* |
|
|
To stop macro recording, ____ |
click the Stop Recording button on the status bar. |
|
|
The FIRST step in planning a macro is to record it. |
false |
|
|
A two-period moving average smoothes out fluctuations in data by using only the maximum data points. |
false |
|
|
You enter labels for the x and y axes in their respective title text boxes. |
true |
|
|
A scenario summary is an Excel table that compiles data from ____ |
the changing cells and corresponding result cells for each scenario |
|
|
A PivotTable row label is a(n) ____ field in a PivotChart |
axis |
|
|
Which of the following is NOT a guideline for planning and designing a PivotTable? |
Determine the formatting of the source data. |
