Excel and Access Quiz
15) Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?
#
22) Which symbol represents that a cell is an absolute cell reference in a function or formula?
$
When no comparison operator is displayed, Access will use the default ________ comparison operator for numeric data types.
=
24) ________ is a group of related data points represented by data markers.
A data series
A user can create a(n) ________ condition by placing criteria for more than one field on the same Criteria row.
AND
13) Which of the following is NOT a way to insert the SUM function into a cell?
Alt+=
12) What is the keyboard shortcut for flash fill?
Ctrl+E
17) A(n) ________ illustrates the value of a cell relative to other cells in the worksheet.
Data Bar
35) Which of the following is NOT a way method to create a new database?
Database wizard
40) Which of the following is NOT a way method to create a new database?
Database wizard
18) The NOW function is ________, meaning that it will update automatically each time the workbook is opened.
Date/Time function
11) Which of the following Excel features recognizes a pattern in the data of a worksheet?
Flash Fill
2) What are the two contextual tabs that display under Chart Tools when a chart is selected?
Format and Design
19) The ________ command allows you to select one or more rows or columns and lock them into place.
Freeze Panes
28) ________ within parentheses are processed first within the order of operations.
Functions
25) Which of the following is NOT one of the three spatial dimensions of 3-D?
Height
3) Where is the fill handle located?
In the lower right corner of a selected cell
29) A(n) ________ chart emphasizes the flow from one data point value to the next.
Line
16) The ________ function determines the largest value in a range of cells.
MAX
The ________ condition is used to display records that meet one or more parts of the specified criteria.
OR
1) Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.
Sparklines
4) When you type data in a cell and press Enter, what cell becomes the active cell?
The cell below
14) The MEDIAN function finds ________.
The middle value in a range of cells
33) When designing a new database, the first question users should ask themselves is ________.
What questions should this database be able to answer?
38) When designing a new database, the first question users should ask themselves is ________.
What questions should this database be able to answer?
21) A(n) ________ refers to a cell by its fixed position in the worksheet.
absolute cell reference
30) A line that serves as a frame of reference for measurement in a chart is a(n) ________.
axis
9) A(n) ________ is a vertical group of cells in an Excel worksheet.
column
34) When linking two tables in a relational database, a user will use a ________ to create the link.
common field
39) When linking two tables in a relational database, a user will use a ________ to create the link.
common field
47) When a user specifies more than one condition in a query, it is called a ________ criteria.
compound
31) A ________ is an organized collection of data.
database
36) A ________ is an organized collection of data.
database
41) To quickly rename a table, a user can ________ on the table name from the Navigation Pane and select Rename.
double-click
32) Databases that not related or linked to other data are called ________ databases.
flat
37) Databases that not related or linked to other data are called ________ databases.
flat
10) Cell content can be one of two things: a constant value or a(n) ________.
formula
44) To edit an existing relationship, a user will need to right-click on the ________ line.
join
8) The ________ displays the name given to a selected cell, table, chart, or object.
name box
43) The most common type of relationship in Access is ________.
one-to-many
26) A(n) ________ displays the relationship of each part of a whole.
pie chart
45) The Query window is broken into two parts, the table area and the ________.
query design grid
42) To connect two or more tables that have common fields, a user will need to establish and define the table ________.
relationships
5) The ________ displays the current cell mode, the page number, and the zoom buttons.
status bar
20) An Excel ________ is a range of cells converted in Excel used to analyze a group of related
table
23) You must select ________ on a worksheet to create a pie chart.
two ranges
27) Goal Seek is a ________ tool in Excel 2016.
what-if analysis
A ________ character is used to represent one or more unknown characters in a string.
wildcard
6) A(n) ________ is an Excel document that stores data.
workbook
7) An Excel workbook contains one or more ________ that are stored in the workbook.
worksheets and spreadsheets
