BIS 155 DEVRY Assignments,BIS 155 DEVRY Tutorials Flashcards Preview

Uop Assignments,DEVRY Assignments,Ashford Tutorials > BIS 155 DEVRY Assignments,BIS 155 DEVRY Tutorials > Flashcards

Flashcards in BIS 155 DEVRY Assignments,BIS 155 DEVRY Tutorials Deck (6):
1

BIS 155 Week 1 to Week 7 All Discussions
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-to-week-7-all-discussions

BIS 155 Week 1 to Week 7 All Discussions
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-to-week-7-all-discussions

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.

You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 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.

BIS 155 Week 3 DQ Data Analysis

Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amounts of sales data you have. What are some of the ways Excel can be used to analyze this data? What are some examples of reports you might want to review?

Using the concepts from this week, how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions?

BIS 155 Week 4 DQ Excel Data Exchange

Excel 2010 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?

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.

BIS 155 Week 5 DQ Data Consolidation and What

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.

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. What are some spreadsheet features you will use to make your spreadsheet professional, readable, reliable, and repeatable? Which spreadsheet functions and data analysis types do you think will be the most challenging to implement in this project? What questions do you have about those functions and types of data analysis?

BIS 155 Week 7 DQ Database Decisions

Discuss the differences between storing data in Access and Excel. Why would you use a spreadsheet over a database? At what point does it become more efficient to store your data in a database rather than a spreadsheet? If you are deciding whether to use a spreadsheet or database, what questions should you consider?

For more Assignments visit

http://www.uopassignments.com

2

BIS 155 Week 1 to Week 5 All Quiz
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-to-week-5-all-quiz

BIS 155 Week 1 to Week 5 All Quiz
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-to-week-5-all-quiz

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

For more Assignments visit

http://www.uopassignments.com

3

BIS 155 Week 1 Quiz Data Analysis with Spreadsheets with Lab
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-quiz-data-analysis-with-spreadsheets-with-lab

BIS 155 Week 1 Quiz Data Analysis with Spreadsheets with Lab
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-quiz-data-analysis-with-spreadsheets-with-lab

(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

(TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)

Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Why would you use cell references in formulas instead of constant values? (Points : 2)

You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

(TCO 1) In Excel 2010, a column width ________. (Points : 2)
is adjustable so you can display more or less characters in a columnis not adjustable so keep the formulas as short as possible
always switches back to default

is best left unchanged unless you absolutely have to

(TCO 1) Which of the following best describes a “Range” in Excel 2010? (Points : 2)

Cannot be selected with the mouse

Are the numbers that fall between the smallest and largest in the formula

Is another word for the active worksheet

Refers to a group of adjacent or contiguous cells

(TCO 1) The fill handle in Excel 2010 _______. (Points : 2)
is the fastest way to type A1 in the name box

helps carry over the fill to the remaining slides

is the same action as pressing “Enter”

is a small black square at the bottom-right corner of a cell that facilitates fill operations

(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula? (Points : 2)

Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula

Has two or more sub-commands related to the command

(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

A shortcut to cell A1

There are two or more sub-commands related to the command

The next step in the process

Directionality

(TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a: (Points : 2)

Workbook.

Ledger

Document

Journal

(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010? (Points : 2)

Refers to the up-down position of contents in a cell

Removes the vertical lines running through the data

Puts a line horizontally through the data

Refers to the left-right position of contents in a cell

(TCO 1) Which of the following best describes a cell address?

Identifies the electronic “neighborhood” of a spreadsheet

Identifies a cell by a column letter and a row number

Searches for and displays similar labels as you type

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Which of the following best describes the AutoComplete function?

Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

Includes letters, numbers, and spaces

Controls the sequence in which Excel performs arithmetic operations

Is a software application used to create and modify business communications

Includes formulas, functions, and formatting

(TCO 1) When you paste copied data, Excel displays the Paste Options button:

In the status bar at the left of the screen

In the next set of nonadjacent ranges

On the toolbar

In the bottom right corner of the pasted data

(TCO 3) A data series is a group of related ____________. (Points : 2)

Charts on a worksheet

Category labels on a horizontal axis

Data points on a chart

Numerical values on a vertical axis

(TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _________. (Points : 2)

line chart

bar chart

pie chart

doughnut chart

(TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: (Points : 2)

diagram.

pop-up comment box.

legend.

note.

(TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)

Shows values as percentages of the whole but may contain more than one data series

Shows the high, low, and close prices for individual stocks over time

Shows trends using two dimensions on a continuous curve

Shows a relationship between two variables
(TCO 3) Which of the following best describes a column chart? (Points : 2)

Displays data comparisons vertically in columns

A horizontal line that borders the plot area to provide a frame of reference for measurement

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

(TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)

Compares values for one set of data

Groups or clusters similar data in columns to compare values across categories

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Compares two or more sets of data in one chart

(TCO 3) When creating a chart in Excel, a multiple data series _______. (Points : 2)

Groups or clusters similar data in columns to compare values across categories

Compares two or more sets of data in one chart

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color

(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart. (Points : 2)

Expanded

Exploded

Displaced

Clustered

(TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: (Points : 2)

Design, Layout, and Format

Home, Insert, and Page Layout

Chart, Type, and Formulas

Data, Review, and Data

(TCO 3) Which of the following best describes a sparkline? (Points : 2)

A label that describes either the category axis or the value axis

A miniature chart contained in a single cell

The value or name of a data point

A label that describes the chart

(TCO 3) Groups of related numeric values in an Excel worksheet are:

Data point

Data roles

Categories

Data series

(TCO 3) Which of the following best describes the chart area?

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

A vertical line that borders the plot area to provide a frame of reference for measurement

A horizontal line that borders the plot area to provide a frame of reference for measurement

(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

Stacked column chart

Pie chart

3-D column chart

Box diagram

(TCO 3) In Excel, an area chart _______

Shows the high, low, and close prices for individual stocks over time

Trends using two dimensions on a continuous curve

Emphasizes the magnitude of changes over time by filling in the space between lines with a color

Shows a relationship between two variables

(TCO 3) After creating a chart, you can change the chart type by using _____.

Page Layout tab / Chart Options button

Design tab / Change Chart Type button

Data tab / Chart Changer tool

You cannot change the chart

For more Assignments visit

http://www.uopassignments.com

4

BIS 155 Week 1 iLab Data Analysis with Spreadsheets with Lab
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-ilab-data-analysis-with-spreadsheets-with-lab

BIS 155 Week 1 iLab Data Analysis with Spreadsheets with Lab
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-week-1-ilab-data-analysis-with-spreadsheets-with-lab

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.

For more Assignments visit

http://www.uopassignments.com

5

BIS 155 Final Exams
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-final-exams

BIS 155 Final Exams
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-final-exams

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)
(TCO 5) You work for a local construction firm “DeVry Engineering Group” and your supervisor, Jessica, needs an updated earned value analysis index of the prior month for an existing capital project (0000001) that has a current Budget at Completion (BAC) of $1500.00, a current earned value of (EV) of $300, a current actual cost (AC) of $500.00, and a current planned value (PV) of $350.00. In order to calculate the current average index, assume the following variables and standard formulas below:

Cost Variance (CV) EV–AC
Cost Performance Index (CPI) EV/AC
Schedule Variance (SV) EV–PV
Schedule Performance Index (SPI) EV/PV
Estimate to Completion (ETC) EAC–AC
Estimate at Completion (EAC) BAC/CPI
Variance at Completion (VAC) BAC–EAC
Status (Earned Value Index) (EVI) (CPI+SPI)/2

Also assume that a final calculated average index of 1.00 or greater represents a project being on track and in good standing. In addition, there could be several options for the descriptive methods to design this worksheet and below is a worksheet setup with the following “3” columns including any other needed top labels like for the existing Month already calculated.

Based on the current calculated earned Status (Earned Value Index) for work order 0000001, is the current capital project in good standing?

Your supervisor, Jessica, wants the worksheet, on row 16 or 17, to automatically provide a project status as being “In the Red” (Poor Standing) or “In the Black” (Good Standing). Explain descriptively how you could use a conditional formula to report the project status.

Your Supervisor, Jessica, has 3 additional projects with work orders, 0000002, 0000003, and 0000004 she wants added to this Excel Workbook where each work order is monitored on a separate worksheet like work order 0000001. Jessica would like to have a summary worksheet which compiles all information for all work orders. The overall design of the summary worksheet will match the same general design as with work orders 0000001 through 0000004. Descriptively describe steps needed to link these worksheets together along with any ideas for formulas and functions to give an overall picture of all project work orders combined so that Jessica can see an overall holistic view of the Status (Earned Value Index) across all these work orders being managed.

Based on the summary worksheet, Jessica, would like to see a chart which can help with future projections of the Status (Earned Value Index). Descriptively describe which chart you would recommend with any features that will help Jessica with future projections. Also using your intuition and creative mind, descriptively describe if any other information needs to be charted from the summary worksheet which may help Jessica with future cost projections and why? (Points : 40)

(TCO 5) A table named “Daily Sales” in a Microsoft Access database has the following fields:

Product A
Product B
Product C
Product D

Each record on the table represents a day of total sales for each product and the data covers the last five years. Your boss asks you to create a visual report of the sales performance of each product during the last 12 months.

Prepare a step-by-step description of how you would use Microsoft Excel to prepare the report and email it to your boss following these steps:

Step 1 – Import data from Access to Excel
Step 2 – Summarize Monthly Data for each product during the last 12 months
Step 3 – Create a visual representation of monthly data
Step 4 – Email the spreadsheet with your comments to your boss (Points : 40)

(TCO 9) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel 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.

For more Assignments visit

http://www.uopassignments.com

6

BIS 155 Entire Course with Final Exam (NEW)
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-entire-course

BIS 155 Entire Course with Final Exam (NEW)
To Buy This material Click below link

http://www.uopassignments.com/bis-155/bis-155-entire-course

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

For more Assignments visit

http://www.uopassignments.com

Decks in Uop Assignments,DEVRY Assignments,Ashford Tutorials Class (524):