MS EXCEL QUIZ | EXAMIANS

The command Edit > Fill Across Worksheet is active only when

When no sheet is selected

One sheet is selected

When many sheets are selected

None of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following action removes a sheet from workbook?

None of above

Select the sheet then choose Format > Sheet > Hide

Select the sheet, then choose Edit > Delete Sheet

Both of above

TRUE ANSWER : ?
YOUR ANSWER : ?

Which chart can be created in Excel ?

Area

Line

All of the listed here

Pie

TRUE ANSWER : ?
YOUR ANSWER : ?

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Math & Trigonometry

Logical

Statistical

Financial

TRUE ANSWER : ?
YOUR ANSWER : ?

Getting data from a cell located in a different sheet is called ___

Referencing

Functioning

Updating

Accessing

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not an example of a value?

0.57

350

Serial Number 50771

May 10, 2001

TRUE ANSWER : ?
YOUR ANSWER : ?

Microsoft Excel is a powerful ___

Spreadsheet package

Communication S/W package

Word processing package

DBMS package

TRUE ANSWER : ?
YOUR ANSWER : ?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

From Edit menu choose Delete

Double click the Format Painter and then press Esc key in keyboard

From Edit menu choose Clear and then Formats

Click on Remove Formatting tool on Standard Toolbar

TRUE ANSWER : ?
YOUR ANSWER : ?

B7:B9 indicates:

Cell B8 only

Cells B7 through B9

None of these

Cells B7 and cell B9 only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the cell pointer indicate that you can move the content to other cell?

Doctor’s symbol (Big Plus)

Small thin plus icon

None of above

Mouse Pointer with anchor at the tip

TRUE ANSWER : ?
YOUR ANSWER : ?