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:
=