A Quick and Easy Way to Make a K-Drama Completion Status Table

Excel Mini-Tutorial

1. Enter list of drama titles into column A.
2. Enter list of number of episodes watched per drama into column B.
3. Enter list of number of total episodes per drama into column C.
4. To perform calculations with columns B and C, enter “=B1/C1” into the cell F1 or the function bar). The calculation for B1/C1 should appear in cell F1. Hover your mouse over the bottom right corner of cell F1 until the mouse icon turns into a cross. Drag the cross icon till you reach the bottom of the column. This should apply the function to all the entries in the column. 

2011 K-Drama Completion Status Table

2011 K-Drama Completion Status Table