download Mastguru Android App

Question Detail

When creating a vertical page break ?

  • The active cell must be in row 1
  • The active cell must be A1
  • The active cell must be in row 10
  • The active cell must be in column A

Answer: Option A

Similar Questions :

1. On Excel screen, Tab scroll buttons are

  • towards the top left corner
  • towards the top right corner
  • towards the bottom right corner
  • towards the bottom left corner

Answer: Option D

2. 3-D reference in a formula ?

  • Spans worksheets
  • Can not be modified
  • Only appears on summary worksheets
  • Limits the formatting options

Answer: Option A

3. In Excel Worksheet how can you show or hide the gridlines ?

  • Click Gridline tool on Forms toolbar
  • Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • Both of above
  • None of above

Answer: Option C

4. Style sheet formats can be applied from ?

  • Table >> Autoformat
  • Format >> Autoformat
  • Table >> Cells
  • Fromat >> Cells

Answer: Option B

5. Which function will you use to enter current time in a woksheet cell ?

  • =time()
  • =nowtime()
  • =now()
  • =currentTime()

Answer: Option C

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs