This week you need to read module 3 of Microsoft Excel (pages EX3-1 – EX3-60). Here is the YouTube link to help you with this module
Document are uploaded in “Student Documents” folder under “Course Documents” The assignment is to submit In the Lab Page EX3-65.
You will need to research (using Google) the gas mileage of several vehicles. (you can make up your own data) Price of gas could be any value you find at your nearest gas station or assume it to be $3.75. You must use Absoulte cell reference in all the three formulas. Choose an appropriate (meaningful) graph (on a different sheet and same workbook) to illustrate your results (using the same data as that of the assignment). Format it appropriately. (Do not use assumptions table while creating graph) Do not forget to answer the question in Part 2 in a separate word document or as part of your submission text.
Important Notes for Module 3 –
This chapter focuses on how to perform a “What If Analysis?”. Additional emphasis is also placed on the production of professional looking spreadsheets as well as on ease of use. An important concept is that of absolute vs. relative cell references. As you have already realized, when you copy a formula using the “Fill-Handle” Excel automatically adjusts the formula to its new location. This is because a reference to a cell within a formula is not to the actual cell but rather relative to its current location. Thus, when the formula is copied, the “relative cell reference” now points to a new cell. There are times when it is desired to refer to a particular cell irrespective of the formula’s new location. We do this by using the “$” symbol to indicate that we want to refer to an absolute location. For example, a reference to $G$5 will point to cell G5 no matter where the formula is copied to. (The use of the “$” symbol has nothing to do with money.) B2 is known as a relative cell reference, $B$2 is known as an absolute cell reference, and $B2 or B$2 are known as “mixed cell references.” in the last two cases either the column or the row is fixed – but not both. One of the most common errors in spreadsheets is due to using relative and absolute cell references incorrectly. Be sure you understand the concept. Another critical concept introduced in this chapter is the use of the “IF” function in conjunction with logical operators (e.g., > < <=, >=, =, <>). This powerful function allows the spreadsheet to make decisions based on the contents of a cell. The use of IF functions leads to sophisticated spreadsheets that aid the user in making critical decisions based upon changing situations. Read this section of the chapter carefully, and make sure you understand how IF functions are used.