This exercise provides practice with importing external data; COUNTA, COUNTIF, AVERAGE, MAX, MEDIAN, MIN, and SUM functions; Pivot Tables and Pivot Charts; cell and worksheet formatting; inserting worksheets; and using data range names to summarize and analyze collected statistics.
Attached are two (2) files: Instructions and a text file to import. Please right-click each link, download or save to a location where you can easily find them, and then open the Instructions file for step-by-step instructions to begin your work. No need to open the text file!
Disclaimer: Instructions for each exercise are written in MS Office 2016 on a PC. All videos demonstrate completing exercises using Windows 10 and MS Office 2016. If you are using a Mac computer, a Mac version of MS Office, an older PC operating system, or a different version of MS Office, you may notice differences. Remember, Google can be your best friend when it comes to technology questions!
We use cookies and other tracking technologies to improve your browsing experience on our website, to analyze our website traffic and to understand where our visitors originate.
By browsing our website, you consent to our use of cookies and other tracking technologies. For more about the information SIUE collects, visit our Web Privacy Notice.
