166. In Excel, an active cell can be represented by

1. 1. 4A

   
   
   

   2. A4

   
   
   

   3. A$4

   
   
   

   4. $A$4

   
   
   

   5. $A4

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   NA

---

167. Which option will we use to give heading in the form ?

1. 1. Label

   
   
   

   2. Text box

   
   
   

   3. Option group

   
   
   

   4. Insert

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   NA

---

---

168. Three types of data can be entered in a worksheet, as number/characters, text and

1. 1. formulas

   
   
   

   2. functions

   
   
   

   3. logic

   
   
   

   4. All of these

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   NA

---

169. To select the current column press

1. 1. Ctrl + Spacebar

   
   
   

   2. Ctrl + B

   
   
   

   3. Shift + Enter

   
   
   

   4. Ctrl + Enter

   
   
   

   5. Ctrl + Shift

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   NA

---

---

170. Scatter chart is also known as

1. 1. XX chart

   
   
   

   2. YX chart

   
   
   

   3. XY chart

   
   
   

   4. YY chart

   
   
   

   5. XZ chart

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   NA

---