Studied by 0 people
Looks like no one added any tags here yet for you.
Use this button to combine two or more cells into one cell and center the text over a group of columns.
Merge and Center
When you click on a cell to activate it, the cell address appears in the:
name box
When you want to delete characters in a cell to the left of the insertion point press:
backspace
After you select and cut cells, the cells are temporarily placed:
on the clipboard
When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select:
freeze panes
In an Excel worksheet dates and times are:
values (e.g. 43565.125)
In Microsoft Excel, the file you create and edit is called a:
workbook
By default, Excel 2019 files are saved with this extension.
xlsx
A rectangular group of cells in Excel is called a(n):
range
To quickly select all the cells in a worksheet:
press ctrl+a
Excel comes with many built-in formulas called:
functions
This Excel feature allows users to use common arithmetic operations to perform a calculation:
formulas
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 (#)
This type of cell reference does not change when copied and remains in a fixed position during operations:
absolute
This symbol alerts Excel that you are entering a formula and not text:
=
To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:
3D cell reference
When you are creating formulas using a cell location, the default cell reference is:
relative
This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:
PMT
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:
F4
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
The Excel tool button that allows you to step through each part of a formula is called:
evaluate formula
It is important to remember that Excel calculates these operations before any others are performed:
items in parentheses
To apply changes to your chart’s Shape Fill, Shape Outline, or Shape Effects separately, use the:
format tab
A variegated blend of colors in a chart element is called a:
gradient
A chart that includes two chart types such as a line chart and a column chart is referred to as a:
combination chart
In a histogram chart, the category labels are shown:
on the horizontal axis
The Excel chart element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the:
trendline
The type of chart that shows percentages of a whole and has no axes is a:
pie chart
An Excel chart that is displayed on its own sheet in the workbook is called a:
chart sheet
When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:
chart
The text label that describes each data series in a chart is called the:
category label
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
In an OR function, if any one of the arguments is true, the result is:
true
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)?
text
The Standard Deviation functions are found in this category:
statistical
The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is:
SUMIFS
The Statistical function that does computations only after data meets multiple criteria is:
COUNTIFS
A function within a function is described as:
Nested
