Unit B Excel Flashcards

1
Q

complex formula

A

one that uses more than 1 arithmetic operator

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

standard order of precedence

A

uses these rules in doing complex formulas.

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

functions

A

predefined worksheet formulas that enable you to perform complex calculations - use insert function button Fx

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

auto complete features

A

suggests function depending on the first letters you type

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

to copy and move cells use

A

cut, copy, and paste, and fill handles.

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

office clipboard

A

temporary storage area that holds the selections you copy out

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

relative cell reference

A

changes the cell as you copy and paste them to new locations

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

round function

A

rounds your result - to eliminate many decimals

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

launcher

A

item on ribbon that opens a dialog box

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

fill handle

A

lets you copy cell contents

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