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