Specify the order of operations used for evaluating formulas in Excel.
How can you wrap the text within a cell?
Explain Macro in MS-Excel.
Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.
Which are the two macro languages in MS-Excel?
Is it possible to prevent someone from copying the cell from your worksheet?
What are charts in MS-Excel?
How can you sum up the Rows and Column number quickly in the Excel sheet?
Explain few useful functions in Excel.
What does a red triangle at the top right of a cell indicate?
How can you add a new Excel worksheet?
What is the use of NameBox in MS-Excel?
How can you resize the column?
Explain pivot tables and its uses.
What are three report formats that are available in Excel?
How would you provide a Dynamic range in “Data Source” of Pivot Tables?
Is it possible to make Pivot table using multiple sources of data?
Which event do you use to check whether the Pivot Table is modified or not?
How can you disable automatic sorting in pivot tables?
What is Freeze Panes in MS-Excel?
What could you do to stop the pivot table from loosing the column width upon refreshing?
Explain workbook protection types in Excel.
What is IF function in Excel?
Can we create shortcuts to Excel functions?
What is the use of LOOKUP function in Excel?
We can you apply the same formatting to every sheet in a workbook in MS-Excel?
What are left, right, fill and distributed alignments?
To move to the previous worksheet and next sheet, what keys will you press?
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?
Which function is used to determine the day of the week for a date?
What is the benefit of using formula in Excel sheet?
What is the “What If” condition in Excel formulas?
How can you disable the automating sorting in pivot tables?
No comments:
Post a Comment