Excel 2016 Quiz

Which of the following is an absolute cell reference?

$A$2

What value would Excel return for this formula? =(82-32)/5+8*2

26

What feature did we use to quickly apply the formatting shown in this image?

Conditional formatting

Which feature starts with a desired result, then calculates the input value that will give that result?

Goal seek

Where is the fill handle located?

In the bottom-right corner of the selected cell

What is the main advantage of selecting the Mark as Final option?

It discourages other users from editing the workbook

Let's say you're trying to find your average grade. What's wrong with the formula shown in the image?

It should have an equals sign (=) at the beginning. (The formula shown is AVERAGE(C2:C10))

In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

Its using the Currency number format (the value in the formula bar is 202, while the value in the cell is $202.00)

The four areas in this image are used to create a ________.

PivotTable

Which of the formulas below are valid? Select all that apply. - =5B+6B - =F2+F3+F4-53 - =R2*D2 - A3+100

R2*D2

True or False: You can view a formula by double-clicking the cell that contains the formula.

True

The intersection of a row and a column is called a ________.

cell

A group of cells is called a ________.

cell range

You can click the tabs at the bottom of a workbook to switch between ________.

worksheets