Computer Science 1A Introduction to Computer Science Topic 4 Excel A n n o u n c e m e n t s Assignment Quiz 2 Spreadsheets in Excel next class on H W Excel 2 of 25 Topic 4 Excel Excel is a electronic spreadsheet It is good for W e h x a c t e l i s Calculations Organizing Data Can use as a small database Tables Topic 4 Excel 3 of 25 1 O p e n i n g Go to File Open Click on the file you want to open F i l e a 4 of 25 Topic 4 Excel A c t i v a t i n g Left clicking on a cell will activate a cell When C e l l a C o l u R m o n w s s a cell is active you can Enter data Enter a formula function Format the Cell NOTE You must hit enter or activate another cell to deactivate your cell 5 of 25 Topic 4 Excel Excel references cells by column letters and row numbers Columns a nRows d Topic 4 Excel 6 of 25 2 W A workbook is the entire file The workbook is the name of the file o W A worksheet is one sheet in a file r o Worksheets are named on tabs at the bottom of the k workbook r s There can be many worksheets in one workbook k h This allows us to organize our work we can put b related worksheets in one workbook e o To access a worksheet click on the tab e o t k s s 7 of 25 Topic 4 Excel W o r k s h e e t s To rename a worksheet right click the tab and click on rename or double left click the tab Worksheets allow us to organize our work To create a new worksheet Related sheets can be places in 1 workbook Right click a tab and click on insert select worksheet By default 3 worksheets are created with each new work book To delete a sheet Right click the tab and click delete Default sheets Topic 4 Excel S c r o l l 8 of 25 Scroll bars can be used to navigate around your spreadsheet B a r s Topic 4 Excel 9 of 25 3 You can navigate by using the arrow keys Clicking on another cell Use scroll bars Or using some ctrl combinations N a v i g a t i n g i n E x c e l Home Takes you to A1 End Goes to last row col cell Down Last cell in col with data Up goes to first col with data Right arrow goes to last right hand cell with data Left arrow goes to last left hand cell with data 10 of 25 Topic 4 Excel The T h e Formula bar the line with the fx Where information for that cell will be entered Can be F B o a r r m u l a Data Formulas Functions Formula Bar 11 of 25 Topic 4 Excel Can E n t e r i n g Can type it in at the formula bar activate the cell and type Activate a cell by left clicking it D a t a Active Cell Topic 4 Excel 12 of 25 4 F o r m a t t i n g i n You can change fonts alignments colors Change Background color Select one cell or a group of cells To select a group click one cell hold down the mouse button and drag across the ones you want to select Or you can hold down the ctrl button and click on each cell you want to select E x Click on the Paint bucket c Select a fill color e l 13 of 25 Topic 4 Excel M o r e F o r m a t t i n g Changing Cell colors Select the A button and choose a color Bolding Centering Select the B button Choose the center alignment button 14 of 25 Topic 4 Excel A u t o f o r m a t t i n g Add Autoformat to the Quick Access Toolbar Click the arrow to the right of the Quick Access Toolbar Select More Commands Click this Arrow More Commands Topic 4 Excel 15 of 25 5 A u t o f o r m a t t i n g Go to Commands not in the ribbon Commands not in the ribbon 16 of 25 Topic 4 Excel Select Then Autoformat Click the add Button Add Autoformat 17 of 25 Topic 4 Excel Select the information to be formatted Click the auto format icon formatted the2 information to be Select 3 Select the style you want 1 Select info to be formatted Topic 4 Excel 18 of 25 6 E n t e r i n g Must start with a Refer to cells by Column Letter then F Row o r m u l a a Topic 4 Excel P r e d e f i n e d f u n c t i o n s Click on fx for a list of predefined functions Can also define your own functions that is for another class Description of the function Topic 4 Excel E x p r e d e f i n e d f u n c t i o n 19 of 25 20 of 25 Syntax how we write it so excel understands SUM number1 number2 number3 SUM ADDS the value in the cells SUM D1 D2 D3 D4 Or we can select a group of cells SUM D1 D4 Topic 4 Excel 21 of 25 7 C o n d i t i o n a l S t a t e m e n t s Sometime we want a cell to do one thing under one condition or another under another condition IF some condition is true THEN Do something ELSE Do something else Relational Operators ways to compare values Equal to Greater than Less than Greater than or equal to Less than or equal to Not equal to 23 of 25 Topic 4 Excel C o n d i t i o n a l F l o w c h a r t In our example False If Gup 5 True Display Upper Belt Display Lower Belt 24 of 25 Topic 4 Excel A n o t h e r E x a m p l e False Pay Hours payrate Topic 4 Excel If hours 40 True Pay 40 payrate Hours 40 1 5 payrate 25 of 25 8 w e c a n u s e c o n d i t i o n a l s Syntax format of our function IF condition true action false action then E x c e l else In our example let s say we want to differentiate between Lower Gups Gups 1 through 5 and Upper Gups Gups 6 10 if statement …