GB 310 lester Exam 2 Lester
For the remaining questions use the "FinalSales_data". How many rows are in this dataset excluding headers
1240
How many people are from Chicago in these data?
200
How many cities are in the workbook?
5
Which of the following excel formal calculated the average correctly in excel?
=Average(80,90,100)
Which person from Akron is the best salesperson (has the highest average sales across the month)?
Akron4
Which type of chart would you use if you wanted to get an idea about distribution of a single variable including outliers?
Box and Whisker Chart
Which of the following months had the highest average profit
February
What is the difference between sorting and filtering the data?
Filtering removes or hides data and sorting reorders the data
What is the primary reason for filtering your data?
Filtering the data makes it easier to see trends in the subset of interest
What is the significance of the total row?
It makes it easy to calculate various statistics for the columns
What type of chart is an effective way of displaying trends over time for different companies?
Line Charts
Which of the following is not a calculation preformed by excel?
Minimum()
Which person had the most sales in April?
NY634
Which city has the highest average sales in October?
New York
Which city has the most number of people in it?
New York
Are there any seasonal trends in terms of the sales data?
No, the mean always stays approximately equal to 111
How do you toggle between absolute and relatively referencing a cell?
Press F4
Scatter plots are in effective way to describe the relationship between two quantitative variables?
True
There are functions designed to format and modify text.
True
How can you tell that these data are formatted as a table?
when you click in the data range the Design Tab becomes Visible