MS excel set 3 Detailed Explanation And More Example

Question : 1

In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

a) Data will be entered in the adjacent cells

b) No data will be entered in the adjacent cells

c) There is no suitable abbreviation for the text

d) There is not time to format the text

Question : 2

Hyperlinks cannot be

a) Special shapes like stars and banners

b) Drawing objects like rectangles ovals

c) Pictures

d) All can be hyperlinks

e) None of these

Question : 3

In Excel which of the following is not a valid data type in excel

a) Number

b) Character

c) Label

d) Date/time

Question : 4

In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

a) Edit

b) Insert

c) Format

d) Tools

Question : 5

Text formulas:

a) Replace cell references

b) Return ASCII values of characters

c) Concatenate and manipulate text

d) Show formula error value

e) None of these

Question : 6

What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

a) 5,430.00

b) 5,436.80.

c) 5,436.8

d) 6.8

e) None of these