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