This topic contains a solution. Click here to go to the answer

Author Question: Match the following five terms to their meanings:I.SUMIF functionII.COUNTIF functionIII.logical ... (Read 143 times)

berenicecastro

  • Hero Member
  • *****
  • Posts: 581

Question 1

Match the following four terms to their meanings:
I.Scenario Manager
II.scenario
III.integer
IV.interval
A.The number of cells to include in the average.
B.A whole number.
C.A set of values that Excel saves and can substitute automatically in your worksheet.
D.A what-if analysis tool to compare alternatives.


Question 2

Match the following five terms to their meanings:
I.SUMIF function
II.COUNTIF function
III.logical function
IV.SUMIFS function
V.syntax
A.A logical function that counts the cells that meet specific criteria in a specified range.
B.A logical function that will add values in multiple ranges that meet multiple criteria.
C.A logical function that will add values in one specified range that meet a certain specific
criteria.
D.A function that tests for specific conditions.
E.The arrangement of the arguments in a function.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by berenicecastro on Mar 18, 2019

komodo7

  • Sr. Member
  • ****
  • Posts: 322
Lorsum iprem. Lorsus sur ipci. Lorsem sur iprem. Lorsum sur ipdi, lorsem sur ipci. Lorsum sur iprium, valum sur ipci et, vala sur ipci. Lorsem sur ipci, lorsa sur iprem. Valus sur ipdi. Lorsus sur iprium nunc, valem sur iprium. Valem sur ipdi. Lorsa sur iprium. Lorsum sur iprium. Valem sur ipdi. Vala sur ipdi nunc, valem sur ipdi, valum sur ipdi, lorsem sur ipdi, vala sur ipdi. Valem sur iprem nunc, lorsa sur iprium. Valum sur ipdi et, lorsus sur ipci. Valem sur iprem. Valem sur ipci. Lorsa sur iprium. Lorsem sur ipci, valus sur iprem. Lorsem sur iprem nunc, valus sur iprium.
Answer Preview
Only 64% of students answer this correctly




komodo7

  • Sr. Member
  • ****
  • Posts: 322

 

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

For a complete list of videos, visit our video library