Question Detail

Which among following wildcard characters are recognized by excel ?

  • + and -
  • ! and ^
  • * and ?
  • < and >
Similar Questions :

1. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  • True
  • False

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

3. What excel feature can you use if you want to work with one record at a time ?

  • Auto Complete
  • Data Form
  • Set Form
  • Auto Text

4. A value used in a formula that does not change is called a ?

  • Constant
  • Cell address
  • Varaible
  • Static

5. How do you change column width to fit the contents ?

  • Single-click the boundary to the left to the column heading
  • Double click the boundary to the right of the column heading
  • Press Alt and single click anywhere in the column
  • All of above
Read more from - MS Excel Questions Answers