Explain the key factors of workbook design

Assignment Help Basic Computer Science
Reference no: EM13555821

(TCO 1) You have been given the task of designing a very important workbook that will contain very important data to be reviewed by very important people over and over again. Explain the key factors of workbook design you should consider in accomplishing this task.
Answer:

Question 2. 2. (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?

Question 3. 3. (TCO 3) You are an analyst for the Vanguard Mortgage Company has been using a spreadsheet created by you in the past which functions well. The current worksheet you created currently contains the customer's account, the cost of the house, down payment, amount financed, mortgage rate, loan years (e.g. 30 year), % financed, date financed and payoff year. You have been tasked with enhancing the worksheet to include noted basic summary statistics. Which sorts of summary statistical methods would you include in the updated workbook? Describe at least six statistical measures that you would use so that you could explain them to your supervisor.

Question 4. 4. (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

Question 5. 5. (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.

Reference no: EM13555821

Questions Cloud

Calculate the annual rate of return for the new machine : Prepare an incremental analysis for the 4 years showing whether Morganstern should keep the existing machine or buy the new machine and calculate the annual rate of return for the new machine.
Estimate what is the pressure of the water : A horizontal pipe contains water at a pressure of 150 kPa flowing with a speed of 2.0 m/s. The pipe narrows to one-half its original diameter. What is the pressure of the water
Estimate what is the air temperature : A sound wave in air has a frequency of 500 Hz and a wavelength of 0.68 m. What is the air temperature
Evaluate the wavelength of this radiation : The Big Bang Theory suggests leftover background radiation. Find the wavelength of this radiation
Explain the key factors of workbook design : The task of designing a very important workbook that will contain very important data to be reviewed by very important people over and over again. Explain the key factors of workbook design you should consider in accomplishing this task.
How far can the canoeist paddle in still water : A canoeist attempts to paddle a canoe due east, directly across a river. Unfortunately there is a current, flowing south at a rate of 3.4 m/s. How far can the canoeist paddle in still water
Accrual basis accounting : Analyze and record the January transactions for Oasis Health Care Inc., using the integrated financial statement framework. Record each transaction by date, and show the balance for each item after each transaction.
Magnitude of the force on electron between the plates : Oppositely charged parallel plates are separated by 5.39 mm. A potential difference of 600 V existsbetween the plates. What is the magnitude of the electric field between the plates?
What is the necessary absolute pressure the pump must exert : A fountain designed to spray a column of water 14 m into the air has a 3 cm diameter nozzle at ground level. What is the necessary absolute pressure the pump must exert

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd