Difference between count, counta, countif and countblank in ms-excel.
Explain few useful functions in excel.
Explain spreadsheet and its basics.
What is the "what if" condition in excel formulas?
Explain pivot tables and its uses.
How can you add a new excel worksheet?
How would you provide a dynamic range in "data source" of pivot tables?
Specify the order of operations used for evaluating formulas in excel.
How can you sum up the rows and column number quickly in the excel sheet?
Is it possible to prevent someone from copying the cell from your worksheet?
Explain macro in ms-excel.
How can you disable the automating sorting in pivot tables?
What filter will you use, if you want more than two conditions or if you want to analyze the list using database function?
What is the quick way to return to a particular area of a worksheet?
What is the and function does in excel?