Computers and Technology, 07.03.2020 04:20 bumeh511

Read the brief case below.

Using the Excel spreadsheet provided, complete the questions.

Downtown Office Supply

Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for busy times of the year. Instructions:In the excle spreadheet provided, complete the tasks below. Upon completion you will submit a single, completed, Excel workbook.10 points each

-Setup the spreadsheet with proper formatting and formulas so it can be presented to management. a.Change the tab called "Quarterly" to "Q1 - Quarterly" and move the tab to the first position.

-Add a column to calculate the total for each product. Use the SUM function.

-Add rows to calculate the Total, Average and Median sales for each quarter. Use the SUM, AVERAGE, and MEDIAN functions.

-Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to show currency.

-Format the total sales column to have a green background.

-Create a bar chart showing for each product (a) the total sales for the year and (b) the proportion of the total contributed by each quarter’s sales. This should be shown in one. You should have 1 bar for each product. Add a title to your chart.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 17:30

Where would you click to edit the chart data?

Answers: 1

Answer

Computers and Technology, 23.06.2019 23:30

Match the following errors with their definitions. a. #name b. #value c. #ref d. 1. when a formula produces output that is too lengthy to fit in the spreadsheet cell 2. when you enter an invalid cell reference in a formula 3. when you type text in cells that accept numeric data 4. when you type in a cell reference that doesn’t exist

Answers: 1

Answer

Computers and Technology, 24.06.2019 15:30

The idea that, for each pair of devices v and w, there’s a strict dichotomy between being “in range” or “out of range” is a simplified abstraction. more accurately, there’s a power decay function f (·) that specifies, for a pair of devices at distance δ, the signal strength f(δ) that they’ll be able to achieve on their wireless connection. (we’ll assume that f (δ) decreases with increasing δ.) we might want to build this into our notion of back-up sets as follows: among the k devices in the back-up set of v, there should be at least one that can be reached with very high signal strength, at least one other that can be reached with moderately high signal strength, and so forth. more concretely, we have values p1 ≥ p2 ≥ . . ≥ pk, so that if the back-up set for v consists of devices at distances d1≤d2≤≤dk,thenweshouldhavef(dj)≥pj foreachj. give an algorithm that determines whether it is possible to choose a back-up set for each device subject to this more detailed condition, still requiring that no device should appear in the back-up set of more than b other devices. again, the algorithm should output the back-up sets themselves, provided they can be found.\

Answers: 2

Answer

Computers and Technology, 24.06.2019 18:00

Hacer un algoritmo que me permita ingresar el nombre de una parcela de terreno y muestre junto al mensaje “tipo de suelos: suelos fumíferos, ¡excelente!

Answers: 1

Answer

You know the right answer?

Read the brief case below.

Using the Excel spreadsheet provided, complete the questions...

Questions