Computer Operator Interview Questions from Ms-Office with answers

Interview Questions from Ms-Office with answers

Question 1. Can I Turn The Ruler Off (or Turn It Back On)?
Answer :
Choose Ruler from the View menu (if the Ruler is on, then you'll see a check next to Ruler).

Question 2. How Do I Change The Default Margins In Ms Office?
Answer :
1. Choose Page Setup from the File menu.
2. Click on the Margins tab.
3. Set the margins the way you want them, then click on Default. Word will inform you that this change will affect all documents based on the Normal template.

Question 3. How Do I Change The Default Document Font In Ms Office?
Answer :
1. Choose Font from the Format menu, then set all of the attributes you want for your default font.
2. Click the Default button.
3. Word will inform you that this change will affect all documents based on the Normal template.

Question 4. How Do I Change The Default Folder for Open and Save?
Answer :
1. Choose Options from the Tools menu.
2. Click on the File Locations tab.
3. Click on Documents under File Types.
4. Click on the Modify button.
5. Use the Look in list to locate the folder you want to use from now on.
6. Click on the folder name, then click on OK to select that location.
7. Click on OK.

Question 5. How Do I Use Headers and Footers In Ms Office?
Answer :
1. Choose Header and Footer from the View menu.

Question 6. How Do I Number Pages In Ms Office?
Answer :
1. Choose Page Numbers from the Insert menu.

Question 7. How Do I Clear The Formatting In A Paragraph Or Block Of Text?
Answer :
To make a "clean start" with a block of text:
1. Select the block of text.
2. Choose Normal from the Style box.

Question 8. How Do I Indent A Paragraph In Ms Office?
Answer :
1. Choose Paragraph from the Format menu.
2. Set Left and Right under Indentation.

Question 9. How you can create a custom watermark?
Answer :
To create your own Watermark, Got to Page Layout tab in the Page Background group click Watermark and select Custom Watermark. Select the Picture Watermark or text watermark option and make changes accordingly.

Question 10. What is ribbon?
Answer :
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 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.

Question 11. Explain Spreadsheet and its Basics.
Answer :
Spreadsheet can be compared to a paper ledger sheet. It consists of rows and columns and their intersection called cells.

Question 12. How many data formats are available in Excel? Name some of them.
Answer :
Eleven data formats are available in Microsoft Excel for data Storage. Example:
Number – Stores data as a number
Currency – Stores data in the form of currency
Date – Data is stored as dates
Percentage – Stores numbers as a percentage
Text Formats – Stores data as string of texts

Question 13. How can you wrap the text within a cell?
Answer :
You must 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.

Question 14. What are charts in MS-Excel?
Answer :
To enable graphical representation of the data in Excel, charts are provided. 

A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an option from Insert tab's Chart group.

Question 15. What is Freeze Panes in MS-Excel?
Answer :
To lock any row or column, freeze panes is used. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.

Question 16. What is IF function in Excel?
Answer :
To perform the logic test IF function is performed. It checks whether certain conditions is 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.

Question 17. What is the benefit of using formula in Excel sheet?
Answer :
Calculating the numbers in Excel sheet, not only help you to give the final 'sum up' of the number but, it also calculates automatically the number replaced by another number or digit. 

Through Excel sheet, the complex calculations become easy like payroll deduction or averaging the student's result.

Question 18. What is the AND function does in Excel?
Answer :
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 output of more than one cells in a single cell, it is possible by using AND function.

Question 19. How cell reference is useful in the calculation?
Answer :
In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.