Let's start by calculating the average grade using a simple formula: =AVERAGE(B7:D7).Įnter a heading (optional) and then highlight a cell in the appropriate column.ĭouble-click your chosen cell to display the Formula Editor and then hold the Command key on your keyboard whilst highlighting the data you wish to calculate. Now, it is time to calculate the average grade of each student, as well as their grade total. Continue until all data has been entered.
Insert the data into your spreadsheet by selecting a cell of your choice and entering a value. I am then going to calculate each student's average grade during this period of time, along with their grade total. You are now ready to insert data into your spreadsheet and format it accordingly.įor this tutorial, I am going to enter example data into my spreadsheet displaying the grades of several students over a three-year period. For the purpose of this tutorial, I have chosen Blank. Select a template from the list and then click Choose. Step 1: Launch NumbersĬlick the Numbers icon in the Dock.
Let's kickstart this tutorial by launching Numbers and creating a new spreadsheet. Numbers '13 is currently available to purchase for £13.99 in the App Store, and comes free of charge with every Mac purchased after 1st October 2013.
With Numbers, you can create powerful spreadsheets using a variety of templates which can be wirelessly transferred between iDevices via iCloud or exported to a different format and shared with your colleagues. Numbers is an Apple-developed spreadsheet application that is packaged as part of iWork. In this tutorial, I will show you how to create a basic spreadsheet using Numbers and format it to your specification. Additionally, Apple is now giving away its productivity suite for free with every qualifying Mac, in addition to a free upgrade for all existing users, making iWork accessible to all. Numbers, along with the rest of iWork, has recently undergone a complete overhaul that boasts a brand new design, iCloud synchronisation and much more.
0 kommentar(er)
