BIS 155 DEVRY ENTIRE COURSE,BIS 155 DEVRY ENTIRE CLASS,BIS 155 DEVRY TUTORIAL,BIS 155 DEVRY ASSIGNMENT Flashcards
DEVRY BIS 155 Course Projects
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-course-projects
For more classes visit
http://www.assignmentclick.com
BIS 155 Week 6 Course Project Memo
BIS 155 Week 6 Course Project.ppt
BIS 155 Week 6 Course Project.xls
BIS 155 Memo Northwind Trades Project
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-course-projects
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Entire Course with Final Exam (NEW)
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-entire-course
For more classes visit
http://www.assignmentclick.com
BIS 155 iLab Week 1 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 2 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 3 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 4 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 5 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 6 Data Analysis with Spreadsheets with Lab
BIS 155 iLab Week 7 Access Data Analysis with Spreadsheets with Lab
BIS 155 Week 1 Quiz
BIS 155 Week 2 Quiz
BIS 155 Week 3 Quiz
BIS 155 Week 4 Quiz
BIS 155 Week 5 Quiz BIS 155 Course Projects
BIS 155 Final Exam
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-entire-course
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Final Exams
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-final-exams
For more classes visit
http://www.assignmentclick.com
BIS 155 Final Exam Data Analysis with Spreadsheets with Lab
(TCO 3) A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet. Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores. Be sure to include formulas that are to be used in the Excel spreadsheet. (Points : 40)
Data consolidation strategy is a new concept that a majority of mangers are trying to adopt in order to keep track of their…
(TCO 5) Mark Jacobs, owner of Jacob’s Mini-Mart currently operates two stores in Atlanta. His business has been very successful, and he is now opening two new stores. He will no longer be able to manage all stores himself, so he is hiring managers for three of the four stores. He will continue to operate one store, and act as general manager over the company. He is looking for an easy and efficient way to collect information from the stores, and he would like your help with the following:PART 1 Marc wants you to design a worksheet for his managers to complete showing the sales by product category by month at each store. He wants to be sure the managers don’t change the formulas in the worksheet. Describes the characteristics of the worksheet.
PART 2 Describe the process Mark will use in combining the completed worksheets into on workbook and creating the summary report. (Points : 40)
Part 1
For the case of Jacob’s Mini-Mart, he needs to have a way of …
Part 2
For the completed worksheets to make sense to the users….
(TCO 9) You are assigned to analyze a large dataset containing the detailed records of invoices of a company’s customers which contain the customer ID, their address, city, region, post code, country and sales person and additional information about specific order id, order date, shipped date, shipper, product ordered, unit price, quantity, discount, ship address, ship city, ship postal code, ship country, and product category name. Explain how you would use Excel and Excel formulas to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations. (Points : 40)
The use of excel for data analysis is one the best processes that data…
(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours.
Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.
Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula.
Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula.
Part 4: Salaried and Exempt employees (Pay Codes E and S) are covered by the company’s health insurance. The deduction is $10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. (Points : 40)
(TCO 3) You are a Microsoft Office trainer for DeVry University. The training topic for the current month is charts using Microsoft Excel. During each training session from different departments or cohorts, the following frequently asked questions were asked and you decide to create a document formalizing answers and suggestions.
My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important?
My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why?
My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why?
My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important? (Points : 40)
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-final-exams
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 1 iLab Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
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.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 1 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)
A range of cells containing results based upon manipulation of the variables in the input area
Displays the name of a worksheet within a workbook
A range of cells containing values for variables used in formulas
Displays the content of the active cell
(TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)
Must have formulas entered into it
Cannot be used for labels or headings
Must have text entered into it
Is the intersection of a column and a row
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 1 to Week 7 All Discussions
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-to-week-7-all-discussions
For more classes visit
http://www.assignmentclick.com
BIS 155 Week 1 DQ Getting Familiar with Excel
Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market.
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. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.
You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-to-week-7-all-discussions
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 1 to Week 7 All Quiz
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-to-week-5-all-quiz
For more classes visit
http://www.assignmentclick.com
BIS 155 Week 1 Quiz Data Analysis with Spreadsheets with Lab
BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab
BIS 155 Week 3 Quiz Data Analysis with Spreadsheets with Lab
BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab
BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-1-to-week-5-all-quiz
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 2 iLab Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-2-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
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.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-2-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-2-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
(TCO 2) In Excel, a relative cell reference: (Points : 2)
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
(TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points : 2)
Calculates the total of values contained in two or more cells.
Displays a list of functions and defined names as you enter a function.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-2-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 3 iLab Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-3-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
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.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-3-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 3 Quiz Data Analysis with Spreadsheets with Lab
s
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-3-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
(TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2)
Formatting
Freezing
Resizing
Tiling
(TCO 4) In Excel, the print area is defined as _____. (Points : 2)
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
TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2)
Indicates where data starts on a new printed page
Collection of structured, related data in columns and rows
Freezing rows to keep them visible
Freezing panes to keep them visible
(TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2)
by the number of pages in the worksheet
by the number of pages in the workbook
by the value in field(s) within a table
by permanently removing extraneous data
(TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____. (Points : 2)
the use of a table element as a formula
a Number Filter
a Text Filter
a Date Filter
(TCO 4) Which of the following best describes conditional formatting? (Points : 2)
Highlights or emphasizes cells that meet certain conditions
Tags a table element as a reference in a formula
Formats the condition of the worksheet in preparation for printing
Calculates an aggregate for values in a range or database
(TCO 4) Using Conditional Formatting to draw attention to cells containing errors _____. (Points : 2)
helps locate errors in cells quickly
displays a particular color based on the relative value of the cell contents to other selected cells
calculates an aggregate for values in a range or database
displays an icon representing a value in the top third based on values in the selected range
(TCO 4) When data is grouped, the margin area displays the _____. (Points : 2)
aggregate columns
group headings
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-3-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 4 iLab Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-4-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
You work with the XYZ Corporation Charitable Trust 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 the Corporation’s 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
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-4-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-4-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
(TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2)
Commas
Tabs
Spaces
Hyphens
(TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections. (Points : 2)
Get External Data
Data Tools
Analysis
Connections
(TCO 8) Which of the following is an example of a text string? (Points : 2)
=B5*B7
=SUM(A5:A10)
=IF(B3>B4, B3)
John Doe
(TCO 8) To change the text string JANE doe to jane doe, use the ________ function. (Points : 2)
CONCATENATE
PROPER
UPPER
LOWER
(TCO 8) When the data source you select for a mail merge is an Excel workbook that has more than one worksheet, what does Word do? (Points : 2)
Automatically uses the data from the first worksheet in the workbook.
Automatically uses the data from the last worksheet in the workbook.
Displays a list of the worksheet names and lets you pick which one to use.
Displays an error message and is unable to continue.
(TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2)
typing the comment into the cell and then clicking New Comment.
right-click the cell and choose Insert Comment.
left-click the cell and choose Insert Comment.
clicking paste on the Home tab after typing in the comment.
(TCO 8) An Excel file saved as a .pdf does all the following EXCEPT: (Points : 2)
preserves the formatting.
prevents editing.
prevents users from printing the file.
can be viewed on multiple computer systems and platforms.
(TCO 8) To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties. (Points : 2)
Properties
Show All Properties
Permissions
Versions
(TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs? (Points : 2)
Review tab
Data tab
File tab
None of the above
(TCO 8) Which of the following is NOT a text file? (Points : 2)
Tab-delimited
Comma-separated value
XML
Fixed-width
(TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2)
Click the Refresh All command.
Save the Excel workbook.
Click the Refresh All arrow, then click Refresh.
Right-click in a range of data and then select Refresh.
(TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2)
File
Data
Insert
Page Layout
(TCO 8) To change the text string jOHn dOE to John Doe, use the ________ function. (Points : 2)
CONCATENATE
PROPER
UPPER
LOWER
(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2)
UPPER
LOWER
PROPER
CONCATENATE
(TCO 8) Which of the following functions does not change the case or capitalization of text? (Points : 2)
PROPER
CAPS
UPPER
LOWER
(TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon. (Points : 2)
Merge
Mailings
Home
Review
(TCO 8) The New Comment command is located on the ________ tab. (Points : 2)
View
Review
Data
File
(TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need: (Points : 2)
Empty columns to the right of column C.
Empty rows at the bottom of the worksheet.
Empty columns to the left of column C.
Empty rows at the top of the worksheet.
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-4-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 5 iLab Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-5-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
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.
http://www.assignmentclick.com/bis-155/bis-155-week-5-ilab-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
DEVRY BIS 155 Week 5 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-5-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
(TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2)
Gray
Yellow
Blue
White
(TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets? (Points : 2)
Click the first tab, hold Shift, and then click the last tab
Click the first tab, hold Ctrl, and then click last tab.
Right-click a worksheet tab, then select Select All Sheets.
Right-click a worksheet tab, then select Group.
(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window. (Points : 2)
The letter B
The number 2
The letter A
The number 1
(TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? (Points : 2)
Drag a split box
Double-click a split box.
Right-click in the active cell and click Split.
Click Split in the Window group on the View tab.
(TCO 5) If a worksheet name has a space in it, ________ surround the worksheet name in the worksheet reference. (Points : 2)
Double quotation marks
Single quotation marks
Parentheses
Brackets
(TCO 5) Which formula would return the #NAME? error? (Points : 2)
=SUM(B6.B12)
=MAX(B6:B12)
=AVG(B6:B12)
=IF(A6=”Atlanta”,A3,0)
(TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)
A1
Check this A+ tutorial guideline at
http://www.assignmentclick.com/bis-155/bis-155-week-5-quiz-data-analysis-with-spreadsheets-with-lab
For more classes visit
http://www.assignmentclick.com
