120+ Advanced Microsoft Office Gk Question and Answer

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: 1^st 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