Unit E

Question 1

convert text to columns

Answer 1

breaks data fields in one column into separate columns

Question 2

delimiter

Answer 2

separator such as 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 =PROPER (A1)

Question 4

Data Tab

Answer 4

lets you work with conversions

Question 5

upper

Answer 5

converts texts to all caps

Question 6

lower

Answer 6

converts text to all lower case

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 reference data in other sheets or in other workbooks

Question 10

external reference indicator

Answer 10

when cells are referenced outside the active sheet

Question 11

IFERROR

Answer 11

displays a message or value you specify rather than the 1 automatically generated by excell

Question 12

circular reference

Answer 12

contains a formula that refers to its own cell location

Question 13

DIVO/!

Answer 13

A NUMBER IS DIVIDED BY 0

Question 14

NA

Answer 14

a value in a formula is not availabel

Question 15

3d refrense

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 a 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 text

Question 22

Scope

Answer 22

worksheet where it can be used

Question 23

logical formula

Answer 23

makes calculations based on criteria

Question 24

stated conditions

Answer 24

criteria you creat

Question 25

logical test

Answer 25

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

Question 26

<

Answer 26

less than

Question 27

>

Answer 27

greater than

Question 28

=

Answer 28

equal to

Question 29

<=

Answer 29

less than or equal to

Question 30

>=

Answer 30

greater than or equal to

Question 31

<>

Answer 31

not equal to

Question 32

Returns

Answer 32

display

Question 33

AND function

Answer 33

evaluates all of its arguments and returns

Question 34

PMT

Answer 34

financial function that calculates payments for money borrowed (car payment) =pmt (rate, nper, pv)

Question 35

FV

Answer 35

future value of money given for monthly investment