0
Login

MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 181 - 190 of 336 Questions

75 Details Computer Science MS Excel Easy

To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

A Edit
B Format
C Tools
D Data
Correct Answer

Option C: Tools

Discussion
74 Details Computer Science MS Excel Easy

You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

A Edit
B View
C Format
D Tools
Correct Answer

Option C: Format

Discussion
72 Details Computer Science MS Excel Easy

Which of the following is not an option in the spelling dialog box?

A Edit
B Ignore
C Ignore all
D Change
Correct Answer

Option A: Edit

Discussion
63 Details Computer Science MS Excel Easy

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
Correct Answer

Option A: Pressing the Alt key

Discussion
74 Details Computer Science MS Excel Easy

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
Correct Answer

Option B: Using the Tools – Wizard – Web Form menu item

Discussion
68 Details Computer Science MS Excel Easy

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
Correct Answer

Option C: Pressing the Esc key

Discussion
68 Details Computer Science MS Excel Easy

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
Correct Answer

Option A: Point to speech on the tools menu, and then click show text to speech toolbar.

Discussion
65 Details Computer Science MS Excel Easy

Which function calculates your monthly mortage payment?

A PMT (payments)
B NPER (number of periods)
C PV (present value)
D All of above
Correct Answer

Option A: PMT (payments)

Discussion
66 Details Computer Science MS Excel Easy

Your 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
Correct Answer

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

Discussion
71 Details Computer Science MS Excel Easy

How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

A On the file menu, point to print area, and then click set print area.
B On the file menu, click print, and then click selection under print what
C On the view menu, click custom views, then click add
D All of above
Correct Answer

Option B: On the file menu, click print, and then click selection under print what

Discussion


Computer Science

WhatsApp Support