Excel 2016 Module 2 Review 2

Which type of cell reference preserves the exact cell address in a formula?

Which of the following is a complex formula?

An Excel complex formula uses more than one arithmetic operator.

In this formula, =ROUND(D4:F4,0), what does the zero indicate?

The default file extension for an Excel 2016 workbook is ____.

In this formula, =D1+C1/F3, which calculation will be performed first?

The COUNTA function is used to count the # of cells in a range that contain what type of data?

Name the button

According to the order of precedence, operations within parentheses are performed last.

This formula, =D8+E8*0.5 is a complex formula.

An Excel user should use a relative cell reference when it is important to ____.

Name the button

Name the button

In Excel, MAX and AVERAGE are examples of ____.

How can this formula, =C12+C13*F4, be changed so that C12 & C13 are added 1st?

Which key on the keyboard allows you to cycle through relative & absolute cell references?

In this formula, =(G15-G14)*$M$3/4, which mathematical operation is performed first?

Name the button

Name the button

Name the button

All functions begin with the formula prefix ____.

To continue a sequence in adjacent cells, use the ____ feature of Excel.

You can create an absolute cell reference by placing a _ in front of the column letter & row number.