Author Question: Match the following functions to their definition. I. AVERAGE II. COUNT III. MODE.SNGL IV. ... (Read 126 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?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

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?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

For a complete list of videos, visit our video library