MS Excel Questions and Answers

Q: Which among the following methods can not be used to enter data in a cell?

Correct answer: Pressing the Esc keyEsc cancels the entry being typed and restores the cell’s previous contents, so it is the one action that does not commit data. Enter, Tab, an arrow key and the tick button on the formula bar all accept what you typed and confirm it into the cell.

281.

Youar German supplier still invoices for parts in deutsche marks. How does 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

Answer: B

Correct answer: On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

The EUROCONVERT function, which converts between the euro and the legacy national currencies at the fixed conversion rates, is supplied by an add-in. Turn it on with Tools → Add-Ins and tick Euro Currency Tools. Inserting the € symbol only changes how a number looks; it converts nothing.

Discuss in Forum

282.

Which among 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

Answer: C

Correct answer: Pressing the Esc key

Esc cancels the entry being typed and restores the cell’s previous contents, so it is the one action that does not commit data. Enter, Tab, an arrow key and the tick button on the formula bar all accept what you typed and confirm it into the cell.

Discuss in Forum

283.

Which among 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

Answer: B

Correct answer: Using the Tools – Wizard – Web Form menu item

Italics can be applied with Ctrl + I, with the Italic button on the Formatting toolbar, or through Format → Cells → Font. The Tools → Wizard → Web Form command builds a web form and has nothing to do with character formatting, so it is the one that will not italicise the selection.

Discuss in Forum

MS Excel Questions and Answers

Topics

Other Subjects

About Us

MS Excel Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications