1) What is Microsoft Excel?
Microsoft Excel is an electronic spreadsheet program included in the Microsoft office which is used by users to store, calculate ,maintain and organize the data with formulas utilizing a spreadsheet system which is divided by rows and columns. It also affords the flexibility to utilize an external database to do search, make reports, etc. thus saving lots of time.
2) What is ribbon?
Ribbon refers to the topmost area of the application that contains menu items and toolbars available in MS-Excel. Ribbon can be shown/hidden using CTRL+F1. The ribbon runs on the top of the application and replace the toolbars and menus. The ribbons have different tabs on the top, and every tab has its individual group of commands.
3) Explain Spreadsheet and its Basics.
Spreadsheet can be correlate to a paper ledger sheet. It consists or rows and columns and their intersection called cells.
4) How many data formats are accessible in Excel? Name some of them.
Eleven data formats are accessible in Microsoft Excel for data Storage. Example:
Number – Stores data as a number
Currency – Stores data as a currency
Date – Data is stored as dates
Percentage – Stores numbers as a percentage
Text Formats – Stores data as a string of texts
5) Specify the order of operations used for classify formulas in Excel.
The order of operations in Microsoft Excel is the same as in mathematics. It's defined by the term "PEMDAS" or "BEDMAS".
Parentheses or Brackets
Exponent
Multiplication
Division
Addition
Subtraction
6) How can you wrap the text inside a cell?
First You have selected the text you want to wrap and then click wrap text from the home tab and you can wrap the text within the cell.
7) Explain Macro in MS-Excel.
Macros are utilized for iterating over a group of tasks. Users can create macros for their custom repetitive functions and instructions. Macros can be either written or recorded confide on the user.
Read also : 5 Important Tips for Creating Excel Macros
8)Which are the two macro languages in MS-Excel?
XLM and VBA (Visual Basic Applications). Earlier versions of Excel used XLM. VBA was introduced in Excel 5 and essentially utilized now.
9) Is it possible to avoid someone from copying the cell from your worksheet?
Yes, it is possible. To care for your worksheet from getting copied, you need to go into Menu bar >Review > Protect Sheet > Password. By entering a password, you can secure your sheet from getting copied by others.
10) What are charts in MS-Excel?
To enable graphical representation of the data in Excel, charts are afforded. A user can utilize any chart type, consist of column, bar, line, pie, scatter, etc. by selecting an option from the Insert tab's Chart group.
11) How can you sum up the Row and Column number instantly in the Excel sheet?
By utilizing SUM function, you can get the total sum of the rows and columns, in an Excel worksheet.
12) Explain few useful functions in Excel.
Following are the functions accessible in Excel for operate the data:
Math and Financial Functions
Logical Functions
Date and Time functions
Index Match
Pivot tables
13) What does a red triangle on the top right of a cell represent?
The red triangle determine that some comment is identified with the cell. Hover the mouse over it, and you can read the full comment.
14) How can you add a new worksheet?
To add a new worksheet, you should insert worksheet tab at the bottom of the screen.
15) What is the use of NameBox in MS-Excel?
Name Box is utilized to return to a particular area of the worksheet by typing the range name or cell address in the name box.
16) How can you resize the column?
To resize the column, you should change the width of one column and then drag the boundary on the right side of the column heading until you find the width. The other style of doing this is to choose the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under the cell section. On clicking on it, the cell size will be formatted.
17) Explain pivot tables and its uses.
A pivot table is a tool that allows for quick summary of large data. It naturally execute a sort, count, total or average of the data stored in the spreadsheet and displays result in other spreadsheet. It saves a lot of time. Confess to link external data sources to our Excel.
18) What are three report formats that are accessible in Excel?
Following are the types of report formats
Compact
Report
Tabular
19) How would you arrange a Dynamic range in "Data Source" of Pivot Tables?
To provide a dynamic range in "Data Source" of Pivot tables, first, create a named range utilizing offset function and base the pivot table utilizing a named range created in the first step.
20) Is it probable to make Pivot table utilizing various sources of data?
If the multiple sources are various worksheets, from the same workbook, then it is possible to make Pivot table utilizing multiple sources of data.
If you want to know more about Microsoft excel interview question and answer, then advance excel training in Chandigarh is best for you.