MICROSOFT EXCEL

The auto-fill feature:

• (A) Extends a sequential series of data
• (B) Automatically adds a range of cell values
• (C) Applies a boarder around selected cells
• (D) None of above

Which of the following is not a valid Zoom percentage in Excel?

• (A) 10
• (B) 100
• (C) 300
• (D) 500

The spelling tool is placed on toolbar:

• (A) Standard
• (B) Formatting
• (C) Drawing
• (D) Reviewing

If you need a text to show vertically in a cell. How will you achieve this?

• (A) Choose Vertical on Text alignment in Format Cells dialog box
• (B) Choose 90 Degrees in Orientation of Format Cells dialog box
• C) Choose Distributed from the Vertical drop down list of Format Cells dialog box
• (D) Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

Can you set 0.5 inch left indentation for a cell in Excel?

• (A) Excel does not have indentation feature
• (B) You can specify indentation only if you turn the rulers on
• (C) Indentation can be set from Format Cells dialog box
• (D) The indentation can be specified only when printing

You can automatically adjust the size of text in a cell if they do not fit in width by:

• (A) Double clicking on the right border of column header
• (B) From Format choose Columns and then Autofit Selection
• (C) From Format Cells dialog box mark Shrink to fit check box
• (D) All of above

Formatting a cell in Currency, you can specify:

• (A) Decimal Places
• (B) Currency Symbol
• (C) Both of above
• (D) None of abov

Formatting a cell in Number format you can’t set:

• (A) Decimal Places
• (B) Use 1000 separator
• (C) Negative numbers
• (D) Currency Symbol

What is entered by the function =today():

• (A) The date value for the day according to system clock
• (B) The time value according to system clock
• (C) Today’s date as Text format
• (D) All of above

Which function will you use to enter current time in a worksheet cell?

• (A) =today()
• (B) =now()
• (C) =time()
• (D) current Time()