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.