BUSI 1520U Lecture 1: September 17th 2015 lecture
Document Summary
Business computer applications lecture september 17th 2015. Absolute cell referencing: adding $" between values keeps it locked no matter what direction you move it (ex. Mixed cell referencing: use to lock one side not both. *use f4 to flip between absolute cell referencing and mixed cell referencing* Double click bottom corner to fill handle the whole area. $ before and between letter and number locks row and column. To change the name of a cell: formulas > define name. Never have a space between the new name. To separate words, place a _" to separate words. Don"t name a cell after a column or row i. e. , a or 5 . To name multiple cells at a time, select all cells wanted to change > create from selection. Formulas > insert function > search for a function to search for the function you need.
