BIS 155 PAPERS Possible Is Everything / bis155papers.com

1
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
2
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 All iLabs Course Project FOR MORE
CLASSES VISIT www.bis155papers.com 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)
3
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Final Exam Guide (Cool Clocks, Inc.) FOR
MORE CLASSES VISIT www.bis155papers.com 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. 1.
Formatting and charts (TCOs 1 3 40
points) a. Enter your name and today's date
on the Documentation sheet b. Select the
Q1Q2 sheet, and adjust the widths of the columns
as needed c. Center the title "Cool Clock,
Inc. Sales by Product" across columns A-D,
increase the font size to 20, and change the font
color to red. d. Bold the column headings
"Product", "Unit Price", "Quantity" and "Total
Sales". e. Add formulas to the Total Sales
column to calculate the total sales for each
product. f. Add a grand total at the bottom
of the Total Sales column, in cell D8.
4
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Final Exam Guide (Music on Demand) FOR
MORE CLASSES VISIT www.bis155papers.com 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 Open the Practical Exam spreadsheet you
downloaded from the course Exam page.Save the
spreadsheet as LastnameFirstInitial Week8
FinalExam.xlsx. (i.e., if your name were Jane
Doe, your file name would be DoeJ Week8
FinalExam.xlsx) Questions/Problems
5
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 1 Upper Saddle River Marching Band
(New) FOR MORE CLASSES VISIT www.bis155papers.com
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. Open the saved file from your Download
folder on your computer. Note If you are using
the Remote Lab environment you will need to
follow the instructions for uploading the file.
These instructions can be found on the iLab page
when you click on the iLab icon on Course
Resources.
6
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 2 First National Bank (New) FOR
MORE CLASSES VISIT www.bis155papers.com Scenario/S
ummary 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.xlsx Workbook.
Open the file in Excel, and save it as the file
name as describe above (i.e., Doe_J_Week2
iLab.xlxsm). Note You may get a popup message
that asks you to "Enable Saving". Simply click
"Yes" to Enable and you will be able to save the
file B. It is recommended that as you
progress through this assignment, that you work
on what you have learned so far, in terms of
readability
7
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 3 Luke Liberty Realty (New) FOR
MORE CLASSES VISIT www.bis155papers.com 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. C.
Insert a documentation sheet that includes
title, author, date, and purpose. Format it
appropriately, including changing the Sheet Name
to Documentation. At the end of this activity,
you will be asked to provide a conclusion as to
whether this realty company "really gets your
price."
8
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 4 Student Education Trust Create
Address Labels (New) FOR MORE CLASSES
VISIT www.bis155papers.com 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_S
tudent.txt. To complete the download, right click
on the file name and select Save Link As. The
file will save to your local drive.
9
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 5 Carina's Pizza Analysis (New) FOR
MORE CLASSES VISIT www.bis155papers.com 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, Southside Workbook, and Downtown
Workbook.
10
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 6 (Week 5) Day Care Center (New) FOR
MORE CLASSES VISIT www.bis155papers.com Senario/Su
mmary 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, but you need to provide
the calculations that will be used as you perform
What-If analysis.
11
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 7 (Week 6) Analysis of a business
Scenario FOR MORE CLASSES VISIT www.bis155papers.c
om 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.
12
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 iLab 8 (Week 7) Descriptive statistics,
formatting, graphs, and regression analysis FOR
MORE CLASSES VISIT www.bis155papers.com Scenario/S
ummary 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. For example, it is true that as ice
cream sales increase, accidents at swimming pools
increase. Does this mean that the more ice cream
that is sold, the more accidents it causes
(correlation/causation)? Of course not, but the
data, if not interpreted correctly, could lead to
false conclusions.
13
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 1 of 7 Saddle River Marching Band
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m 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.
14
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 2 of 7 Excel's Advanced Formulas
Functions (Devry) FOR MORE CLASSES
VISIT www.bis155papers.com 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.
15
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m Lab 3 of 7 Alice Barr Realty Analysis You are
an intern with the Regional Realty Association
and are analyzing the claim made by Alice Barr
Realty that "we get your price." You
have prepared a spreadsheet that shows data
relating to 3 months' sales by Alice Barr 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 (5 points) You must open a workbook
that lists home sales for 3 months. A. Download
the file chap4_cap_barr from DocSharing, Lab
16
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 4 of 7 Create Address Labels
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m Create labels for the letters. The XYZ
Corporation wishes to use mailing labels to
address the envelopes. They own 8 1/2 x 11"
sheets of label paper with 1" by 4" labels, which
they purchased from Office Depot. Download the
Lab 4, Step 3 Instructions. A. Create a new file
for printing labels. B. Merge data from your
Excel spreadsheet into the new label document. Sub
mit your completed workbook and the two
Word documents (merged letters and merged labels)
to the Dropbox. Make sure you post a comment
about what you learned when submitting the
files. 3 Create Address Labels (15
points) Create labels for the letters. The XYZ
Corporation wishes to use mailing labels to
address the envelopes. They own 8 1/2 x 11"
sheets of label paper with 1" by 4" labels, which
they purchased from Office
17
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m 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.
18
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 6 of 7 Day Care Center (Devry) FOR
MORE CLASSES VISIT www.bis155papers.com 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.
19
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Lab 7 of 7 Access Database (Devry) FOR
MORE CLASSES VISIT www.bis155papers.com 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.
20
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 1 DQ Getting Familiar With Excel FOR
MORE CLASSES VISIT www.bis155papers.com 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.
21
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 1 Quiz (Excel Fundamentals and
Charting) (Devry) FOR MORE CLASSES
VISIT www.bis155papers.com 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)
(TCO 1) The three types of data that can be
entered in a cell in an Excel worksheet are
__________. (Points 2) (TCO1) In Excel, a
border ________. (Points 2) (TCO 3) A data
series is a group of related ____________.
(Points 2) (TCO 3) A __________ is usually
the most effective way to display proportional
relationships, such as market share data, where
the individual data values represent parts of a
whole. (Points 2)
22
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 1 Quiz (New) FOR MORE CLASSES
VISIT www.bis155papers.com 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? Is where all the
functions of the database perform the
calculations Is the cell that always holds the
current date Is the location of the insertion
point as indicated by a dark border Is where all
the formulas of the workbook do the math
23
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 1-7 All DQs FOR MORE CLASSES
VISIT www.bis155papers.com 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
24
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 2 DQ Formulas and Functions FOR MORE
CLASSES VISIT www.bis155papers.com 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. You wish to calculate the total
pay for an employee who receives regular time for
40 hours, time and a half for 4050 hours, and
double time for hours over 50. You have a list of
contracts and due dates for annual maintenance
fees. You wish to determine when you have a
contract due in the next 45 days and provide a
note that warns you that the payment is due.
25
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 2 Quiz (Excel s Advanced Formulas
Functions) (Devry) FOR MORE CLASSES
VISIT www.bis155papers.com 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) (TCO 2)
Arithmetic operations, cell references, and
____can be used in Excel formulas. (Points
2) (TCO 2) To simplify entering ranges in
formulas, you can use _____. (Points 2)
26
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 2 Quiz (New) FOR MORE CLASSES
VISIT www.bis155papers.com 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? Occurs when a formula directly or
indirectly refers to the cell containing the
formula Causes a potential error Contains
absolute or relative cell references, but not both
27
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 3 DQ Data Analysis Tools FOR MORE
CLASSES VISIT www.bis155papers.com   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 Excel spreadsheet that you can
use to illustrate your answers.
28
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 3 Quiz (Data Analysis Functions)
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m 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) (TCO 4) When data is grouped,
the margin area displays the _____. (Points
2) (TCO 4) A _____ allows you to identify
relationships between variables in your data.
(Points 2) (TCO 4) Data mining techniques such
as PivotTables can detect _____ of data. (Points
2)
29
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 3 Quiz (New) FOR MORE CLASSES
VISIT www.bis155papers.com 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 Question 3. Question (TCO
4) When sorting in Excel, it arranges records in
a table _____. by the number of pages in the
worksheet
30
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 4 DQ Excel Data Exchange FOR MORE
CLASSES VISIT www.bis155papers.com 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.)
31
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 4 Quiz (New) FOR MORE CLASSES
VISIT www.bis155papers.com Question 1.
Question (TCO 8) Which of the following
is one of the most common file types imported
into Excel? Text PowerPoint Web Word 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 Question 3. Question
(TCO 8) All of the following will display
data range properties EXCEPT click Properties in
the Connections Group.
32
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 4 Quiz (Office Integration and Mail
Merge) (Devry) FOR MORE CLASSES
VISIT www.bis155papers.com 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) (TCO 8) To change
the text string Jack Doe to JACK DOE, use the
________ function. (Points 2) (TCO 8) Which of
the following cannot be used in a CONCATENATE
function? (Points 2)
33
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 5 DQ Data Consolidation and What-If
Analysis FOR MORE CLASSES VISIT www.bis155papers.c
om 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.
34
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 5 Quiz (Consolidating Data and
What-If Analysis) (Devry) FOR MORE CLASSES
VISIT www.bis155papers.com 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) (TCO 5) Excel's ability to manage
worksheets allows you to do all EXCEPT (Points
2) (TCO 5) If A1 contains the hourly pay rate of
10.25, A2 contains the hours worked (40), and A3
contains A1A2, which cell is the dependent
cell(s)? (Points 2)
35
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 5 Quiz (New) FOR MORE CLASSES
VISIT www.bis155papers.com Question 1.
Question (TCO 5) The tabs of grouped
worksheets are displayed with a _____
background. gray yellow blue white Question 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. Question 3.
Question (TCO 5) When two windows of the
same workbook are opened, Excel adds _____ to the
title bar of the second window. the letter B
36
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 6 Course Project Excel Project
(Devry) FOR MORE CLASSES VISIT www.bis155papers.co
m 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. Analyze the Data Analyze the data
in at least three different ways. Each form of
Data Analysis should be provided on a separate,
appropriately labeled worksheet.
37
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 6 DQ Bringing It All Together FOR
MORE CLASSES VISIT www.bis155papers.com 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.
You might want to look at how you responded to
the above question, and from that list, identify
implementation challenges, and state why you feel
that way.
38
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 7 DQ Uses and Applications of
Statistics FOR MORE CLASSES VISIT www.bis155papers
.com 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
39
BIS 155 PAPERS Possible Is Everything /
bis155papers.com
BIS 155 Week 8 Final Exam (Devry) FOR MORE
CLASSES VISIT www.bis155papers.com (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)
40
BIS 155 PAPERS Possible Is Everything /
bis155papers.com