BUS 180 FINAL EXAM SPIVEY
the 3 number formats located on the Home Tab
1. accounting 2. Percent 3. comma
a formula can combine what elements:
1. cell reference 2. arithmetic operations 3. values 4. functions
EXCEL HOME PAGE
1. name box 2. insert function 3. formula bar 4. column heading 5. select ALL 6. active cell 7. row heading 8. sheet tab navigation 9. sheet tab 10. new sheet 11. view & zoom
list the order of operations
1. parenthesis 2. exponent 3. multiplication 4. division 5. addition 6. subtraction
two ways to copy a worksheet
1. press & hold CRTL key and drag to worksheet tab 2. right click the sheet tab and select move or copy
the page setup dialog box controls allows users to:
1. specify page options 2. set margin options 3. create header and footers 4. select sheet options, which includes repeating rows and columns
Relationship in Access
A connection between two tables with a common field
way to automatically populate the Primary Key
Auto Number
A field that displays the results of an expression
Calculated Field
tools on a form to add, edit, and display data
Controls
determines the type of data allowed in a field
Data Type
A _____ is used to identify different data types in criteria
Delimiter
a view that is shared by all objects
Design view
The way to preserve table relationships when new data is entered
Enforce Referential Integrity
A combination of elements that produce a value is___ ?
Expression
_____ allows a query to summarize data by the values of a field
Grouping
The comparison operate that will identify blank fields
Is Null
When sorting multiple columns the first sort must always be _____?
On the left
which of the following is NOT a database object
Pivot Table
the table or query that supplies the records for a form
Record source
Primary Key
The unique record identifier in a table
the button used to switch between filtered and non-filtered views
Toggle Fitler
Select the wildcard that will match any character not in the brackets
[!]
a tool that performs calculations on the entire column of data and returns a single value
aggravate function
A feature that searches for text in the same column and automatically displays items that begin with the same text that you are typing is _____.
auto complete
_____ is a feature that helps you complete a sequence of ____ or ____
auto fill & words & values
using a form will _____?
both A and B are true
the intersection of a column and a row is a _____.
cell
the tilde key can be used to display ______
cell formulas
You should use_____ instead of _____ in formulas where possible
cell reference & values
_____ is a collection of format settings to provide a consistent appearance within a worksheet
cell style
the cell address is identified first by its _____ and then by its _____.
column letter & row number
the condition when data is duplicated in two or more tables
data redundancy
Start a formula with an ____ sign
equal (=)
A tool in access that can help create more complicated expressions
expression builder
The foreign key uniquely identifies each record in a table
false
the _____ is a small square that appears to provide fill options
fill handle
to edit a cell; click in the _____ or press ______
formula bar & F2
paste formulas
formulas, but no formatting
a predefined computation that performs a complex calculation
function
paste special
gives more pasting options
click on ----&----- to change the sort order in a report
group & sort
Sub-form
info from a related table is shown as other info on a form
a form view where data can be viewed, but not changed
layout view
merge and center
merges selected cells together and centers data in one cell
(#####) displays when a cell is too ____ to display the value
narrow
_____ contains multiple ____
nonadjacent ranges & ranges
paste formatting
number & text formatting only; no cell contents
______ settings control how a value is displayed
number format
The relationship when primary key in one table matches many foreign keys in adjoining table
one-to-many
______ displays in the bottom-right corner of the pasted data and offers different result options
paste options button
paste values
pastes un-formatted values that are results of formulas
an object that answers a question about data in a table and creates subsets or summarizes
query
_____ refers to a group of adjacent or contiguous cells
range
cell references in copied formulas adjust based on their _____ locations to the _______ formula
relative & original
the easiest way to create a tabular report based on a table or query
report tool
a series of step by step questions to design a custom report
report wizard
a form that shows two views of the same data
split form
A _____ is an electronic file that contains a grid of columns and rows used to organize and display data.
spread sheet
Design rule for a table
store data in the smallest parts
Choose the last statement that best describes an application part
the ability to add a pre made section
the primary difference between text and value entries is that _____ entries can be basis of _____, whereas ____ cannot
value & calculations & text
A _____ is a single spreadsheet, while a _____ is a collection of one or more related worksheets
work sheet & work book
use____ to make data appear on multiple lines within a cell
wrap text
