MS EXCEL QUIZ

Which of the following is not true regarding Conditional Formatting?

You can set condition to look for Bold and apply Italics on them

You can add more than one condition to check

You can delete any condition from Conditional Formatting dialog box if it is not requried

You can apply Font, border and pattern formats that meets the specified conditions

TRUE ANSWER : ?
YOUR ANSWER : ?

To view a cell comment

Position the mouse pointer over the cell

Click the edit comment command on the insert menu

Click the display comment command on the window menu

Click the comment command on the view menu

TRUE ANSWER : ?
YOUR ANSWER : ?

Long text can be broken down into many lines within a cell. You can do this through

Justify in Edit > Cells

Wrap Text in Format > Cells

All of above

Text Wrapping in Format > Cells

TRUE ANSWER : ?
YOUR ANSWER : ?

What is represented by the small, black square in the lower-right corner of an active cell or range?

Copy handle

Fill handle

Insert handle

Border

TRUE ANSWER : ?
YOUR ANSWER : ?

A worksheet can have a maximum of ________ number of rows.

1048576

256

1024

65535

TRUE ANSWER : ?
YOUR ANSWER : ?

Which setting you must modify to print a worksheet using letterhead?

Orientation

Paper

Layout

Margin

TRUE ANSWER : ?
YOUR ANSWER : ?

What does COUNTA () function do?

Counts non-empty cells

Counts cells having number

Counts cells having alphabets

Counts empty cells

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Number format

Font format

Border format

All of above

TRUE ANSWER : ?
YOUR ANSWER : ?

Excel displays the current cell address in the ___

Formula Bar

Title Bar

Name Box

Status Bar

TRUE ANSWER : ?
YOUR ANSWER : ?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?

Press Ctrl + Home

Press Alt + Home

Press Shift + Home

Press Home

TRUE ANSWER : ?
YOUR ANSWER : ?

↑