Microsoft Office Tutorials and References
In Depth Information
Review Questions
REVIEW QUESTIONS
You will find the data on the Review sheet in the Excel file Chapter 10:
1. The data on the sheet Review of Excel
le Chapter 10 has 20,000 values in A1:
D5000. Name the data in A1:D5000 with a meaningful name like Numbers.
2. Use the Excel statistical functions
menu to calculate the following: the average,
the highest and lowest values, the standard deviation, the mode, and the median.
3. Use Excel shortcuts to calculate the sum and the average of the data.
ANSWERS
1. Select the range A1:D5000. Type the word
Numbers
in the Name Box and
click Enter. See
gure below.
2. Average 1,300.18, highest 1,799, lowest 800, standard deviation 287.61, mode
1,559, and median 1,299.
3. Sum: 26,002,751, Average: 1,300.110.
 
Search JabSto ::




Custom Search