Ask Question, Ask an Expert

+61-413 786 465

Ask Financial Accounting Expert

Excel Quiz

1. Start Excel 2016 and download and open the file Excel Quiz1F18.

2. Save the workbook as FirstName_LastName_Excel_Quiz1 where FirstName is your own First Name and LastName is your Surname (for example Roger_de_Peiza_Excel_Quiz1).

3. On the Debt worksheetselect the range A1:I1, fill with Colour Purple Accent 4, and then Merge and Center.

4. Change the width of columns B to I to 90 pixels.

5. Wrap text in cells H2:I2.

6. In the range B8:H8, insert the column totals. Ensure that all the totals are properly seen.

7. Apply the Total cell style to range B8:H8only and then display no decimals.

8. In cell I3, calculate the Percent of Total Debt. In your formula, use an absolute cell reference when referring to cell H8.

9. AutoFill the formula down through cell I7, and then format the results as percentages with one decimal place.

10. In the range B10:G10, insert a function to calculate the highest monthly debt. In the range B11:G11, insert a function to calculate the lowest monthly debt. In the range B12:G12, insert a function to calculate the average monthly debt.

11. Insert a 3D Pie chart based on the nonadjacent ranges A2:A7 and H2:H7. Move the pie chart to a chart sheet with the sheet name Debt Chart.

12. For the pie chart, apply Layout 6, and then apply the Chart Style 8.

13. Change the data label Font Size to 12. Fill the chart background with blue, accent 1, lighter 80%.

14. Pull out slightly the largest piece of the pie.

15. Go back to the Debt worksheet, insert a 3D Clustered Column chart based on the range A2:G7.

16. Move the chart below the data, and then resize the chart to approximately the range A15:I38. Apply the chart Style 3.

17. Change the title of the chart to Aspen City Debt.

18. Insert three sheet rows at the top of the worksheet (before row 1).

19. Insert WordArt, using the style Gradient Fill - Purple, Accent 4, Outline - Accent 4.

20. Change the WordArt text to Aspen Falls and then change the FontSize to 36.

21. Move the WordArt to the top of the worksheet, centering it above the text "City Debt" on row 4.

22. Save your workbook.

23. Group the1st Quarter, 2nd Quarter, 3rd Quarter and 4th Quarter worksheets.

24. In cell E5, construct a formula to compute Net Income = Income - (Indirect Costs + Direct Costs).

25. AutoFill the formula down through cell E7.

26. In the nonadjacent ranges B5:E5 and B8:E8, apply the Currency [0] cell style.

27. Insert a new worksheet.

28. Rename the new Worksheet tabSummary and apply the worksheet tab color Orange, Accent 6.

29. Move the new worksheet tab to before the 1stQuarter worksheet.

30. Copy the range A1:E4 from any of the detail worksheets, and then on the Summary sheet, click cell A1. Paste the range using the Keep Source Column Widths paste option.

31. Change the subtitle of cell A2to City Center Annual Revenue and then change the label in cell A4 to Quarter.

32. In cell A5, type 1st Quarter and then AutoFill the labels in the range A6:A8. In cell A9, type Total

33. In the Summary worksheet, enter a formula in cell B5 setting the cell to equal cell B8 in the 1st Quarter worksheet.

34. Enter the Income total from the 2nd Quarter, the 3rd Quarter, and the 4th Quarter worksheets in the range B6:B8.

35. Select the range B5:B8, and then use the Quick Analysis Lens button to insert the column total.

36. AutoFill the range B5:B9 to the right through column E.

37. In row 9, apply the Total cell style.

38. Set the cell style of ranges B5:E5 and cells B9:E9to currency[0] and cell style of the range B6:E8to comma [0].

39. Autofit columns A to E.

40. Insert a Clustered Bar chart using the nonadjacent ranges A4:A8 and C4:D8 as the source data.

41. Move the chart to a chart sheet with the sheet name City Cost Chart.

42. Apply the Style 10 chart style.

43. Change the Chart Title to City Center Costs.

44. Save your workbook.

45. On the Recycling worksheetclick on cell E3 and insert the NOW function.

46. Select A5:G5, and apply a BottomBorder.

47. In F6:F27, insert Line Sparklines using the data in columns B:E.

48. Show the Low Point on the Sparklines.

49. In G6, insert the IF function. For the logical test, check whether theFY 2017 result is greater than the FY 2016 value in the same row.If the logical test is TRUE, Yesshould be displayed, and if it is FALSE,Needs Workshould be displayed.

50. Center the results, and then AutoFillG6 down through G27.

51. Select G6:G27. Apply a Text Contains conditional format that will display any cells that contain Needs Work formatted with Light Red Fill.

52. Save your workbook.

53. Create a copy of the Recycling sheet, and move the copy to the end of theworkbook. Rename the new worksheet tab Improvements.

54. On the Improvementssheet, format A5:G27 as an Excel table, usingthe Table Style Light 16.

55. Filter column G to display only the rowsthat improved from the previous year.

56. Display the Total row, and then display the four FY sums. In G28,select None.

57. Sort the FY 2016column from the smallest to the largest value.

58. Hide column B.

59. Save your workbook.

60. Group all the worksheets. Change the page orientation to Landscape.

61. Add the file name in the left footer and the sheet name in the rightfooter.

62. Enter your name in the Center section of the Header

63. Adjust the page width to one page.

64. Ensure that you are viewing your worksheets in Normal View.

65. Ungroup the sheets.

66. Save your workbook.

67. Upload your completed workbook to the Excel Quiz 1 dropbox.

Attachment:- Excel

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M93131559
  • Price:- $120

Guranteed 48 Hours Delivery, In Price:- $120

Have any Question? 

Related Questions in Financial Accounting

What has been strides position on dividend payouts in the

What has been Strides' position on dividend payouts in the past (pattern, relationship with earnings, etc.)? What factors affected its dividend policy?

Assessment 1develop complex spreadsheetsthis is an

Assessment 1 Develop Complex Spreadsheets This is an assessment that may be worked on in study time and as homework. Assessment presentation should be completed in a manner that is appropriate to professional business re ...

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r-­-e". The revenue and expenses f ...

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

Consider the following account starting balances and

Consider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance of Cash is ...

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

Budgets and managerial responsibilitythis module explores

Budgets and Managerial Responsibility This module explores budgets and the benefits of creating budgets. In recent years, many organizations faced one of the hardest economic conditions with the recession. Many organizat ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

The ipl just signed sachin to a contract consisting of

The IPL just signed Sachin to a contract consisting of eight, end-of-year payments worth $9 million each, with the first payment precisely one year from today. On the other hand, Dhoni recent deal calls for six annual pa ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As