BIS 155 Course Experience Tradition / bis155.com

1
BIS 155 Course Experience Tradition / bis155.com
The goal of higher education should be to
champion the airing of all honest viewpoints.
Nothing less is acceptable.
For more Tutorials
Visit Now
www.bis155.com
2
BIS 155 Course Experience Tradition / bis155.com
BIS 155 All iLabs Course Project
BIS 155 Course Project Excel Project BIS 155 Lab
1 of 7 Saddle River Marching Band BIS 155 iLab 1
Upper Saddle River Marching Band (New) BIS 155
Lab 2 of 7 Excel's Advanced Formulas
Functions BIS 155 iLab 2 First National Bank
(New) BIS 155 Lab 3 of 7 Alice Barr Realty
Analysis BIS 155 iLab 3 Luke Liberty Realty
(New) BIS 155 Lab 4 of 7 Create Address
Labels BIS 155 iLab 4 Student Education Trust
Create Address Labels (New) BIS 155 Lab 5 of 7
Bruno's Pizza Analysis BIS 155 iLab 5 Carina's
Pizza Analysis (New) BIS 155 Lab 6 of 7 Day Care
Center BIS 155 iLab 6 (Week 5) Day Care Center
(New)
3
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Entire Course (Devry)  
BIS 155 Week 6 Course Project Excel Project BIS
155 Lab 1 of 7 Saddle River Marching Band BIS 155
Lab 2 of 7 Excel's Advanced Formulas
Functions BIS 155 Lab 3 of 7 Alice Barr Realty
Analysis BIS 155 Lab 5 of 7 Bruno's Pizza
Analysis BIS 155 Lab 6 of 7 Day Care Center BIS
155 Lab 7 of 7 Access Database BIS 155 Week 1
Quiz (Excel Fundamentals and Charting) BIS 155
Week 2 Quiz (Excel s Advanced Formulas
Functions) BIS 155 Week 3 Quiz (Data Analysis
Functions)
4
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Final Exam Guide (Cool Clocks, Inc.)
BIS155 Practical Final Exam Instructions 1 for
Cool Clocks, Inc. (v2) Complete the tasks below
using Microsoft Excel.   You may refer to your
notes, the textbook, or other resources (for
example, you may search the Web for
information).  You may not get interactive help
from any other person (either in person or via
email, text messaging, IM, or other
communications channels). I strongly recommend
that you save your work frequently.
5
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Final Exam Guide (Music on Demand)
Complete the tasks below using Microsoft Excel.
You may refer to your notes, the textbook, or
other resources such as the Web You may not get
interactive help from any other person, either in
person or via email, text messaging, instant
messaging, or other communications channels. I
strongly recommend that you save your work
frequently. You have 4 hours to complete this
exam. Note Be sure to spell check on every
worksheet and correct all spelling
errors. Getting started Open Excel (either on
your desktop or in Citrix) If you are using
Citrix, you need to upload the spreadsheet to
your virtual drive before you can open it in Excel
6
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 1 Upper Saddle River Marching Band
(New)
Scenario/Summary You are the assistant to the
band director for the Upper Saddle River Marching
Band, and you must prepare a report showing the
status of the marching band fundraising event for
presentation to the board of trustees. The report
will summarize all sales of all items and include
the total profit-to-date with the amount
remaining to reach the profit goal. You will open
the partially completed workbook, create
formulas, format for presentation to the board,
and add charts to graphically depict the sales
over time and by product. Deliverables STEP 1
Opening and Saving Download the spreadsheet,
Week1 iLab Capital Fundraising Student.xslx. You
will be prompted to save the file. Click yes.
7
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 2 First National Bank (New)
Scenario/Summary You are an intern at First
National Bank working in the loan department, and
your boss has asked you to prepare the monthly
"New Loan Report" for the Board of Directors.
This analysis report will clearly list and
summarize all new loans for residential housing
in the past month. The summary area includes the
loan statistics as labeled data in the data file.
The format of the report should be appropriate
for the Board of Directors for the First National
Bank. Be sure to watch the tutorials at the end
of the Lesson page. Deliverables Step 1 Open,
Save, and Document the Workbook A.       
Download the Week2_iLab_FirstNatlBank_Students.xls
x Workbook
8
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 3 Luke Liberty Realty (New)  
You are an intern with the Regional Realty
Association and are analyzing the claim made by
Luke Liberty Realty that "we get your price." You
have prepared a spreadsheet that shows data
relating to 3 months' sales by Luke Liberty
Realty. You are going to determine the percent of
asking price for each home sold and analyze the
sales data to determine the true track record of
the company in selling homes for the asking
price. STEP 1 Open, Save, and Document the
Workbook You must open a workbook that lists home
sales for 3 months. A.        Download the
workbook Week3_iLab_LibertyRealty_Student.xlsx B. 
       Open the workbook in Excel, and save it
according to the file naming convention above.
9
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 4 Student Education Trust Create
Address Labels (New)  
You work with the Student Education Trust, which
allows you to demonstrate your expertise with
Excel. The trust is sponsoring an auction, and
you have received a list of all donors who have
contributed to this auction. The list was pulled
from their database as a comma-separated text
file. You have been asked to create a letter that
will go out to each of the contributors that will
accept their donation. Tickets to the event will
be enclosed. The letter requires that you provide
the following pieces of information.           
Full name and address            First
name            Donated item           
Value            Number of tickets
requested STEP 1 Import Text File Into a
Spreadsheet and Clean up Data A.        Download
the text file Week4_iLab_MailingData_Student.txt.

10
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 5 Carina's Pizza Analysis (New)  
The owner of Carina's Pizza, wants to evaluate
the profitability of the three restaurants before
expanding further. They are particularly
interested in the comparative results of three
dining categories, dine-in, pickup, and delivery.
Carina has asked for your help in doing this
analysis in return for a small stipend and all
the pizza you can eat. You have already prepared
a template and distributed it to each restaurant
manager, who has entered the sales data for last
year. Your next task is to consolidate the data
into a single workbook that shows the total sales
for each quarter and each dining category. The
information should be shown in tabular, as well
as graphical formats. You will also create a
documentation sheet so that Joe will know exactly
what you have created. Lab Steps STEP 1 Open all
Worksheets and consolidate into a summary
worksheet. You will be using Week5_Lab5_Carinas_Su
mmary_Student.xlsx the partially completed
Summary workbook and the completed Northside
Workbook
11
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 6 (Week 5) Day Care Center (New)  
Senario/Summary Your friend, Adair Deske, is
considering opening a day care center. She has
started compiling her assumptions and putting
together an Income Statement. She has determined
that she must make at least 75,000 profit per
year in order to start the business. She has
asked you to analyze her Income Statement and
help her determine whether it is viable for her
to start this business. You have agreed to help
her complete her Income Statement and to perform
What-If analysis to help her look at her
potential profitability. When submitting the
workbook to the Dropbox, provide a comment in the
Dropbox comments area explaining what you learned
from completing this iLab activity. Lab
Steps STEP 1 Open Worksheet and Complete the
Income Statement Adair needs your help in
completing her Income Statement. She has provided
the basic assumptions
12
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 7 (Week 6) Analysis of a business
Scenario
Scenario/Summary The purpose of this exercise is
to use the Excel skills you have acquired thus
far, and apply them to an analysis of a business
scenario, of your choice. This will consist of
preparing the groundwork in Excel (importing
data, preparing the analysis using tables,
charts, graphs, pivot tables, etc.) and preparing
a memo to your management, explaining your three
separate analysis. This is different than prior
iLab assignments, in that there are no specific
instructions as to what type of analysis (i.e.,
Sales/Units/discounts by Country/Rep/Product/Date/
Category, etc.) is to be performed. The general
requirement is for you to prepare a minimum of
three discrete analyses and perform a write-up to
management, using the memo format
provided. Remember that you are making a
professional analysis and presentation, so be
sure to give some thought to what you are trying
to recommend to management, and why.
13
BIS 155 Course Experience Tradition / bis155.com
BIS 155 iLab 8 (Week 7) Descriptive statistics,
formatting, graphs, and regression analysis
Scenario/Summary Hopefully you will find this
week's iLab activity fun and useful. We'll be
exploring the world of statistics from a business
perspective this week, allowing you to practice
your skills with descriptive statistics,
formatting, graphs, and regression analysis. As
discussed in the lesson, the value of statistics
lies in the ability to analyze data more
effectively for the purpose of improving decision
making.  You might have heard the expression that
"statistics never lie, and only liars use
statistics". There is an obvious truth in this
statement, in that, depending on the questions
being asked and the data collected, the
statistics can skew reality.
14
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 1 of 7 Saddle River Marching Band
(Devry)  
Lab 1 of 7 Saddle River Marching Band (50
Points) Submit your assignment to the Dropbox
located on the silver tab at the top of this
page. L A B O V E R V I E W Scenario/Summary You
are the assistant to the band director for the
Upper Saddle River Marching Band, and you must
prepare a report showing the status of the
marching band fundraising event for presentation
to the board of trustees. The report will
summarize all sales of all items and include the
total profit-to-date with the amount remaining to
reach the profit goal. You will open the
partially completed workbook, create formulas,
format for presentation to the board, and add
charts to graphically depict the sales over time
and by product.
15
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 2 of 7 Excel's Advanced Formulas
Functions (Devry)  
BIS 155 Lab 2 of 7 Excels Advanced Formulas
Functions You are an intern at First National
Bank working in the loan department, and your
boss has asked you to prepare the monthly "New
Loan Report" for the Board of Directors. This
analysis report will clearly list and summarize
all new loans for residential housing in the past
month. The summary area includes the loan
statistics as labeled data in the data file. The
format of the report is appropriate for the Board
of Directors for the First National Bank.
16
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
(Devry)
Lab 3 of 7 Alice Barr Realty Analysis You are an
intern with the Regional Realty Association and
areanalyzing the claim made by Alice Barr Realty
that "we get your price." You haveprepared a
spreadsheet that shows data relating to 3 months'
sales by Alice BarrRealty. You are going to
determine the percent of asking price for each
homesold and analyze the sales data to determine
the true track record of thecompany in selling
homes for the asking price. STEP 1 Open, Save,
and Document theWorkbook (5 points) You must
open a workbook that lists home sales for 3
months. A. Download the file chap4_cap_barr from
DocSharing, LabMaterials.
17
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 4 of 7 Create Address Labels
(Devry)  
Create labels for the letters. The XYZ
Corporation wishes to usemailing labels to
address the envelopes. They own 8 1/2 x 11"
sheets of labelpaper with 1" by 4" labels, which
they purchased from OfficeDepot. Download the
Lab 4, Step 3 Instructions. A. Createa new file
for printing labels. B. Merge data from your
Excel spreadsheet into the new labeldocument. Sub
mit your completed workbook and the two
Worddocuments (merged letters and merged labels)
to the Dropbox. Make sure you posta comment
about what you learned when submitting the
files. 3 Create Address Labels (15
points) Create labels for the letters.
18
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
(Devry)  
The owner of Bruno's Pizza, Joe Bruno, wants to
evaluate the profitability of his three
restaurants before he expands further. He is
particularly interested in the comparative
results of three dining categories, dine-in,
pickup, and delivery. Joe has asked for your help
in doing this analysis in return for a small
stipend and all the pizza you can eat. You have
already prepared a template and distributed it to
each restaurant manager, who has entered the
sales data for last year. Your next task is to
consolidate the data into a single workbook that
shows the total sales for each quarter and each
dining category. The information should be shown
in tabular, as well as graphical formats. You
will also create a documentation sheet so that
Joe will know exactly what you have created.
19
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 6 of 7 Day Care Center (Devry)  
Your friend, Jane Morales, is considering opening
a Day Care Center. She has started compiling her
assumptions and putting together an Income
Statement. She has determined that she must make
at least 75,000 profit per year in order to
start the business. She has asked you to analyze
her Income Statement and help her determine
whether it is viable for her to start this
business. You have agreed to help her complete
her Income Statement and to perform What-If
analysis to help her look at her potential
profitability
20
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Lab 7 of 7 Access Database (Devry)  
Hopefully you will find this week's lab activity
fun and useful. If you have never created a
database, you will be able to tell all of your
friends and family that you are now a database
designer. You will walk through the steps of
creating and populating an Access database to
keep a record of items in your home. The database
will have a table, a form, a query, and a
report. Turn in one database named
Lab7_yourlastname.accdb to the DropBox. When
submitting the database, provide a comment in the
Dropbox comments area explaining what you learned
from completing this lab activity.
21
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 1 DQ Getting Familiar With Excel
Excel was introduced in 1985. Since then, it has
become a standard business tool. Discuss and
explain at least six different (unique) features
of Excel that make it a valuable business
tool. Discuss what type of Excel skills would be
important in todays job market and why. Be
specific. Note In addition to the Microsoft
Excel 2013 overview in the Course Home, there are
many Excel resources, in addition to your text,
on the Web. For example, try an Internet search
on "top ten Excel 2013 features" and sift through
some of the resources. Be sure to read your
classmates posts, and see how many features you
can find that haven't been listed yet.
22
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 1 Quiz (Excel Fundamentals and
Charting) (Devry)  
 Week 1 Quiz   (TCO 1) Which of the following
describes the function of the Formula Bar (as it
applies to Excel 2010)? (Points 2) (TCO 1)
Which of the following best describes a cell
address? (Points 2) (TCO 1) If you wanted to
insert the current date into an active cell,
which of the following would you use? (Points
2) (TCO 1) In Excel a Formula is _______. (Points
2) (TCO 1) Which of the following describes the
Auto Fill in Excel 2010? (Points 2) (TCO 1)
Ribbon Commands with arrows indicate_____.
(Points 2)
23
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 1 Quiz (New)
Question 1.      Question         (TCO 1) An
Input Area (as it applies to Excel 2013) is
defined as_____. a range of cells containing
results based on the output area displays the
name of a worksheet within a workbook a range of
cells containing values for variables used in
formulas   Question 2.      Question        
(TCO 1) In Excel 2013, a cell is best described
by which of the following? Must have formulas
entered into it Cannot be used for labels or
headings Must have text entered into it  Question
3.      Question         (TCO 1) Which of the
following best describes the active cell?
24
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 1-7 All DQs
BIS 155 Week 1 DQ Getting Familiar With Excel BIS
155 Week 2 DQ Formulas and Functions BIS 155 Week
3 DQ Data Analysis Tools BIS 155 Week 4 DQ Excel
Data Exchange BIS 155 Week 5 DQ Data
Consolidation and What-If Analysis BIS 155 Week 6
DQ Bringing It All Together BIS 155 Week 7 DQ
Uses and Applications of Statistics
25
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 2 DQ Formulas and Functions
One of the benefits of Excel is the ability to
use formulas and functions. Discuss the
differences between formulas and functions. Pick
a function in Excel and discuss how that function
is used to calculate results in your worksheets.
Review your classmates posts to make sure that
you're not duplicating formulas/functions already
discussed. Using the following scenarios, discuss
how you would apply the Excel functions or create
a formula to solve the scenario. Be specific! You
wish to calculate the commission on sales. The
commission is 6 on all sales that are at least
20 above cost.
26
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 2 Quiz (Excel s Advanced Formulas
Functions) (Devry)  
Week 2 Quiz (TCO 2) An absolute cell reference
(Points 2) (TCO 2) Which of the following best
describes a circular reference? (Points 2) (TCO
2) E2-G4 contains examples of _____ cell
references. (Points 2) (TCO 2) In Excel, an
Argument would be best described by which of the
following statements? (Points 2) (TCO 2) The
MEDIAN function would identify the ____. (Points
2) (TCO 2) The MAX function identifies the _____.
(Points 2) (TCO 2) The NOW function would
perform which of the following? (Points2) (TCO
2) The _____ number is the number of the column
in the lookup table that contains the return
values. (Points 2)
27
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 2 Quiz (New)
Question 1.      Question         (TCO 2) In
Excel, a relative cell reference indicates a
cell's specific location and the reference does
not change when you copy the formula. contains
both an absolute and a relative cell
reference. indicates a cell's relative location
from the cell containing the formula the
reference changes when you copy the
formula. occurs when a formula directly or
indirectly refers to the cell containing the
formula.   Question 2.      Question        
(TCO 2) Which of the following best describes a
mixed cell reference?
28
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 3 DQ Data Analysis Tools
Excel provides many different ways in which to
analyze data. Discuss the different methods by
which you can analyze data in your spreadsheet.
That is, try an Internet search for "data
analysis with excel" or use some of the methods
you learned in this week's lesson. P.S. Please
don't use the same methods. Show your research
and creativity skills. Assume the role of a
regional manager for a retail organization
looking at ways to analyze the large amounts of
sales data you have. Give some examples. Note As
you answer these questions, a recommended
approach would be to attach a sample
29
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 3 Quiz (Data Analysis Functions)
(Devry)  
Week 3 Quiz (TCO 4) If there are certain columns
of information that are not needed at a
particular time but might be needed later,_ the
unneeded columns to allow users to focus on only
the essential information. (Points2) (TCO 4) In
Excel, the print area is defined as _____.
(Points 2) (TCO 4) When sorting in Excel, it
arranges records in a table _____. (Points
2) (TCO 4) Filtering the Cost column (field) to
show only records greater than 10,000
is......__. (Points2) (TCO 4) To create a new
Conditional Formatting Rule, _____. (Points
2) (TCO 4) In addition to sorting and filtering
cells by content, you can sort and/or filter by
_____. (Points 2)
30
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 3 Quiz (New)
Question 1.      Question         (TCO 4) If
there are certain columns of information that are
not needed at a particular time but might be
needed later, _____ the unneeded columns to allow
users to focus on only the essential
information. hide delete freeze format   Question
2.      Question         (TCO 4) In Excel, the
print area is defined as _____. an individual
piece of data, such as a last name a complete set
of data for an entity the sequence in which pages
print the range of data to print
31
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 4 DQ Excel Data Exchange
Excel 2013 provides the capability to exchange
data with other applications. Discuss the
different types of ways to exchange data between
Excel and other Microsoft applications. Are there
limitations to the exchange process? Think of
some specific examples. How can you exchange data
with other applications that are not part of the
Microsoft Office Suite? Discuss how you would
exchange data with external data sources, such as
websites. (Be certain to include your references
from your research.)
32
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 4 Quiz (New)
Question 1.      Question         (TCO 8) Which
of the following is one of the most common file
types imported into Excel? Text PowerPoint Web Wor
d   Question 2.      Question         (TCO 8) To
create a connection between the original data
source and the imported data in Excel, use the
_____ on the Data tab. Data Validation
command Connection command Edit Links
command Commands in the Get External Data group
33
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 4 Quiz (Office Integration and Mail
Merge) (Devry)  
Week 4 Quiz (TCO 8) Which of the following is one
of the most common file types imported into
Excel? (Points 2) (TCO 8) Which of the
following is NOT a text file? (Points 2) (TCO
8) Which of the following is NOT a method for
refreshing data? (Points 2) (TCO 8) The Convert
Text to Columns Wizard allows you to choose the
file type, such as Delimited____(Points2) (TCO
8) Which of the following is a frequently used
function to manipulate txt? (Points 2)
34
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 5 DQ Data Consolidation and What-If
Analysis
Discuss and compare the group summations and
What-If analysis (Consolidation) Excel tools. You
may need to look up (research) the group
summations. Under what circumstances would you
use each of these features? Do they both serve
the same purpose, or is each one used under
different scenarios? Give examples of how each
can be used. Please include your research
references in APA format.
35
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 5 Quiz (Consolidating Data and
What-If Analysis) (Devry)  
Week 5 Quiz (TCO 5) When multiple worksheets are
selected, the word ________ appears in the title
bar. (Points 2) (TCO 5) In Excel, which of the
following would you perform to group adjacent
worksheets? (Points 2) (TCO 5) When two windows
of the same workbook are opened, Excel adds
________ to the.... (Points2) (TCO 5) After
saving the arrangement of windows, a workbook can
be opened by opening __file. (Points2) (TCO
5)Which of the following functions do NOT work
with 3D formulas? (Points 2)
36
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 5 Quiz (New)
Question 1.      Question         (TCO 5) The
tabs of grouped worksheets are displayed with a
_____ background. gray yellow blue white   Questio
n 2.      Question         (TCO 5) If several
worksheets are grouped and you enter a formula in
cell A10 in one of the grouped sheets the same
formula is entered into all grouped
worksheets. the formula changes by one row in
each grouped worksheet. the formula changes by
one column in each grouped worksheet. nothing
happens to the other sheets.
37
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 6 Course Project Excel Project
(Devry)  
Objective The general instructions for this
project can be found in the Week 6 Lecture
material. The Week 6 Lecture describes the
assignment and provides an overview of the
project as a whole. There are no step-by-steps
for the course project. The following are grading
criteria for this project. Guidelines Organize
the Data Data imported from SalesData.csv text
file located in Course Project Materials in
DocSharing. Professional formatting follows the
formatting guidelines we studied during the first
week of class. Documentation sheet added to
provide author, purpose, and date and provide
information about each of the sheets you will
create as you analyze the data. At least one
calculated field added and copied to all cells in
the worksheet.
38
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 6 DQ Bringing It All Together
This week will be an opportunity to share ideas
and approaches to the Excel course project due
this week. What are some spreadsheet features you
will use to make your spreadsheet professional,
readable, reliable, and repeatable? This is an
opportunity to show your creativity and depth of
understanding of what you have learned up to this
point. Which spreadsheet functions and data
analysis types do you think will be the most
challenging to implement in this project?  You
will need to have reviewed the project
requirements prior to answering this question.
39
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 7 DQ Uses and Applications of
Statistics
More than 100 years ago, H.G. Wells commented
that "statistical thinking will one day be as
necessary as the ability to read and write." If
you were to google "statistics for managers", you
will see a list of all sorts of books on this
topic, followed by thousands of articles and
resources. Provide a detailed application for the
use of some of the many forms of statistics in
business. As you perform this analysis, be sure
to describe the scenario in detail, why you will
need the use of statistics, and explain which
type of statistics you will use to solve your
scenario question. Two-hundred-word minimum, well
formatted and referenced.  
40
BIS 155 Course Experience Tradition / bis155.com
BIS 155 Week 8 Final Exam (Devry)  
(TCO 1) You work for a local construction firm,
"DeVry Engineering Group" and your supervisor
wants to test your knowledge and skills with
Microsoft Excel and has instructed you to develop
a spreadsheet to calculate weekly payroll for
15 employees with the following
assumptions....... (Points 40) (TCO 3) You
currently work for an automotive parts supply
store. Your company is growing and is
considering expansion. The company currently has
three locations (North, South, and Central) in
one state. Each parts supply store carries
inventory in four categories. You have been
presented with the sales figures for the last
three years for each location and inventory
category by store. Based on this information,
you're tasked with analyzing current sales for
each store by category and overall total sales by
store and category.. (Points 40) (TCO 4) You
are given a spreadsheet with daily sales numbers
ordered by date from January 1st to December 31st
41
BIS 155 Course Experience Tradition / bis155.com
The goal of higher education should be to
champion the airing of all honest viewpoints.
Nothing less is acceptable.
For more Tutorials
Visit Now
www.bis155.com