Computer Science

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 181 - 190 of 1111 Questions

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

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

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

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

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

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

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

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

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

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



WhatsApp Support