Practice MS Office Questions and Answers

• In Microsoft Excel, which shortcut key is used to insert a page break?
• What is the shortcut key for inserting a page break in Microsoft Word?
• In Microsoft Excel, what does the "$" symbol represent when used in cell referencing?
• First row in MS Excel is written as?
• Which shortcut key is used to center-align text in Microsoft Word?
• Which of the following formulas correctly calculates the sum of values in cells A1 to A5 in Excel?
• Which keyboard shortcut is commonly used to access macros in Microsoft Office applications?
• Which of the following operations is done using shortcut key Ctrl + Shift + > in MS Word 365?
• Which formatting feature in MS Word 365, is used to emphasise text by making it bold, italic or underlined in documents?
• The most popular combination of 'shortcut keys' to 'copy' some selected text and 'paste' the same at some other location in most of the MS Windows applicat...
• Which of the following software is generally preferred most, to create a tabular sheet to store marks scored by 100 students of a boarding house in the las...
• Which of the following software is generally preferred most, to create an animated multimedia presentation on the topic 'Health and Hygiene in a Boarding H...
• _________ are the visual effects which appear in PowerPoint when one slide moves to next.
• _________ is used to quickly apply the same formatting, such as colour, font style and size, or border style, to multiple pieces of text or graphics.
• Eena Khande is creating her project report as a document and is interested in typing the same in an easy-to-use software with facility of formatting page s...
• Which out of the following is the correct file extension of an Excel file?
• Mohak Shangle is interested in making a digital presentation for marketing his company's new product using an Open Source Software. Which of the following ...
• Which out of the following is the extension of MS PowerPoint file?
• Which out of the following is true about cell range in MS Excel?
• Which of the following is not a file extension of an image file?
• Which of the following colored wavy lines is used to represent spelling errors in an MS Word 365 document?
• Which of the following options in MS Word 365 means the page is oriented vertically?
• In MS Excel 365, which Microsoft Excel view allows you to see how the printed worksheet will look before actually printing it?
• In MS Word 365, which keyboard shortcut is used to cut the selected text?
• In MS Excel 365, which of the following is an example of absolute reference pointing to cell A1?
• Which of the following options allows you to choose whether to keep or discard the formatting of pasted text in MS Word 365?
• Which of the following inbox categories helps to focus on the emails that matter the most and separates the inbox into different tabs in MS-Outlook 365?
• Which of the following options in the Shape Format tab is used to make a line dotted or dashed in MS-PowerPoint 365?
• The ‘Ctrl + W’ keyboard shortcut is used for which of the following purposes in MS Word 365?
• Which of the following functions in MS Excel 365 is used to search for an item in a range of cells and then return the relative position of that item in th...
• What is the purpose of the keyboard shortcut ‘Ctrl + Left Bracket ([)’ in MS Word 365?
• The paragraphs, drawing, and editing related commands appear under the ____ menu in MS-PowerPoint 2016.
• Which of the following statements is/are true? (i) System software facilitates the working of application software. (ii) MS-Word is both system and applica...
• What is the keyboard shortcut to invoke the ‘Insert Hyperlink’ window in MS-Word 2016?
• Which of the following symbols/characters is used to enter a formula in the cell of an MS-Excel worksheet?
• What is the address of the cell in an MS-Excel worksheet which lies at the intersection of the second row and the third column?
• Which of the following is a valid data type in MS Excel?
• In Microsoft PowerPoint, which feature allows you to add visual effects between slides?
• Which function key displays the Print Preview window in Microsoft Office applications?
• In Excel, what does the VLOOKUP function do?