Excel 2016 Lecture PDF
Document Details
Uploaded by NeatestTopology
Tags
Summary
This document is an instructional guide for Excel 2016, detailing various functions, features, and formatting options. It covers topics like cell functions and error messages, along with explanations of how to use certain tools, such as inserting, deleting, and formatting data.
Full Transcript
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