Microsoft Excel Q/a(Computer Aptitude ) Questions and answers for exam Preparation

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 3 of 64 pages

Question 21. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply t

Use -if function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
None of these

Discuss Question

Answer: Option B. -> Apply Conditional Formatting command on Format menu

Question 22. To activate the previous cell in a pre selected range, press

The Alt key
The Tab key
The Enter key
All of the above
None of these

Discuss Question

Answer: Option D. -> All of the above

Question 23. The view that puts a blue a blue line around each page that would be printed is the......

Print Preview
Normal View
Page Break Preview
Split View
None of these

Discuss Question

Answer: Option C. -> Page Break Preview

Question 24. How do you insert a row?

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit > Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
None of these

Discuss Question

Answer: Option A. -> Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Question 25. You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?

New
Save As
Edit
Save
None of these

Discuss Question

Answer: Option B. -> Save As

Question 26. Excel uses the …. Function when creating a data table

Count
Table
Average
Sum

Discuss Question

Answer: Option B. -> Table

Question 27. In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?

Click the arrow on the paste button on the standard toolbar, then click formulas
Click the arrow on the paste button on the standard toolbar, then click values.
Click the Paste button on the standard toolbar
All of above

Discuss Question

Answer: Option B. -> Click the arrow on the paste button on the standard toolbar, then click values.

Question 28. You cannot link Excel worksheet data to a Word document