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

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

For a complete list of videos, visit our video library