03 Excel summary.pdf

Excel 2016 lecture  The Word creates a document that contains a set of pages and the extension of its file docx  The Powerpoint creates a presentation that contains a set of slides and the extension of its file pptx  The Excel creates a book or workbook that contains a set of wo...

Excel 2016 lecture  The Word creates a document that contains a set of pages and the extension of its file docx  The Powerpoint creates a presentation that contains a set of slides and the extension of its file pptx  The Excel creates a book or workbook that contains a set of work sheets and the extension of its file xlsx  The Excel program contains 1048576 rows and 16 thousand columns.  The working environment inside Excel is the cell.  The cell is made up of the column name with letter the row number. Data is entered into the cell.  Data has different types such as (numbers - salary - date - time - percentage......)  What is the main interface of the program? 1. Title bar 2. Tabs bar 3. Formula bar Contains:  the name of the active cell, box name  Three active cell states (Enter – ready – edit)  Insertion mark, cancel mark, and insertion of a function  Cell content of data First: View Tab 1. Sheet display formats 2. Show and hide (formula bar - column and row headers - and gridlines) 3. Window commands 4. Change the size of the zoom sheet How to hide and re-show the Menu Bar (Ribbon button): Hide: We click on Collapse the Ribbon, which is located on the far right of the Menu Bar Show: Click on any Menu and then click on Pin the ribbon Second: File tab  Work on the file from the outside of the file tab such as (new file - save - print....) Third: Home Tab The basic formatting operations found in the Home tab are used 1. Font group 2. Clipboard group 3. Number group 4. Alignment group 5. Cell group Insert: add (row - column - cell -sheet) Delete: remove (row - column - cell - sheet) Format: It is possible to format  row height & column width  Auto fit row and column  Hide/unhide row, column and sheet  Rename the sheet  Copy  Sheet transfer  Protect the sheet from data modification) 6. Style group Patterns prepared by the program can be used. 7. Editing group Find: To search for a word within the document = Ctrl + F. Replace: It is used to replace one word with another in the document = Ctrl + H Select: is used to select the entire document, an item, or text. Fill Sort (ascending and descending) Delete clear (content only - format only - all) Fourth: Insert Tab Fifth: Page layout Tab Margins: Adjust margins from above, below, right and left. Orientation: Page orientation we choose portrait or landscape Size: Page Size Print area: Add a background Excel Sheet Direction Show and hide gridlines – hide headers of columns and rows The direction of the excel sheet is from right to left or from left to right. Error messages (important) #NULL! → Separate multiple cell references in a formula with a space instead of a math operator such as the plus sign #DIV/O! → appears when dividing by zero #VALUE! → performs operations that are not of the same data type (for example, combining text with a number) #REF! → When the reference cell that has been deleted. That is meaning I have performed a function or arithmetic operation that is based on a cell that has been deleted. #NAME! → appears when typing an error in the name of the function #NUM! → The formula or function contains invalid numeric values #NA! → The equation could not find what she was asked to search for #### → When the text is larger than the width of the cell Circular reference error → It appears if the range of the formula contains the result cell