Excel PDF - Spreadsheet Software Guide

Excel Stm Understand Spreadsheet Software Microsoft Excel is the electronic spreadsheet program within the Microsoft Office suite An electronic spreadsheet is an app you use to perform numeric calculations and to analyze and present numeric data the electronic spreadsheet you work in is call...

Excel Stm Understand Spreadsheet Software Microsoft Excel is the electronic spreadsheet program within the Microsoft Office suite An electronic spreadsheet is an app you use to perform numeric calculations and to analyze and present numeric data the electronic spreadsheet you work in is called a worksheet, and it is contained in a file called a workbook Microsoft Excel extension is.xlsx. When you use Excel, you have the ability to: Enter data quickly and accurately , Recalculate data easily , Perform what-if analysis , Change the appearance of information , Create charts , Share information , Build on previous work Quick analysis tool making information visually appealing and easier to understand. You can also use predesigned, formatted files called templates to create new worksheets quickly Identify Excel 2016 Window Components The Name box displays the active cell address The formula bar allows you to enter or edit data in the worksheet The worksheet window contains a grid of columns and rows. Columns are labeled alphabetically and rows are labeled numerically The worksheet contain a total of 1,048,576 rows and 16,384 columns The intersection of a column and a row is called a cell Cells can contain text, numbers, formulas, or a combination of all three. Every cell has its own unique location or cell address, which is identified by the coordinates of the intersecting column and row The cell pointer is a dark rectangle that outlines the cell you are working in. This cell is called the active cell Sheet tabs below the worksheet grid let you switch from sheet to sheet in a workbook By default a workbook file contains one worksheet Sheet tab scrolling buttons let you navigate to additional sheet tabs when available status bar is located at the bottom of the Excel window. It provides a brief description of the active command or task in progress. The mode indicator in the lower-left corner of the status bar provides additional information about certain tasks you select a range when you want to perform an action on a group of cells at once Understand formulas formula is an equation in a worksheet All Excel formulas begin with the equal sign ( = ). It is important to use cell reference rather than values Enter Labels and Values and Use the AutoSum Button Labels are entries that contain text and numerical information not used in calculations Values are numbers, formulas, and functions that can be used in calculations Labels are left-aligned by default, and values are right-aligned by default Excel recognizes an entry as a value if it is a number or it begins with one of these symbols ( +, -, =, @, #, $) When a cell contains both text and numbers, Excel recognizes it as a label  Function predefined formula that provides a shortcut for a commonly used or complex calculation, such as SUM Argument Information that a function uses to create the final answer function arguments Edit Cell Entries You can change, or edit, the contents of an active cell at any time Pressing [Enter] to accept an edit moves the cell pointer down one cell Pressing [Tab] to accept an edit moves the cell pointer one cell to the right Pressing [F2] switches Excel to Edit mode Pressing [F2] activates the cell for editing directly in the cell instead of the formula bar Enter and Edit a Simple Formula You use formulas in Excel to perform calculations such as adding, multiplying, and averaging Formulas in an Excel worksheet start with the equal sign (=), also called the formula prefix Calculation operators indicate what type of calculation you want to perform on the cells, ranges, or values operators can include : Example 1. Arithmetic operators which perform mathematical calculations I o 2. Comparison operators which compare values for the purpose of true/false results a a s 3. Text concatenation operators which join strings of all text in different cells & 4. Reference operators which enable you to use ranges in calculations Switch Worksheet Views Changing sheet view does not affect the contents of a worksheet Normal view is the default view in Excel it shows the worksheet without headers and footers, rulers and a page number Page Layout view provides a more accurate view of how a worksheet will look when printed. Also, displays margins of the page, header, footer ruler, and page number on the status bar Page Break View displays a reduced view of each page of your worksheet, along with page break indicators that you can drag to include more or less information on a page. Both of header and footer are made up of three text boxes: left, center, and right You can press the [Tab] to advance from one header or footer box to the next Choose print options You can use tools on the Page Layout tab to adjust print orientation, paper size, and location of page breaks You can also use the Scale to Fit options on the Page Layout tab to fit a large amount of data on a single page without making changes to individual margins, and to turn gridlines and column/row headings on and off You can also adjust page layout settings from within Backstage view and immediately see the results in the document preview Module2 Create a Complex Formula Complex formula uses more than one arithmetic operator In complex formula Excel uses the standard order of precedence rules to determine which operation to perform first You can change the order of precedence in a formula by using parentheses around the part you want to calculate first Dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells, this option is called Auto Fill Insert a Function Functions are predefined worksheet formulas that enable you to perform complex calculations easily Functions are organized into categories, such as Financial, Date & Time, and Statistical, based on their purposes If you use a function alone, it always begins with an equal sign ( = ) as the formula prefix Type a Function you can manually type the function into a cell and then complete the arguments needed Formula AutoComplete feature makes it easier to enter function names by typing, because its suggest functions depending on the first letters you type Copy and Move Cell Entries There are three ways you can copy or move cells and ranges from one location to another : 1. the Cut, Copy and Paste buttons on the Home tab 2. the fill handle in the lower-right corner of the active cell or range 3. the drag-and-drop feature Understand Relative and Absolute Cell References relative Cell reference a cell address that refers to a cell's location in relation to the cell containing the formula and that automatically changes to reflect the new location when the formula is copied or moved Absolute Cell Reference a cell address that refers to a specific cell and does not change when you copy the formula You create an absolute cell reference by placing a $ dollar sign in front of both the column letter and the row number of the cell address press [F4] the dollar signs are added automatically Round a value with a function You can round a value or formula result to a specific number of decimal places by using the Round Function When you type Zero indicates that you don’t want any decimal places appear in the calculated When you complete the edit, the parentheses at either end of the formula briefly become bold, indicating that the formula has the correct number of open and closed parentheses and is balanced Module 3 Format Values The format of a cell determines how the labels and values look Formatting changes only the appearance of a value or label; it does not alter the actual data in any way Accounting number format button adds dollar signs and two decimal places to the data makes it clear that its values are monetary values Change Font and Font Size font is the name for a collection of characters The font size is measured in units called points A point is equal to 1 /72 of an inch The default font and font size in Excel is ( 11 point - Calibri ) Change Font Styles and Alignment Font styles are formats such as bold, italic, and underlining You can also change the alignment of labels and values in cells to position them in relation to the cells edges Merge & Center button Centers text, and combines two or more selected, adjacent cells into one cell Wrap Text Button Wraps long text into multiple lines in the cell Adjust Column Width The default column width is 8.43 characters, a little less than 1 " The column heading is the box at the top of each column containing a letter Double-clicking the right edge of a column heading activates the Autofit feature Autofit feature automatically resizes the column to accommodate the widest entry in the column You can change the width of multiple columns at once Insert and delete Rows and Columns pressing [Delete] on the keyboard removes only the contents of a selected row or column When you insert a new row, the row is inserted above the cell pointer and the contents of the worksheet shift down from the newly inserted row When you insert a new column, the column is inserted to the left of the cell pointer and the contents of the worksheet shift to the right of the new column Rename And Move a Worksheet By default, an Excel workbook initially contains one worksheet named Sheet 1 you can rename each sheet and add color to the tabs You can rename sheet by : Double click or Right click then select rename or from cell group format You can delete a sheet by : click delete sheet in the cell group or right click then select delete Check Spelling Excel includes a spell checker to help you ensure that the words in your worksheet are spelled correctly Any words you've added to the dictionary using Word, Access, or PowerPoint are also available in Excel Module 4 Create a chart To create a chart in Excel, you can you The Quick analysis tool or the insert tab on the ribbon Chart sheet is a sheet in a workbook that contains only a chart that is linked to the workbook data known as Embedded chart because it is inserted directly in the current worksheet and doesn’t exist in a separate file The border around the chart and the sizing handles the small series of dots at the corners and sides of the chart's border indicate that the chart is selected Move and Resize a chart A chart is an object, or an independent element on a worksheet, and is not located in a specific cell or range You can move a selected chart anywhere on a worksheet without affecting formulas or data in the worksheet Any data changed in the worksheet is automatically updated in the chart You can even move a chart to a different sheet in the workbook, and it will still reflect the original data Change the chart design The layouts in the chart Layouts group on the Chart Tools Design tab offer arrangements of objects in your chart such as its legend, title, or gridlines; choosing one of these layouts is an alternative to manually changing how objects are arranged in a chart Change the Chart Format Chart Elements button makes it easy to add, remove, and modify individual chart objects such as a chart title or legend Major gridlines represent the values at the value axis tick marks Minor gridlines represent the values between the tick marks At Mama too BEEN