This video is entirely about Mixed Cell Referencing in Excel. We are using the Multiplication Table to Workout this example but literally its should give you a picture of when to Lock a reference or when to make an absolute Column and Relative Row as well an absolute Row and Relative Column and that entire formula will now have mixed references in it.