Computer - Mock Test 62

Question 611

In MS-Excel default header for a worksheet is?

A) Your name B) The date and time C) date D) None of these

---

No Details

Question 612

In Excel 3-D reference in a formula?

A) Cannot be modified B) Only appears on summary of Worksheet C) Limits the formatting options D) spans worksheet

---

No Details

Question 613

In MS-Excel you can insert labels for?

A) All the data markers on a chart B) A data series C) A selected data marker D) All of the above

---

No Details

Question 614

In MS-Excel what does SUMIF function do?

A) Adds up cell values based on a condition B) Adds all the numbers in a range of cells C) Returns a subtotal in a list or database D) Both a & b

---

No Details

Question 615

In MS-Excel to select an individual data marker or data label, you must?

A) Double click the data series B) Right click selected marker C) Both a & b D) Double click the marker or label

---

No Details

Question 616

In MS-Excel the view that puts a blue a blue line around each page that would be printed is the?

A) Print Preview B) Normal View C) Page Break Preview D) None of these

---

No Details

Question 617

In MS-Excel the view that puts a blue a blue line around each page that would be printed is the?

A) Print Preview B) Normal View C) Page Break Preview D) None of these

---

No Details

Question 618

In MS-Excel Graphics objects on a chart are used to?

A) Add emphasis to chart data B) Add interest to a chart C) Help explain the chart data D) All the above

---

No Details

Question 619

In MS-Excel constant is another name for this type of data?

A) number B) equation C) formula D) None of these

---

No Details

Question 620

In MS-Excel which is used to perform what if analysis?

A) Solver B) Goal seek C) Scenario Manager D) All of above

---

No Details