What can you do with data validation? Select all that apply.

Which of the following VLOOKUP functions is using the correct arguments?

Which function can display a different value depending on a condition?

In this image, which formula would we use to display the text Waffles: bunny?

Which function can find the highest value in a cell range?

Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?

Which function would you use to add several numeric values?

In Excel, the values 75 and 75% are equivalent.

In the order of operations, which of the following comes first?

Which of the formulas below are valid? Select all that apply.

In this image, which formula could you use to subtract the inventory costs from the monthly budget?

Excel will always tell you if there is a problem with a formula you’ve created.

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

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

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

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

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

Which of the formulas below are valid? Select all that apply.

Which of the following is an absolute cell reference?

You can view a formula by double-clicking the cell that contains the formula.

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

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

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

Where is the fill handle located?

A group of cells is called a ________.

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