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.

126.

To view a cell comment in Excel

A.

Click the edit comment command on the insert menu

B.

Click the display comment command on the window menu

C.

Position the mouse pointer over the cell

D.

Click the comment command on the view menu

Correct answer is C

No explanation has been provided for this answer.

127.

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A.

Press Ctrl + Home

B.

Press Home

C.

Press Shift + Home

D.

Press Alt + Home

Correct answer is A

No explanation has been provided for this answer.

128.

You want to track the progress of the stock market on a daily basis. Which type of chart should you use in Excel?

A.

Pie chart

B.

Row chart

C.

Line chart

D.

Column chart

Correct answer is C

No explanation has been provided for this answer.

129.

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000. How can you accomplish this?

A.

You have to retype everything and manually add the dollar signs, commas, and decimals

B.

Select Format > Money from the menu

C.

Click the Currency Style button on the formatting toolbar

D.

None of these

Correct answer is C

No explanation has been provided for this answer.

130.

Excel Paste Special command lets you copy and paste

A.

Cell comments

B.

Formatting options

C.

The resulting values of a formula instead of the actual formula

D.

None of the above

Correct answer is C

No explanation has been provided for this answer.