Shopping Cart
Your shopping cart is empty!
Categories
BIS 221T Week 3 Apply Excel Exam
$1.99

BIS 221T Week 3 Apply Excel Exam

This Tutorial was purchased 9 times & rated A+ by student like you.

 

This Tutorial contains following Attachments

  • BIS 221 file to be attached.docx

BIS 221T Week 3 Apply Excel Exam

Howard, the manager of QuickStove, would like to maintain a list of customers from the United Kingdom in an Excel worksheet. He needs help to format the worksheet so that it will be easier to use. Complete the follow tasks to appropriately format, sort, and filter the worksheets in this workbook.

Insert a new column between columns C and D. Label the new column (cell D3) “Customer ID”

0 / 2  (0.0%)

 

Feedback:

 

[-2] Did not insert and label “Customer ID” column

 

Use the “Fill” feature of Excel to insert the numbers 1 to 73 in cells D4:D76.

2 / 2.0  (100.0%)

 

Make the table headers (range B3:K3) bold

1 / 1.0  (100.0%)

 

Center the table headers (range B3:K3) horizontally

1 / 1.0  (100.0%)

 

Make cell B2 bold

1 / 1  (100.0%)

 

Italizice cell B2

1 / 1  (100.0%)

 

Make cell F2 bold

1 / 1  (100.0%)

 

Italizice cell F2

1 / 1  (100.0%)

 

Merge and center cell F2 across columns F:K

2 / 2  (100.0%)

 

Change the format of the date range (E4:E76) to “Short Date” – display as MM/DD/YY.

1 / 1.0  (100.0%)

 

Resize column B to a width of 13.73 (1.2 inches/3.05 cm)

1 / 1  (100.0%)

 

Resize column C to 11.36 (1 inch/2.54 cm)

1 / 1  (100.0%)

 

Resize column D to 10.64 (.94 inches/2.39 cm)

1 / 1  (100.0%)

 

Resize column E to 10.09 (0.89 inches/2.26 cm)

1 / 1  (100.0%)

 

Resize column F to 24 (2.06 inches/5.23 cm) – notice this is not large enough to fit all of the cell contents for all cells.

1 / 1  (100.0%)

 

Resize column G to 24 (2.06 inches/5.23 cm) – notice this is not large enough to fit all of the cell contents for all cells.

1 / 1  (100.0%)

 

Resize column H to 14.73 (1.28 inches/3.25 cm)

1 / 1  (100.0%)

 

Resize column I to 19.27 (1.65 inches/4.19 cm)

1 / 1  (100.0%)

 

Resize column J to 10.09 (0.89 inches/2.26 cm)

1 / 1  (100.0%)

 

Center the cells in the table (range B4:K76) horizontally

2 / 2.0  (100.0%)

 

Notice that all of the customers are from the United Kingdom, so there is no reason to display the Country column (column K). Hide column K.

1.5 / 1.5  (100.0%)

 

Place a “Thick Bottom Border” (from the border drop-down menu) under the data labels (range B3:J3)

1 / 1  (100.0%)

 

Place a dotted line border (the option directly under “None” in the “Border” tab of the “Format Cells” dialog window) under each subsequent row in the table.

2.5 / 2.5  (100.0%)

 

Fill rows 2 and 3 of the table (range B2:J3) using any color (not “No Fill”) from the “Fill Color” drop-down menu.

1.5 / 1.5  (100.0%)

 

Use the “Wrap Text” feature in Excel to display all of the contents of cells F4:G76. Resize the rows if necessary to fit the contents of the cells.

2.5 / 2.5  (100.0%)

 

Set the print area of the worksheet to include only the area of the data table (Range B2:K76)

2 / 2  (100.0%)

 

Set the left and right print margins of the worksheet to be .5 inches (1.27 centimeters). Note: you may need to select a printer in the File menu before you can set the page margins.

2 / 2  (100.0%)

 

Your report may print on more that one page. You want the last name for each customer to repeat on each page of the report. To do this, set column C as “Columns to repeat at left” page titles for this worksheet.

0 / 1.5  (0.0%)

 

Feedback:

 

[-1.5] “Columns to repeat at left” page titles not set correctly

 

You want to make a second copy of the address book in a new worksheet. Insert a new worksheet in the workbook. Change the name of the worksheet to “Address Book Copied”

1.5 / 1.5  (100.0%)

 

Copy the Address Book table (range B2:J76) to the “Address Book Copied” worksheet using the “Copy” and “Paste” features of Excel. Paste the range starting in cell B2 of the “Address Book Copied” worksheet.

2 / 2  (100.0%)

 

You want reaarange the customers on the table in the “Address Book Sorted” worksheet to display customers by the city they live in and then by their last name. In the same sort, first sort the table on the “Address Book Sorted” worksheet by City in ascending order (A to Z) then sort the table by Last Name in ascending order (A to Z).

0 / 4  (0.0%)

 

Feedback:

 

[-4] The Customer Address Table is not sorted correctly

 

Filter the table on the “Address Book Sorted” worksheet to display only customers whose “Province” contains the text “shire”.

4 / 4  (100.0%)

 

You have decided to purchase a new car. You plan to take out a loan to pay for the car. The loan amount is $18,900. You will pay 6.5% interest and will pay off the car in 48 months. You are interested in calculating the total amount of money and the total amount of interest you will pay over the course of the loan. To help you with these calculations, you decide to construct an amortization table. An amortization table provides details about the payment, interest amount, principle amount, and loan balance for every month of the loan. Complete the tasks to complete the amortization table and the summary calculations below.

Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function that you use. (Notice that “Payment” on the table fills with the payment amount in cell C15.)

Amortization!C15: =PMT(C13/C12,C12,C11,0,)

 

6 / 9  (66.7%)

 

Feedback:

 

[-3] The value in cell C15 is not correct

 

Calculate the interest amount for period 1 in cell D20 by multiplying balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12 (to create a montly interest rate). This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period.

Amortization!D20: =F19*C13/12

 

6 / 6  (100.0%)

 

Copy the interest amount calculation down to complete the “Interest” column of the amortization table.

0 / 3  (0.0%)

 

Feedback:

 

[-3] The interest values in column D are not correct

 

Calculate the principle amount for period 1 in cell E20. The principle amount is the difference between the payment amount (cell C20) and the interest amount (cell D20) for period 1. Construct your formula in such a way that it can be reused to complete the interest column of the amortization table.

Amortization!E20: =C20-D20

 

6 / 6  (100.0%)

 

Copy the principle amount calculation down to complete the “Principle” column of the amortization table.

3 / 3  (100.0%)

 

Calculate the balance for period 1 in cell F20. The balance is the difference between the balance for period 0 (cell F19) and the principle amount for period 1 (cell E20). This formula is reusable. The balance is always calculated as the difference between the balance from the previous period and the principle amount for the current period.

Amortization!F20: =F19-E20

 

6 / 6  (100.0%)

 

Copy the balance amount calculation down to complete the “Balance” column of the amortization table.

3 / 3  (100.0%)

 

Calculate the “Total Amount Paid” in cell G12 by multiplying the payment amount (cell C15) by the term of the loan (cell C12).

Amortization!G12: =C15*C12

 

6 / 6  (100.0%)

 

Calculate the total interest paid in cell G13. The total interest paid is the sum of all interest paid on the amortization table.

Amortization!G13: =SUM(D20:D67)

 

9 / 9  (100.0%)

 

You can check to see if the total interest calculation from the amortization table is correct. The total interest paid is also equal to the difference between the Total Amount Paid” over the course of the loan and the original loan amount. Insert a formula into cell G14 to check the result of the SUM calculation you just made in cell G13. This formula should calculate the difference between the total amount paid and the original loan amount (notice the negative sign associated with the original loan amount).

0 / 6  (0.0%)

 

Feedback:

 

[-3] The value for the SUM check calculation in cell G14 is incorrect

 

[-3] The formula for the SUM check calculation in cell G13 is incorrect

 

Assume you have made the first 36 payments on your loan. You are interested in trading the car in for another new car. You believe that you can sell your car for $4000. Will this cover the balance remaining on the car in period 36? Answer either “Yes” or “No” in cell G15.

Amortization!G15: No

 

3 / 3  (100.0%)

 

Consider the tables on the “Google” worksheet that detail the revenue for Google, Inc. from 2003 to 2010. Complete the tasks to construct a column, stacked column, pie, and line chart to discover patterns or trend in revenue across the eight years.

Construct a column chart to examine the total annual revenue for Google, Inc. from 2003 to 2010 (use the data on table 1 – range C12:J12). Format the chart with the title on top “Total Google Revenue”, the years across the horizontal axis, and no legend.

8 / 11  (72.7%)

 

Feedback:

 

[-3] The horizontal axis labels for the “Total Google Revenue” chart are not correct.

 

Add a linear trend to the “Total Google Revenue” chart.

2 / 2  (100.0%)

 

Construct a stacked column chart to compare the revenue totals for each year (use the quarterly revenue totals – range C8:J11). Format the chart with the title “Google Revenue by Quarter”, the year as the horizontal axis, and a legend that depicts each quarter from the text labels provided in the tables. Do not include the “Total Annual Revenue” (range C12:J12) in the chart.

12 / 18  (66.7%)

 

Feedback:

 

[-3] The “Quarterly Google Revenue” chart type is not correct.

 

[-3] The horizontal axis labels for the “Quarterly Google Revenue” chart are not correct.

 

Construct a pie chart to compare the business segments for 2010 (range J16:J18). Format the chart with the title “Google Revenue by Business Segment”, a legend that depicts each business segment, and data labels with the percentage for each segment on the chart.

11 / 13  (84.6%)

 

Feedback:

 

[-2] The category labels for the “Google Segments” chart are not correct.

 

Construct a line chart to examine the “Total Annual Revenue” for Google, Inc. from 2003 to 2010 (use the data on table 2 – range C19:J19). Format the chart with the title on top “Google Revenue Line”, the years across the horizontal axis, and no legend.

7 / 9  (77.8%)

 

Feedback:

 

[-2] The horizontal axis labels for the “Google Revenue Line” chart are not correct.

 

Add a linear trend to the “Google Revenue Line ” chart.

2 / 2  (100.0%)

 

Completed assignment file:

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$5.00

This Tutorial was purchased 4 times & rated A by student like you.

Resources: Week 5 Learning Team Collaborative Discussion Research an example of a new or emerging technology. Write a 350- to 700-word paper in which you discuss the uses of emerging technology in your professional life. In this paper be sure to:  Identify an e..
$6.00

This Tutorial was purchased 2 times & rated No rating by student like you.

Create an 8- to 12-slide Microsoft® PowerPoint® presentation, including detailed speaker notes, in which you discuss your personal brand and future story. Include the following in the presentation:  A biographical description of who you are (e.g. your family, where you grew up, ..
$6.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Resources: Week 3 Learning Team Collaborative Discussion  Research a current article on the use of wireless technologies in the workplace.  Write a 350- to 700-word summary of your selected article on wireless technology. Be sure to also include the following:&nbs..
$6.00

This Tutorial was purchased 5 times & rated B+ by student like you.

Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following: Create a label called "Income" and add your monthly business income in the next cell: $42000. Add a label called "Rent" and enter the amount in the next cell: -$2000. Add a ..
$6.00

This Tutorial was purchased 6 times & rated B+ by student like you.

Research the importance of information systems and information security in the work environment. Write a 700- to 1,050-word summary of your research findings using Microsoft® Word® Template. Include the following  in your summary using the features of Microsoft Word: ..
$5.00

This Tutorial was purchased 4 times & rated No rating by student like you.

Resources: Week 2 Learning Team Collaborative Discussion Write a 350-word summary of the Learning Team Collaborative Discussion including your own personal views on ethics and privacy as they relate to information security. Save the Microsoft® Word® document saved under the foll..
$5.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Create a Microsoft® Word® document saved under the following format: Lastname_Course#_W1.doc Research three different brands of computers using an Internet search engine (e.g. Google™, Bing™, Yahoo™, etc.). Research the benefits of information systems in the work environmen..
$35.00

This Tutorial was purchased 9 times & rated A+ by student like you.

BIS 221 Week 1 Hardware and Software Recommendations   BIS 221 Assignment Week 2 Apply Customer Service Support Proposal   BIS 221 Assignment Week 3 Sales Analysis    BIS 221 Assignment Week 4 Presentation Alternative    ..
$8.00

This Tutorial was purchased 6 times & rated No rating by student like you.

This Tutorial contains 2 Presentation   BIS 221 Week 5 Online Productivity Applications Purpose of Assignment  This assignment will demonstrate the student’s ability to use online productivity tools and how they contribute to increased productivity in the work environmen..
$8.00

This Tutorial was purchased 9 times & rated B+ by student like you.

This Tutorial contains 2 Presentations   BIS 221 Week 4 Social Media and Online Collaboration Tools Purpose of Assignment  The purpose of this assignment is to familiarize students with the multiple collaboration tools available. Students will evaluate three online colla..
$8.00

This Tutorial was purchased 14 times & rated No rating by student like you.

This Tutorial contains 2 Set of Budget   BIS 221 Week 3 Business Budget Purpose of Assignment  Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and ..
$8.00

This Tutorial was purchased 3 times & rated A+ by student like you.

This Tutorial contains 2 Papers   BIS 221 Week 2 Business Value of Software Applications Purpose of Assignment  Security in the work place is a major concern businesses must address to protect company data. In addition, to automated security, it is also the company’s res..
$5.00

This Tutorial was purchased 9 times & rated B+ by student like you.

BIS 221 Week 2 Charter: Individual Assignment Resources: Week 2 Learning Team Collaborative Discussion and the Learning Team Charter for Collaborative Learning Activities. Write a 150- to 200-word individual response to the following: Consider the multiple definitions of..
$8.00

This Tutorial was purchased 35 times & rated No rating by student like you.

This Tutorial contains 2 Papers   Purpose of Assignment  The purpose of this assignment is to understand what basic hardware and software components make up a computer. Students will research hardware components, operating system software, and application software to determi..
$7.99

This Tutorial was purchased 33 times & rated A+ by student like you.

Purpose of Assignment  In this assignment, you to develop your skills using Microsoft® Word to address a business case.   Assignment Steps  Resources:  •Microsoft® Office Help and Training  •Other tutorials available online     &nbs..
$6.99

This Tutorial was purchased 3 times & rated A by student like you.

Purpose of Assignment This assignment will help you assess hardware and software  specifications for different computer and business purposes, and  provides the student with an opportunity to explore and apply options to  satisfy various needs. Assignment Steps Resource..
$7.99

This Tutorial was purchased 16 times & rated A by student like you.

In this assignment, you apply Microsoft® Excel® formatting to a business example. You will use this skill to enter and analyze data using charts.   Assignment Steps  Resources:   •Microsoft® Office Help and Training  •Other tutorials available online ..
$9.99

This Tutorial was purchased 13 times & rated A by student like you.

Purpose of Assignment In this assignment, you apply integrated office software and social media applications to resolve specific business needs. Assignment Steps Resources:  • Microsoft® Office Help and Training • Other tutorials available online Create a 15- to 20-sl..
$9.99

This Tutorial was purchased 17 times & rated A by student like you.

Purpose of Assignment In this assignment, you research alternative applications to Microsoft® PowerPoint®, and practice using PowerPoint® to present those alternatives and make a recommendation. You may research applications by developers other than Microsoft if you desire. Assignment Ste..
$6.99

This Tutorial was purchased 6 times & rated A+ by student like you.

BIS 221 Week 1 Apply Week 1 Exam Complete the Week 1 Exam in MyEducator®. Note: You have only one attempt available to complete this assignment. Grades must be transferred manually to eCampus by your instructor. Don’t worry, this might happen after your due date &nb..
$6.99

This Tutorial was purchased 5 times & rated A+ by student like you.

BIS 221 Week 1 Practice Week 1 Knowledge Check Complete “Practice: Week 1 Knowledge Check” in MyEducator®. Note: You have unlimited attempts available to complete this practice assignment. The highest scored attempt will be recorded. These assignments have earlier due ..
$1.99

This Tutorial was purchased 7 times & rated B+ by student like you.

BIS 221T Week 2 Apply Wandering Travel Report Complete the “8.10 Week 2 Apply: Wandering Travel Report” activity in MyEducator®. Note: You have only one attempt available to complete this assignment. Grades must be transferred manually to eCampus by your instructor. Don..
$1.99

This Tutorial was purchased 4 times & rated No rating by student like you.

BIS 221T Week 2 Practice Creating Professional Letters This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the mo..
$1.99

This Tutorial was purchased 4 times & rated A by student like you.

BIS 221T Week 2 Practice Editing a Report This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. ..
$1.99

This Tutorial was purchased 9 times & rated A+ by student like you.

BIS 221T Week 2 Practice Working with Tables Working With Tables   This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see wh..
$1.99

This Tutorial was purchased 11 times & rated A+ by student like you.

BIS 221T Week 3 Practice Charting The Education table contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemployment. ..
$1.99

This Tutorial was purchased 8 times & rated A+ by student like you.

BIS 221T Week 3 Practice Excel Basics Insert a new column between columns B and C. Label the new column (cell C3) “Record ID” World Records!C3: Record ID 1 / 1  (100.0%) Feedback: Use the “Fill” feature of Excel to insert the numbers 1 to 47 in cells C4:C50. ..
$1.99

This Tutorial was purchased 6 times & rated A+ by student like you.

BIS 221T Week 3 Practice Formulas and Functions You are responsible for tracking daily sales. The table below lists a few of transactions for your company. Notice that the sales tax amount and transaction totals are not filled in. Complete the tasks to the right to complete the table. ..
$1.99

This Tutorial was purchased 6 times & rated A+ by student like you.

BIS 221T Week 4 Apply Travel Spotlight Karen works at the West Coast Travel Agency. She has asked you to help her complete the travel spotlight on Peru. On the “Title and Content” Custom Layout of the Slide Master make the following three additions: Add the “westcoastlogosmall” imag..
$1.99

This Tutorial was purchased 4 times & rated No rating by student like you.

  BIS 221T Week 4 Practice Developing a Presentation This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need..
$1.99

This Tutorial was purchased 4 times & rated No rating by student like you.

  BIS 221T Week 4 Practice Developing PPT Designs This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need th..
$1.99

This Tutorial was purchased 4 times & rated A+ by student like you.

BIS 221T Week 4 Practice Editing a Presentation This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most prac..
$1.99

This Tutorial was purchased 4 times & rated No rating by student like you.

BIS 221T Week 4 Practice Editing PPT Designs This assignment has a total of 100 points.   Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practic..
$1.99

This Tutorial was purchased 4 times & rated A+ by student like you.

BIS 221T Week 5 Apply LinkedIn Profile Apply: Week 5 LinkedIn Profile Purpose of Assignment   Social media is becoming increasingly used to conduct business transactions, and for many businesses it has become a primary tool for marketing communications, sales, and customer su..
$6.99

This Tutorial was purchased 4 times & rated A+ by student like you.

BIS 221T Week 5 Practice Knowledge Check The term “App” is derived from shortening what word? Application Appease Appropriate Applicative What is Doug Cutting’s son’s toy elephant’s name? Edvald Edward Hadoop Eugene What is a schematic b..