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.

211.

How many users can open an Excel file at the same time?

A.

64 users

B.

128 users

C.

256 users

D.

512 users

Correct answer is C

A total number of 256 users can open the excel file at the same time. For this, the "Allow changes by more than one user..." setting should be enabled.

212.

The total number of columns in an Excel worksheet is _________

A.

26

B.

256

C.

12,834

D.

16,384

Correct answer is D

No explanation has been provided for this answer.

213.

The total number of rows in an Excel worksheet is _____

A.

Unlimited

B.

65,535

C.

1,048,576

D.

1,068,576

Correct answer is C

No explanation has been provided for this answer.

214.

What is a collection of worksheets called?

A.

Ledger

B.

Book

C.

Testbook

D.

Workbook

Correct answer is D

No explanation has been provided for this answer.

215.

In Microsoft Excel, shortcut key CTRL + D is used to ____

A.

open Font dialog box

B.

open Format Cells dialog box

C.

shift current cell's value in the right cell

D.

fill down in the selection

Correct answer is D

No explanation has been provided for this answer.