Functions and Formulas in Excel

What is a function in MS Excel?

Which of the following is NOT a characteristic of functions in Excel?

• Automatically calculates results

• Perform worksheet actions

• An expression in a formula spreadsheet

• Assist with decision making based on the information provided.

The SUM function starts with an equal sign (=) followed by the word 'AUTOSUM', an open bracket, the argument and a closing bracket.

• True

• False

Whenever we want to add up the values of a column or row of continuous cells we use the ________ function.

Draw the AutoSum button

Which of the following is NOT a type of function

• AVERAGE

• MAX

• COUNT

• REF

Which function would be used to find the mean of a set of values?

• AVERAGE

• COUNT

• MEAN

• MIN

Which function is used to find the smallest value in a set of values in a row or column?

• COUNT

• MAX

• AVERAGE

• NONE OF THE ABOVE

_____________ _________ _______________ prevents the cell references in a formula from changing. Therefore A dollar sign must be place before and after the column.

When the structure of the formula remains the same, but the addresses of the cells used in the formula will change relative to the position of the formula.......what is this called?

• None of the above

• Absolute Cell referencing

• Relative Cell Referencing

• Both