110 likes | 146 Views
Learn how to analyze data, create charts, and use functions/formulas effectively in Excel. Understand the concepts of relative and absolute references. Expert guidance on plotting charts and printing sheets.
E N D
When to use Excel? When you want to: • Calculate and analyze data • Create charts (graphs)
Worksheets Workbook J2:K3 H7 Cell/range references
Functions/Formula • Function = predefined Formula • E.g. the following formula contains the SUM function: = (B4 + 25) / SUM(D5:F5)
Relative / Absolute References E.g. • Enter the formula =A1 into cell B2 • Copy the formula from B2 and paste into B3. Formula changes to =A2 automatically. • Copy the formula from B2 and paste into C4. • Formula changes to =B3 automatically. Why? – Relative B2 to C4: column no. +1. So A becomes B in the formula A1 row no. + 2. So 1 becomes 3 in the formula A1 Hence Formula changes to =B3 Final result:
Relative / Absolute References E.g. • Enter the formula =$A$1 into cell B2 • Copy the formula from B2 and paste into B3. Formula remains as =$A$1 – absolute!!. • Copy the formula from B2 and paste into C4. • Formula remains as =$A$1 – absolute!!. Final result??
Charts Follow the instructor to create formula/functions and plot charts
Printing • Print what: • Active sheet • Selected range • Entire workbook • Can remove gridlines before printing: • File>Page Setup>Sheet
MS Excel • ASSIGNMENT