211. Which of the following is not a valid formula in Microsoft Excel ?

1. 1. = A2 + A1

   
   
   

   2. = A2 + 1

   
   
   

   3. = 1 + A2

   
   
   

   4. = 1A + 2

   
   
   

   5. = A1 + A2

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   NA

---

212. In a worksheet in MS-Excel what is short-cut key to hide entire row ?

1. 1. Ctrl + 2

   
   
   

   2. Ctrl + 9

   
   
   

   3. Ctrl + N

   
   
   

   4. Ctrl + -

   
   
   

   5. Ctrl + N

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   NA

---

---

213. Which of the following is not an example of a document file ?

1. 1. Spreadsheet

   
   
   

   2. Memo

   
   
   

   3. Letter

   
   
   

   4. Term Paper

   
   
   

   5. Thesis

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   NA

---

214. A collection of worksheets is called

1. 1. Excel book

   
   
   

   2. Worksheets

   
   
   

   3. Excel sheets

   
   
   

   4. Workbook

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   NA

---

---

215. Which command is used to calculate total characters in a cell ?

1. 1. Len

   
   
   

   2. Length

   
   
   

   3. Mid

   
   
   

   4. Sid

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   NA

---