ITM CH 2 & 3
Which of the following has an answer of 11?
3+2*4
Which of the following references cells located in another worksheet in the same workbook?
3D cell reference
Which of the following is the constant in the formula =D5*85%?
85%
Which of the following is not used as an identifier in formulas? $ ! = range name
=
Which of the following formulas includes only relative references?
=D21+E21
Which of the following shows the correct syntax for the ROUND function?
=ROUND(number, num_digits)
Which of the following chart elements provides a vertical background for a 3D chart?
A chart wall provides a vertical background for a 3D chart
Which of the following is a horizontal or vertical line that extends across the plot area to help in identifying values?
A gridline is a horizontal or vertical line that extends across the plot area to help in identifying values
Which of the following encompasses all of the other items? shape style shape fill shape outline shape effects
A shape style is a predesigned set of borders, fill colors, and effects for a chart element.
Which of the following is a small line or marker on an axis to guide in reading values?
A tick mark
Which of the following statements about circular references is false?
A workbook cannot be saved with a circular reference. *A workbook CAN be saved with a circular reference
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula?
Trace Precedents tool
Which of the following is an example of a Math & function that is often used in business or personal calculations?
All of the above: SUMIF, SUMPRODUCT, ROUND
The cell address $G4 is a relative cell address. True or False?
False
The formula to add the values in cells D3 and D4 is @D3+D4. True or False?
False
To insert the current date in a cell, use the NOW function. True or False?
False *To insert the current date in a cell, use the TODAY function.
The Funnel chart type plots each element in a running total and displays negative and positive effects of each on the total. True or False?
False *The Funnel chart plots values that progressively decrease from one stage or process to the next.
Which of the following is not True about filters? A filter is criteria that specifies which data is shown. A filter is criteria that specifies which data is hidden. Filters let you switch between several scenarios for your data. Filters alter the source data range
Filters alter the source data range.
Formula Auditing
Formula auditing is the process of displaying suggestions for completing a formula.
Which of the following statements is not True? Formulas are case sensitive. To cancel a formula before it is complete, press Esc. Do not navigate using an arrow key while you are entering a formula. Use the numeric keypad or the symbol keys to insert math operators.
Formulas are case sensitive * Formulas are NOT case sensitive
Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values?
Histogram
Which of the following functions evaluates a specified condition and returns one value if the condition is True and another value if the condition is False?
IF
If the cell range you want to use in a chart contains non-adjacent cells, hold down the Alt key to select each range.
If the cell range you want to use in a chart contains non-adjacent cells, hold down the Ctrl key to select each range
Which of the following functions finds the largest value in a range of cells?
MAX function
Which of the following functions adjusts a value to a specified number of decimal places?
ROUND
Which of the following is a color-coded editing tool that applies different colors to each cell or cell range within a formula?
Range Finder
Which of the following is a text box with a preset font style, fill, and text effect?
WordArt is a text box with a preset font style, fill, and text effect.
Which of the following charts displays relationships among numeric values in two or more data series?
XY charts
What can pie charts graph?
a single data series
Which of the following is the fixed location of a cell referenced in a formula or dialog box?
absolute reference
In a chart, which of the following can you fill with pictures? bars, columns, pie slices
all of the above
Which of the following terms refers to the text label that describes each data series?
category label
What does the Trace Dependents auditing tool do?
displays arrows to all cells that use the active cell directly or indirectly in a formula.
In a pie chart, what is a data series represented by?
the whole pie
A marker for a sparkline is the data point value. true or false
true
To delete a chart element, click it to select it and press Delete. True or false?
true
Which of the following is an absolute cell address?
$B$2 is an absolute cell address.
Which of the following formulas includes an absolute reference and a constant?
$D$21+21
Which of the following provides an example of a mixed reference and a relative reference?
$D21+E21
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
$F2
Which of the following is a valid 3D cell reference?
'Inventory#'!$B2
Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?
To change a relative cell address to an absolute cell address, select the cell address and press F4 to insert the dollar signs quickly.
Which of the following function keys makes it easier to insert a range name in a formula?
To insert a range name, press F3 function key to display the Paste Name dialog box
Which of the following criteria can you use to sum sales for all items that begin with the letter p?
To sum sales for all items that begin with the letter p, use p* as the criteria.
How many charts can be combined in a combination chart?
2 or more
Which of the following has an answer of 8?
10-4/2
Which of the following functions adds cell values together and divides the total of the values by the number of values?
AVERAGE
Which of the following is a True statement?
All of the above: A relative cell reference is the location of a cell, such as cell B2. The type of cell references included in a formula determines the result of a formula when it is copied. Cells that contain absolute references do not change when copied
Once you have selected the appropriate data, which of the following keyboard shortcuts creates a default chart object?
Alt+F1 creates a default chart object.
Which of the following features displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?
AutoCalculate displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells.
Which of the following is a mixed cell address?
B$2
Which of the following is a relative cell address?
B2
In the function =SUM(B2:B6), which part of the function is the argument?
B2:B6
Which of the following chart types displays comparisons among individual items or values at a specific period of time?
Bar charts
Which of the following functions tallies the number of cells in a range that contain numbers?
COUNT
Which of the following functions counts the number of cells in a range based on specified criteria?
COUNTIF function
Which of the following occurs when a formula includes the cell address of a formula?
Circular Reference
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes what is going on with this formula?
Circular reference
Which of the following chart types illustrates data changes over a period of time or shows comparisons among items?
Column charts illustrate data changes over a period of time or show comparisons among items.
Which of the following keystroke combinations completes a formula?
Ctrl+Enter
Which of the following Formula Auditing tools steps through each part of a formula?
Evaluate formula
Which of the following keys creates an automatic column chart sheet for selected data?
F11
A circular reference occurs when a formula references the wrong cell address. True or False?
False
A pie chart uses two data series to display each value as a percentage of the whole. True or False?
False
Column and row references do not change when you copy a relative cell address. True OR false?
False
Excel calculates addition operations before operations within parentheses are performed. True or False?
False
Formula auditing is the process of displaying suggestions for completing a formula. True or False?
False
The IF function calculates loan payment amounts. True or False?
False
Which of the following mathematical operations is always performed last?
Subtraction
The Range Finder highlights and color codes each cell as you type its address. True or False?
T
Which of the following functions can be formatted to show both the current date and time?
TODAY and TIME
The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme. True or False?
TRUE
Which of the following chart types displays the magnitude of change over time and shows the rate of change?
The Area chart type displays the magnitude of change over time and shows the rate of change
Which of the following tools steps through each part of a formula and displays an outcome for each part so that an error can be isolated?
The Evaluate Formula tool steps through each part of a formula and displays an outcome for each part so that an error can be isolated.
Which of the following functions retrieves a value from a range or table of cells located in another area of the worksheet?
The LOOKUP function retrieves a value from a range or table of cells located in another area of the worksheet.
Which of the following functions multiplies and then adds a series of arrays?
The SUMPRODUCT function multiplies and then adds a series of arrays.
Which of the following is true about the TODAY and NOW functions?
The TODAY and NOW functions do not have any arguments.
Trace Precedents
The Trace Precedents auditing tool displays tracer arrows that point to the cells referenced in the selected formula in the active cell.
Which of the following chart types displays a hierarchical view of data with different sized and colored rectangles and sub-rectangles to compare the sizes of groups?
The TreeMap chart
Which of the following cell addresses will change when it is copied?
The cell address F2 is a relative address and will change when copied.
Which of the following shows the correct syntax for the IF function?
The formula =IF(C5<=20,7,10) is using the correct syntax.
Circular References
The formula results of a circular reference are inaccurate. When you open a workbook with a circular reference, you will see a message box. When you open a workbook with a circular reference, the reference is noted in the Status bar.
Which of the following explains the symbols, textures, or colors used to differentiate data series?
The legend
What is a mixed reference?
This is a cell reference that uses an absolute column or row reference. (E.g., $D21+E21)
Arguments are the pieces of information within parentheses in functions that determine what value a function returns. True or False?
True
AutoCalculate allows you to view totals, averages, and other select statistical information without inserting a function in the worksheet. True or False?
True
Data tables are located just below a chart. True or False?
True
Each group of data points or values used in a graph is a data series. True or False
True
It is possible to replace a chart title box with WordArt. True or False?
True
Pressing Shift+F3 opens the Insert Function dialog box. True or False?
True
Range names describe the cell or purpose of a group of cells and make it easier to interpret a formula. True or FaLse?
True
Some chart types cannot be combined to create a combination chart. True or False?
True
Sparklines are miniature charts displayed in a cell or cell range with your data. True or False?
True
The PMT function assumes the borrower makes regular payments and the loan has a constant interest rate. True or False?
True
The SUMIF function combines the SUM function with the logical criteria component of the IF function. True or False?
True
The cell address $R$6 is an absolute cell reference. True or False?
True
To cancel a formula before it is complete, press Esc.
True
Which of the following functions uses a lookup table that is organized in columns?
VLOOKUP function
Which of the following is a requirement or condition that identifies which data is shown and which is hidden?
filter
Which of the following contains one relative reference (either the row number or column letter) and one absolute reference (the remaining row number or column letter)?
mixed reference
