Category 1
•A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
Active Cell
A function that counts the number of blank cells in a range is called?
Count Blank
- Parentheses inside of parentheses within a formula.
Nested Parentheses
- The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook is called ?
Scope
•A built-in set of filtering capabilities is called?
AutoFilter
•A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
Backstage view
A feature found in most Office applications that allows you to quickly copy formatting attributes that you have already applied and “paint” those attributes onto other text, shapes, pictures, and worksheet cells is called?
Format Painter
The rules Excel follows to calculate any formula that contains two or more operators is called?
Order Of Operations
A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually
Style
•To condense groups into single-row headings called outlines is called?
Collapse
Arrange in a line or bring into alignment is called ?
Align
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
External Reference
- A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much more is called?
Paste Special
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
Value
•A command to help you search for certain content is called?
Find Command
- A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function is called?
Auto sum
- A function that determines the minimum value in a range of cells is called?
Min Function
- A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more is called?
Rules Manager
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on is called?
Variable
•To prevent portions of a worksheet from moving on the screen is called ?
Freeze
A function that returns the mean of the arguments is called?
Average Function
A group of cells, and occasionally a single cell, with a designated name is called?
Named Range
A function that totals all of the cells in a range is called?
Sum Function
To automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height is called?
Wrap
A divider that breaks a worksheet into separate pages for printing is called?
Page Break