1.How can you tell the difference between a bar chart and a histogram?

A bar chart has spaces between bars, while the histogram does not

Histogram has spaces between bars, while the bar graph does not

The bar graph is always displayed horizontally

A and C

The SUM function is used to do the following:

Add the total of textual data

Count the total of numeric data

Add the total of numeric data

Count the total of textual data

2.What option can be used to remove erroneous values (i.e. values that shouldn't be in your dataset)?

Sort

Find & Remove

Find & Select

None of the Above

3.COUNTIF(A9:A13,"10") will do what?

Willpopulate all the cells with a 10 in it

Will count only cells from A9 through A13 containing a10

Will count only cells A9 through A14 containing a 10

None of the above

4.The followingchart elements can be formatted:

Chart Title

Data Labels

Legend

All of the above