Midterm Flashcards
(280 cards)
1
Q
A user interface in Office 2016 and Windows 10 that groups the commands for performing related tasks on tabs across the upper portion of the program window.
A
Ribbon
2
Q
Characters that display on the screen, but do not print, indicating where the ENTER key, the SPACEBAR, and the TAB key were pressed; also called formatting marks.
A
Nonprinting characters
3
Q
The symbol ¶ that represents the end of a paragraph.
A
Paragraph Symbol
4
Q
The term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.
A
Default
5
Q
A combination of two or more keyboard keys, used to perform a task that would otherwise require a mouse.
A
Keyboard shortcut
6
Q
A small toolbar containing frequently used formatting commands that displays as a result of selecting text or objects.
A
Mini toolbar
7
Q
A group of formatting commands, such as font, font size, font color, paragraph alignment, and line spacing that can be applied to a paragraph with one command.
A
Style
8
Q
A technology that shows the result of applying an editing or formatting change as you point to possible results—before you actually apply it.
A
Live preview
9
Q
An Office feature that displays a list of potential results instead of just the command name.
A
Gallery
10
Q
Microsoft’s collection of Apps for Office that you can download within an application.
A
Office Store
11
Q
A reserved area for text or graphics that displays at the bottom of each page in a document.
A
Footer
12
Q
An instruction to a computer program that causes an action to be carried out.
A
Command
13
Q
A button that displays when an object is selected and that has commands to choose how the object interacts with surrounding text.
A
Layout Options
14
Q
A text box, picture, table, or shape that you can select and then move and resize.
A
Object
15
Q
Small squares that indicate a picture or object is selected.
A
Sizing handles
16
Q
The action of pressing and releasing the left button on a mouse pointing device one time is called:
A
click
17
Q
The action of moving your mouse pointer over something on your screen is called:
A
point
18
Q
The process of making changes to text or graphics in an Office file is called:
A
editing
19
Q
The action of holding down the left mouse button while moving your mouse is called:
A
dragging
20
Q
The action of clicking the right mouse button one time is called
A
right-click
21
Q
The action of canceling the selection of an object or block of text by clicking outside of the selection is called:
A
deselect
22
Q
The tab in Backstage view that displays information about the current file is the:
A
info tab
23
Q
Tabs that are added to the ribbon automatically when a specific object, such as a picture, is selected, and that contain commands relevant to the selected object are:
A
contextual tabs
24
Q
A page orientation in which the paper is taller than it is wide is called:
A
portrait
25
A set of characters with the same design and shape is a
font
26
A font design that includes small line extensions on the ends of the letters to guide the eye in reading from left to right is a:
serif font
27
Formatting emphasis such as bold, italic, and underline is referred to as:
font style
28
In an Office program window, the small row of buttons in the upper left corner of the screen from which you can perform frequently used commands is the:
quick access toolbar
29
A set of three dots indicating that a dialog box will display if you click the command is:
an ellipsis
30
The process of updating computer files that are in two or more locations according to specific rules is called:
syncing
31
Text added to a picture or object that helps people using a screen reader understand what the object is.
alternative text
32
A command that identifies a work, section, or place in a document so that you can find it quickly without scrolling.
bookmark
33
A command that searches your document for features that may not be supported by older versions of Office.
Check Compatibility
34
Details about a file that describe or identify it, including the title, author name, subject, and keywords that identify the document's topic or contents.
document properties
35
A reserved area for text or graphics that displays at the bottom of each page in a document.
footer
36
A command that searches your document for hidden data or personal information that you might not want to share publicly.
inspect document
37
In an Office program window, the small row of buttons in the upper left corner of the screen from which you can perform frequently used commands.
quick access toolbar
38
A group of formatting commands, such as font, font size, font color, paragraph alignment, and line spacing that can be applied to a paragraph with one command.
style
39
An Office feature in Word, Excel, and PowerPoint that enables you to change normal text into decorative stylized text.
wordart
40
The action of increasing or decreasing the size of the viewing area on the screen.
zoom
41
A cell reference that refers to cells by their fixed position in a worksheet.
Absolute cell reference
42
2. A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
Cell style
43
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Auto Fill
44
4. An equation that performs mathematical calculations on values in a worksheet.
Formula
45
5. An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Name Box
46
6. A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.
Quick Analysis Tool
47
7. A specific way in which Excel displays number in a cell.
Number format
48
8. A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
Sparkline
49
9. The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.
Chart layout
50
10. A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa.
Switch Row/Column
51
An Excel file that contains one or more worksheets.
Workbook
52
Another name for a worksheet.
Spreadsheet
53
The intersection of a column and a row.
Cell
54
The labels along the lower border of the Excel window that identify each worksheet.
Sheet tabs
55
A vertical group of cells in a worksheet.
Column
56
A horizontal group of cells in a worksheet.
Row
57
Anything typed into a cell.
Cell content
58
Text or numbers in a cell.
Data
59
Numbers, text, dates, or times of day that you type into a cell.
Constant value
60
An equation that performs mathematical calculations on values in a worksheet.
Formula
61
Constant values consisting of only numbers.
Number values
62
Another name for a cell reference.
Cell address
63
Another name for a constant value.
Value
64
The small black square in the lower right corner of a selected cell.
Fill handle
65
The graphic representation of data in a worksheet.
Chart
66
On startup, Excel displays a new blank
workbook
67
An element in the Excel window that displays the value or formula contained in the active cell is the
formula bar
68
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
name box
69
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
select all box
70
A cell surrounded by a black border and ready to receive data is the
active cell
71
The feature that generates and extends values into adjacent cells based on the values of selected cells is:
Auto Fill
72
The default format that Excel applies to numbers is the:
general format
73
The data that displays in the Formula Bar is referred to as the
underlying value
74
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
75
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
76
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
autofit
77
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
operators
78
A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:
Quick Analysis tool
79
The area along the bottom of a chart that identifies the categories of data is the:
category axis
80
A feature that outlines cells in color to indicate which cells are used in a formula is called:
range finder
81
A predefined formula that performs calculations by using specific values in a particular order or structure.
Function
82
Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.
Statistical functions
83
A predefined formula that adds all the numbers in a selected range.
SUM function
84
An Excel function that adds a group of values and then divides the result by the number of values in the group.
AVERAGE function
85
An Excel function that finds the middle value that has as many values above it in the group as are below it.
MEDIAN function
86
An Excel function that determines the smallest value in a range.
MIN function
87
An Excel function that determines the largest value in a range.
MAX function
88
A command that enables you to select one or more rows or columns and lock them in place.
Freeze Panes
89
A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
Logical functions
90
Conditions that you specify in a logical function.
Criteria
91
A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria.
COUNTIF function
92
Any value or expression that can be evaluated as being true or false.
Logical test
93
A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.
IF function
94
Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (
Comparison operator
95
A format that changes the appearance of a cell based on a condition.
Conditional format
96
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a
data bar
97
The function that retrieves and then displays the date and time from your computer is the:
NOW function
98
The process of moving within a worksheet or workbook:
navigate
99
A series of rows and columns that contains related data and that is managed independently from other data is an Excel
table
100
The process of arranging data in a specific order based on the value in each field is called:
sorting
101
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:
filtering
102
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
print titles
103
The labels along the lower border of the workbook window that identify each worksheet are the:
sheet tabs
104
A worksheet where totals from other worksheets are displayed and summarized is a:
summary sheet
105
The worksheets that contain the details of the information summarized on a summary sheet are called:
detail sheets
106
The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:
paste
107
The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:
flash fill
108
The values that an Excel function uses to perform calculations or operations are the:
arguments
109
The target destination for data that has been cut or copied using the Office Clipboard is the:
paste area
110
The term used to describe an Excel function that is subject to change each time the workbook is opened is called:
volatile
111
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
average
112
An Excel function that determines the largest value in a selected range of values.
max
113
A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments—the range of cells to check and the criteria.
COUNTIF
114
A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.
conditional formatting
115
An Excel function that retrieves the date and time from your computer’s calendar and clock and inserts the information into the selected cell.
NOW
116
A command that enables you to select one or more rows or columns and lock them into place; the locked rows and columns become separate panes.
freeze panes
117
Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages.
scale to fit
118
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.
filter
119
The action of placing cell contents that have been copied or moved to the Clipboard into another location.
paste
120
The process of arranging data in a specific order based on the value in each field.
sort
121
A chart that shows the relationship of each part to a whole.
Pie chart
122
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
Goal Seek
123
In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to in the formula.
Relative cell reference
124
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
Data marker
125
A workbook sheet that contains only a chart.
Chart sheet
126
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
Bevel
127
The entire chart and all of its elements.
Chart area
128
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
What-if analysis
129
The mathematical formula to calculate a rate of increase.
Rate = amount of increase/base
130
The mathematical rules for performing multiple calculations within a formula.
Order of operations
131
The Excel feature which, after typing = and the first letter of a function, displays a list of function names.
Formula AutoComplete
132
A line that serves as a frame of reference for measurement and that borders the chart plot area.
Axis
133
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.
Category axis
134
A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.
Value axis
135
The formula for calculating the value after an increase by multiplying the original value—the base—by the percent for new value.
Value after increase = base × percent for new value
136
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:
an enterprise fund
137
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:
absolute
138
A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:
point
139
Related data points represented by data markers are referred to as the data:
series
140
The action of pulling out a pie slice from a pie chart for emphasis is called:
explode
141
The value in a chart’s value axis that determines the spacing between tick marks and between the gridlines in the plot area is the:
major unit
142
The percent by which one number increases over another number is the percentage rate of:
increase
143
A chart type that displays trends over time is a
line chart
144
The area bounded by the axes of a chart, including all the data series, is the:
plot area
145
The x-axis is also known as the:
category axis
146
The term that refers to an image that appears to have all three spatial dimensions is:
3-D
147
The y-axis is also known as the
value axis
148
In a chart, each data point—bar, slice, and so on—has a unique
color or pattern
149
The starting point when you divide the amount of increase by it to calculate the rate of increase is the:
base
150
A pie slice is an example of
data marker
151
A type of chart that shows the relationship of each part to a whole.
pie
152
A type of chart that displays trends over time.
line
153
A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
legend
154
The area bounded by the axes of a chart, including all the data series.
plot area
155
A workbook sheet that contains only a chart.
chart sheet
156
The numerical scale on the left side of a chart that shows the range of numbers for the data points.
value axis
157
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
goal seek
158
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
data point
159
The command that moves a chart to a worksheet that contains only a chart and no other worksheet data.
move chart
160
The Paste option used to paste calculated values that result from the calculation of formulas along with the formatting applied to the copied cells.
Values & Number Formatting
161
An organized collection of facts about people, events, things, or ideas related to a specific topic.
Database
162
Facts about people, events, things, or ideas.
Data
163
Data that is organized in a useful manner.
Information
164
A simple database file that is not related or linked to any other collection of data.
Flat database
165
The database object that stores the data, and which is the foundation of an Access database.
Table
166
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.
Record
167
A single piece of information that is stored in every record and represented by a column in a table.
Field
168
A principle stating that data is organized in tables so that there is no redundant data.
First principle of good database design
169
A principle stating that techniques are used to ensure the accuracy of data entered into a table.
Second principle of good database design
170
The process of applying design rules and principles to ensure that a database performs as expected.
Normalization
171
A field in one or more tables that stores the same data.
Common field
172
The basic parts of a database; for example tables, queries, forms, and reports.
Objects
173
The window area that organizes the database objects and from which you open objects.
Navigation Pane
174
The window area that displays each open object on its own tab.
Object window
175
The action of filling a database with records.
Populate
176
The Access view that displays data in columns and rows like an Excel worksheet is:
datasheet view
177
The characteristic that defines the kind of data you can store in a field is the:
data type
178
The box at the left of a record in Datasheet view that you click to select an entire record is the:
record selector box
179
To add on to the end of an object, such as to add records to the end of an existing table, is to:
append
180
Characteristics of a field that control how the field displays and how data is entered are:
field properties
181
The field that uniquely identifies a record in a table is known as the
primary key
182
The underlying design of a table is referred to as the
structure
183
The object that retrieves specific data and then displays only the data that you specify is a:
query
184
The object that displays fields and records from a table or query in a printable format is a:
report
185
Information repeated in a database in a manner that indicates poor design is said to be:
redundant
186
The data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a ZIP code is:
short text
187
The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is:
currency
188
Precise changes to the properties—characteristics—of selected items in database can be made in the:
property sheet
189
The data type that describes a unique sequential or random number assigned by Access as each record is entered is:
autonumber
190
A more sophisticated type of database that stores multiple collections of data that are related to one another; for example, data about the students, the courses, and the faculty members at a college is a:
relational database
191
An Access view that displays data in rows similar to the format of an Excel worksheet.
datasheet
192
An Access view that displays the underlying view of an object
design
193
A classification or the kind of data that you can store in a field, such as numbers, text, or dates.
data type
194
Term used to describe a unique sequential or random number assigned by Access as each record is entered.
autonumber
195
The process of adding data from an Excel spreadsheet to an existing Access table that is closed.
appending
196
Settings that control how the field displays and how data can be entered into the field.
field properties
197
An Access field property that limits the number of characters that can be typed into a text or number field.
field size
198
The required field in the table that uniquely identifies a record.
primary key
199
A preformatted database that contains prebuilt tables, queries, forms, and reports that perform a specific task, such as tracking events.
database template
200
A data type that describes numbers that represent a quantity and may be used in calculations.
number
201
The area directly below the ribbon that displays information such as security alerts.
Message Bar
202
An area where you can view the security and privacy settings for your Access installation.
Trust Center
203
An association that you establish between two tables based on common fields.
Relationship
204
A relationship between two tables, where one record in the first table corresponds to many records in the second table.
One-to-many relationship
205
In the query design window, in the table area, the list of field names in a table.
Field list
206
The primary key field is connected to this field in the related table to create a relationship.
Foreign key
207
A set of rules that ensures that the data between related tables is valid.
Referential integrity
208
The visual cue in the Relationships window that indicates tables are related by connecting common fields.
Join line
209
In Datasheet view, clicking the plus sign (+) displays the related records in this format.
Subdatasheet
210
The process of arranging data in a specific order based on the data in a field.
Sorting
211
A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.
Ascending
212
A sorting order that arranges text in reverse alphabetical order (Z to A) and numbers from the highest number to the lowest number.
Descending
213
In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting.
Outermost
214
In Datasheet view, when sorting using multiple fields, the field that is used for the last level of sorting.
Innermost
215
The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.
Run
216
Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:
cascade options
217
The lower area of the query design window where criteria is entered is the:
design grid
218
Min, Max, Avg, and Sum are examples of:
aggregate functions
219
Conditions in a query that identify the specific data for which you are looking are known as:
criteria
220
A criteria that searches for fields that are empty is:
Is null
221
They symbols =, >, and < are known as:
comparison operators
222
A comparison operator that searches for values within a range is:
between . . . and
223
The logical operator that requires all criteria to be met to return a result is:
AND
224
A wildcard character that serves as a placeholder for one or more unknown characters is the:
*
225
A field that stores the value of a mathematical operation is:
calculated field
226
For a calculated field, the new field name must be followed by:
colon
227
A query that uses an aggregate function and displays data grouped by two types of information is:
a crosstab query
228
A query that prompts you for criteria when it is run is a
parameter query
229
Criteria that can be changed when a query is run is a
parameter
230
A good parameter for a City field is:
[enter a city]
231
An Access relationship where one record in the first table corresponds to many records in the second table.
One-to-many
232
A set of rules that Access uses to ensure that the data between related tables is valid.
Referential integrity
233
A sort order that sorts text alphabetically (A to Z) and sorts numbers from the lowest number to the highest number.
ascending
234
The first level of sorting when sorting records on two or more fields.
outermost
235
In a query with multiple sort fields, the fields with a Sort setting must be placed in what order?
left to right
236
Symbols that are used to evaluate data in the field to determine if it is the same (=), greater than (>), less than (
comparison operators
237
Symbols that enable you to enter multiple criteria for the same field or for different fields.
logical operators
238
A field that stores the value of a mathematical operation.
calculated
239
A query that uses an aggregate function for data that can be grouped by two types of information and displays the data in a compact, spreadsheet-like format with column headings and row headings.
crosstab query
240
A query that prompts you for criteria before running the query.
parameter query
241
1. The Access view in which you can make changes to a form or report while the object is
running—the data from the underlying data source displays.
layout view
242
_____2.The term used to describe objects and controls that are based on data that is stored in tables.
bound
243
_____3. The Access view that displays the detailed structure of a form or report, may be the view in which
some tasks must be performed, and only displays the controls (not the data).
design view
244
_____4. Information such as a form's title that displays at the top of the screen in Form view or Layout
view and is printed at the top of the first page when records print as forms
form header
245
_____5. The section of a form or report that displays the records from the underlying table or query.
detail section
246
_____6. Information at the bottom of the screen in Form view or Layout view that is printed after the last
detail section on the last page of a printout.
form footer
247
_____7. In Design view, a grey bar in a form or report that identifies and separates one section from
another, used to select the section and to change the size of a section.
section bar
248
_____8. An object on a form or report that displays data or text, performs actions, and lets you view and
work with information.
control
249
_____9. An example of a bound control on a form or report that displays the data from a field in the
underlying table or query.
text box control
250
_____10. A control that retrieves its data from a field in an underlying table or query.
bound control
251
_____11. A control on a form or report that contains descriptive information, usually a field name
or title.
label control
252
_____12. A control that does not have a source of data, such as a title in a form or report.
unbound control
253
_____13. The grouped arrangement or layout of controls on a form or report.
control layout
254
_____14. A control that contains an expression, often a formula or function, that most often
summarizes a field that contains numeric data.
calculated control
255
_____15. A control on a form or report that inserts the current date each time the form or report is
opened.
date control
256
A database object that you can use to enter new records into a table, or to edit, delete, and display existing records in a table is a
form
257
The order in which the insertion point moves from one field to another in a form when you press the Tab key is:
tab order
258
A small symbol that displays in the upper left corner of a control layout in a form or report that is displayed in Layout view or Design view and that is used to move or format entire group of controls is the:
layout selector
259
An area that displays at the bottom of the window in which you can control how information is sorted and grouped in a report is the:
Group, Sort, & Total pane
260
The process of displaying only a portion of the total records (a subset) based on matching specific values to provide a quick answer is:
filtering
261
An Access command that filters the records in a form based on one or more fields, or based on more than one value in the field, is Filter by:
form
262
A condition in which records display only when all of the specified values are present in the selected field is:
AND
263
A database object that summarizes the fields and records from a query or table in an easy-to-read format suitable for printing is a:
report
264
Information printed at the end of each group of records in a report that is most commonly used to display summary information is the:
group footer
265
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to all of the objects in a database or to individual objects is a:
theme
266
To align controls in a report, first display the report in
design view
267
Select multiple controls to format by holding down
shift
268
An Access tool that walks you step-by-step through the creation of a report is the:
report wizard
269
To apply a filter that has been saved with a form, in the navigation area, click:
unfiltered
270
The default setting for grouping of records in a report is:
do not keep group together on one page
271
A control that retrieves its data from an underlying table or query; a text box control is an example of a bound control.
bound control
272
An object on a form or report that displays data or text, performs actions, and lets you view and work with information.
control
273
A control on a form or report that inserts the current date each time the form or report is opened.
date control
274
The section of a form or report that displays the records from the underlying table or query.
detail section
275
An Access command that filters the records in a form based on one or more fields, or based on more than one value in the field.
filter by form
276
The process of displaying only a portion of the total records (a subset) based on matching specific values to provide a quick answer to a question.
filtering
277
A small symbol that displays in the upper left corner of a selected control layout in a form or report that is displayed in Layout view or Design view; used to move or format an entire group of controls.
layout selector
278
The Access view in which you can make changes to a form or report while the object is running—the data from the underlying data source displays.
layout view
279
The tables or queries that provide the underlying data for a form or report
record source
280
An Access tool that walks you step by step through the creation of a report and that gives you more flexibility in the design, layout, and number of fields in a report.
report wizard
