Final

Question 1

the _____ displays the current cell mode, the page number, and the zoom buttons

Answer 1

status bar

Question 2

a text value in excel is also referred to as a ______

Answer 2

label

Question 3

where is the fill handle located?

Answer 3

in the lower right corner of a selected cell

Question 4

a defined set of formatting characteristics such as font, font size, and font color are knows as a

Answer 4

cell style

Question 5

the value axis is also know as the ____

Answer 5

y-axis

Question 6

to display document properties, click the ____ tab

Answer 6

file

Question 7

comma style format displays a number with _____

Answer 7

two decimal places

Question 8

the COUNT function counts the number of cells in a range that _________

Answer 8

contain a number

Question 9

the COUNTIF function has two arguments

Answer 9

the range of cells to check and the criteria

Question 10

What does a data bar in a cell represent?

Answer 10

the value of a cell relative to the other cells

Question 11

What is an Excel table?

Answer 11

a series if rows and columns that contains related data that can be managed independently from other data in a worksheet

Question 12

on your keyboard, which two symbols function identically in date formula

Answer 12

the hyphen key and the forward slash key

Question 13

the ____ is the temporary storage location for cell contents copied from a worksheet

Answer 13

clipboard

Question 14

you must select ____ on a worksheet to create a pie chart

Answer 14

two ranges

Question 15

a chart and all of its elements s known as the ____

Answer 15

chart area

Question 16

____ is an excel tool that finds the input needed to arrive at a desired result

Answer 16

goal seek

Question 17

the process of changing cells in a worksheet to see how those changes affect the outcome of furmulas is known as_____

Answer 17

what-if analysis

Question 18

in a line chart, which of the following resides along the bottom of the chart

Answer 18

the x-axis

Question 19

databases that are not related or linked to other data are called___ databases

Answer 19

flat

Question 20

When designing a new database, the first question users should ask themselves is _____

Answer 20

What questns should this database be able to answer

Question 21

when appending or creating a new table from an import, the file that is being imported is called the ____ file

Answer 21

source

Question 22

there are two vies for tables n Access: Datasheet view and____ view

Answer 22

design

Question 23

the ___ key refers to the unique field that identifies each record

Answer 23

primary

Question 24

fields that contain numbers that are not used in calculations should be set to ___

Answer 24

short text

Question 25

a ___ is a database object that retrieves specific data from one or more database objects

Answer 25

query

Question 26

the ___ view of a form allows a user to view the data while making changes to the elements of the form

Answer 26

layout

Question 27

to quickly rename a table, a user can ____ on the table name from the navigation pane and select remane

Answer 27

right-click

Question 28

to correct two or more tables that have common fields, a user will need to establish and define the table ____

Answer 28

relationships

Question 29

____ is the process of arrangng data in a specific order based on the value in a field

Answer 29

sorting

Question 30

when creating a table sort on two or more fields, the first level of sorting is referred to as the ____ sort field

Answer 30

outermost

Question 31

fields in teh query design grid include all of the following except:

Answer 31

they don’t include fields that are listed as primary keys

Question 32

a user can add ___ to the criteria for a field in the query design grid to return results where there is nothing in that field

Answer 32

Is Null

Question 33

If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ____

Answer 33

> =500

Question 34

single record forms are helpful to users who ___

Answer 34

perform data entry

Question 35

by using a single-record form to add, modify, and delete record, a user can reduce the number of ___ because the individual performing the changes is only looking at one entry at a time

Answer 35

entry errors

Question 36

when a user makes changes to a record in a form, the record is also updated in the underlying ___

Answer 36

table

Question 37

___ records in a form display only a portion of the total records based on matching specific values

Answer 37

filtering

Question 38

when users create an AND condition for their filter criteria, the results returned where ___ criteria are met

Answer 38

all

Question 39

a ____ control displays to the left of a text box control and contains descriptive info, usually the field name

Answer 39

label

Question 40

users can export an Access database to all of the following except a ___

Answer 40

powerpoint

Question 41

Relationships where the join line displays 1 and infnity are displayed indicate that ____ is selected

Answer 41

enforce referental integrity

Question 42

users can create a report using the report _____ to walk them through a step by step process to help group and sort data in a new report

Answer 42

wizard

Question 43

____ data in a report helps to organize and summarize the data.

Answer 43

grouping