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?

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

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

The shortcut to highlight a row is

Which setting must you modify to print a worksheet using a letterhead?

How may criteria can the SUMIF function have?

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:

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

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

A formula may return any of the following error values:

Which option would you to use visualize the relative value of cells in a range?