MS EXCEL QUIZ

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

Apply Conditional Formatting command on Format menu

All of above

Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

Use =if() function to format the required numbers red

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Font format

Border format

All of above

Number format

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is invalid statement?

Some picture can be applied as a background of a sheet

You can set the column width automatically fit the amount of text

The width of a row and be specified manually or fit automatically

Sheet tabs can be colored

TRUE ANSWER : ?
YOUR ANSWER : ?

It is acceptable to let long text flow into adjacent cells on a worksheet when

Data will be entered in the adjacent cells

No data will be entered in the adjacent cells

There is not time to format the text

There is no suitable abbreviation for the text

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command will you choose to convert a column of data into row?

Paste Special > Transpose

Both of above

Cut and Paste

None of above

TRUE ANSWER : ?
YOUR ANSWER : ?

The Cancel and Enter buttons appear in the:

Menu bar

Title bar

Sheet tabs

Formula bar

TRUE ANSWER : ?
YOUR ANSWER : ?

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

Macro sheet

Data sheet

Work sheet

Chart sheet

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following options is not located in the page setup dialog box ?

Page Break Preview

Margins

Headers and Footers

Page Orientation

TRUE ANSWER : ?
YOUR ANSWER : ?

In the formula, which symbol specifies the fixed columns or rows ?

&

*

$

%

TRUE ANSWER : ?
YOUR ANSWER : ?

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

The sheet tab is changed

The status bar does not display the cell address

An absolute cell address is created

Cell address will change when it is copied to another cell

TRUE ANSWER : ?
YOUR ANSWER : ?

↑