Which of the following is not an appropriate use of the SUM function?
Give this one a try later!
=SUM(D15-C15)
What function would you use to identify a value's rank as a percent, excluding 0 and 1?
Give this one a try later!
PERCENTRANK.EXC
Which of the following is not an alignment option?
, Give this one a try later!
Fill color
You want to create a single chart that shows each of five divisions' proportion of
yearly sales for each year for five years. Which type of chart can accommodate your
needs?
Give this one a try later!
100% stacked column chart
Which tab contains commands to apply a predefined chart layout that controls which
elements are included, where, and their color scheme?
Give this one a try later!
Design
What function would you use to calculate the strength of a relationship between two
or more variables?
Give this one a try later!
Correl
Give this one a try later!
=SUM(D15-C15)
What function would you use to identify a value's rank as a percent, excluding 0 and 1?
Give this one a try later!
PERCENTRANK.EXC
Which of the following is not an alignment option?
, Give this one a try later!
Fill color
You want to create a single chart that shows each of five divisions' proportion of
yearly sales for each year for five years. Which type of chart can accommodate your
needs?
Give this one a try later!
100% stacked column chart
Which tab contains commands to apply a predefined chart layout that controls which
elements are included, where, and their color scheme?
Give this one a try later!
Design
What function would you use to calculate the strength of a relationship between two
or more variables?
Give this one a try later!
Correl
