📁 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

Absolute reference is represented by which symbol:Answer: $ Which of the following provide User friendly interface?Answer: Operating system What is the purpose of Pivot table purpose:Answer: To summarize and analyze data Which function is used to insert current date and time:Answer: NOW() In cell range, Count Function is used to:Answer: Count cells containing numbers How can we add Clip art in MS word:Answer: Insert → Clip Art Which of the function is used to find the average:Answer: AVERAGE() Dropcap mean:Answer: A large first letter at the beginning of a paragraph Which shortkey is used to change the case of font:Answer: Shift + F3 Which shortkey is used to save the document:Answer: Ctrl + S Which key is used to copy the document:Answer: Ctrl + C Graphical Representation of data is called as:Answer: Chart By default, you can save you document in:Answer: Documents folder Compare documents option is available in which tab of MS word:Answer: Review In MS Word, Master documents contains:Answer: Subdocuments What is extension of MS PowerPoint presentation of file in 2007 and later?Answer: .pptx Which key is used to delete a character to the left side of the cursor in MS Word?Answer: Backspace Microsoft Word displays hyperlinks as a _______?Answer: Blue underlined text Which of the following functions is used to sum the values in a range that meet criteria that can you specify?Answer: SUMIF Borders can be applied to ___.Answer: Cell text paragraph What is the purpose of Insert >> Picture >> Clip Art?Answer: To insert clip art in a document Which of following is page margin?Answer: Narrow The name of the PowerPoint file can be seen on _____?Answer: Title bar To insert a hyperlink which shortkey is used?Answer: Ctrl+K Which sign is used to create an absolute cell reference in MS Excel?Answer: $ Which is used for arranging data in ascending/descending order in MS Excel?Answer: Data, sort Where is the Print option located in MS Word?Answer: File > Print Which tab contains the row or column option in MS Word?Answer: Layout Tab Which file format is typically opened in word processing software?Answer: MS Doc Which key is used to create chart from selected data in excel?Answer: F11