📁 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

Join Torchbearers Platform.Answer: Sign Up Extension of PowerPoint is?Answer: .pptx MS Excel is based on?Answer: Rows and columns In Excel, the SUMIF function is used to?Answer: Sum values based on a condition The actual page margin is?Answer: The space between the text and the edge of the paper MS Access is a software for?Answer: Database Management What does the red wavy line show in MS Word?Answer: Spelling mistake To go to a specific location in a MS Word 200, we use _____?Answer: Bookmark Which one is the most suitable reason to use Macro in MS Office (Word, Excel, PPT, etc)?Answer: To automate repetative tasks How many characters can be typed in a single cell in Excel ?Answer: 32767 What type of chart is useful for comparing values over categories?Answer: Column Chart What type of chart will you use to compare performance of sales of two products ?Answer: Column Chart A feature that displays only the data in column (s) according to specified criteriaAnswer: Filtering Which of the following is not a worksheet design criterion?Answer: Description You want to track the progress of the stock market on a daily basis. Which type of chart should you use?Answer: Line chart When you want to insert a blank embedded excel object in a word document you canAnswer: Click the object command on the insert menu Excel worksheet cells work very similarly to what common element of the windows graphical user interfaceAnswer: Text boxes Which of the following is a correct order of precedence in formula calculation?Answer: None of these Rounding errors can occurAnswer: When you use multiplication, division, or exponentiation in a formula When you link data maintained in an excel workbook to a word documentAnswer: The word document contains a reference to the original source application What type of chart is good for single series of data ? Column Chart Line ChartAnswer: Both A and B What are inserted as cross-reference in Word ?Answer: Word fields What is a way for me to keep all my data organized in google drive .Answer: All of these which google app for education allows me to customize and collect different types of data and view in a spreadsheet .Answer: Google Forms Ctrl+JAnswer: justifies the current line How columns are numbered in MS Excel?Answer: Alphabetic In PowerPoint which shortcut key is used to open the transitions tab?Answer: Alt+K What is active cell in MS-Excel ______?Answer: Rectangular box Which key is used for Help in PowerPoint?Answer: F1 MS Office is used for ______?Answer: Office work and productivity