Tip:
Highlight text to annotate it
X
http://youtu.be/geh-NngvKZc
Testing testing
In this exercise I'm going to show you how to do the excel in one drive exercise
in excel 2. The first thing is do is go two the learning
resources and open the data zip file Here I'm opening it in winzip you could also
open in windows explorer I'll grab the make it right spreadsheet and
drag it to my desk top and now I want to follow the directions on
pages 57 through 58 in the text so the first thing is you need to open one
drive if you don't have one drve yet you can follow
the directions in the one drive PDF file in the assignment.
If you do have it then you can open one drive. The directions to tell you to first create
a folder and I'll call this one in CIS 101 now I'm going to open that folder and insert
the spreadsheet into it. Double-click the spreadsheet and it will open
in excel online this is a version of excel with a number of
the main features of the real excel program Then follow the directions from step one is
which says merge and center the top two rows
So I click here and extend it out two column F
I do the same for the second row Format the titles with one of the cell styles
We don't have styles in excel online So I'm simply going to make this one a little
bigger - 14 and this one I'll make 12 And now make this one bold and this one and
I'll change the color of the letters to brown I'll also set the background to a light gray
So that has formatted the top two rows Then it says correct the spelling mistakes
The first one is in the top row click there and change it to exotic
This the second one is Cleveland which is misspelled
And then we get down to step five where it says and a column header for totals
So I click here and type totals Then I'm going to center all of these row
headers also make than bold and I will left justify all
these row headers and make them bold Then I adjust the column sizes by double-clicking
between them Now I need to apply the formula to create
the total field So I click here and I type in the formula
equals Sum of B4 through E4 And when I enter a should see a number there
Now I move cursor becomes a plus sign then I drag down like that and the sums show here
Now we format the columns to the right width Then it tells us that the sum function in
cell E8 does not cover all the numbers in the column
So if I look at cell B8 and look at the sum function it says E6 and I change that to E7
Now the next thing is resize and move the chart
we move it down here They say to use Alt keys to have it's snap
to the grid We cannot do that in excel online
So I will just pull it out until it's about right
There it looks pretty good Now I have to rename the bottom tab on the
spreadsheet so I right click on it and select
rename and call it a exotic pets annual cost of goods.
For the totals row - we will add a light gray color
Now I need to share it ans sure enough there is a sharebutton
Right-click share and and I'm going to share it with me henryd@OTC.EDU
Click share Sure enough it shares OK
If I check my OTC email Sure enough there is a share message for the
document So I'll see that when you have done your assignment
right