WorksheetsExcel Unit 1-3
Total questions: 36
Worksheet time: 27mins
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 bar located between the ribbon and the worksheet in which users can edit the contents of the cell
c)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
d)
A box on the grid identified by the intersection of a column and a row.
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)
A word assigned to a document's properties that makes it easier to organize and file documents
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)
Cells that run from top to bottom in a worksheet and are identified by letters.
3.
cell
a)
A box on the grid identified by the intersection of a column and a row.
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)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
d)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
4.
column
a)
Cells that run from top to bottom in a worksheet and are identified by letters.
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)
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)
Task-oriented tabs that are organized on the ribbon.
5.
command group
a)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
b)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
c)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
d)
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
6.
command tabs
a)
Task-oriented tabs that are organized on the ribbon.
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 small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
d)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
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)
To insert data from the Clipboard to a new location in a worksheet
c)
A collection of worksheets in a single file.
d)
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.
8.
FILE tab
a)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
b)
Highlighting that is to be changed
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)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
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)
Items you directly change, such as keyword
c)
Highlighting that is to be changed
d)
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.
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 box on the grid identified by the intersection of a column and a row.
c)
Items you directly change, such as keyword
d)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
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)
Cells that run from top to bottom in a worksheet and are identified by letters.
c)
Pre-set settings that determine how Excel behaves when performing an action.
d)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
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)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
c)
Commands on the default ribbon tabs that are related in functionality.
d)
A collection of worksheets in a single file.
13.
ScreenTips
a)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
b)
Task-oriented tabs that are organized on the ribbon.
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 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.
14.
workbook
a)
A collection of worksheets in a single file.
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)
Several settings that enable you to change how a document prints.
d)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
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)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
c)
A box on the grid identified by the intersection of a column and a row.
d)
A box on the grid identified by the intersection of a column and a row.
16.
Auto Fill
a)
An excel feature that automatically fill cells with data, formatting, or both.
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)
Cells that run from top to bottom in a worksheet and are identified by letters.
d)
Cells that run from top to bottom in a worksheet and are identified by letters.
17.
Copy
a)
To duplicate data from a worksheet to the Clipboard
b)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
c)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
d)
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
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 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)
Task-oriented tabs that are organized on the ribbon.
d)
Task-oriented tabs that are organized on the ribbon.
19.
Cut
a)
To remove data from a worksheet
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 in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
d)
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
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 small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
c)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
d)
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
21.
Flash Fill
a)
A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.
b)
A collection of worksheets in a single file.
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)
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.
22.
Formula Bar
a)
A bar located between the ribbon and the worksheet in which users can edit the contents of the cell
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 toolbar that gives you fast and easy access to the tools you use most often in Excel.
d)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
23.
Key Word
a)
A word assigned to a document's properties that makes it easier to organize and file documents
b)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
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 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.
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)
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 line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
d)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
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 toolbar that gives you fast and easy access to the tools you use most often in Excel.
c)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
d)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
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)
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)
A collection of worksheets in a single file.
d)
A collection of worksheets in a single file.
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)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
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)
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.
28.
Paste
a)
To insert data from the Clipboard to a new location in a worksheet
b)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
c)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
d)
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
29.
Selecting Text
a)
Highlighting that is to be changed
b)
A collection of worksheets in a single file.
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 toolbar that gives you fast and easy access to the tools you use most often in Excel.
30.
Workbook Properties
a)
Items you directly change, such as keyword
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)
To insert data from the Clipboard to a new location in a worksheet
d)
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.
31.
default settings
a)
Pre-set settings that determine how Excel behaves when performing an action.
b)
Highlighting that is to be changed
c)
Highlighting that is to be changed
d)
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
32.
group
a)
Commands on the default ribbon tabs that are related in functionality.
b)
Items you directly change, such as keyword
c)
Items you directly change, such as keyword
d)
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
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)
Pre-set settings that determine how Excel behaves when performing an action.
c)
Pre-set settings that determine how Excel behaves when performing an action.
d)
A collection of worksheets in a single file.
34.
print options
a)
Several settings that enable you to change how a document prints.
b)
Commands on the default ribbon tabs that are related in functionality.
c)
Commands on the default ribbon tabs that are related in functionality.
d)
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.
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 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 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 formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
36.
template
a)
A file that includes formatting and formulas complete with designs, tools, and specific data types.
b)
Several settings that enable you to change how a document prints.
c)
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
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.
100 %
