FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Excel

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

List the six common categories of functions in Microsoft Excel.

The name box shows the address of the selected cell.

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 horizontal and vertical axes are included in the plot area.

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?

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.

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

Specify the order of operations in which the following formula would be calculated: =(4+7)+3^2*5-2

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

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

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

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

Describe how to change the number format in a cell.

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

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.

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

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

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