Another Excel Command

Here is an Excel command for figuring out the average of a group of cells:

=AVERAGE(cellnum1:cellnum2)

Paste this into your Excel file somewhere, replacing cellnum1 with the first cell in your series and cellnum2 with your last number in the series.

Excel Commands

Here are some commands that can be used in Excel for estimating if either a coin is heads or tails.

Copy into cells A1-A100:

=IF(RAND()<0.5,"heads","tails")

Copy into cell B1:

=COUNTIF(A1:A100,"heads")

Copy into cell B2:

=COUNTIF(A1:A100,"tails")

Update

I was just given a self-assesment sheet and I realized that I haven't updated my blog in weeks! Well, this update is too late to make the sheet, but here it is anyway. This week I have been working on various Excel assignments, comprising of line graphs, scatter graphs, and other graphs.