UNIT E EXCEL Flashcards

COMPUTERS UNIT E EXCEL

1
Q

Convert text to column

A

breaks data fields in one column into separate columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Delimiter

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

PROPER function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Data Tab

A

lets you work with conversion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

UPPER

A

converts text to all caps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

LOWER

A

converts text to all lowercase

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

IF commands

A

are used based on different conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Consolidate

A

summarizes similar data that exist in different sheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Link

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

External reference indicator

A

cells referenced are outside of the active sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

IFEROR

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Circular reference

A

contains a formula that refers to its own cell location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

DIV/O!

A

a number is divided by 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

NA

A

a value in a formula is not available

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

3-D reference

A

reference other sheets - which creates another dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

NUM!

A

invalid use of a number in a formula

17
Q

VALUE!

A

wrong type of formula argument or operand

18
Q

NAME?

A

formula contains text error

19
Q

NULL!

A

invalid intersection of areas

20
Q

REF!

A

invalid cell referance

21
Q

#####

A

cell is to small

22
Q

Scope

A

a worksheet where a formula can be used

23
Q

Logical formula

A

makes calculations based on criteria

24
Q

Stated conditions

A

criteria that you create

25
Q

Logical test

A

a condition that can be answer TRUE or FALSE

26
Q

<

A

less than

27
Q

>

A

Greater than

28
Q

=

A

equal to

29
Q

<=

A

less than or equal to

30
Q

> =

A

Greater than or equal to

31
Q

<>

A

not equal to

32
Q

Returns

A

display

33
Q

AND function

A

evaluates all of its arguments and returns

34
Q

PMT

A

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

35
Q

FV

A

future value of money for monthly investment