In Excel, a data list, or database table, is a table of worksheet data that utilizes a special structure, a built-in Data Form allow the users to edit records in a data list. For smaller data list, you can use the navigation keys as well the scroll bar of the data form to locate record require editing. What type of commands can be used for locating a record if we want to make changes in it while using larger data list?

Excel provides ____, which are labels applied to a single cell or to a range of cells?

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?

Which is not a date and time function?

When your chart is selected, how can you get a small pop-up of alternate chart styles to choose?

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?