Excel UwU Unit owo begun uwu - Unit B

Question 1

Complex formula

Answer 1

One that uses more than 1 arithmetic operator. (More than just one type of math symbol =+-) (Addition and Multiplication.)
=(4+2)*5

Question 2

Standard order of precedence

Answer 2

Use these rules in doing complex formulas.

Question 3

Functions

Answer 3

Predefined worksheet formulas that enable you to perform complex calculations – use insert function button Fx.

Question 4

Auto complete feature

Answer 4

Suggests functions depending on the first letters you type. – list in alphabetical order.

Question 5

To copy & move cells

Answer 5

use cut, copy, and paste, and fill handles.

Question 6

Office clipboard

Answer 6

Temporary storage area that holds the selections you copy or cut.

Question 7

Relative cell reference

Answer 7

Changes the cells as you copy and paste them to new location.

Question 8

Absolute cell reference

Answer 8

Formulas that do not change when copied = $c$12+$d$12

Question 9

Mixed cell reference

Answer 9

Part of the formula changes when copied and part does not = $c14+$d14

Question 10

Fill button list arrow

Answer 10

Can be used to fill cells containing formulas going left, right, up, and down in series.

Question 11

Round function

Answer 11

Rounds your result – to eliminate many decimals.

Question 12

Launcher

Answer 12

Item on ribbon that opens a dialogue box.

Question 13

Fill handle

Answer 13

Lets you copy cell contents or continue a series of data into a range of selection cells.

Question 14

F4

Answer 14

Converts a relative formula to an absolute cell reference.

Question 15

To enter a function

Answer 15

Insert function button, use sum list arrow or use autocomplete.