Duplicate of Excel / Access Final Exam

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

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

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

Afield with the Memo data type can ____.

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

Thedefault view for a worksheet is ____.

Usingthe mouse to move or copy cells is called ____.

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

To override the orderof operations, use ____.

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

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

Which of thefollowing is an absolute cell reference?

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

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

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

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

The columns in thetables are called ____.

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

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

Gr*would return the following in a search.

You can use the fillhandle to ____.

Storing data in morethan one place can cause ____.

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

The rows in thetables are called ____.

Excel displays whichof the following for an invalid reference?

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

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

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

Criteriafor text data needs to be enclosed in ____.

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

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

____are symbols that represent any character or combination of characters.

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

____means storing the same fact in more than one place.

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

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

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

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

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

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

Thearithmetic operator for division is ____.

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

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

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

Thegeneral form of the IF function is ____.   

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

Todisplay your worksheet in formula view, press ____.

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

The values that youuse with a function are called ____.

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

The____ function displays the highest value in a range.

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

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

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

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

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

Objecttabs for the open objects appear ____ the work area.

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

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

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

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

The arithmeticoperator for multiplication is ____.

The ____ is the orderin which arithmetic operators are calculated.

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

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

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

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

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

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

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