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

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

IgA antibodies protect body surfaces exposed to outside foreign substances. IgG antibodies are found in all body fluids. IgM antibodies are the first type of antibody made in response to an infection. IgE antibody levels are often high in people with allergies. IgD antibodies are found in tissues lining the abdomen and chest.

For a complete list of videos, visit our video library