Introduction:
Microsoft is an American multinational technology which was founded in the year 1975 by Bill Gates and Paul Allen. Microsoft released Window 1.0 on November 1985 as a graphical extension. In 1990, Microsoft introduced the Microsoft Office suite which bundled separate applications such as Microsoft Word and Microsoft Excel.
Here are 120+ Computer Gk Question and Answer About Microsoft Office:
Q.1 Microsoft Office was developed by which company?
Answer: Microsoft.
Q.2 In which year was Microsoft Office first released for Windows?
Answer: 1st October, 1990
Q.3 Which operating system was Microsoft Office initially launched for?
Answer: Apple Macintosh.
Q.4 What is Microsoft Word mainly used for?
Answer: Creating and editing text documents.
Q.5 Which Microsoft Office application is used for spreadsheets?
Answer: Microsoft Excel.
Q.6 Which tool in MS Excel is used to perform calculations?
Answer: Formula.
Q.7 What is Microsoft PowerPoint used for?
Answer: Creating Presentations.
Q.8 Which MS Office application is used for managing emails?
Answer: Microsoft Outlook.
Q.9 What is the default file extension of MS Word documents?
Answer: .docx
Q.10 What is the default file extension of MS Excel files?
Answer: .xlsx
Also Read:
150+ Basic Gk Question and Answer About Computer
Q.11 What is the default file extension of MS PowerPoint presentations?
Answer: .pptx
Q.12 Which Microsoft Office tool is used for database management?
Answer: Microsoft Access.
Q.13 What is a cell in MS Excel?
Answer: The intersection of a row and a column.
Q.14 What is a worksheet in Excel?
Answer: A single spreadsheet page.
Q.15 What is a workbook in Excel?
Answer: A collection of worksheets.
Q.16 Which key is used to start a new line in MS Word?
Answer: Enter key.
Q.17 What is the shortcut key to save a document?
Answer: Ctrl + S.
Q.18 What is the shortcut key to copy text?
Answer: Ctrl + C.
Q.19 What is the shortcut key to paste content?
Answer: Ctrl + V.
Q.20 What is the shortcut key to cut text?
Answer: Ctrl + X.
Q.21 Which view shows the final printed layout in MS Word?
Answer: Print Layout view.
Q.22 What is the ribbon in MS Office?
Answer: A toolbar containing commands and tools.
Q.23 Which features checks spelling mistakes in MS Word?
Answer: Spelling and Grammer.
Q.24 What does AutoCorrect do in MS Word?
Answer: Automatically corrects common typing errors.
Q.25 Which Excel function finds the average of numbers?
Answer: AVERAGE.
Q.26 Which Excel function finds the largest value?
Answer: MAX.
Q.27 Which Excel function finds the smallest value?
Answer: MIN.
Q.28 Which function counts numeric values in Excel?
Answer: COUNT.
Q.29 What is a slide in PowerPoint?
Answer: A single page of a presentation.
Q.30 Which features adds movement to objects in PowerPoint?
Answer: Animation.
Q.31 What are slide transitions?
Answer: Effects between slides.
Q.32 Which PowerPoint view is used while presenting?
Answer: Slide Show view.
Q.33 What is Microsoft OneNote used for?
Answer: Taking digital notes.
Q.34 Which MS Office app is used for desktop publishing?
Answer: Microsoft Publisher.
Q.35 What is the shortcut key to undo an action?
Answer: Ctrl + Z.
Q.36 What is the shortcut key to redo an action?
Answer: Ctrl + Y.
Q.37 What does formatting mean in MS Word?
Answer: Changing the appearance of text.
Q.38 What is the shortcut key to insert a new slide in PowerPoint?
Answer: Ctrl + M.
Q.39 Name one common font used in MS Word?
Answer: Times New Roman.
Q.40 What does bold formatting do?
Answer: Makes text darker and thicker.
Q.41 What does italic formatting do?
Answer: Slants the text.
Q.42 What does underline formatting do?
Answer: Draws a line under text.
Q.43 What is a template in MS Office?
Answer: A pre-designed document format.
Q.44 Which option is used to insert pictures in Word?
Answer: Insert tab.
Q.45 What is text box?
Answer: Movable text container.
Q.46 Which chart shows data in circular form?
Answer: Pie chart.
Q.47 Which chart is best for comparing values?
Answer: Bar chart.
Q.48 What is conditional formatting?
Answer: Formatting cells based on conditions.
Q.49 Which Excel feature sorts data?
Answer: Sort.
Q.50 Which Excel feature filters data?
Answer: Filter.
Q.51 What is page orientation?
Answer: Layout direction of a page.
Q.52 Which are the two types of page orientations in MS Word?
Answer: Portrait and Landscape.
Q.53 What is header in MS Word?
Answer: Text at the top of each page.
Q.54 What is footer in MS Word?
Answer: Text at the bottom of each page.
Q.55 What is mail merge used for?
Answer: Creating bulk personalized documents.
Q.56 Which application is used for official letters?
Answer: Microsoft Word.
Q.57 What is a macro in MS Office?
Answer: A set of automated commands.
Q.58 What is Microsoft Office 365 now called?
Answer: Microsoft 365.
Q.59 Which key combination selects all content in a document?
Answer: Ctrl + A.
Q.60 Which Office app supports formulas most?
Answer: Microsoft Excel.
Q.61 What is alignment in MS Word?
Answer: Positioning of text.
Q.62 Which PowerPoint feature repeats animations?
Answer: Loop animation.
Q.63 What is bullet list?
Answer: A list marked with symbols.
Q.64 What is numbered list?
Answer: A list with numbers.
Q.65 Which shortcut opens a new document?
Answer: Ctrl + N.
Q.66 Which shortcut prints a document?
Answer: Ctrl + P.
Q.67 What is zoom feature in MS Office?
Answer: Changes document view size.
Q.68 Which Excel feature freezes rows?
Answer: Freeze Panes.
Q.69 What is Microsoft Access file extension?
Answer: .accdb
Q.70 Which Excel function adds values?
Answer: SUM.
Q.71 What is a formula bar?
Answer: Area where formulas show in Excel.
Q.72 What is cell reference?
Answer: Address of a cell.
Q.73 What is the default slide size in PowerPoint?
Answer: Widescreen (16:9).
Q.74 What is MS Office used for?
Answer: Office productivity work.
Q.75 Which app is best for financial analysis?
Answer: Microsoft Excel.
Q.76 What is SmartArt?
Answer: Visual diagrams in Office.
Q.77 What is word wrap?
Answer: Automatically moving text to next line.
Q.78 What is track changes used for?
Answer: Monitoring document edits.
Q.79 What is comment feature?
Answer: Adding notes to a document.
Q.80 Which tab is used to change margins?
Answer: Layout tab.
Q.81 What is table in MS Word?
Answer: Data arranged in rows and columns.
Q.82 What is hyperlink?
Answer: A clickable link.
Q.83 What is slide master?
Answer: Controls slide design.
Q.84 Which Excel feature allows data validation?
Answer: Data Validation.
Q.85 What is a drop-down list in Excel?
Answer: A selectable list created using data validation.
Q.86 What is CC in email?
Answer: Carbon Copy.
Q.87 What is BCC in email?
Answer: Blind Carbon Copy.
Q.88 Which Office app supports cloud storage?
Answer: Microsoft 365.
Q.89 What is OneDrive?
Answer: Microsoft cloud storage service.
Q.90 What is the use of the Status Bar in Excel?
Answer: Displays quick calculations.
Q.91 What is page break?
Answer: Separates pages.
Q.92 What is clipboard?
Answer: Temporary storage for copied items.
Q.93 What does Find feature do?
Answer: Searches text.
Q.94 What does Replace feature do?
Answer: Changes selected text.
Q.95 What is AutoSave?
Answer: Automatically saves changes.
Q.96 What is password protection?
Answer: Securing documents.
Q.97 Which app is best for resumes?
Answer: Microsoft Word.
Q.98 What is column in Excel?
Answer: Vertical series of cells.
Q.99 What is row in Excel?
Answer: Horizontal series of cells.
Q.100 What is pivot table used for?
Answer: Data analysis.
Q.101 Which MS Office app supports real-time chat?
Answer: Microsoft Teams.
Q.102 Which app is used for reports?
Answer: Microsoft Word.
Q.103 What is VBA?
Answer: Visual Basic for Applications.
Q.104 Which Office app uses VBA heavily?
Answer: Microsoft Excel.
Q.105 What is spreadsheet software?
Answer: Software for numerical data.
Q.106 Which Office version came before Office 2016?
Answer: Office 2013.
Q.107 What is the use of comments in Excel?
Answer: To add notes to cells.
Q.108 Which Office app support handwriting?
Answer: OneNote.
Q.109 What is slide layout?
Answer: Arrangement of slide content.
Q.110 What is animation pane?
Answer: Controls animations.
Q.111 What is watermark?
Answer: Faint background text or image.
Q.112 Which feature protects document editing?
Answer: Restrict Editing.
Q.113 Which Excel tool remove duplicate data?
Answer: Remove Duplicates.
Q.114 What is the use of the Tell Me feature?
Answer: To quickly find commands.
Q.115 Which Excel function returns today’s date?
Answer: =TODAY().
Q.116 What is equation editor used for?
Answer: Writing mathematical formulas.
Q.117 Which Excel feature creates graphs?
Answer: Charts tool.
Q.118 What is spell check shortcut?
Answer: F7.
Q.119 What is status bar?
Answer: Shows document information.
Q.120 Which Excel function is used to join text from different cells?
Answer: CONCAT or CONCATENATE.
Q.121 What is the purpose of the Format Painter tool?
Answer: To copy formatting from one place to another.
Q.122 What does Protect Workbook do in Excel?
Answer: Prevents unauthorized changes.
Q.123 What is the use of Freeze Panes?
Answer: Keeps rows or columns visible while scrolling.
Q.124 Which function is use to change written work which is already done?
Answer: Edit
Q.125 The red wave underline in MS-Word document indicates?
Answer: Spelling Errors
Connect with us on:
Instagram: https://www.instagram.com/test_your_gk?igsh=MWN6b3Bwd2lhaDN1OA==
Facebook: https://www.facebook.com/profile.php?id=61561756379011&mibextid=ZbWKwL
Pinterest: https://pin.it/4ad8gsy44
Telegram: https://t.me/testyourgkofficial