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.
- Q41.
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 › - Q42.
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 › - Q43.
The process of making changes to an existing document is referred to as __________ it.
A. ModifyingB. AdjustingC. ChangingD. EditingeasyAsked in TCS ExamView solution › - Q44.
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 › - Q45.
Excel documents are stored as files called _________.
A. WorksheetsB. WorkforceC. WorkprojectD. WorkbookseasyAsked in TCS ExamView solution › - Q46.
In MS Excel, text in a column is generally aligned
A. justifiedB. rightC. centerD. lefteasyAsked in TCS ExamView solution › - Q47.
To remove data from the existing cell in MS-Excel, we use the _______ key.
A. Ctrl + XB. Ctrl + CC. DeleteD. Ctrl+ Alt + Shift XeasyAsked in TCS ExamView solution › - Q48.
What is the keyboard shortcut for making selected text bold in Word?
A. Ctrl+ AB. Ctrl + BC. Ctrl + CD. Ctrl + DeasyAsked in TCS ExamView solution › - Q49.
To move to the bottom of a Word document, which of the following keys should be used?
A. Ctrl+ Page DownB. EndC. HomeD. Ctrl + EndeasyAsked in TCS ExamView solution › - Q50.
In Word documents, the automatic correction of errors is known as
A. GREPB. Spell checkC. AutocorrectD. Search and FindeasyAsked in TCS ExamView solution › - Q51.
Tab key is used for
A. To go upward in a lineB. To go downward in a lineC. To go leftward of the lineD. To indent a lineeasyAsked in TCS ExamView solution › - Q52.
With which of the following signs do formulas in excel start?
A. /B. *C. $D. =easyAsked in TCS ExamView solution › - Q53.
How are data organised in a spreadsheet?
A. Lines and spacesB. Layers and ChannelsC. Attributes and TransparencyD. Rows and columnseasyAsked in TCS ExamView solution › - Q54.
Which of the following task is accomplished by using bookmarks?
A. To quickly jump to a specific location in the documentsB. To add hyper links in a web pageC. To add anchors in a web pageD. To mark the ending of a page of documentmediumAsked in TCS ExamView solution › - Q55.
Accidental click on undo button in Excel 2007 is reversed by clicking
A. RevertB. Step to the BackC. RedoD. Step BackwardeasyAsked in TCS ExamView solution › - Q56.
Which option is for print preview in MS Office?
A. Print MenuB. Print Tab in Microsoft Office Backstage viewC. Ctrl + F2D. Both B and CmediumAsked in TCS ExamView solution › - Q57.
Which key allows movement from one cell of a table to the next?
A. ShiftB. CtrlC. EscD. TabeasyAsked in TCS ExamView solution › - Q58.
Which of the following is a Undo Command?
A. Ctrl + UB. Ctrl + ZC. Ctrl+VD. Ctrl + CeasyAsked in TCS ExamView solution › - Q59.
The keyboard shortcut for hiding entire rows in Excel is
A. Ctrl + 4B. Ctrl + RC. Ctrl+VD. Ctrl +9mediumAsked in TCS ExamView solution › - Q60.
In which format is a spreadsheet file saved?
A. .jpegB. .xlsxC. .docxD. .flveasyAsked in TCS ExamView solution ›