With technology always changing, it is hard to keep up with the new lingo. Interview questions and answers for ms office can be a confusing subject in particular if you don’t know what MS Office is. We have compiled a list of some of the most commonly asked interview questions about MS Office so that you are prepared when one comes up during an interview. You’ll find this article informative and helpful! Here are some examples: What does Pivot Table stand for? How do I access my email from Outlook on my phone? What’s PowerPoint’s function? These are just a few of many common interview questions about MS Office that we answer here at OfficeInterviewQuestionsAndAnswers.com!
1. What is MS Office?
MS Office is a software suite that consists of different applications, such as Word, Excel, and PowerPoint. The different applications allow for document creation, data analysis, and presentation creation.
2. When was MS Office created?
MS Office was first introduced in 1990 and later made available for individuals to purchase in 2007. It has since been one of the most commonly used software suites throughout businesses around the world!
3. Why do employers ask questions about MS Office during an interview?
It is essential that you know as much as possible about MS Office before you get to your interview. Employers love candidates that are knowledgeable about what the company uses on a daily basis, which is why it’s important that you study up!
4. Who created MS Office?
Microsoft released its first version of MS Office in 1990 after creating it for IBM in 1983.
5. What does the name MS Office stand for?
MS Office stands for Microsoft Office.
6. What are the different applications that come with MS Office?
The different applications that come in MS Office include Word, Excel, PowerPoint, Access, Publisher, and Outlook. Each application has its own unique functions that can be used in a variety of ways!
7. What is the difference between MS Office and OpenOffice?
MS Office is a suite of different applications that allow for document creation, data analysis, and presentation creation. OpenOffice, on the other hand, is a single application that allows for document creation only.
8. How do I save my work in MS Office?
In order to save your work in MS Office, you will need to click on the “File” tab and then select “Save As.” You will then be able to choose where you would like to save your document and what file type you would like it to be.
9. What is a PDF?
PDF stands for Portable Document Format and is a file type that allows you to view and print documents regardless of the software or hardware used.
10. What is the function of Excel?
Excel is a program that allows users to create and manipulate data in spreadsheets. It is often used for financial analysis, data tracking, and other types of numerical recording.
11. What is the function of Access?
Access allows you to store and manipulate data, allowing it to be easily accessible whenever needed.
12. What is the function of PowerPoint?
PowerPoint helps users create dynamic presentations by combining text, pictures, video, and sound. It can be used in a variety of different ways in order to effectively communicate a message.
13. How do I create a new document in MS Office?
In order to create a new document in MS Office, you will need to open the application that you would like to use. For example, if you want to create a new Word document, you will need to open Word. Then, click on the “New” tab and select the document type you would like to create.
14. What is Spell Check?
Spell check allows you to check for any misspelled words within your document or presentation. You can access spell check by clicking on the “Review” tab and then clicking on “Spelling.” Alternatively, you can press “Ctrl + ‘” in order to open up a window that will allow you to check for any misspelled words.
15. How do I add a new slide in PowerPoint?
In order to create a new slide, you will need to click on the “Home” tab and then select “New Slide.” A screen will appear with two options: Title Slide and Blank Presentation. Title slide will allow you to add a title and subtitle to your presentation, while the blank presentation option will allow you to enter your content without any additional information.
16. What is a table?
A table is a collection of the information displayed in a spreadsheet-like format. It allows users to organize data in an easy-to-read table format.
17. What is a keyboard shortcut?
A keyboard shortcut allows users to execute certain functions by pressing specific keys on the keyboard instead of clicking on a menu or icon within your document or presentation. You can access all available Microsoft Office keyboard shortcuts by going to “File” and then selecting “Options.” Within this menu, you will be able to select “Keyboard.” From there, you can choose the specific application that you would like to view keyboard shortcuts for.
18. What is a template?
A template is a document that has placeholder text already included, allowing it to be used as a foundation for creating unique documents. You can access Microsoft Office templates by clicking
19. What is a spreadsheet?
A spreadsheet is an electronic version of traditional paper spreadsheets, allowing for easier data input and manipulation. Spreadsheets are often used to keep track of budgets, financial transactions, student grades, etc.
20. How do I create a chart in PowerPoint?
In order to create a chart in PowerPoint, you will need to first select the data that you would like to include in your chart. Once the data is selected, click on the “Insert” tab and then select “Chart.” A screen will appear that will allow you to choose the type of chart that you would like to create. You can also adjust the chart’s settings by clicking on “Design” and then selecting “Chart Styles.” This will allow you to modify different aspects of your chart, such as color, size, style, etc.
21. How do I create a table in Word?
First, highlight the data that you would like to include in your table. Once it is highlighted, go to the “Table” tab and select “Insert Table.” A table will be inserted into your document and you will be able to format it by selecting the “Table Tools” tab and then clicking on “Design.” From here, you can change the table’s properties, such as color, border style, etc.
22. How do I create a line graph in Excel?
A line graph is one of the many different types of graphs you can create with Microsoft Excel. To create this type of graph, you will need to first highlight the data that you would like to include in your chart. Once it is highlighted, go to the “Insert” tab and select “Chart.” A screen will appear that will allow you to choose the type of chart that you would like to create. You can also adjust the chart’s settings by clicking on “Design” and then selecting “Chart Styles.” From there, you can change the graph’s properties, such as color, size, style, etc.
23. What is a SmartArt graphic?
A SmartArt graphic is an image that has been created using one of the many pre-designed templates that are available in Microsoft Office. It allows users to easily create professional-looking graphics without having to use any additional software. To insert a SmartArt graphic, go to the “Insert” tab and select “SmartArt.” A screen will appear that will allow you to choose the type of SmartArt graphic that you would like to create. You can also adjust the SmartArt graphic’s settings by clicking on “Design” and then selecting “SmartArt Styles.”
24. What is a hyperlink?
A hyperlink is a link within a document that will take the user to another location, such as another webpage or even another part of your current document. You can create a hyperlink by highlighting text or an image and then going to the “Insert” tab and selecting “Hyperlink.” This will allow you to enter a location within your current document or on the web. You can also make your hyperlink more aesthetically pleasing by selecting “Format” and then choosing “Font.” Once you are there, click on the arrow next to “Font.” From here, you can change the font size, color, style, etc.
25. What is a bookmark?
A bookmark is essentially just an anchor within your document that allows you to quickly return to a specific location. To create a bookmark, go to the location within your document that you would like to bookmark and then click on the “Bookmark” tab and select “Add Bookmark.” You can also edit your bookmarks by clicking on the “Bookmark” tab and selecting “Edit Bookmarks.”
26. How can I change the number of pages in my document?
One way to change the page count within your document is by clicking on “Page Layout” and then selecting “Breaks.” This will allow you to insert a section break that will start a new page. You can also just type in the number of pages that you would like your document to have directly into the “Pages” field under the “Layout” tab.
27. How can I make my text bold, italicized, or underlined?
To make your text bold, go to the “Font” tab and select the “Bold” check box. To make your text italicized, go to the “Font” tab and select the “Italic” check box. To make your text underlined, go to the “Font” tab and check the “Underline” box.
28. How can I add a border around my document?
To add a border around your document, click on the “Page Layout” tab and select “Border.” This will open a menu where you can choose the type of border that you would like to add, as well as the color and width. You can also add a border to selected text or images by going to the “Format” tab and selecting “Borders.” From there, you can choose the type of border, color, and width.
29. How can I make my text aligned to the center or to the right?
To align your text to the center, go to the “Format” tab and select “Paragraph.” This will open a menu where you can choose the “Alignment” that you would like your text to be in. To align your text to the right, go to the “Format” tab and select “Paragraph.” This will open a menu where you can choose the “Alignment” that you would like your text to be in and then check the “Right” box.
30. How can I insert a table into my document?
To insert a table into your document, go to the “Insert” tab and select “Table.” This will open a menu where you can choose the size of your table, as well as how many columns and rows you would like it to have. You can also add additional columns and rows by clicking on the “Table Tools” tab and selecting “Design” and then “Insert Rows/Columns.”
31. How can I delete a table or a row/column from my table?
To delete a table, go to the “Table Tools” tab and select “Layout.” From there, click on the “Delete Table” button. To delete a row or column from your table, go to the “Table Tools” tab and select “Design” and then “Delete.” For a column, click on the column border that you would like to delete. To delete a row, simply click on the small blue box above your row (labeled as “-“) and drag it down until it is fully deleted.
32. How can I format my table?
To change the color of your table, go to the “Design” tab and select “Table Styles.” From here, you can choose a new style for your table that will include new colors such as borders and backgrounds. To change how your text wraps within your cells of the table, go to the “Table Tools” tab and select “Layout.” From there, click on the “Text Wrapping” button and choose the option that you would like. You can also change the width of your table by going to the “Design” tab and selecting “Table Properties.” Under the “Width” tab, you can type in a new width for your table. Note that the width of your table will change either in pixels or relative to how much content is within it.
33. How can I get rid of gridlines on my page?
To remove vertical gridlines from the left-hand side while typing, go to the “Page Layout” tab and select “Gridlines.” From there, uncheck the “Visible Gridlines” box. To remove horizontal gridlines from the top and bottom of your page, go to the “Page Layout” tab and select “Gridlines.” From there, uncheck the “Show Horizontal Gridlines” box. If you only want to see gridlines while you are editing your document, you can select “View” and then click on the “Grids” box to uncheck it.
34. How can I add more pages?
To add a new page before the current one, go to the “Insert” tab and select “Page Break.” This can also be done by pressing Ctrl + Enter on your keyboard. To add a new page after the current one, go to the “Page Layout” tab and select “Page Break.” This can also be done by pressing Ctrl + Enter on your keyboard. Alternatively, you can go to the “File” tab and select “Print.” From there, under the “Pages” section, you can click on the “+” button to add a new page.
35. I am having trouble seeing my images. How can I fix this?
If you are having trouble seeing your images, make sure that they are saved either in JPG or PNG format and not in TIF format. If both of these options fail, you may need to resize your images. To do this, go to the “Insert” tab and select “Image.” This will open a menu where you can choose the image that you would like to insert into your document. Once the image is inserted, click on it and then go to the “Format” tab. Under the “Size” section, you will see an option to resize the picture. Select the dimensions that you would like your image to be on either in inches or millimeters. Be warned that if you make the image size too small, it will become pixelated when printed.
