Module 7 Chapter 9
Which code in a header converts to the worksheet name when you click outside the header section?
&[Tab]
The formula =IF(F4>=500,F4*10%,0) is in cell H4. F4 contains the value 600. What result will Excel display in H4?
60
Which of the following formulas provides the arithmetic mean of a range?
=AVERAGE(A2:A25)
Which of the following entries is not a valid date entry?
=DATE(11-19-2021)
Which of the following is not one of the three buttons that display next to a chart that are used for modifying the chart?
Chart Gallery
What does Excel do when a chart is moved to its own chart sheet?
Excel scales the chart to fill a letter-size page in landscape orientation.
You notice the dates displayed along the bottom of a line chart were converted incorrectly when the chart was graphed. Which task pane would you open to correct the dates?
Format Axis
Which option would you choose from the Number Format drop-down list to open the Format Cells dialog box to format cells with dates?
More Number Formats
To name a cell or a selected range, type the descriptive label in the
Name box
Which of the following functions is not considered a statistical function?
PMT
Which of the following is the financial function that calculates a payment for a loan?
PMT
Open the _____ dialog box with the Margins tab active to center a worksheet horizontally.
Page Setup
Which dialog box would you open to instruct Excel to print worksheet comments on a separate page after the worksheet is printed?
Page Setup
When adding a header to a worksheet, click in the Header pane using which view?
Page layout
Which button that appears when you select a range is used to produce a chart?
Quick Analysis
Which ribbon tab would you click to attach a comment to the active cell?
Review
Format a selected range as an independent group of cells that can be analyzed separately from other cells by clicking the _____ tab from the Quick Analysis button.
Tables
Which of the following is not an indicator that some rows of data in a table are temporarily hidden?
The Title bar has an asterisk after the file name.
When a logical test proves true, Excel calculates the statement in which box of the Function Arguments dialog box?
Value_if_true
A column chart is well suited to show
a comparison of values over time.
What feature can you use to reference a cell that makes creating and understanding a formula that uses the cell easier?
a range name
A cell referenced with a range name automatically becomes a(n) _____ reference.
absolute
To create formulas correctly in Excel requires an understanding of two types of references: relative and
absolute
Most lending institutions express the interest rate in which time period?
annually
Which of the following refers to the parameters for a function?
argument
Which option can you add to a pie chart to add context with the size of each pie slice?
data labels
A valid time entered into a cell is stored as a _____ representing a fraction of a day.
decimal value
Which Excel feature temporarily hides rows with data that does not meet a criterion so that you can examine a subset of data?
filter
Which Excel library is frequently updated and expanded?
function library
Which type of chart helps a reader identify trends, growth spurts, dips, or unusual points in a data series?
line
A statement to evaluate a comparison for Excel to perform one of two actions is called a(n)
logical test
When a formula is copied, a dollar symbol in front of a column letter or row number in the source cell means that the address will
not update
Which of the following is the term for a miniature chart embedded in a cell?
sparkline chart
What does the value you enter for Pv when calculating a loan payment represent?
the principal (amount to be borrowed)
Column charts display each data point in a colored bar, with the height of the bar representing the data point's value on which axis?
vertical axis
What is another name for the category axis in a column chart?
x-axis
