Which of the following is the correct formula to refer to cell A1 on Sheet1 in a workbook named Annual Budget.xlsx?

To force cell A1 to only accept the text value which of the following is correct?

To create the consolidations- For example, to compute the total for cell A1 in worksheets named Sheet2 through Sheet10 you will use the following formula:

How can you remove duplicate rows in Excel?

How can you add a total row to an already created table?

To autofill month names you need to type __ and then drag the fill handle. (choose all that apply)

What is the keyboard shortcut to copy a formula/value to the highlighted cell from the cell to the left?

What is the simplest possible way to insert picture in cell A1 which shows on Mouse Hover on cell A1?

The aggregate function extends the capability of the subtotal function. Which function calculates the variance of values in the range by examining a sample of the values?

I have a price list stored in a worksheet, and I need to increase all prices by 10%. Can I do this without reentering all the prices?

To use the Subtotals feature, the list that has numbers you want to add must be: