محاضرات حاسوب مرحله 3.pdf

Ministry of Higher Education and Scientific Research Al Salam University College The third stage Lectures in Excel "You must be strong for your future" ...

Ministry of Higher Education and Scientific Research Al Salam University College The third stage Lectures in Excel "You must be strong for your future"  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Excel Excel: It is an electronic spreadsheet program that allows storing a large number of data in tables, performing calculations and statistical analyses, and creating graphs for them. To run the program, follow these steps: - 1- From the Start, choose all programs located at the bottom left of the screen 2- Click on Microsoft Office, and from the submenu, click on Microsoft Office Excel 3- An empty workbook is automatically created containing three separate worksheets, as shown in the figure:- The basic elements that make up the Excel 2007 window First - the title bar: which contains the title of the open workbook. When we open a new workbook, Excel gives it the name New Microsoft Word Document, and when we store the workbook with a new name, this new name appears on the title bar, and this bar contains the icons for closing, minimizing, maximizing, and hiding the window. It contains the quick access toolbar, which includes the commands that are frequently used during work Second - The Ribbon that appears at the top of the workbook, which is used for menus and toolbars. This ribbon contains three parts, as in the figure.  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 1 2 3 1- Tab: - It is at the top of the bar, and when you click on it, you can access its commands 2- Orders: which are arranged in separate groups 3- Groups: They are a group of related commands used to carry out a specific task. There is a small arrow in the lower right corner of the group, which when clicked shows additional options for the group. Third: The mathematical formula bar: which shows the contents of the active cell, whether it is a mathematical formula or any other data  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Fourth: The two navigation bars: They are used when the dimensions of the workbook are larger than the dimensions of the screen Fifth: - Status bar: - It appears at the bottom of the window and shows the views of the workbook, in addition to brief information about the workbook’s current status. Worksheet The new Microsoft word document workbook is a file in the Excel program that contains worksheets. The worksheet consists of a group of: - 1- Rows: They are the group of cells that are arranged horizontally in the table and are indicated by numbers 2- Columns: - They are the group of cells that are arranged vertically in the table and are indicated by letters  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 3- The cell: It is the intersection of the row and the column and has an address called the cell reference. It consists of a letter and a number. The letter identifies the column and the number identifies the row. Create a new workbook When we run Excel, it opens a new workbook directly. When we open another refinery, we must do the following:- 1- We click the Office or File button, then the New button, and the New Workbook dialog box appears, as shown in the figure 2- From the Templates category, we choose a Blank and Recent template, and from the right side, we choose a Blank workbook. Insert a new worksheet The Excel workbook consists of three worksheets by default that appear as tabs at the bottom of the workbook. To insert more worksheets into the workbook, we click the Insert Worksheet tab at the bottom of the workbook, as in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Delete the worksheet To delete a worksheet from an Excel workbook, we select the sheet to be deleted, then go to the Home tab, and from there to the group of cells, click the arrow below Delete, then click Delete Sheet, as in the figure: - A confirmation window will appear and you must click OK to confirm the deletion Save the workbook After completing all the work on the worksheet, the saving process takes place as follows: 1- Click the Office or File button, then click the Save button, and the Save As dialog window will appear as in the figure: - 2- The Default My Documents folder appears in the top bar. If we want to change the saving location, this can be done through this bar, and here the following tasks must be performed: In the drop-down arrow of the save bar, we select the disk we want to save to, double-click on it, and it is entered. Then we enter the name we want for the file in the file name bar, then click Save, and the file name appears on the title bar.  Ministry of Higher Education and Scientific Research Al Salam University College The third stage After the file is saved and any changes are made to it, these changes are saved by clicking the Save button located in the quick launch toolbar. Note: Excel workbooks have the extension xlsx Close the workbook To close the current workbook without exiting the program, we click Close from the Office or File button, and the current window is closed, or we click Close from the title bar in the upper right corner of the window, and then the following window appears: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage In this window when 1. We click Save, which means closing the workbook and saving the modifications 2. Click Do not save. This means closing the workbook without saving the modifications 3. We click Ignore. This means undoing the closing and continuing to work in the workbook To open a pre-stocked workbook, we do the following: From the Office or File menu, click Open, and the Open window will appear as in the figure In this window, we locate the desired workbook in the top bar, click on the name of the workbook that we want to open, and it appears in the file name bar, then click Open, and the workbook opens. Enter data into the workbook To enter data into a worksheet in a workbook, we place the cursor in the cell to which we want to enter data by clicking in that cell or using the arrows on the keyboard. A box appears around the cell indicating that this is the active cell. We enter data or mathematical formulas into it and then press Enter.  Ministry of Higher Education and Scientific Research Al Salam University College The third stage The data entered can be modified in several ways 1. We place the cursor in the cell whose data you want to modify, and the entered value appears on the mathematical formula bar, and a flashing vertical cursor appears on it, where the new value can be entered. When you press Enter, the modifications are applied to the cell. 2. We double-click in the cell whose data we want to modify, and a flashing vertical cursor appears so that we can make the modification we want. 3. We click on the cell whose data you want to modify, then we enter the new data directly Select cells When we want to perform any command on a cell or a group of cells, these cells must be selected first, and the selection is done in several ways, including: - 1. To select a single cell, we click on the cell or move to it using the arrow keys, as in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 2. To select a range of cells, we place the mouse cursor in the cell from which we want to start selecting, then press the left button and move in the direction we want while continuing to press until the desired area is selected, as in the figure: - 3. To select all cells of the worksheet, we click the Select All button by pressing Ctrl + A as in the figure: - 4. To select a specific row, we place the cursor on the row number, and the cursor turns into a small black arrow, so we click on the number as in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 5. To select a group of spaced rows, we select the first row, then press Ctrl and while continuing to press, we click the number of the second and third rows, and so on, as in the figure: - 6. To select a specific column, we place the cursor on the letter of the column, and the cursor turns into a small black arrow, so we move on the letter as in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 7. To select a group of spaced columns, we select the first column, then press the Ctrl key and while continuing to press it, we click the letter of the second and third columns, and so on, as in the figure: - Insert a row To insert one or more rows at a certain point in the worksheet, we place the cursor at the beginning of the row in which we want to add a new row. From the Home tab and from a group of cells, we click on the arrow next to Insert, then we click on Insert Table Rows, as in the figure: - A new row is inserted to the top of the selected row  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Insert column To insert one or more columns at a certain point in the worksheet, we place the cursor at the beginning of the column before which we want to add a new column. From the Home tab and from a group of cells, we click on the arrow next to Insert table columns, as in the figure: - Delete rows or columns Entire rows or columns can be deleted and removed as follows: We click on the title of the column or row that we want to delete, and from the Home tab and from a group of cells, we click on the arrow below Delete, as in the figure: - Freeze row titles When the data is wider than the width of the page shown on the screen, the row headings can freeze when we browse the far columns The method is as follows: - 1. We move the cursor to the right of the column whose title we want to fix 2. From the View tab, we go to the Windows group, click Freeze Parts, then click Freeze the First Column. A vertical line appears showing that the columns to the left of this line have been frozen. Using the horizontal scroll bar, the columns can be moved to the left, except for the frozen area. To cancel this freeze, we go to the View tab, and from there to the Windows group, we click Unfreeze Panels, and the vertical line disappears, indicating that the freeze has been cancelled.  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Freeze column titles When the data is wider than the length of the page shown on the screen, the column headings can freeze when we browse the distant rows The method is as follows: - 1. We move the cursor to the bottom of the cells of the address we want to fix 2. From the View tab, we go to the Windows group, click Freeze Panels, then click Freeze Top Row. A horizontal line appears showing that the rows located above this line have been frozen. Using the vertical scroll bar, the rows can be moved to the top, except for the frozen area. To cancel this freeze, we go to the View tab, and from there to the Windows group, we click Unfreeze Panels, and the horizontal line disappears, indicating that the freeze has been cancelled. Maximum value function and minimum value function To find the maximum value of a group of adjacent cell values, we click on one of the cells at the bottom of the column that contains the numbers or one of the cells located to the left of the row that contains the numbers. Then we go to the Formula tab and click on the arrow next to AutoSum and from the drop-down list we choose the maximum value and then press Enter to get The maximum value and the same method if the minimum value is found in the specified cell as in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Text formatting The text on the worksheet can be formatted in terms of font color and style, as follows: 1. The cells to be formatted must be selected, even if they are empty of data 2. We go to the Home Page tab, and from there to the Font group, and click on the arrow in the lower right corner of the group. A list of available font types appears, where we can choose the font we want, as Excel provides a large group of fonts in both Arabic and English, as shown in the figure: -  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 3. The font size can be controlled by highlighting the text, clicking on the text size box and clicking on the arrow. A list of text sizes will appear from which the desired size can be chosen. 4. The size in the icon can be highlighted and the desired size can be written directly in it 5. The font enlargement icon and the font reduction icon can be used within the font group 6. The rest of the icons in the font group can be used, such as the font icon through which you can specify the desired font type 7. The font color icon can be used to change the font color, and the sheet background color icon can be used to change the background color of the selected cell or cells 8. You can use a group of icons where B is an abbreviation for the word bold, which means wide, an abbreviation for the word Italic which means italic, and an abbreviation for the word underline which means to put a line from the bottom.  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 9. The icon can be used to place a variety of frames around the selected cells, where a drop-down list appears from which the desired frame can be selected. To remove borders from cells, click the arrow next to the border icon, and from the drop-down list, choose No borders Function library By going to the Formulas tab, we find it divided into four groups: The first group is the function library, where we notice to its left the Insert Function icon which when clicked opens the Insert Functions window as in the figure: From this window, you can choose the category of functions that you want to use, as in this example, the logical functions were chosen (and, or, not true, false). This tab also contains the following groups of functions: - 1. Auto sum group: - which contains the functions (sum, max, min) 2. Recently used group: which contains the functions that were recently used 3. Financial group: - which contains financial functions 4. Logical group: - which contains logical functions 5. Text group: - which contains functions for texts  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 6. The Date & Time group, which contains the functions for date and time 7. Lookup & Reference group: - which contains functions related to the location and reference of the cell 8. Math & Trig group: - which contains functions for mathematics and triangles 9. More Function group: which consists of four subgroups: - - Statistical: which represents statistical functions - Engineering: - which represents geometric functions - Cube: - which represents cubic functions - Information: - which represents informational functions Insert an image You can add an image from a file by going to the Insert tab, from there to the Illustrations group, and there we click on an image as in the figure: - The Insert Image window appears; through which we can insert an image from any storage location on the computer  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Adjust the image Some adjustments can be made to the image after inserting it into the worksheet by going to the Image Tools tab, then to Format, and then to the Adjust group. In the Adjust group, we notice the following instructions:- 1. Brightness: - where the appropriate surfaces for the image can be determined 2. Contrast: - The appropriate contrast for the image can be determined 3. Recolor: - The image can be recolored in all forms 4. Compress Picture: - The image size can be compressed 5. Reset picture:- Where the image can be changed to another image from the storage media on the computer  Ministry of Higher Education and Scientific Research Al Salam University College The third stage Insert shapes Different shapes can be inserted from the group of illustrations. From the group of shapes, we click on the arrow in it, and from the drop-down list, we choose the desired shape. Page setup By clicking on the Page Layout tab and going to Page Settings, we notice a set of options related to page settings, as in the figure: - Available options:- 1. Margins:- Change page margins 2. Orientation: - Make the page in the vertical or horizontal direction 3. Size: - Determine the size of the paper 4. Print area: Select a cell, group of cells, or a specific area of the sheet to print 5. Separators: Through which specific breaks can be placed on the page or removed  Ministry of Higher Education and Scientific Research Al Salam University College The third stage 6. Background: You can change the shape of the page’s layout and place a specific picture or diagram on the background of the page 7. Print titles: - Through this, you can open the well-known page settings window and deal with it