Linggo, Enero 18, 2015

Computer Science 1: ExCELLS

          Our next lesson was about cell reference.We were taught some tips and techniques like how to use AutoFill, Paste Special and Ctrl +`. There are also three types of reference type. The first one is Relative which adjusts and changes when copied or when using AutoFill. In Absolute, dollar signs ($) are used to hold a row and/or column reference constant. The last one is mixed which is a combination of the relative and absolute type. After the discussion, we were challenged to make a multiplication table in Excel using the reference types as shortcut. It was quite difficult. Well, Sir Tom have never given us easy challenges!

Walang komento:

Mag-post ng isang Komento