What is Microsoft Excel?
Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.

What is ribbon?
The ribbon runs on the top of the application and is the replacement for the toolbars and menus.  The ribbons have various tabs on the top, and each tab has its own group of commands.

How can I hide or show the ribbon?
Use the “CTRL + F1” key to toggle & show or hide the ribbon.

What are cells?
The area where data is stored is known as cell.

How can you wrap the text within a cell?
You have to select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.

How you can sum up the Rows and Column number quickly in the excel sheet?
By using SUM function, you can get the total sum of the rows and columns, in an excel worksheet.

How you can add a new excel worksheet?
To add a new Excel worksheet, you have to insert worksheet tab at the bottom of the screen.

How you can resize the column?
To resize the column, you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.
How many report formats are available in Excel and what are their names?
In Excel, we have three formats available:
  • Compact
  • Report
  • Tabular
How would you provide 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 using offset function and base the pivot table using a named range created in the first step.

Is it possible to make Pivot table using multiple sources of data?
If the multiple sources are different worksheets, from same workbook, then it is 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?
To check whether the pivot table is modified or not we use “PivotTableUpdate” in worksheet containing the pivot table.

What you could do to stop the pivot table from losing the column width upon refreshing?
Format loss in pivot table can be stopped simply by changing the pivot table options.  Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “Auto Format” option.

What are the advantages of using formula in Excel sheet?
Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.

How you can resize the column?
To resize the column, you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.

What is a Dashboard and what are the important things we should keep in mind while creating a dashboard?
Dashboard is a technique used to present important information through graphical representation. It is helpful in presenting huge data in a single computer screen so it can be monitored with a glance.
There are few things which should be taken care of, while preparing the dashboards:
  • Minimum distraction
  • Simple, easy to communicate
  • Important data
  • Few Colors
  • Relevant graphs
  • Dashboard should be on single computer screen
How can you format a cell? What are the options?
We can format a cell by using the “Format Cells” option and there are 6 options
  • Number
  • Alignment
  • Font
  • Border
  • Fill
  • Protection
What is the sequence of operating mathematical operation in Excel?
The order of sequence of operating is BEDMAS
  • Brackets
  • Exponents
  • Division
  • Multiplication
  • Addition
  • Subtraction
What is IF function in excel?
To perform the logic test IF function is performed. It checks whether certain conditions are true or false. If the condition is true, then it will give result accordingly if the condition is false then the result or out-put will be different.

What is the “What If” condition in excel formulas?
The “What If” condition is used to change the data in Microsoft excel formulas to give different answers.

What is the AND function does in excel?
Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.

How you can disable the automating sorting in pivot tables?
To disable the automating sorting in pivot tables,
Go to > “More Sort Options”> Right Click “Pivot table” > Select “Sort” menu > Select “More Options” > Deselect the “Sort automatically when the report is created”.

How to prevent someone from copying the cell from your worksheet?
If you want to protect your worksheet from being copied, go into
Menu bar > Review > Protect sheet > Password
By entering password, you can prevent your worksheet from getting copied.
Request to Download PDF

Post A Comment:

0 comments: