1
By default, Excel 2019 files are saved with this extension.
What is xlsx?
After you select and cut cells, the cells are temporarily placed:
What is the clipboard?
This symbol alerts Excel that you are entering a formula and not text:
What is the equals sign?
This type of cell reference does not change when copied and remains in a fixed position during operations:
What is absolute?
The text label that describes each data series in a chart is called the:
What is a category label?
To quickly select all the cells in a worksheet:
What is Double-click?
In an Excel worksheet dates and times are:
What is Values? (e.g. 43565.125)
An Excel chart that is displayed on its own sheet in the workbook is called a:
What is a chart sheet?
In a histogram chart, the category labels are shown:
What is the horizontal axis?
To apply changes to your chart’s Shape Fill, Shape Outline, or Shape Effects separately, use the:
What is the format tab?
A rectangular group of cells in Excel is called a(n):
What is range?
When you click on a cell to activate it, the cell address appears in the:
What is the name box?
A variegated blend of colors in a chart element is called a:
What is a gradient?
A chart that includes two chart types such as a line chart and a column chart is referred to as a:
What is a combination chart?
To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:
What is a 3D cell reference?
Use this button to combine two or more cells into one cell and center the text over a group of columns.
What is Merge & Center?
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:
What is the IF function?
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:
What is F4?
The Excel tool button that allows you to step through each part of a formula is called:
What is Evaluate Formula?
Which type of function would you use to format a value as a label (like we did in Assignment 2 to turn a date value into a very specifically formatted date)?
What is text?
When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select:
What is Freeze Panes?
This Excel feature allows users to use common arithmetic operations to perform a calculation:
What is formulas?
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns:
What is an error that begins with a #?
This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:
What is a PMT function?
The Standard Deviation functions are found in this category:
What is Statistical?