download Mastguru Android App

Question Detail

Which among following wildcard characters are recognized by excel ?

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

Answer: Option C

Similar Questions :

1. VLOOKUP function used to ?

  • Finds related records
  • Looks up text that contain "v"
  • Check if two cells are identical
  • None of above

Answer: Option A

2. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

  • C1:10H
  • C1:H10
  • C1:H-10
  • C1:H:10

Answer: Option B

3. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

  • F11
  • F10
  • F4
  • F2

Answer: Option A

4. Which of the following methods cannot be used to edit the content of cell ?

  • Pressing F2
  • Clicking the formula bar
  • Pressing the Alt key
  • Double clicking the cell

Answer: Option C

5. 3-D reference in a formula ?

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

Answer: Option A

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