Excel / Access Final Exam

A cell reference withonly one dollar sign before either the column or the row is called 

Toverify that a formula contains the intended cell references, use Excel’s ____.

Afield with the Memo data type can ____.

A(n)____ is a prewritten formula that is built into Excel.

A(n) ____ join is thedefault join in Access.

A ____ is apredefined set of colors, fonts, cell styles, and fill effects that can beapplied 

You can assign a ____to a cell and Excel will calculate the result.

Everytime you enter a value into a cell in the worksheet, Excel ____ all formulas.

Database ____ refersto the arrangement of data into tables and fields.

A dot on the screenthat contains color is called a ____.

Mostof the time, you will use ____ view to create queries.

You can use the fillhandle to ____.

The Currency datatype in Access is referred to as ____ in SQL Server.

A unique identifieralso is called a(n) ____ key.

Exceluses which of the following as the default date and time format?

In Datasheet view,the table is represented as a collection of rows and columns called a ____.

The rows in thetables are called ____.

To override the orderof operations, use ____.

Displaying ##### in acell refers to which of the following?  

The ____ is the orderin which arithmetic operators are calculated.

Criteriafor text data needs to be enclosed in ____.

When you insert arow, the new row automatically ____ the format from the row above.

To ____ the tables finds records in the 2 tables that have identical values in matchingfields.

A____ is made up of two values and a relational operator.

____ are simply questions,the answers to which are in the database.

You can apply ____formatting that appears only when the value in a cell meets conditions 

The ____ button givesoptions for how to fill cells following a fill operation.

A formula using a(n)____ reference instructs Excel to adjust the cell reference as it copies 

The ____ argument ofthe IF function is made up of two expressions and a comparison operator.

Todisplay your worksheet in formula view, press ____.

Use the ____ functionto determine the lowest number in a range.

Thedefault view for a worksheet is ____.

____are symbols that represent any character or combination of characters.

A(n)____ criterion is true provided either individual criterion is true

The____ function displays the highest value in a range.

All thetables, reports, forms, and queries that you create are stored in a single filecalled 

Theworksheet entries that determine the size of the slices in a pie chart arecalled the ____.

To display additionaldecimal places in a cell, click the ____ button on the Ribbon.

Whenyou use queries, usually you are looking for those records that satisfy some____.

Thearithmetic operator for division is ____.

To ensure that Excel interpretsyear values the way you intend, use ____.

The process offinding and correcting errors in a worksheet is called ____.

You can use eitherthe Blank database option or a ____ to create a new database.

Which of thefollowing is an absolute cell reference?

To select nonadjacentranges, select the first range, hold down the ____ key and drag 

Exceldisplays the error message ____ in cells to indicate a cell reference error.

____ view is onlyused to create a table or to modify the structure of the table.

Each field has a data____. This indicates the type of data that can be stored in the field.

Objecttabs for the open objects appear ____ the work area.

A formula in a cellthat contains a reference back to itself is called a ____ reference.

The most common typeof relationship you will encounter between tables is the ____ relationship.

Gr*would return the following in a search.

____means storing the same fact in more than one place.

Usingthe mouse to move or copy cells is called ____.

The ____ alerts Excelthat you are entering a formula or function and not text.

A(n)____ chart is used to show the relationship of the parts to a whole.

Excel displays whichof the following for an invalid reference?

Storing data in morethan one place can cause ____.

To specify anabsolute cell reference, enter a(n) ____ before the letter and number 

The columns in thetables are called ____.

A(n) ____ instructsthe paste operation to keep the same cell reference as it copies a formula 

The arithmeticoperator for multiplication is ____.

Thegeneral form of the IF function is ____.   

Allof the following characters cannot be used in a file name EXCEPT: ____.

Whichof the following comparison operator means greater than or equal to?

The____ dollar sign displays to the far left in a cell.

The ____ functionreturns a number that corresponds to the system date and time beginning 

The values that youuse with a function are called ____.

Whenfirst entering text in Excel, its angle is ____ degrees.

Whenyou decrease a column width to ____, the column is hidden.