Ch 3 excel

The IF function can use which of the following comparison operators? Select all the options that apply. = (equal) > (greater than) * (multiplication) <> (not equal)

= (equal) > (greater than) <> (not equal)

What is the correct formula to insert the date January 12, 1998 into a cell?

=DATE(1998,1,12)

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

=MONTH(DATE(2016,7,0))

Which of the following functions generate random values? Select all the options that apply. RAND RANDDOWN RANDUP RANDBETWEEN

All of the above

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

AutoFill Options button

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

Click the AutoFill Options button and then click Fill Without Formatting.

AutoComplete can extend any data pattern involving dates, times, numbers, and text.

False

To create a formula that provides a statistical analysis of data, include a function from the Text category.

False

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

False

To retrieve a return value from a vertical lookup table, you use the VTABLE function.

False

You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables.

False

Which of the following is a type of logical function? AVERAGE ROUND IF VLOOKUP

IF

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

If it needs an absolute cell reference.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Sum

A constant is a term in an equation whose value does not change.

True

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

True

Rohan can display the current date in a cell using the TODAY() function.

True

Use Goal Seek to specify an output value and work backward to find the input value needed to reach that goal.

True

Which of the following are true about entering a function using the Insert Function dialog box? Select all the options that apply. -You open the dialog box by typing "function" in the formula bar. -You can use the search tool in the Insert Function dialog box to find a function. -You can select a category to explore functions by type. -You can use the Insert Function dialog box to insert a function based on nearby formulas.

all of the above