📁 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

Which key is used to move from cell to cell in an MS Word table?Answer: Tab In MS Word which of the following refers to the placement of paragraph text relative to the left and right margins?Answer: Alignment In MS Word lines, arrows, callouts, and banners are examples of ______?Answer: Shapes Following objects can be drawn in MS Word EXCEPT?Answer: Photographs Which of the following is a valid range reference?Answer: C3:E5 The formula = (B3+B4+B5+B6)/4 would have the same result as the function _______?Answer: =AVERAGE (B3:B6) Which of the following expressions will give a value of 6?Answer: =6*6/6 If a formula = B14*C14 in cell D14, and is copied to D16, the new formula would be _____?Answer: =B16*C16 ______ is a collection of graphics you can utilize to organize information within your document. It includes timelines, processes, or workflows.Answer: SmartArt ______ are types of changes that occur when text has been omitted from a document and must be inserted later.Answer: None of these A ________ contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar.Answer: Toolbar Which option in File pull-down menu is used to close a file in MS Word?Answer: Close The ______ in the Resume Wizard dialog box indicates the wizard is ready to create a document.Answer: Finish panel The category of software most appropriate for controlling the design and layout of complex documents like newsletters and brochures is _____?Answer: Desktop publishing The ______ program compresses large files into a smaller file.Answer: WinZip program How do you change column width to fit the contents?Answer: Double-click the boundary to the right of the column heading How are data organized in a spreadsheet?Answer: Rows and columns Except for the ______ function, a formula with a logical function shows the word “True” or “False” as a result.Answer: IF Which function displays row data in a column and column data in a row?Answer: Transpose C7:C9 indicates ______?Answer: Cells C7 through C9 Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?Answer: Financial A ______ is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.Answer: PivotTable In Excel, a trendline can be added to a ______?Answer: Chart _____ provides visual cues to help you quickly make sense of your data?Answer: Conditional Formatting Microsoft Excel can ______ text so it appears on multiple lines in a cell.Answer: Wrap In order to use mail merge to send bulk email messages, a MAPI-compatible email program like ______ needs to be installed.Answer: Outlook or Gmail Suppose you are working on page 5 and you want to start a new text on page 6. Which is the best way to move to the next page?Answer: Use a page break at page 5 Hyphenation is used to ______?Answer: Save space in a document In order to remove page numbers, if the “Remove Page Numbers” button is not available or if some page numbers are still there _____?Answer: Double-click in the header or footer, select the page number, and press Delete While converting text to a table, if you have commas in your text, use ______ for your separator characters.Answer: Tabs