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

A. Number format

B. Border format

C. Font format

D. All of above

Answer: Option D

Solution(By Examveda Team)

AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

MS Excel mcq solution image

This Question Belongs to Computer Fundamentals >> MS Excel

Join The Discussion

Comments ( 11 )

  1. Lalith Moni
    Lalith Moni :
    1 year ago

    How to add comments to tha cells?

  2. Harriette Roshen
    Harriette Roshen :
    3 years ago

    What happens when dollar signs ($) are entered in a cell address? (ex. SBS2:$B$10)

  3. Harriette Roshen
    Harriette Roshen :
    3 years ago

    The spelling dialog box can be involved by choosing spelling from menu.

  4. Harriette Roshen
    Harriette Roshen :
    3 years ago

    How do you rearrange the data in ascending or descending order?

  5. Paramasivam Kandasamy
    Paramasivam Kandasamy :
    4 years ago


  6. Malehu Maria
    Malehu Maria :
    4 years ago

    Arror in program is called?

  7. Sadaqat Ali
    Sadaqat Ali :
    4 years ago

    i could not understand

  8. Sarika Kalawane
    Sarika Kalawane :
    5 years ago

    Yes it's right because number,font style and border you can take same for all official documents.

  9. Face ID
    Face ID :
    6 years ago

    couldnt understand............................

  10. Chandan Keshri
    Chandan Keshri :
    6 years ago


  11. Abhijit Narah
    Abhijit Narah :
    6 years ago


Related Questions on MS Excel