Unit E

Question 1

Convert Text to columns

Answer 1

breaks data feels in one column to separate columns

Question 2

delimiter

Answer 2

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

Question 3

Proper function

Answer 3

capitalizes the first letter of a word in a column

Question 4

data tab

Answer 4

lets you work with conversion

Question 5

UPPER

Answer 5

converts text to all caps

Question 6

LOWER

Answer 6

converts text to all lowercase

Question 7

IF commands

Answer 7

are used based on different conditions

Question 8

Consolidate

Answer 8

summarizes similar data that exists in different sheets

Question 9

link

Answer 9

allows you to references data in other sheets or in other workbooks

Question 10

external reference indicater

Answer 10

cells referred are outside the active sheets

Question 11

IF ERROR

Answer 11

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

Question 12

Circular references

Answer 12

contains a formula that refers to its own cell location

Question 13

DIV/0!

Answer 13

a value in a formula is not available

Question 14

NA

Answer 14

a value in formula is not available

Question 15

3-D reference

Answer 15

reference other sheets - which creates another dimension

Question 16

NUM

Answer 16

invalid use of a number in a formula

Question 17

VALUE

Answer 17

wrong type of formula argument or operand

Question 18

NAME?

Answer 18

formula contains text error

Question 19

NULL!

Answer 19

invalid intersection of areas

Question 20

REF!

Answer 20

invalid cell reference

Question 21

#####

Answer 21

column is not wide enough to display data

Question 22

Scope

Answer 22

worksheets where it can be used

Question 23

Logical formula

Answer 23

makes calculations based on criteria

Question 24

sated conditions

Answer 24

criteria you create

Question 25

<

Answer 25

less then

Question 26

>

Answer 26

greater then

Question 27

=

Answer 27

equal

Question 28

<+

Answer 28

less then or equal

Question 29

>=

Answer 29

greater then or equal to

Question 30

<>

Answer 30

not equal to

Question 31

Returns

Answer 31

displays

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

further value of money given for monthly investment