Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

Microsoft Excel Interview Questions and Answers

Ques 6. How you can sum up the Rows and Column number quickly in the excel sheet?

Ans. By using SUM function you can get the total sum of the rows and columns, in an excel worksheet.

Is it helpful? Add Comment View Comments
Ques 7. How you can add a new excel worksheet?
Ans. To add a new Excel worksheet you have to insert worksheet tab at the bottom of the screen.
Is it helpful? Add Comment View Comments
Ques 8. How you can resize the column in MS Excel?
Ans. 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.
Is it helpful? Add Comment View Comments
Ques 9. What are three report formats that are available in Excel?
Ans.
  • Compact
  • Report
  • Tabular
Is it helpful? Add Comment View Comments
Ques 10. How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?
Ans. 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 helpful? Add Comment View Comments

Most helpful rated by users:

©2016 WithoutBook