Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
a. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
b. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
c. Apply a selected background color
d. All of above
Q. Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. All of above
Q. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
a. Point to speech on the tools menu, and then click show text to speech toolbar.
b. Click validation on the data menu
c. Point to speech on the tools menu, and then click speech recognition
d. All of above
Q. Which of the following methods can not be used to enter data in a cell?
a. Pressing an arrow key
b. Pressing the tab key
c. Pressing the Esc key
d. Clicking the enter button to the formula bar
Q. Which of the following will not set text in selected cells to italics?
a. Pressing Ctrl + I on the keyboard
b. Using the Tools – Wizard – Web Form menu item
c. Using the Format – Cells – Font menu item
d. None of the above
Q. Which of the following methods cannot be used to edit the content of cell?
a. Pressing the Alt key
b. Clicking the formula bar
c. Pressing F2
d. Double clicking the cell
Q. Which of the following is not an option in the spelling dialog box?
a. Edit
b. Ignore
c. Ignore all
d. Change
Q. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
a. Edit
b. View
c. Format
d. Tools
Q. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
a. Edit
b. Format
c. Tools
d. Data
Q. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
a. Edit
b. Insert
c. Format
d. Tools
Q. Which of the following is not a worksheet design criterion?
a. Efficiency
b. Auditability
c. Description
d. Clarity
Q. To copy cell contents using drag and drop, press the
a. End key
b. Shift key
c. Esc key
d. None of above
Q. If you press …., the cell accepts your typing as its contents.
a. Enter
b. Ctrl + Enter
c. TAB
d. Insert
Q. The autofill feature
a. Extends a sequential series of data
b. Automatically adds a range of cell values
c. Applies a boarder around selected cells
d. None of above