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. A function inside another function is known as ?

  • Round function
  • Sandwich function
  • Switch function
  • Nested function

Answer: Option D

2. Which among following wildcard characters are recognized by excel ?

  • + and -
  • ! and ^
  • * and ?
  • < and >

Answer: Option C

3. Which shortcut can be used to Switch between open workbooks ?

  • Ctrl + F2
  • Ctrl + F6
  • Ctrl + F8
  • Ctrl + F10

Answer: Option B

4. How is data organized in a spreadsheet ?

  • Rows and columns
  • Layers and planes
  • Lines and spaces
  • Height and width

Answer: Option A

5. Which dialogue box we can use to name a constant ?

  • Create Name
  • Define Name
  • Get Name
  • Create Constant

Answer: Option B

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