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 21. To move to the previous worksheet and to next sheet, what keys will you press?

Ans. To move to the previous worksheet you will use the keys Ctrl+PgUp, and to move to the next sheet you will use keys Ctrl+PgDown.

Is it helpful? Add Comment View Comments
Ques 22. How do I put password to protect my entire Spreadsheet so data cannot be changed?
Ans. 1. Click Tools 
2. Scroll down to Protection, then Protect Sheet 
3. Enter a password, Click OK 
4. Re-enter password, 
Click OK 
Is it helpful? Add Comment View Comments
Ques 23. What is Freeze Panes and how do I do it?
Ans. 1. Row - Select the row below where you want the split to appear 
2. Column - Select the column to the right of where you want the split to appear 
3. Go to the Menu Bar 
4. Click Windows
and then click Freeze Panes 
Is it helpful? Add Comment View Comments
Ques 24. How do I Format data in MS Excel?
Ans. 1. Must Always highlight the data before formatting 
2. Click Format 
3. Then go to Cells 
Is it helpful? Add Comment View Comments
Ques 25. How do I resize Columns and Rows to better fit the data in MS Excel?
Ans. 1. Move the mouse in between any two labels (Rows/numbers or Columns/letters) 
2. The pointer will turn into a vertical (letters) or horizontal (numbers) line with arrows on both ends 
3. Simply drag the column or row to the desired size 
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2016 WithoutBook