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.
______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 › - Q22.
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 › - Q23.
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 › - Q24.
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 › - Q25.
Calisto MT, Arial and Century are various types of______.
A. Word ArtB. Font sizesC. StylesD. FontseasyAsked in TCS ExamView solution › - Q26.
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 › - Q27.
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 › - Q28.
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 › - Q29.
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 › - Q30.
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 › - Q31.
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 › - Q32.
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 › - Q33.
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 › - Q34.
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 › - Q35.
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 › - Q36.
What is the shortcut key for centre alignment of a line or text in MS Office software?
A. Ctrl+EB. Ctrl+CC. Ctrl+GD. Ctrl+AeasyAsked in TCS ExamView solution › - Q37.
In computing, which terms refers to a pre-designed document that already has coordinating fonts, a layout, and background?
A. GuidesB. Anchor objectsC. ScriptsD. TemplateseasyAsked in TCS ExamView solution › - Q38.
The process of making changes to an existing document is referred to as __________ it.
A. ModifyingB. AdjustingC. ChangingD. EditingeasyAsked in TCS ExamView solution › - Q39.
The basic unit of a worksheet into which we enter data in Excel is called a ________.
A. TabB. CellC. BoxD. RangeeasyAsked in TCS ExamView solution › - Q40.
Excel documents are stored as files called _________.
A. WorksheetsB. WorkforceC. WorkprojectD. WorkbookseasyAsked in TCS ExamView solution ›