Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/180
Score 0
A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
30
active cell
Q 2/180
Score 0
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
30
Backstage view
180 questions
Q.
A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.
1
30 sec
Q.
A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.
2
30 sec
Q.
A box on the grid identified by the intersection of a column and a row.
3
30 sec
Q.
Cells that run from top to bottom in a worksheet and are identified by letters.
4
30 sec
Q.
Task-specific groups divided among the command tabs appropriate to the work a user currently performs.
5
30 sec
Q.
Task-oriented tabs that are organized on the ribbon.
6
30 sec
Q.
An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.
7
30 sec
Q.
In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.
8
30 sec
Q.
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.
9
30 sec
Q.
A toolbar that gives you fast and easy access to the tools you use most often in Excel.
10
30 sec
Q.
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.
11
30 sec
Q.
A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.
12
30 sec
Q.
A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.
13
30 sec
Q.
A collection of worksheets in a single file.
14
30 sec
Q.
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.
15
30 sec
Q.
An Excel feature that automatically fill cells with data, formatting, or both.
16
30 sec
Q.
To duplicate data from a worksheet to the Clipboard.
17
30 sec
Q.
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. When this pointer appears you can drag the cell or range of cells to the new location.
18
30 sec
Q.
To remove data from a worksheet. Cut data may be pasted into a new location or locations in a worksheet.
19
30 sec
Q.
A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.
20
30 sec
Q.
A tool identified with symbols such as dotted, dashed, or solid lines that fill the space before tabs.
21
30 sec
Q.
A bar located between the ribbon and the worksheet in which users can edit the contents of a cell.
22
30 sec
Q.
A word assigned to a document's properties that makes it easier to organize and find documents.
23
30 sec
Q.
Text entered in 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.
24
30 sec
Q.
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.
25
30 sec
Q.
A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.
26
30 sec
Q.
A location that collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Office programs.
27
30 sec
Q.
To insert data from the Clipboard to a new location in a worksheet.
28
30 sec
Q.
A group of adjacent cells you select to perform operations on all of the selected cells.
29
30 sec
Q.
Highlighting text that is to be changed.
30
30 sec
Q.
Items you directly change, such as keywords
31
30 sec
Q.
Pre-set settings that determine how Excel behaves when performing an action.
32
30 sec
Q.
Commands on the default ribbon tabs that are related in functionality.
33
30 sec
Q.
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.
34
30 sec
Q.
Several settings that enable you to change how a document prints.
35
30 sec
Q.
(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.
36
30 sec
Q.
A file that includes formatting and formulas complete with designs, tools, and specific data types.
37
30 sec
Q.
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.
38
30 sec
Q.
Operators that specify the calculations to be performed.
39
30 sec
Q.
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
40
30 sec
Q.
A number or text value entered directly into a formula.
41
30 sec
Q.
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
42
30 sec
Q.
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
43
30 sec
Q.
A cell reference that uses an absolute column or row reference, but not both.
44
30 sec
Q.
A group of cells, and occasionally a single cell, with a designated name.
45
30 sec
Q.
Parentheses inside of parentheses within a formula.
46
30 sec
Q.
An element that identifies the values to be used in a calculation.
47
30 sec
Q.
The rules Excel follows to calculate any formula that contains two or more operators.
48
30 sec
Q.
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.
49
30 sec
Q.
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.
50
30 sec
Q.
A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
51
30 sec
Q.
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
52
30 sec
Q.
A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
53
30 sec
Q.
A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
54
30 sec
Q.
A function that determines how many cells in a range contain a number.
55
30 sec
Q.
A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
56
30 sec
Q.
A function that counts the number of blank cells in a range.
57
30 sec
Q.
A predefined formula that performs a calculation.
58
30 sec
Q.
A function that returns the largest value in a set of values.
59
30 sec
Q.
Two or more cells combined into a single cell.
60
30 sec
Q.
A function that determines the minimum value in a range of cells.
61
30 sec
Q.
A function that totals all of the cells in a range.
62
30 sec
Q.
Arrange in a line or bring into alignment.
63
30 sec
Q.
A formatting characteristic, such as bold, italic, or underlined text.
64
30 sec
Q.
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
65
30 sec
Q.
A set of text properties that affects the typeface, size, and similar aspects of text.
66
30 sec
Q.
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.
67
30 sec
Q.
A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.
68
30 sec
Q.
Two or more cells combined into a single cell.
69
30 sec
Q.
A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands.
70
30 sec
Q.
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.
71
30 sec
Q.
A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.
72
30 sec
Q.
A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.
73
30 sec
Q.
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.
74
30 sec
Q.
The line between rows or columns.
75
30 sec
Q.
The identifying letter of a column.
76
30 sec
Q.
The left-to-right measurement of a column.
77
30 sec
Q.
A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.
78
30 sec
Q.
Something that modifies the appearance of an object.
79
30 sec
Q.
Lines of text that appear at the bottom of each page.
80
30 sec
Q.
The lines that display around worksheet cells.
81
30 sec
Q.
A line of text that appears at the top of each page of a printed worksheet.
82
30 sec
Q.
The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.
83
30 sec
Q.
A divider that breaks a worksheet into separate pages for printing
84
30 sec
Q.
An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document.
85
30 sec
Q.
An Excel view that enables you to see what your document will look like before sending it to the printer.
86
30 sec
Q.
The identifying letter of a row.
87
30 sec
Q.
The top-to-bottom measurement of a row.
88
30 sec
Q.
Shrinking or stretching printed output to a percentage of its actual size.
89
30 sec
Q.
Changes your cell data to change orientation.
90
30 sec
Q.
Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel.
91
30 sec
Q.
The empty area of a document in which no content appears.
92
30 sec
Q.
A command to help you search for certain content.
93
30 sec
Q.
To prevent portions of a worksheet from moving on the screen. When you freeze panes, such as a row of column headings, the column headings remain visible as you scroll down the worksheet or change magnification.
94
30 sec
Q.
To make a worksheet invisible.
95
30 sec
Q.
A portion of a divided window.
96
30 sec
Q.
An Excel feature that allows you to add content to a text box and replace any matches Excel finds
97
30 sec
Q.
To make a worksheet visible again.
98
30 sec
Q.
An Excel feature that allows you to make a worksheet appear bigger (zoom in) or smaller (zoom out).
99
30 sec
Q.
A feature that automatically groups selected rows in Excel.
100
30 sec
Q.
A built-in set of filtering capabilities.
101
30 sec
Q.
To condense groups into single-row headings called outlines.
102
30 sec
Q.
A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria.
103
30 sec
Q.
An electronic file that stores a series of records in a relatively simple format.
104
30 sec
Q.
A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data.
105
30 sec
Q.
A character that separates data entries from one another.
106
30 sec
Q.
A restriction that Excel uses to determine which worksheet rows to display.
107
30 sec
Q.
Organizing data so it can be viewed as a collapsible and expandable outline.
108
30 sec
Q.
A series of steps you record that you might want to repeat frequently to save time.
109
30 sec
Q.
Single-row headings.
110
30 sec
Q.
Symbols that add controls next to the row and column headings to change the view of an outlined worksheet.
111
30 sec
Q.
To separate into components. Also, to interpret character by character.
112
30 sec
Q.
Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.
113
30 sec
Q.
One of the ways to filter a table so that it shows only records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does).
114
30 sec
Q.
The sum of values that are grouped together.
115
30 sec
Q.
A range of cells in a worksheet that contains related data and can be used by a lookup function.
116
30 sec
Q.
A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.
117
30 sec
Q.
The parameters of a function.
118
30 sec
Q.
A formula in which the result is determined by the presence or absence of a particular condition.
119
30 sec
Q.
A condition you specify to limit which records are returned when filtering data.
120
30 sec
Q.
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
121
30 sec
Q.
A range of cells in a worksheet that contains related data and can be used by a lookup function.
122
30 sec
Q.
Data in a table arranged in rows and columns.
123
30 sec
Q.
In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed.
124
30 sec
Q.
Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.
125
30 sec
Q.
A workbook set up to allow multiple networked users to view and make changes simultaneously.
126
30 sec
Q.
A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.
127
30 sec
Q.
A feature that marks and records changes made to a workbook.
128
30 sec
Q.
A line bordering the chart plot area used as a frame of reference for measurement.
129
30 sec
Q.
A graphical representation of numeric data in a worksheet.
130
30 sec
Q.
The entire chart and all its elements.
131
30 sec
Q.
A sheet that contains only a chart.
132
30 sec
Q.
Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.
133
30 sec
Q.
A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell.
134
30 sec
Q.
A row or column of data represented by a line, set of columns, bars, or other chart type.
135
30 sec
Q.
A chart placed on a worksheet rather than on a separate chart sheet.
136
30 sec
Q.
An explanatory list that identifies the patterns or colors assigned to the data series or categories in a chart.
137
30 sec
Q.
A graphical representation of the data in a PivotTable.
138
30 sec
Q.
A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
139
30 sec
Q.
The area bounded by axes in a chart.
140
30 sec
Q.
Miniature graphs that summarize data; typically used to graphically describe trends in data.
141
30 sec
Q.
Descriptive text that is aligned to an axis or at the top of a chart.
142
30 sec
Q.
Various artistic mediums and special effects designed for use on photos in Excel.
143
30 sec
Q.
An image with two colors.
144
30 sec
Q.
An art-related object, such as a drawing, image, or shape.
145
30 sec
Q.
A small box on the side and/or corner of the graphic that you click and pull to increase or decrease the size of a graphic.
146
30 sec
Q.
A set of data that describes and gives information about other data.
147
30 sec
Q.
Changing from color to black and white or to greater or reduced levels of color.
148
30 sec
Q.
An editable line, circle, arrow, star, or other form.
149
30 sec
Q.
A visual representation of information and ideas, such as an organization chart, a flow chart, a process, or a Venn diagram.
150
30 sec
Q.
A floating box in a worksheet that can contain text or graphics.
151
30 sec
Q.
An Office feature that combines text and artistic effects.
152
30 sec
Q.
The parameters of a function.
153
30 sec
Q.
A formula in which the result is determined by the presence or absence of a particular condition.
154
30 sec
Q.
A condition you specify to limit which records are returned when filtering data.
155
30 sec
Q.
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
156
30 sec
Q.
A range of cells in a worksheet that contains related data and can be used by a lookup function.
157
30 sec
Q.
Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.
158
30 sec
Q.
In a shared workbook, a feature that includes the name of the person who made each change, when the change was made, and what data was changed.
159
30 sec
Q.
Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.
160
30 sec
Q.
A workbook set up to allow multiple networked users to view and make changes simultaneously.
161
30 sec
Q.
A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.
162
30 sec
Q.
A feature that marks and records changes made to a workbook.
163
30 sec
Q.
Arrange in a line or bring into alignment.
164
30 sec
Q.
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
165
30 sec
Q.
Two or more cells combined into a single cell.
166
30 sec
Q.
A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more
167
30 sec
Q.
A line bordering the chart plot area used as a frame of reference for measurement.
168
30 sec
Q.
A graphical representation of numeric data in a worksheet.
169
30 sec
Q.
The entire chart and all its elements.
170
30 sec
Q.
A sheet that contains only a chart.
171
30 sec
Q.
Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.
172
30 sec
Q.
A row or column of data represented by a line, set of columns, bars, or other chart type.
173
30 sec
Q.
A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)
174
30 sec
Q.
A chart placed on a worksheet rather than on a separate chart sheet.
175
30 sec
Q.
A graphical representation of the data in a PivotTable.
176
30 sec
Q.
A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
177
30 sec
Q.
A tool that offers Excel users the ability to generate PivotTables very quickly on very large data sets of tens or even hundreds of millions of rows.
178
30 sec
Q.
A term that describes when two tables have a connection between two fields.
179
30 sec
Q.
A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.