Foundation year Practical Lec 4 Spreadsheet Software Using

Foundation year Practical Lec. 4: Spreadsheet Software Using Microsoft Excel 2106 Computer For Health Sciences COMP 101 Lecturer: Dalia Mirghani

Exploring the Excel Environment http: //www. gcflearnfree. org/excel 2016/getting-started-with 2 excel/1/

Page Views To Change Page Views: • Locate the Page View options in the bottom, right corner. The Page View options are Normal, Page Layout, and Page Break. • Left-click an option to select it. 3

Excel Rows and Columns • Spreadsheets are displayed in a grid layout. The letters across the top are Column headings. To highlight an entire Column, click on any of the letters. The image below shows the B Column highlighted: you can click a number to highlight an entire Row. If you look at the image beside, you'll see that Row 5 has been highlighted. 4

Active cells and the address Left-click a cell to select it. Each rectangle in the worksheet is called a cell. As you select a cell, the cell address appears in the Name Box. Enter text into the cell using your keyboard. The text appears in the cell and in the formula bar. 5

Active cells and the address… Each cell has a name, or a cell address based on the column and row it is in. For example, this cell is C 3 since it is where column C and row 3 intersect. • You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A 1, A 2, A 3, A 4 and A 5 would be written as. A 1: A 5. 6

To Move Through a Worksheet Using the Keyboard • Press the Tab key to move to the right of the selected cell. • Press the Shift key and then the Tab key to move to the left of the selected cell. • Use the Page Up and Page Down keys to navigate the worksheet. • Use the arrow keys. 7

Hide or Unhide Rows or Columns • Select the row or column you wish to hide or unhide • Click the Format button on the Cells group of the Home tab • Click Hide & Unhide • Or right click the selected column or row to find Hide & Unhide commands. 8

Modifying Columns, Rows, and Cells • To Modify Column Width: • Position the cursor over the column line in the column heading and a double arrow will appear. • Left-click the mouse and drag the cursor to the right to increase the column width or to the left to decrease the column width. • Release the mouse button. • OR 9

• Click the Format command in the Cells group on the Home tab. A menu will appear. • Select Column Width to enter a specific column measurement. • Select Auto. Fit Column Width to adjust the column so all the text will fit. 10

To Insert Rows • Select the row below where you want the new row to appear. • Click the Insert command in the Cells group on the Home tab. The row will appear. 11

To Insert Columns • Select the column to the right of where you want the column to appear. • Click the Insert command in the Cells group on the Home tab. The column will appear. • To Delete Rows and Columns: • Select the row or column you’d like to delete. 12 • Click the Delete command in the Cells group on the Home tab.

Formatting Cells http: //www. gcflearnfree. org/excel 2016/formattingcells/1/ 1. 2. 3. 4. 5. 6. 7. How to change the font size? How to change the font color? How to add Cell borders and fill colors? How add Cell styles? How to change text alignment? How to change horizontal & vertical text alignment? 13

How to Merge Cells To merge cells, do the following. • Type the words Shopping Bill into cell A 1 of a spreadsheet • Highlight the cells A 1, B 1 and C 1 • On the Alignment panel of the Excel Ribbon, locate the "Merge and Center" item: Click on "Merge and Center". Your three cells will then become one - A 1, to be exact! 14

Working with multiple sheets http: //www. gcflearnfree. org/excel 2016/working -with-multiple-worksheets/1/ 1. 2. 3. 4. 5. 6. How to copy a worksheet? How to rename a worksheet? How to change the worksheet tab color? How to delete a worksheet? How to Grouping and ungrouping worksheets? 15

Currency Symbols in Excel…. • Enter some prices on a spreadsheet (any will do), and highlight the cells • With the cells highlighted, locate the Number panel in the Home tab Click the drop down list that says General. You'll then be presented with a list of options: Click More. . the Currency item to add a pound sign or you'll see the default currency for your country. 16

To Sort in Alphabetical Order Select a cell in the column you want to sort (In this example, we choose a cell in column A). • Click the Sort & Filter command in the Editing group on the Home tab. • Select Sort A to Z. Now the information in the Category column is organized in alphabetical order. 17

To Filter Data Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading. Uncheck Select All. • Choose Flavor. • Click OK. All other data will be filtered, or hidden, and only the Flavor 18 data is visible.

Entering a Formula • A formula is an expression that returns a value • A formula is written using operators that combine different values, returning a single value that is then displayed in the cell – The most commonly used operators are arithmetic operators • The order of precedence is a set of predefined rules used to determine the sequence in which operators are applied in a calculation 19

Entering a Formula • Click the cell in which you want the formula results to appear • Type = and an expression that calculates a value using cell references and arithmetic operators • Press the Enter key or press the Tab key to complete the formula 20

Entering a Formula 21

Entering a Formula 22

• Example 1 • Using this order, let us see how the formula 20/(8 -4)*8 -2 is calculated in the following breakdown: 23

Entering a Formula 24

How to save your work in Excel • click the round Office button in the very top left of Excel 2007. This one: • When you click the Office button, you'll see the options list appear: 25

How to save your work in Excel…. • And here's the Save As dialogue box: 26

Protect your file 1 - Choose Save. 2 -Specify the name of the file. 3 -Choose Tools button then 4 -General Options 5 - Specify the passwords 6 - Click save At the end when you open the file will ask you enter the password to open it. 27

Wish you all the best 28