Microsoft Word Basic Questions and Answers
1. Q: What is Microsoft Word?
A: Microsoft Word is a word processing program used to create, edit, and format text
documents.
2. Q: What file extension does Microsoft Word use by default?
A: The default file extension is .docx.
3. Q: How do you save a document in Word?
A: Click File > Save or press Ctrl + S on your keyboard.
4. Q: How can you make text bold in Word?
A: Select the text and press Ctrl + B or click the Bold icon on the toolbar.
5. Q: What is the shortcut to copy and paste text?
A: Ctrl + C to copy and Ctrl + V to paste.
6. Q: How do you change the font size of text?
A: Select the text, then use the font size dropdown in the toolbar or press Ctrl + Shift + > to
increase and Ctrl + Shift + < to decrease font size.
7. Q: What is the use of the 'Undo' button?
A: It reverses the last action taken in the document. Shortcut is Ctrl + Z.
8. Q: What is a header in Word?
A: A header is text that appears at the top of every page in a document.
9. Q: How do you insert a picture in a Word document?
A: Click Insert > Pictures and choose the image you want to insert.
10. Q: What is the use of 'Spell Check' in Word?
A: It checks for spelling and grammar errors in the document.
11. Q: What is the function of the 'Find' tool in Word?
A: It helps locate specific words or phrases in a document. Shortcut: Ctrl + F.
12. Q: How do you align text to the center in Word?
A: Select the text and click the Center alignment button or press Ctrl + E.
13. Q: What is a footer in Word?
A: A footer is the section at the bottom of a page where you can add text like page numbers
or dates.
14. Q: What is line spacing?
A: Line spacing is the amount of space between lines of text in a paragraph.
15. Q: How do you create a bullet list in Word?
A: Select the text and click the Bullets icon on the toolbar.
16. Q: What is a template in Word?
A: A template is a pre-designed document you can use to quickly create new documents.
17. Q: How do you insert a table in a Word document?
A: Click Insert > Table and choose the number of rows and columns.
18. Q: What is the default font in Microsoft Word (in newer versions)?
A: The default font is Calibri (Body).
19. Q: What is the purpose of the 'Review' tab?
A: It contains tools for spelling check, word count, track changes, comments, and more.
20. Q: How do you add page numbers to a document?
A: Click Insert > Page Number and choose where to place them.
Microsoft Excel Basic Questions and Answers
1. Q: What is Microsoft Excel?
A: Microsoft Excel is a spreadsheet program used for data organization, analysis, and
visualization.
2. Q: What file extension does Excel use by default?
A: The default file extension is .xlsx.
3. Q: How do you save an Excel workbook?
A: Click File > Save or press Ctrl + S.
4. Q: What is a cell in Excel?
A: A cell is the intersection of a row and a column where data is entered.
5. Q: How do you start a formula in Excel?
A: All formulas in Excel start with an equal sign (=).
6. Q: What is the shortcut to copy and paste in Excel?
A: Ctrl + C to copy and Ctrl + V to paste.
7. Q: How can you insert a new row in Excel?
A: Right-click the row number and choose 'Insert' or use the Home tab > Insert.
8. Q: What does the SUM function do?
A: The SUM function adds a range of numbers.
9. Q: How do you create a chart in Excel?
A: Select the data and click Insert > Chart.
10. Q: What is the use of 'AutoFill' in Excel?
A: AutoFill allows you to quickly copy and fill data or formulas into adjacent cells.
11. Q: What is a worksheet in Excel?
A: A worksheet is a single spreadsheet within a workbook.
12. Q: How do you merge cells?
A: Select the cells and click Merge & Center on the Home tab.
13. Q: What is a range in Excel?
A: A range is a selection of two or more cells.
14. Q: What does the AVERAGE function do?
A: It calculates the average of a range of numbers.
15. Q: What is a formula in Excel?
A: A formula is an expression used to perform calculations in a cell.
16. Q: How do you freeze panes in Excel?
A: Go to View > Freeze Panes to keep rows or columns visible while scrolling.
17. Q: How do you apply a filter in Excel?
A: Select the data and click Data > Filter.
18. Q: How do you sort data in Excel?
A: Use the Sort options under the Data tab to arrange data in ascending or descending order.
19. Q: What is conditional formatting?
A: Conditional formatting changes the appearance of cells based on specific conditions.
20. Q: What is a function in Excel?
A: A function is a predefined formula that performs a specific calculation.
Microsoft PowerPoint and Access Basic Questions and Answers
Microsoft PowerPoint Questions and Answers
1. Q: What is Microsoft PowerPoint?
A: It's a presentation program used to create slideshows composed of text, graphics, and
multimedia.
2. Q: What is a slide in PowerPoint?
A: A slide is a single page of a PowerPoint presentation.
3. Q: How do you start a new presentation?
A: Open PowerPoint and choose “Blank Presentation” or select a template.
4. Q: What file extension does PowerPoint use by default?
A: .pptx
5. Q: How do you insert a new slide?
A: Click 'New Slide' on the Home tab or press Ctrl + M.
6. Q: How can you apply a design theme to a presentation?
A: Go to the Design tab and select a theme from the gallery.
7. Q: What is the use of Slide Sorter view?
A: It allows you to see and manage all your slides at once in thumbnail view.
8. Q: How do you insert an image in a slide?
A: Click Insert > Pictures and choose your image file.
9. Q: What is a transition in PowerPoint?
A: A visual effect that occurs when you move from one slide to another.
10. Q: How do you start a slideshow from the beginning?
A: Press F5 or click Slide Show > From Beginning.
11. Q: What is the purpose of the Notes section in PowerPoint?
A: To add speaker notes that won’t appear in the slideshow.
12. Q: How do you add animations to text or objects?
A: Select the object and use the Animations tab.
13. Q: How can you duplicate a slide?
A: Right-click the slide and choose 'Duplicate Slide'.
14. Q: What is the shortcut for creating a new slide?
A: Ctrl + M
15. Q: What is the use of the Slide Master?
A: It lets you control the design and layout of the entire presentation.
16. Q: How do you insert a chart or graph?
A: Click Insert > Chart and choose the type of chart.
17. Q: What is the difference between a transition and an animation?
A: A transition applies to slides; animation applies to objects within a slide.
18. Q: How can you print a PowerPoint presentation?
A: Click File > Print and choose your print options.
19. Q: How do you change the layout of a slide?
A: Select the slide and choose Layout from the Home tab.
20. Q: What is Presenter View?
A: A view that lets the presenter see notes, upcoming slides, and time controls while the
audience sees only the slide.
Microsoft Access Questions and Answers
1. Q: What is Microsoft Access?
A: It’s a database management system used to store, manage, and analyze data.
2. Q: What is a database?
A: A structured collection of data that can be easily accessed, managed, and updated.
3. Q: What is a table in Access?
A: A table is where data is stored in rows and columns.
4. Q: What is a primary key?
A: A unique identifier for each record in a table.
5. Q: What is a query in Access?
A: A way to search, filter, and retrieve data from one or more tables.
6. Q: How do you create a new table in Access?
A: Click 'Table Design' and define your fields and data types.
7. Q: What is a form in Access?
A: A user-friendly interface to enter, view, or edit data in a table.
8. Q: What is a report in Access?
A: A formatted way to display and print data.
9. Q: What is the difference between a form and a report?
A: A form is used for data input; a report is used for data output and presentation.
10. Q: What does a relationship do in Access?
A: It connects data in different tables using a common field.
11. Q: What is the use of the Design View?
A: It allows you to create or modify the structure of tables, queries, forms, and reports.
12. Q: What is a data type in Access?
A: It defines what kind of data a field can hold, like text, number, or date.
13. Q: What is a record?
A: A record is a complete set of data for one item in a table (a row).
