📁 Microsoft Office Solved MCQs with Answers

Practice 795 approved 📁 Microsoft Office questions with verified answers from the 💾 Computer Science subject for Pakistan exams.

795 solved MCQs

A collection of related worksheets is called ______?Answer: Workbook To delete the selected text in MS Word, which key is used?Answer: Delete In MS Excel, comments put in the cell are called?Answer: Cell tips In Microsoft PowerPoint, which tab is used to display all slides during a presentation?Answer: Slide Show Through which tab can an object be animated in MS PowerPoint?Answer: Animations When we take a print, which option is important?Answer: Print Preview A word processor would most likely be used to do?Answer: Type a biography In MS Word, Ctrl + Y is used for ____?Answer: Redo Which of the following is not PowerPoint view(s)?Answer: Presentation View MS Word is which type of software?Answer: Word processor The default settings for Narrow margins in MS Word are?Answer: 5 inches on all four sides (Top, Bottom, Left, and Right) What is the function of the Shift + End shortcut key?Answer: Select text from the cursor to the end of the current line Background color or effects applied on a document is not visible in?Answer: Print Preview What is the maximum number of columns that can be inserted in MS Word?Answer: 63 What is the maximum number of lines you can set for a drop cap?Answer: 10 What happens if you press Ctrl + Shift + F8 in Microsoft Word?Answer: It activates the rectangular selection In MS PowerPoint we press _____ key to start slideshow from current slide.Answer: Shift + F5 Which keyboard shortcut key is used to edit the formula or the selected cell in MS Excel?Answer: F2 Which of the following standard file formats is used in PowerPoint when saving a presentation?Answer: .pptx Which of the following is not a correct method of editing the contents of a cell in MS Excel?Answer: Press the Alt key What is the slide-tittle master pair in MS PowerPoint 2016?Answer: A slide master and title master for a specific design template. Which of the following formulas MS-Excel 2016 will not able to calculate? =SUM(Sales)-A3, =SUM(A1:A5)*.5, =SUM(A1:A5)/(10-10), =SUM(A1:A5)-10Answer: =SUM(Sales)-A3 Second Step in Creating Macros in Excel?Answer: Record the macro MS access has primary _____ keysAnswer: 1 In MS Access, which 5-letter term starts with S?Answer: Datasheet view Pivot Table is a feature of which of the following software?Answer: Microsoft Excel Complex Number Sum in Excel using?Answer: IMSUM() VLOOKUP in Excel is?Answer: Vertical Lookup Reasons to use Macro in Microsoft Office ?Answer: Automate Frequently used tasks Which language does MS-Word use to create Macros?Answer: Visual Basic