Within minutes, through the use of the AVERAGE function you can average grades accurately and efficiently.
MICROSOFT WINDOWS SERVER 2012 R2 STANDARD LICENSE HOW TO
After the video showed how to manually average cells and the susceptibility to human error, it then showed how to correctly enter the function in one time and then apply the function to the entire spreadsheet. Formulas are basic math arithmetic, including: addition, subtraction, multiplication, division and exponents, whereas functions are pre-made formulas, such as: AVERAGE, SUM, MAX, MIN,etc. I found that in under 5 minutes I could see how easy it can be to calculate any math problem in a spreadsheet. The first section I learned about was titled Understanding Formulas and Functions.
For more information on setting up a spreadsheet, you can refer to Sylvia’s post on Excel 2013: Essential Training. By understanding this information it can assist you in organizing data in a whole new way, which is both simple and quick. Do you ever feel like the only time you use Microsoft Excel is when you are required to enter assessment data each quarter or at the beginning of the school year to compile student contact information? Do you dread having to enter information into each cell and then cross your fingers the cells save correctly as you entered it in? Do you spend an abundant amount of time averaging grades using a calculator and entering the average into a class roster list? If any of these circumstances apply to you, Microsoft Excel has a solution to help you save time and organize your data/information very neatly in an Excel spreadsheet.īy viewing, Excel 2010: Essential Training Chapter 3 Excel Formula Basics on you can learn how to create formulas and functions, enter data into a worksheet, and understand how to add numbers manually.
0 kommentar(er)
