Excel

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

3D cell reference.

5. An Excel chart that is displayed on its own sheet in the workbook is called:

A chart sheet.

9. The type of chart that shows percentages of a whole and has no axes is:

A pie chart

8. When you apply a predesigned set of built-in format options such as borders, fill colors, and effects for an Excel table, you use:

A table style.

3. The type of importable document that includes raw data, no formatting, and uses commas or other characters to separate the data into columns and rows is:

A text file.

7. This type of cell reference does not change when copied and remains in a fixed position during operations:

Absolute

5. The Microsoft Office relational database application that works with Excel to import and export data is called:

Access.

When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns:

An error message that begins with a number sign (#).

12. This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

AutoCalculate

1. When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:

Chart.

-A chart that includes two chart types such as a line chart and a column chart is referred to as a:

Combination chart.

12. When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells, use this Excel feature:

Conditional formatting

8. The thin black plus sign pointer is used to:

Copy cell contents or complete a series.

To use an Advanced Filter in Excel, you first need to create a:

Criteria range.

A quick way to insert a new column or row in an existing worksheet is to select a column or row and press:

Ctrl+plus sign (+).

13. The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is:

Data visualization.

4. When you import a document into Excel that uses special characters, such as commas to separate columns, you are importing a:

Delimited file.

15. To sort numerical data from the largest to the smallest value, use this sort order:

Descending

5. The Excel tool button that allows you to step through each part of a formula is called:

Evaluate Formula.

1. Imported content in a worksheet that originated in another program or format is called:

External data.

11. The chart feature that allows you to specify which data is shown and which is hidden is the:

Filter.

1. This Excel feature allows users to evaluate values and return a result:

Formulas

12. When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select:

Freeze Panes.

11. Excel comes with many built-in formulas called:

Functions.

13. A variegated blend of colors in a chart element is called a:

Gradient.

7. In an Excel table, the first row of the table with unique descriptive titles or labels is called the:

Header row.

14. The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell should be formatted is:

Highlight Cells Rules.

This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false:

IF

10. It is important to remember that Excel calculates these operations before any others are performed:

Items in parentheses

6. Web site data can be imported into Excel if the data is:

List-type.

Use this button to combine two or more cells into one cell and center the text over a group of columns.

Merge and Center

The default view in Excel is:

Normal.

6. A new Excel workbook uses the default theme named:

Office

10. After you select and cut cells, the cells are temporarily placed:

On the Clipboard.

4. In a histogram chart, the category labels are shown:

On the horizontal axis.

9. In Excel, the acronym "Please Excuse My Dear Aunt Sally" helps the user remember:

Order of operations.

11. When you use Excel's subtotal command your list data is formatted as a(n):

Outline.

This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:

PMT

9. To quickly select all the cells in a worksheet:

Press Ctrl+A.

3. This chart type displays the frequency of multiple data series relative to a center point with an axis for each category:

Radar

3. The color-coded editing tool that applies different colors to each cell or cell range included within a formula is called the:

Range Finder.

When you are creating formulas using a cell location, the default cell reference is:

Relative.

12. The background color for a chart element is called the:

Shape Fill.

9. The process of arranging rows of data in an identified order is called:

Sorting.

15-A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is called a/an:

Sparkline.

6. When you change the preset group of elements in an Excel chart, you are changing:

The layout.

7. To apply changes to your chart's Shape Fill, Shape Outline, or Shape Effects separately, use:

a. Format tab.

By default, Excel 2016 files are saved with this extension.

b. .xlsx

When you click on a cell to activate it, the cell address appears in:

b. The name box.

2. This symbol alerts Excel that you are entering a formula and not text:

c. =

Text in a worksheet that displays a name, a main title, row or column titles, and similar descriptive information is called:

c. A label.

In Microsoft Excel, the file you create and edit is called:

c. A table.

2. The text label that describes each data series in a chart is called the:

c. Category label.

2. An Excel command that recognizes a pattern and duplicates it is:

c. Flash Fill.

10. The Excel chart element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the:

c. Trendline.

11. In an Excel worksheet dates and times are:

c. Values.

5. When you want to delete characters in a cell to the left of the insertion point press:

d. Backspace.

8. A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is:

e. F4.

A rectangular group of cells in Excel is called a(n):

e. Range.

8. Chart styles are based on:

e. Workbook themes.