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. How we can view a cell comment ?

  • position the mouse pointer over the cell
  • click the comment command on the view menu
  • click the edit comment commands on the Insert menu
  • click the Display comment command on the window menu

Answer: Option A

2. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

  • NOT
  • OR
  • IF
  • AND

Answer: Option C

3. To drag a selected range of data to another worksheet in the same workbook, use the ?

  • Ctrl key
  • Shift key
  • Alt key
  • Tab key

Answer: Option A

4. Protection and the Protect Sheet options can be selected from ?

  • Data
  • Tools
  • Edit
  • Format

Answer: Option B

5. What term describes explanatory text attached to a cell ?

  • Context
  • Callout
  • Comment
  • Dialog

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