Info. Tech, Excel Module 2, 2019

The formula =7*6 is a complex formula

? are predefined worksheet formulas that enable you to perform a complex calculations easily.

AVERAGE is an example of a Function.

Excel uses the standard ? rules to determine which operation to perform first.

=3*(4+7)/3 is ?

The type of cell referencing that combines both Absolute and Relative cell references is ?

A reference that changes in relation to the formula in the cell when copied is ?

=(5*3)+7 is a complex formula

The formula =4+3*6 equals?

Excel ? are predesigned workbook files intended to save time when you create common documents such as a balance sheet.

A reference that does not change when you copy a formula is ?

A formula always begins with an = sign.

You use the ? button to fill the cells with only specific elements of the copied cell

A ? is a formula that uses more than one arithmetic operator.

When you use the copy command, the information temporarily goes to the clipboard

In the Order of Precedence, you would add before you would divide.

The Excel ? feature makes it easier to enter function names by typing, because it suggests functions.

You can round a value or formula result to a specific number of decimal places by using the ? function