Explain types of workbook protection in excel.
How can you disable the automatic sorting of information in a pivot table?
How can the user change the size of the column?
What do you mean by ribbon?
What do you mean by freeze panes in ms-excel?
What do you mean by charts in ms-excel?
What is the benefit of using the formula in excel sheet?
Explain the spreadsheet.
How can users check that the pivot table is modified?
How is dynamic range provided in data source of pivot tables?
What could be done in order to stop the pivot table from losing the column width while refreshing?
How many types of data formats are available in microsoft excel for storing the data/ values? Name a few of them.
How is text wrap done within a cell?
Is it possible to sum up the rows and column number in the excel sheet?
State the purpose of “name box” in ms-excel?