MS Excel MCQ (Multiple Choice Questions)

MS-Excel can be used to automate

a) Financial statements, Business forecasting
b) Transaction registers, Inventory control
c) Accounts receivable, accounts payable
d) Any of above
e) None of above

Check Answer

The correct answer is option D ” Any of the above”.
NOT, AND, OR and XOR are

a) Logical operators
b) Arithmetic operators
c) Relational operators
d) None of above

Check Answer

The correct answer is option A ” Logical operators”.
We can save and protect the workbook by

a) Write Reservation Password
b) Protection Password
c) Read-Only Recommended
d) Any of above
e) None of above

Check Answer

The correct answer is d) Any of the above.

You can save and protect a workbook by setting a password. There are several types of passwords that you can use:
a) Write Reservation Password: This password prevents unauthorized users from making changes to the workbook.
b) Protection Password: This password prevents unauthorized users from opening the workbook.
c) Read-Only Recommended: This option marks the workbook as read-only and recommends that users open it in read-only mode. However, users can still choose to edit the workbook if they wish.

You can use any of the above options to save and protect your workbook.
Exact Study
Logo