Data Entry Operations Quiz

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

• A. Wrap Text in Format >> Cells

• B. Justify in Edit >> Cells

• C. Text Wrapping in Format >> Cells, Layout tab

• D. All of above

What type of chart is useful to track changes over short and long periods of time?

• A. Pie chart

• B. Column Chart

• C. Line Chart

• D. Dot Graph

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

• A. F8

• B. F9

• C. F10

• D. F11

Which of the following is not a valid function in MS-Excel?

• SUBTRACT( )

• COUNTA( )

• SUM( )

• COUNT( )

Which is not a font style?

• A. Bold

• B. Italic

• C. Strikethrough

• D. Regular

Which Function in excel checks whether a condition is true or false?

• Condition( )

• IF ( )

• Average( )

• TrueOrFalse( )

“Ctrl + Page Down” is used for :

• A. Moving the cursor one paragraph down

• B. Moving the cursor one page down

• C. Moving the cursor one line down

• D. None of the above

What type of chart is useful for comparing parts of a whole?

• A. Column Chart

• B. Line Chart

• C. Pie chart

• D. Dot Graph

Short cut key for Undo is :

• A. Ctrl + Y

• B. Ctrl + X

• C. Ctrl + V

• D. Ctrl + Z

Assertion(A) & Reason(R)-

Assertion: Writer is a word processing software.

Reason: Style is a set of text formatting characteristics such as font size, color and alignment.

• a. Both A and R are true and R is the correct explanation of A.

• b. Both A and R are true but R is NOT the correct explanation of A.

• c. A is true but R is false

• d. A is false but R is true

• e. Both are A & R are false