In most cases the PivotTable loss the column width when it is refreshed. Which of following option is true when The PivotTable is refreshed, not to lose the width of column when it is refreshed?

When you force a lookup function to return an exact match and if it cannot find the one, it returns the #N/A error. Which of the following function allow you to hide errors returned by Lookup function?

Some features work differently in Excel Online as compared to Excel desktop version. Which of the following is not true for Excel Online?

To get the real time Web Based Co-authoring, a new component is added on the server that sends notifications to all browsers connected to a workbook. How the changes are visible to each connected browser of a workbook, if any of the cell value is been changed?

Excel contains a conditional formatting preset that highlights top/bottom values. However, using a formula instead provides more flexibility. If you have a series of data with high & low magnitude values and you want to format only N number of high magnitude values in the series of data, which of the following formulas is valid?

Which of the following formulas is not entered correctly?

In cell E2, you write the formula =$C2*E$1. You then copy that formula to cell F6. What does it update to?

The total sales for Year 1 is in C20, and the total sales for Year 2, which is greater, is in D20. What formula will show the percentage increase?

What's one method of entering headers and footers?

How do you create a dynamic drop-down menu in Excel that automatically detects if new options (strings) were added to the source list?

what is the maximum limit of digits in excel?