Microsoft Office Questions with Solutions
Microsoft Office questions test practical knowledge of the most widely used office applications: MS Word for documents, MS Excel for spreadsheets, MS PowerPoint for presentations, and MS Access and Outlook at a basic level. Common topics include file extensions (.docx, .xlsx, .pptx), menus and ribbon tabs, formatting features, keyboard shortcuts, and mail merge in Word. For Excel, questions cover cell references (relative, absolute and mixed, such as $A$1), common functions (SUM, AVERAGE, COUNT, IF, VLOOKUP), charts and sorting. For PowerPoint, they cover slide views, transitions and animations. Keyboard shortcuts such as Ctrl + Z (undo), Ctrl + Y (redo), F5 (start slideshow) and F7 (spell check) are among the most frequently asked questions, so a shortcut revision sheet is very useful. Practise the Microsoft Office questions below. Each answer includes an explanation.
- Q21.
Which of the following option is used to move data from one place to another in a document (MS-Office)?
A. CutB. CopyC. PasteD. Cut and PasteeasyAsked in TCS ExamView solution › - Q22.
______and _______ are the smallest and largest font size available in Font Size tool on formatting toolbar in MS-Office.
A. 12 and 72B. 8 and 64C. 8 and 72D. 12 and 64easyAsked in TCS ExamView solution › - Q23.
Which of the following feature is used to apply motion effects in between a slide exits and another enters?
A. Slide TransitionB. Animation ObjectsC. Animation SchemeD. Slide DesigneasyAsked in TCS ExamView solution › - Q24.
In Microsoft Excel, Ctrl+ right arrow key leads to _______ cell movement on spreadsheet.
A. End of columnB. End of rowC. One cell LeftD. One cell righteasyAsked in TCS ExamView solution › - Q25.
In Microsoft Excel, Ctrl+ down arrow key leads to _____ cell movement on spreadsheet.
A. End of columnB. End of rowC. One cell LeftD. One cell righteasyAsked in TCS ExamView solution › - Q26.
Calisto MT, Arial and Century are various types of______.
A. Word ArtB. Font sizesC. StylesD. FontseasyAsked in TCS ExamView solution › - Q27.
Which of the following group is NOT present in the Insert tab of MS Excel?
A. IllustrationsB. ParagraphC. LinksD. SymbolsmediumAsked in TCS ExamView solution › - Q28.
In Microsoft Word, the________, tab contains the most-used features, such as tools for changing fonts and font attributes, customising paragraphs, using styles, and finding and replacing text.
A. HOMEB. DESIGNC. REVIEWD. INSERTeasyAsked in TCS ExamView solution › - Q29.
In Microsoft Word _________ are small dots, squares, dashes or graphics that are often seen before the text
A. IndentationB. BulletsC. NumberingD. TabseasyAsked in TCS ExamView solution › - Q30.
In Microsoft Word, _________ view shows how the document would look when it is printed
A. Web LayoutB. Normal LayoutC. Reading LayoutD. Print LayouteasyAsked in TCS ExamView solution › - Q31.
In Excel, which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric?
A. CountB. AverageC. SumD. AddeasyAsked in TCS ExamView solution › - Q32.
In the context of Microsoft Word, there is a feature called 'Gutter Margin'. What is this feature used for?
A. Improve the clarity of graphics and imagesB. Give provision for better document bindingC. Improve the clarity of the printed textD. Facilitate the insertion of page numbersmediumAsked in TCS ExamView solution › - Q33.
What is the keyboard shortcut to paste the contents of the clipboard in a Microsoft Word file?
A. Ctrl+ PB. Ctrl + VC. Ctrl+CD. Ctrl+XeasyAsked in TCS ExamView solution › - Q34.
When entered in the cells of a Microsoft Excel Worksheet, numbers are, by default _________.
A. left alignedB. centre alignedC. right alignedD. JustifiedeasyAsked in TCS ExamView solution › - Q35.
In Microsoft Word, you can customise or choose predefined margin settings by going to _________.
A. Layout> MarginsB. Insert > MarginsC. Review> MarginsD. Draw > MarginseasyAsked in TCS ExamView solution › - Q36.
In Microsoft PowerPoint 2016, _________ contains formatting, positioning and placeholder boxes for all of the content that appears on a slide.
A. Outline viewB. Slide formatC. Slide layoutD. Slide mastermediumAsked in TCS ExamView solution › - Q37.
In MS-PowerPoint, _________ lets you copy all of the formatting from one object and apply it to another one.
A. Format StyleB. Format AllC. Format PasteD. Format PaintereasyAsked in TCS ExamView solution › - Q38.
In Microsoft Power Point, you want to ensure that your company logo appears on the righthand top corner of all the slides in a given presentation, which of the following views would. you use to do this?
A. Slide SorterB. Slide MasterC. Notes MasterD. Outline VieweasyAsked in TCS ExamView solution › - Q39.
To insert a table of contents in a Microsoft Word 2016 document, you would need to go to the ________ menu tab.
A. LayoutB. DesignC. ReferencesD. InserteasyAsked in TCS ExamView solution › - Q40.
Which of the following statements is NOT true with regard to the AutoFilter option in Microsoft Excel?
A. By filtering information in a worksheet, you can find values quickly.B. You can set a filter on only one column of data at a time.C. You can control not only what you want to see, but also what you want to exclude.D. You can search for text or numbers using the AutoFilter option.mediumAsked in TCS ExamView solution ›