You can work with a wide variety of data sources in Excel, including native data and external data. Some, but not all, of the external data sources that you can use in Excel are supported in Excel Services and Excel Web App. Which of the following data connections are not supported in Excel Services?

To visualize the relative values in a range, that’s where Excel’s ___ come in. __ are colored, horizontal bars that appear “behind” the values in a range?

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?

Which function is used to create dynamic range names?

Which of the following options is NOT located in Page Setup?

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?