Final Flashcards
the _____ displays the current cell mode, the page number, and the zoom buttons
status bar
a text value in excel is also referred to as a ______
label
where is the fill handle located?
in the lower right corner of a selected cell
a defined set of formatting characteristics such as font, font size, and font color are knows as a
cell style
the value axis is also know as the ____
y-axis
to display document properties, click the ____ tab
file
comma style format displays a number with _____
two decimal places
the COUNT function counts the number of cells in a range that _________
contain a number
the COUNTIF function has two arguments
the range of cells to check and the criteria
What does a data bar in a cell represent?
the value of a cell relative to the other cells
What is an Excel table?
a series if rows and columns that contains related data that can be managed independently from other data in a worksheet
on your keyboard, which two symbols function identically in date formula
the hyphen key and the forward slash key
the ____ is the temporary storage location for cell contents copied from a worksheet
clipboard
you must select ____ on a worksheet to create a pie chart
two ranges
a chart and all of its elements s known as the ____
chart area
____ is an excel tool that finds the input needed to arrive at a desired result
goal seek
the process of changing cells in a worksheet to see how those changes affect the outcome of furmulas is known as_____
what-if analysis
in a line chart, which of the following resides along the bottom of the chart
the x-axis
databases that are not related or linked to other data are called___ databases
flat
When designing a new database, the first question users should ask themselves is _____
What questns should this database be able to answer
when appending or creating a new table from an import, the file that is being imported is called the ____ file
source
there are two vies for tables n Access: Datasheet view and____ view
design
the ___ key refers to the unique field that identifies each record
primary
fields that contain numbers that are not used in calculations should be set to ___
short text
a ___ is a database object that retrieves specific data from one or more database objects
query
the ___ view of a form allows a user to view the data while making changes to the elements of the form
layout
to quickly rename a table, a user can ____ on the table name from the navigation pane and select remane
right-click
to correct two or more tables that have common fields, a user will need to establish and define the table ____
relationships
____ is the process of arrangng data in a specific order based on the value in a field
sorting
when creating a table sort on two or more fields, the first level of sorting is referred to as the ____ sort field
outermost
fields in teh query design grid include all of the following except:
they don’t include fields that are listed as primary keys
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
Is Null
If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ____
> =500
single record forms are helpful to users who ___
perform data entry
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
entry errors
when a user makes changes to a record in a form, the record is also updated in the underlying ___
table
___ records in a form display only a portion of the total records based on matching specific values
filtering
when users create an AND condition for their filter criteria, the results returned where ___ criteria are met
all
a ____ control displays to the left of a text box control and contains descriptive info, usually the field name
label
users can export an Access database to all of the following except a ___
powerpoint
Relationships where the join line displays 1 and infnity are displayed indicate that ____ is selected
enforce referental integrity
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
wizard
____ data in a report helps to organize and summarize the data.
grouping
