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.
- Q1.
To take any text from its original place to another place without deleting it is called
A. ScrollingB. SearchingC. MovingD. CopyingeasyAsked in MAH MCA CET 2023View solution › - Q2.
Which of the following is used to move a document (or selected text)?
A. Copy & pasteB. Cut & pasteC. Move & pasteD. Cut & undoeasyAsked in MAH MCA CET 2023View solution › - Q3.
An electronic spreadsheet contains (most correct answer):
A. RowB. ColumnC. CellD. Options (A), (B) and (C)easyAsked in MAH MCA CET 2023View solution › - Q4.
To save a file on a computer for the first time, which option is used?
A. Save asB. Save onC. PrintD. Save ineasyAsked in MAH MCA CET 2023View solution › - Q5.
When a page is ready to print, we can review it using —
A. Print PreviewB. List PreviewC. Print ScreenD. NoneeasyAsked in MAH MCA CET 2023View solution › - Q6.
The feature that aligns text evenly along the right margin is —
A. Word WrapB. Right RaggedC. Right JustifiedD. None of theseeasyAsked in MAH MCA CET 2023View solution › - Q7.
The operation of combining two cells into a single cell in Excel is known as
A. AddB. SumC. AverageD. ConcatenatemediumAsked in TCS ExamView solution › - Q8.
In MS Access, which one is the default data type of a field?
A. TextB. Auto NumberC. NumberD. MemoeasyAsked in TCS ExamView solution › - Q9.
In order to choose the font for a sentence in a word document:
A. select font in the format menuB. select font in the edit menuC. select font in the tools menuD. select font in the view menueasyAsked in TCS ExamView solution › - Q10.
Downloaded images can be inserted in a Word document using the ________ option of the Illustration group.
A. PictureB. From FileC. ClipartD. ImageseasyAsked in TCS ExamView solution › - Q11.
Which of the following is not related to text formatting:
A. Line spacingB. Text spacingC. Margin ChangeD. SearchingeasyAsked in TCS ExamView solution › - Q12.
How can you increase the font size of the selected text in a Word document by one point every time?
A. By pressing Ctrl+]B. By pressing Ctrl+[C. By pressing Ctrl+}D. By pressing Ctrl+{easyAsked in TCS ExamView solution › - Q13.
Which is a save document command in Microsoft Word?
A. Ctrl + ZB. Ctrl + WC. Ctrl + SD. Ctrl + AeasyAsked in TCS ExamView solution › - Q14.
In Microsoft Word _______ provides tools for formatting like bold, italic, underline etc.
A. Standard tool barB. Menu barC. Formatting tool barD. Status bareasyAsked in TCS ExamView solution › - Q15.
In Microsoft Word, ______ provides options to switch between Normal, Web Layout. Print Layout, Outline and Reading Views.
A. Standard tool barB. View ButtonsC. Formatting tool barD. Tab stopeasyAsked in TCS ExamView solution › - Q16.
In Microsoft Word _______ setting allows us to align the text at a particular point, or to create a tabular layout.
A. IndentationB. BulletsC. NumberingD. TabseasyAsked in TCS ExamView solution › - Q17.
In Microsoft Word, font, font style, size, font color etc. are options of __________
A. Character formattingB. Paragraph formattingC. Sentence formattingD. Font formattingeasyAsked in TCS ExamView solution › - Q18.
In Microsoft Word, under character formatting ________ used to underline some particular text.
A. Font styleB. UnderlineC. EffectsD. SizeeasyAsked in TCS ExamView solution › - Q19.
Which of the following is the file extension of MS Excel?
A. .exlsB. .xlsxC. .elsD. .exleasyAsked in TCS ExamView solution › - Q20.
Thesaurus tool in MS-Word is used for:
A. Correcting sentencesB. Grammar optionsC. Spelling suggestionsD. Synonyms and Antonyms wordseasyAsked in TCS ExamView solution ›