Exam 4: Excel

To change the color of a sparkline marker is to change its ____.

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures. Describe which chart type you should use to show how each quarter contributed to the total sales for a single department.

When you copy a formula to a new cell, the original cell references are replaced with cell references that are in the same ____ position as those in the original formula.

The name box shows the address of the selected cell.

You can apply _____ formatting to individual cells based on certain conditions being met.

A trendline is a line that connects high or low points in a data series and shows a trend.

The Quick Analysis button appears whenever you select a range of ____ or more cells.

List the six common categories of functions in Microsoft Excel.

The horizontal and vertical axes are included in the plot area.

Describe how to change the number format in a cell.

The _________ gallery contains popular conditional formatting options like data bars and color scales.

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations. Your spreadsheet contains a list of dates and you need to determine the intervals between the dates in the list. Which set of functions should you use to determine how many days have passed?

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

To insert a column, click the column heading to the right of where you want the new one, and then click the Insert button in the ____ group.

The AVERAGE function is so common it has its own button on the Home tab. _________________________

A group of selected cells that share boundaries is called a cell range. _________________________

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

A worksheet is a much more effective way to communicate data to an audience than a chart.

You can identify the smallest value in a range of cells using the ____________________ function.