Computer - Mock Test 66

Question 651

In MS-Excel which of the following is an absolute cell reference?

A) !A!1 B) $A$1 C) #a#1 D) None of these

---

No Details

Question 652

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 653

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 654

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 655

In MS-Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

A) Category axis B) Data marker C) Both a & b D) Gridline

---

No Details

Question 656

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 657

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

Question 658

In MS-Excel you can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu?

A) Edit B) Insert C) Tools D) None of these

---

No Details

Question 659

In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu?

A) Edit B) Format C) Tools D) All of the above

---

No Details

Question 660

In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013?

A) Workday B) Date C) Networkday D) Weekday

---

No Details