Question

II. Fill in the blanks:

1.A _______ is a set of mathematical instructions.

2.______ in Microsoft Excel are predefined formulas.

3.______cell referencing method is helpful when you need to update only the value of one cell

4._______ is used to format the cells based on the set of specified conditions.

5. _____ filter is used to filter data based on specific complex criteria.​

Answer 1

Answer:

1)Formula

2)functions

4)Conditional formatting

5)Auto filter