Computer - Mock Test 63

Question 621

In MS-Excel two common wildcard characters that MS-Excel recognizes are?

A) * and ? B) < and > C) ^ and / D) None of these

---

No Details

Question 622

In MS-Excel Chart wizard term data categories refers to?

A) A chart plot area B) A horizontal axis C) The organization of individual values with a chart's data series D) All of these

---

No Details

Question 623

In MS-Excel chart wizard term data series refers to?

A) A chart legend B) A collection of chart data markers C) A set of values you plot in a chart D) None of these

---

No Details

Question 624

In MS-Excel Documentation should include?

A) Destination and users of the output data B) Source of input data C) Information on the purpose of the workbook D) All of the above

---

No Details

Question 625

In MS-Excel how can you delete a record?

A) Delete the column from the worksheet B) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button C) Select Data > Delete Record from the menu D) None of these

---

No Details

Question 626

In MS-Excel comments can be added to cells using?

A) Edit > Comments B) Insert > Comments C) File > Comments D) None of these

---

No Details

Question 627

In MS-Excel which elements of worksheet can be protected from accidental modification?

A) Contents B) Objects C) Scenarios D) All of above

---

No Details

Question 628

In MS-Excel value used in a formula that does not change is called a?

A) Cell address B) Constant C) Function D) None of these

---

No Details

Question 629

What MS-Excel feature can you use if you want to work with one record at a time?

A) Auto Complete B) Auto Filter C) Data Form D) All of the above

---

No Details

Question 630

In MS-Excel 3-D reference in a formula?

A) Cannot be modified B) Only appears on summary worksheets C) Both a & b D) Spans worksheets

---

No Details