Author Question: Match the following functions to their definition. I. AVERAGE II. COUNT III. MODE.SNGL IV. ... (Read 129 times)

123654777

  • Hero Member
  • *****
  • Posts: 585
Match the following functions to their definition.
 
  I. AVERAGE
  II. COUNT
  III. MODE.SNGL
  IV. MEDIAN
  V. COUNTA
 
  A. Returns the mean of a set of numbers
  B. Returns the number in the middle of a set of numbers
  C. Counts the number of cells in a range that are not empty
  D. Counts the number of cells in a range that contain numbers
  E. Returns the value the occurs most often in a range

Question 2

________ is a tool in Access that can help you format your calculated fields correctly.
 
  A) Field properties sheet
  B) Navigation Pane
  C) Expression Builder
  D) Navigation bar


princessflame2016

  • Sr. Member
  • ****
  • Posts: 298
Answer to Question 1

A, D, E, B, C

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

123654777

  • Hero Member
  • *****
  • Posts: 585
Both answers were spot on, thank you once again




 

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Your heart beats over 36 million times a year.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

For a complete list of videos, visit our video library