New Notes UwU - Unit E Notes

Question 1

1. Convert Text to Columns:

Answer 1

Breaks data fields in one column into separate columns.

Question 2

2. Delimiter:

Answer 2

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

Question 3

3. PROPER function:

Answer 3

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

Question 4

4. Data Tab:

Answer 4

Lets you work with conversion.

Question 5

5. UPPER:

Answer 5

Converts text to all caps.

Question 6

6. LOWER:

Answer 6

Converts text to all lowercase.

Question 7

7. IF commands:

Answer 7

IF commands are based on different conditions.

Question 8

8. Consolidate:

Answer 8

Summarizes similar data that exists in different sheets.

Question 9

9. Link:

Answer 9

Allows you to reference data in other sheets or in other workbooks.

Question 10

10. External reference indicator:

Answer 10

Cells referenced are outside the active sheet.

Question 11

11. IF-ERROR:

Answer 11

Displays a message or value that you specify, rather than the one automatically generator by Excel.

Question 12

12. Circular reference:

Answer 12

Contains a formula that refers to its own cell location.

Question 13

13. # DIV/0!:

Answer 13

A number is divided by 0 (Zero).

Question 14

14. # NA:

Answer 14

A value in a formula is not available.

Question 15

15. 3-D reference:

Answer 15

Reference other sheets – which creates another dimension.

Question 16

16. # NUM!:

Answer 16

Invalid use of a number in a formula.

Question 17

17. # VALUE!:

Answer 17

Wrong type of formula arguments or operand.

Question 18

18. # NAME?:

Answer 18

Formula contains text error.

Question 19

19. # NULL!:

Answer 19

Invalid intersection of areas.

Question 20

20. # REF!:

Answer 20

Invalid cell reference.

Question 21

21. ##### :

Answer 21

Column is not wide enough to display data.

Question 22

22. Scope:

Answer 22

Worksheets where it can be used.

Question 23

23. Logical formula:

Answer 23

Makes calculations based on criteria.

Question 24

24. Stated conditions:

Answer 24

Criteria you create.

Question 25

25. Logical test:

Answer 25

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

Question 26

26. < :

Answer 26

Less than.

Question 27

27. > :

Answer 27

Greater than.

Question 28

28. = :

Answer 28

Equal to.

Question 29

29. <= :

Answer 29

Less than or equal to.

Question 30

30. >= :

Answer 30

Greater than or equal to.

Question 31

31. <> :

Answer 31

Not equal to.

Question 32

32. Returns:

Answer 32

Displays.

Question 33

33. AND function:

Answer 33

Evaluates all of its arguments and returns.

Question 34

34. PMT:

Answer 34

Financial function that calculates the periodic payment amount for money borrowed (car payment) = pmt (rate, nper, pv).

Question 35

35. FV:

Answer 35

Future value of money given for monthly investment.