Unit E

Question 1

Covert Text to columns

Answer 1

Breaks data fields in one column into separate columns

Question 1

Delimiter

Answer 1

Separator, such as a space, comma, or semicolon used to separate data elements

Question 2

Proper function

Answer 2

Capitalizes the first letter of a word in a column example:= PROPER (A1)

Question 3

Data Tab

Answer 3

lets you work with conversation

Question 4

Upper

Answer 4

Converts text to all caps

Question 5

Lower

Answer 5

Converts text to all lowercase

Question 6

If commands

Answer 6

are used based on different conditions

Question 7

Consolidate

Answer 7

Summarizes similar data that exists in different sheets

Question 8

Link

Answer 8

Allows you to references data in other sheets or in workbooks

Question 9

External reference indicator

Answer 9

cells referenced are outside the active sheet

Question 10

IFERROR

Answer 10

Displays a message or value that you specify, rather than one automatically generated by Excel

Question 11

Circular reference

Answer 11

contains a formula that refers to its own cell location

Question 12

DIVI/0

Answer 12

a number is divided by 0

Question 13

NA

Answer 13

a value in a formula is not available

Question 14

3-D reference

Answer 14

Reference other sheets- which creates another dimension

Question 15

NUM!

Answer 15

invalid use of a number in a formula

Question 16

VALUE

Answer 16

Wrong type of formula argument or operand

Question 17

Name ?

Answer 17

formula contains text error

Question 18

NULL!

Answer 18

invalid intersection of areas

Question 19

REF!

Answer 19

invalid cell reference

Question 20

####

Answer 20

Column is not wide enough to display data

Question 21

Scope

Answer 21

Worksheet where a formula can be used

Question 22

Logical Formula

Answer 22

Makes calculations based on criteria

Question 23

Stated conditions

Answer 23

Criteria you create

Question 24

Logical test

Answer 24

a condition that can be answered with a true or false response

Question 25

<

Answer 25

less than

Question 26

>

Answer 26

greater than

Question 27

=

Answer 27

equal to

Question 28

<=

Answer 28

less than or equal to

Question 29

> =

Answer 29

greater than or equal to

Question 30

<>

Answer 30

not equal to

Question 31

Returns

Answer 31

Display

Question 32

And function

Answer 32

evaluates all of its arguments and returns

Question 33

Pmt

Answer 33

Financial function that calculates the periodic payment amount for money borrowed (car payment) =Pmt (rate, per, pv)

Question 34

FV

Answer 34

future value of money given for monthly investment