FINAL, PT 2

A ____ is a prewritten formula that is built into Excel. a. function b. calculation c. task d. feature

A. function

Worksheet titles and subtitles should be as wordy as possible. True False

False

You can select nonadjacent ranges using the SHIFT key. True False

False

You should press the SPACEBAR to clear a cell. True False

False

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

Formula bar

____________________ cells involves creating a single cell by combining two or more selected cells.

Merging

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. True False

True

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. True False

True

A unique identifier is also called a primary key. True False

True

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship. True False

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data. True False

True

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. True False

True

Form view displays a single record at a time. True False

True

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. True False

True

Redundancy means storing the same fact in more than one place. True False

True

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. _________________________ True False

True

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing. True False

True

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. a. format b. save c. clear d. print

a. format

Which comparison operator means "not equal to"? a. > b. <> c. <= d. <

b.

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. a. sparkle b. sparkline c. special d. section

b. sparkline

All of the following are valid Excel arithmetic operators EXCEPT ____. a. % b. * c. > d. ^

c. >

A(n) ____________________ contains a specific piece of information within a record.

field

Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the Completion Date field?

Time data type

You can press the ____________________ key to quit Range Finder.

ESC

A thin red border indicates the active cell. True False

False

Excel can display characters in only three font colors: black, red, and blue. True False

False

In Access, the columns in a table are called records. True False

False

Which of the following is not a valid format symbol? a. dollar sign ($) b. comma (,) c. percent sign (%) d. semi-colon (;)

D. semi-colon (;)

The rows in the tables are called __________

Records

What data type should Joe use for the Social Security Number field? Why?

Short text data type. Even though the field will contain numbers, there will not be any calculations or arithmetic associated with them.

Which field in the Employee table should be the primary key and why?

Social security number should be the primary key because it contains nine digits for each person, which will make it easier to organize. Whereas the city, and states could be the same and cause confusion.

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

Sum

Which field in the Project table should be the primary key and why?

The primary key for the project table should be the project code due to it being different for each employee, making it easy to recognize and organize.

The <= comparison operator means less than or equal to. True False

True

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area. True False

True

The Navigation Pane contains a list of all the objects in the database. True False

True

The equal sign (=) precedes a formula. True False

True

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. True False

True

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message. a. #REF! b. #N/A c. #DIV/0! d. #NULL!

a. #REF

When you decrease the row height to ____, the row is hidden. a. 0 b. 1 c. 2 d. 3

a. 0

Which of the following calculations multiplies 23 by 0.01? : a. =23% b. =23 c. =24-.01 d. =23+.01

a. =23%

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. a. Accounting number format b. Currency style format c. Comma style format d. Percent style format

a. Accounting number format

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu. a. Delete b. Remove c. Erase d. Trash

a. Delete

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency. a. Format b. Description c. Field Size d. Caption

a. Format

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu. a. Open b. Datasheet View c. Results View d. Run

a. Open

A field whose data type is ____ can contain any characters. a. Short Text b. Alpha c. Normal d. Character

a. Short Text

George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do? a. increase the width of column H c. run the calculation again to find the available value b. provide a correct argument or operand d. replace the incorrect formula in cell H14 with one that does not divide by zero

a. increase the width of column H

A(n) ____ contains information about a given person, product, or event. a. record b. field c. column d. attribute

a. record

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

absolut

In the order of operations, the last operation Excel performs is _______________

addition

Which of the following patterns extends the fill series to 525, 475, 425?​ a. ​500, 475 b. ​625, 575 c. ​560, 580 d. ​650, 600

b. 625, 575

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. a. DIVSUM b. AVERAGE c. RANGEAVG d. MAX

b. AVERAGE

If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet? a. Copy and paste all his Sales data formulas with relative references c. Add the NOW function formula to his Sales data worksheet b. Add an IF function formula to his Sales data worksheet d. Copy and paste all his Sales data formulas with absolute references

b. Add an IF function formula to his sales data worksheet

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. a. AutoFormat b. AutoCalculate c. AutoFunction d. AutoComplete

b. AutoCalculate

What effect does the Comma Style format have on the selected cells? a. Allows for substitution of selected characters b. Displays cell contents with two decimal places and commas as thousands separators c. Converts decimals to commas within a cell d. Converts decimals to commas within merged cells

b. Displays cell contents with two decimal places and commas as thousands separators

Which of the following happens when you enter the formula =G15 into a cell? a. Nothing; =G15 is an invalid formula b. Excel assigns the value in cell G15 to the active cell c. Excel recalculates all formulas in the worksheet d. Excel assigns the sum of the values in the previous 15 cells to the active cell

b. Excel assigns the value in cell G15 to the active cell

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. a. Copy Cells b. Fill Formatting Only c. Fill Without Formatting d. none of the above

b. Fill Formatting only

Which of the following keys moves the insertion point to the beginning of data in a cell? a. TAB b. HOME c. ENTER d. INSERT

b. HOME

___ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Normal b. Page Layout c. Full Screen d. Page Break Preview

b. Page Layout

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery. a. Print Active Sheets b. Print Selection c. Print Entire Workbook d. none of the above

b. Print Selection

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. a. semi-colon (;) b. colon (:) c. period (.) d. none of the above

b. colon (:)

Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this? a. Spell checker c. Point mode b. Conditional formatting d. Formulas version

b. conditional formating

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. a. placement b. operations c. positioning d. selections

b. operations

Now Anna wants to know the longest total time she has run. By looking at the total time values, she finds the longest total time to be 54 minutes. Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time. Why did Anna prefer to use the MAX function? a. She believes that 54 minutes is her best running time. c. She believes that 54 minutes is not her best running time. b. The MAX function recalculates the highest value each time a new value is entered into the worksheet. d. The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet.

b. the MAX function recalculates the highest value each time a new value is entered into the worksheet

The ____ function is useful when you want to assign a value to a cell based on a logical test. a. OR b. NOW c. IF d. AND

c. IF

The ____ function displays the highest value in a range. a. SUM b. AVERAGE c. MAX d. MIN

c. MAX

A ____ reference is an adjusted cell reference in a copied and pasted formula. a. retained b. revised c. relative d. recycled

c. relative

The first step in creating an effective worksheet is to make sure you ____. a. enter the data b. apply font formatting c. understand what is required d. insert a chart

c. understand what is required

You should use a ____ chart to compare values side by side, broken down by category. a. Bar b. Column c. Line d. Clustered Column

d. Clustered Column

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu. a. SQL b. Query Window c. Open d. Design View

d. Design view

To import data to a table, tap or click the ____ tab on the ribbon. a. IMPORT b. DATABASE TOOLS c. FILE d. EXTERNAL DATA

d. EXTERNAL DATA

___ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. a. Option b. Formula c. Function d. Goal

d. Goal

Pressing the ____ key to complete an entry activates the adjacent cell to the right. a. DOWN ARROW b. LEFT ARROW c. UP ARROW d. RIGHT ARROW

d. RIGHT ARROW

A ____ is text and graphics that print at the top of each page. a. crown b. margin c. topper d. header

d. header

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. a. duplicate b. included c. other d. nested

d. nested

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject. a. attribute b. record c. tabular d. relational

d. relational

the adjusted cell references in a copied and pasted formula are called ____ cell references. a. pasted b. related c. alternative d. relative

d. relative

When working with a large worksheet, you can split the window into ____ panes. a. three or four b. four or five c. two or six d. two or four

d. two or four

The / arithmetic operator indicates __________

division

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll

freeze