Excel and Access Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

A&P Ch. 19-20: Reproduction & Fetal Development PART 2

View Set

vce english language formal language

View Set

Unit 01: Shapes & Transformations

View Set

Radiographic positioning of the Hand, Wrist, Fingers

View Set

Personal Finance Study Guide: Final EXAM!

View Set