Unit E notes

Question 1

Convert text columns: breaks data fields in one column into separate columns.

Question 2

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

Question 3

Proper function: capitalizes the first letter of a word in the column example =proper(A1)

Question 4

data tab: lets you work with conversion.

Question 5

upper: converts text to all caps.

Question 6

lower: converts text to all lowercase.

Question 7

IF commands: are used based on different conditions.

Question 8

consolidate: summarizes similar data that exist in different sheets.

Question 9

link: allows you to reference data in other sheets or in other workbooks.

Question 10

External reference indicator: cells referenced are outside the active sheet.

Question 11

IF ERROR: displays a message or value that you specify, rather than the one automatically generated by excel.

Question 12

circular reference: contains a formula that refers to its own cell location

Question 13

DIV/0!: a number is divided by 0

Question 14

NA: a value in a formula is not available.

Question 15

3-D reference: reference other sheets- which creates another dimension

Question 16

NUM!: invalid use for a number in a formula

Question 17

VALUE!: wrong type of formula argument or operand

Question 18

NAME?: formula contains text error

Question 19

NULL!: invalid intersection of areas

Question 20

REF!: invalid cell reference

Question 22

Scope: worksheets where it can be used

Question 23

logical formulas: makes calculations based on criteria

Question 24

stated conditions: criteria you create

Question 25

logical test: a condition that can be answered with a true or false response

Question 26

<: less than

Question 27

>: greater than

Question 28

=: equal to

Question 29

<=: less than or equal to

Question 30

<=: less than or equal to

Question 31

>=: greater than or equal to

Question 32

<>: not equal to

Question 33

returns: displays

Question 34

AND function: evaluates all of its arguments and returns

Question 35

PMT: finanial function that calculates the periodic payment amount for money borrowed

Question 36

FV: future value of money given for monthly investment