PLS 21 Lecture 3: PLS 21 Lab #3-Excel
limepig485 and 2 others unlocked
8
PLS 21 Full Course Notes
Verified Note
8 documents
Document Summary
Top left is a1 and bottom right is d6. Top left and command a highlights all of the cells in the doc. Can type directly into the cell or the top bar. Highlight all cells and click sigma icon. Make sure to add () when needed. When we move down a row, excel will move the formula down the row too. Locks a cell using 9740 (make sure to put it in front of both column and row) Means the number is too large to show. To fix- put cursor in between the 2 columns and double click. Right click format cell---> alignment---> merge cells. When you merge two cells, the second cell disappears. Place border around cells in formatting cells. Will show the text by making the cell larger. Highlight whole row, by placing cursor and wait for the black arrow to show up. Highlight the row that"s one below the rows you want to freeze.