Excel Interview Questions
- What is Microsoft Excel?
- What is ribbon?
- Explain Spreadsheet and its Basics.
- 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?
- What is the AND function does in Excel?
- How cell reference is useful in the calculation?
No comments :
Post a Comment