Which of the following feature is correct about autofill?

Use___ to visualize the relative values of cells in a range. In this case, however, Excel adds a particular icon to each cell in the range, and that icon tells you something about the cell’s value relative to the rest of the range?

We can perform What-If Analysis in Excel with the use of Data Tables in which we can see the effect of changing an input value on the result returned by a formula as soon as we enter a new input value in the cell that feeds into the formula. Which types of Data Tables can we create to perform What-If Analysis in Excel?

When creating dashboards and reports in Excel, it’s often useful to have a helper table that contains a list of dates that represent business days. This kind of a helper table can assist in calculations like revenue per business day, units per business day, and so on. Which of the ways to generate easiest a list of business days is to use the following function?

How would you provide a Dynamic range in “Data Source” of Pivot Tables?

How cell reference is useful in the calculation?

Which worksheet function returns the sum of squares of deviations?

Which tab will you select to unhide and hide the sheet?

Which of the following is a valid type of graph?

Which worksheet function returns the standard error of the predicted y-value for each x in the regression?

Which worksheet function returns the probability that values in a range are between two limits?