Microsoft Office questions and answers

Microsoft Office Questions and Answers

A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.

6.

A ________ is a collection of predefined design elements and color schemes.

A.

Feature

B.

Hyperlink

C.

Palette

D.

Theme

Correct answer is D

Themes provide a complete design for our document, including background designs, font styles, colors, and layouts.

7.

What are Macros in MS Word?

A.

Small programs created in MS-Word to automate repetitive tasks by using VBA

B.

Small add-on programs that are installed afterwards if you need them

C.

Programming language that you can use to customize MS-Word

D.

Large tools in Word such as mail merge

Correct answer is A

A macro can help improve efficiency when creating documents and spreadsheets, adding or maintaining information, or creating forms for other people to fill out.

Microsoft Word and Excel are popular software in which people utilize macros to make data entry and retention easier. Macros in Word and Excel are created using the Visual Basic programming language or by recording actions performed.

8.

Which of the following enables us to send the same letter to different persons?

A.

Macros

B.

Template

C.

Mail merge

D.

None of above

Correct answer is C

Mail Merge is a useful tool that allows us to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet.

9.

You can detect spelling and grammar errors by

A.

Pressing Shift + F7

B.

Pressing Ctrl + F7

C.

Pressing Alt+ F7

D.

Pressing F7

Correct answer is D

F7 is commonly used to spell-check and grammar-check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

10.

With which view can you see how text and graphics will appear on the printed page?

A.

Normal

B.

Print Layout

C.

Outline

D.

Web Layout

Correct answer is B

No explanation has been provided for this answer.