Microsoft Excel Set-20

191. 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
192. 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
193. 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
194. Formatting a cell in Currency, you can specify
     a. Decimal Places
     b. Currency Symbol
     c. Both of above
     d. None of above
195. Formatting a cell in Number format you can’t set
     a. Decimal Places
     b. Use 1000 separator
     c. Negative numbers
     d. Currency Symbol
196. 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
197. Which function will you use to enter current time in a worksheet cell?
     a. =today()
     b. =now()
     c. =time()
     d. =currentTime()
198. Special category of Number tab in Format Cells dialog box can be used to apply formats like
     a. Zip Code
     b. Phone Number
     c. Both of above
     d. None of above
199. Merge cells option can be applied from
     a. Format Cells dialog box Alignment Tab
     b. Formatting toolbar
     c. Both of above
     d. None of above
200. Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
     a. from Fromat >> Cells
     b. from Format >> Autoformat
     c. from Table >> Autoformat
     d. All of above

____________________________________________________________________________