Computer - Mock Test 64

Question 631

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 632

MS-Excel uses the . . . . Function when creating a data table ?

A) Average B) Count C) Both a & b D) Table

---

No Details

Question 633

MS-Excel uses the . . . . Function when creating a data table?

A) Average B) Count C) Both a & b D) Table

---

No Details

Question 634

In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore?

A) You can automatically apply formatting to a data series B) You can change the position of a data marker and that automatically changes the data point value in the worksheet C) You can change a data point value and automatically that is drawn in the chart D) Both b & c

---

No Details

Question 635

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

Question 636

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 637

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 638

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 1⃣ & 2⃣ D) Double click the marker or label

---

No Details

Question 639

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 640

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

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

---

No Details