excel multiple choice questions

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

F4

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

a chart sheet

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

a label

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

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

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

a workbook

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

absolute

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 #

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

autocalculate

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

backspace

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

category label

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

When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells use:

conditional formatting

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 is an existing worksheet is to select a column or row and press:

ctrl + plus sign

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

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

delimited file

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

descending

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

evaluate formula

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

external data

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

filter

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

flash fill

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

format tab

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

formulas

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

freeze panes

Excel comes with many built-in formulas called:

functions

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

gradient

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

header row

The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell is 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

It is important to remember that Excel calculates these operations before any other are performed:

items in parenthesis

Website 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

A new Excel workbook uses the default theme named:

office

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

on the clipboard

In a histogram chart, the category labels are shown:

on the horizontal axis

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

order of operations

When you use Excel's subtotal command your list data is formatted as an:

outline

The type of chart that shows percentages of a whole and has no axis is:

pie chart

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

pmt

To quickly select all the cells in a worksheet:

press ctrl + A

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

radar

A rectangular group of cells in Excel is called a:

range

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

The background color for a chart element is called the:

shape fill

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

sorting

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:

sparkline

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

the layout

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

the name box

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

trendline

In an Excel worksheet, dates and times are:

values

Chart styles are based on:

workbook themes

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

.xlsx

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

3D cell reference

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

=