{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Module_D9_for_Office_2003

# Module_D9_for_Office_2003 - E X TENDE D L E ARN IN G MOD U...

This preview shows pages 1–4. Sign up to view the full content.

EXTENDED LEARNING MODULE D DECISION ANALYSIS WITH SPREADSHEET SOFTWARE Student Learning Outcomes Define a list and list definition table within the context of spreadsheet software and describe the importance of each. Compare and contrast the autofilter function and custom autofilter function in spreadsheet software. Describe the purpose of using conditional formatting. Define a pivot table and describe how you can use it to view summarized information by dimension. 1. 2. 3. 4.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
D.2 Extended Learning Module D Introduction As you just read in Chapter 4, technology can and does play a vitally important role in both supporting decision making and, in some instances, actually making decisions or recommendations. In this module, we’ll focus on decision-making support, by exploring many of the advanced and productive features of Microsoft Excel. Microsoft Excel is spreadsheet software that allows you to work with any kind of information, with each individual piece of information located in a cell. A cell is the intersection of a row and column and is uniquely identified by its column character and row number. In Figure D.1 you can see two workbooks. The first (the one in the background) shows all the detailed information for a group of customers. The second shows the number of customers by region (North, South, East, and West) and by rent versus own. There are a total of 487 customers (cell D9 in the workbook in the foreground), of which 262 own a home (cell B9) and 225 rent (cell C9). Within this workbook, you can easily see some interesting information. For example, there are 148 customers in the East region while only 98 live in the South region. By region and ownership status, 82 own a home in the East region while only 47 rent in the South region. Customers by region Total number of customers Customers by rent versus own Figure D.1 Number of Customers by Region and by Rent versus Own

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern