NEW
Font size
S
M
L
XL
WorksheetsUnit 1 Terminology Excel
Total questions: 51
Worksheet time: 51mins
Name
Class
Date
1.
active cell
a)
A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
b)
A box on the grid identified by the intersection of a column and a row.
c)
Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
d)
Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
e)
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
2.
Backstage view
a)
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
b)
Cells that run from top to bottom in a worksheet and are identified by letters.
c)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
d)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
e)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
3.
cell
a)
A box on the grid identified by the intersection of a column and a row.
b)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
c)
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
d)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
e)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
4.
column
a)
Cells that run from top to bottom in a worksheet and are identified by letters.
b)
Task-oriented tabs that are organized on the ribbon.
c)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
d)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
e)
A collection of worksheets in a single file.
5.
command group
a)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
b)
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
c)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
d)
To insert data from the Clipboard to a new location in a worksheet
e)
A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
6.
command tabs
a)
Task-oriented tabs that are organized on the ribbon.
b)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
c)
A collection of worksheets in a single file.
d)
Highlighting that is to be changed
e)
An excel feature that automatically fill cells with data, formatting, or both.
7.
Dialog Box Launcher
a)
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
b)
Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
c)
A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
d)
Items you directly change, such as keyword
e)
To duplicate data from a worksheet to the Clipboard
8.
FILE tab
a)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
b)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
c)
An excel feature that automatically fill cells with data, formatting, or both.
d)
Pre-set settings that determine how Excel behaves when performing an action.
e)
An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down CTRL while you point to the border of the selection
9.
Name Box
a)
Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.
b)
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
c)
To duplicate data from a worksheet to the Clipboard
d)
Commands on the default ribbon tabs that are related in functionality.
e)
To remove data from a worksheet
10.
Quick Access Toolbar
a)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
b)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
c)
An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down CTRL while you point to the border of the selection
d)
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
e)
A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
11.
ribbon
a)
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.
b)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
c)
To remove data from a worksheet
d)
Several settings that enable you to change how a document prints.
e)
A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.
12.
row
a)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
b)
A collection of worksheets in a single file.
c)
A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
d)
(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
e)
A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
13.
ScreenTips
a)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
b)
A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
c)
A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.
d)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
e)
A word assigned to a document's properties that makes it easier to organize and file documents
14.
workbook
a)
A collection of worksheets in a single file.
b)
An excel feature that automatically fill cells with data, formatting, or both.
c)
A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
d)
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
e)
Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
15.
worksheet
a)
A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.
b)
To duplicate data from a worksheet to the Clipboard
c)
A word assigned to a document's properties that makes it easier to organize and file documents
d)
Operators that specify the calculations to be performed.
e)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
16.
Auto Fill
a)
An excel feature that automatically fill cells with data, formatting, or both.
b)
An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down CTRL while you point to the border of the selection
c)
Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
d)
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
e)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
17.
Copy
a)
To duplicate data from a worksheet to the Clipboard
b)
To remove data from a worksheet
c)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
d)
A number or text value entered directly into a formula.
e)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
18.
Copy Pointer
a)
An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down CTRL while you point to the border of the selection
b)
A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
c)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
d)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
e)
To insert data from the Clipboard to a new location in a worksheet
19.
Cut
a)
To remove data from a worksheet
b)
A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.
c)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
d)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
e)
Highlighting that is to be changed
20.
Fill Handle
a)
A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
b)
A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
c)
To insert data from the Clipboard to a new location in a worksheet
d)
A cell reference that uses an absolute column or row reference, but not both.
e)
Items you directly change, such as keyword
21.
Flash Fill
a)
A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.
b)
A word assigned to a document's properties that makes it easier to organize and file documents
c)
Highlighting that is to be changed
d)
A group of cells, and occasionally a single cell, with a designated name.
e)
Pre-set settings that determine how Excel behaves when performing an action.
22.
Formula Bar
a)
A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
b)
Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
c)
Items you directly change, such as keyword
d)
Parentheses inside of parentheses within a formula.
e)
Commands on the default ribbon tabs that are related in functionality.
23.
Key Word
a)
A word assigned to a document's properties that makes it easier to organize and file documents
b)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
c)
Pre-set settings that determine how Excel behaves when performing an action.
d)
An element that identifies the values to be used in a calculation.
e)
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
24.
Lables
a)
Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.
b)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
c)
Commands on the default ribbon tabs that are related in functionality.
d)
The rules Excel follows to calculate any formula that contains two or more operators.
e)
Several settings that enable you to change how a document prints.
25.
Move Pointer
a)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
b)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
c)
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
d)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
e)
(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
26.
Natural Series
a)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
b)
To insert data from the Clipboard to a new location in a worksheet
c)
Several settings that enable you to change how a document prints.
d)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
e)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
27.
Office Clipboard
a)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
b)
Highlighting that is to be changed
c)
(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
d)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
e)
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
28.
Paste
a)
To insert data from the Clipboard to a new location in a worksheet
b)
Items you directly change, such as keyword
c)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
d)
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
e)
Operators that specify the calculations to be performed.
29.
Selecting Text
a)
Highlighting that is to be changed
b)
Pre-set settings that determine how Excel behaves when performing an action.
c)
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
d)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
e)
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
30.
Workbook Properties
a)
Items you directly change, such as keyword
b)
Commands on the default ribbon tabs that are related in functionality.
c)
Operators that specify the calculations to be performed.
d)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
e)
A number or text value entered directly into a formula.
31.
default settings
a)
Pre-set settings that determine how Excel behaves when performing an action.
b)
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
c)
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
d)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
e)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
32.
group
a)
Commands on the default ribbon tabs that are related in functionality.
b)
Several settings that enable you to change how a document prints.
c)
A number or text value entered directly into a formula.
d)
To insert data from the Clipboard to a new location in a worksheet
e)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
33.
navigation pane
a)
A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
b)
(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
c)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
d)
Highlighting that is to be changed
e)
A cell reference that uses an absolute column or row reference, but not both.
34.
print options
a)
Several settings that enable you to change how a document prints.
b)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
c)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
d)
Items you directly change, such as keyword
e)
A group of cells, and occasionally a single cell, with a designated name.
35.
tab
a)
(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.
b)
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
c)
A cell reference that uses an absolute column or row reference, but not both.
d)
Pre-set settings that determine how Excel behaves when performing an action.
e)
Parentheses inside of parentheses within a formula.
36.
template
a)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
b)
Operators that specify the calculations to be performed.
c)
A group of cells, and occasionally a single cell, with a designated name.
d)
A number or text value entered directly into a formula.
e)
An element that identifies the values to be used in a calculation.
37.
absolute cell reference
a)
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
b)
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
c)
Parentheses inside of parentheses within a formula.
d)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
e)
The rules Excel follows to calculate any formula that contains two or more operators.
38.
calculation operator
a)
Operators that specify the calculations to be performed.
b)
A number or text value entered directly into a formula.
c)
An element that identifies the values to be used in a calculation.
d)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
e)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
39.
cell reference
a)
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
b)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
c)
The rules Excel follows to calculate any formula that contains two or more operators.
d)
A cell reference that uses an absolute column or row reference, but not both.
e)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
40.
constant
a)
A number or text value entered directly into a formula.
b)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
c)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
d)
A group of cells, and occasionally a single cell, with a designated name.
e)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
41.
external reference
a)
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
b)
A cell reference that uses an absolute column or row reference, but not both.
c)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
d)
Parentheses inside of parentheses within a formula.
e)
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
42.
formula
a)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
b)
A group of cells, and occasionally a single cell, with a designated name.
c)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
d)
An element that identifies the values to be used in a calculation.
e)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
43.
mixed cell reference
a)
A cell reference that uses an absolute column or row reference, but not both.
b)
Parentheses inside of parentheses within a formula.
c)
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
d)
The rules Excel follows to calculate any formula that contains two or more operators.
e)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
44.
named range
a)
A group of cells, and occasionally a single cell, with a designated name.
b)
An element that identifies the values to be used in a calculation.
c)
A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.
d)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
e)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
45.
nested parentheses
a)
Parentheses inside of parentheses within a formula.
b)
The rules Excel follows to calculate any formula that contains two or more operators.
c)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
d)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
e)
To insert data from the Clipboard to a new location in a worksheet
46.
operand
a)
An element that identifies the values to be used in a calculation.
b)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
c)
A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.
d)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
e)
Highlighting that is to be changed
47.
order of operations
a)
The rules Excel follows to calculate any formula that contains two or more operators.
b)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
c)
To insert data from the Clipboard to a new location in a worksheet
d)
To insert data from the Clipboard to a new location in a worksheet
e)
Items you directly change, such as keyword
48.
relative cell reference
a)
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
b)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
c)
Highlighting that is to be changed
d)
Highlighting that is to be changed
e)
Pre-set settings that determine how Excel behaves when performing an action.
49.
scope
a)
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
b)
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
c)
Items you directly change, such as keyword
d)
Items you directly change, such as keyword
e)
Commands on the default ribbon tabs that are related in functionality.
50.
value
a)
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
b)
The rules Excel follows to calculate any formula that contains two or more operators.
c)
Pre-set settings that determine how Excel behaves when performing an action.
d)
Pre-set settings that determine how Excel behaves when performing an action.
e)
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
51.
variable
a)
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
b)
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
c)
Commands on the default ribbon tabs that are related in functionality.
d)
Parentheses inside of parentheses within a formula.
e)
A cell reference that uses an absolute column or row reference, but not both.
Reset
