Question: Begin in the Documentation worksheet: enter your name and date ( use a function for the current date ) . ( 1 mark ) 2

Begin in the Documentation worksheet: enter your name and date

(

use a function for the current

date

) . (1

mark

)

2 .

Copy the second worksheet and re

-

name it Consolidated Annual Sales. Move it to the right of the

Documentation worksheet.

(1)

3 .

In the Consolidated Annual Sales worksheet, delete all the numeric data under the headings Period

1,

Period

2,

Period

3

and Period

4 (

5

53) .

4 .

In C

5

use a

3

D reference to calculate the sales for each product for all locations. Copy the formula to

5,

and down to F

53 . (2)

5 .

Group Consolidated Annual Sales and the

4

locations worksheets. In cell G

5

create a formula to

calculate the Annual Sales Total for all months and autofill the formula.

(2)

6 .

Ungroup the sheets. In the Consolidated Annual Sales worksheet, in cell I

5,

insert an external link to

Test

1

Part

2

V#### Start File.xlsx

.

Make sure the Text to Display makes sense to users.

(3)

7 .

Create a new worksheet and name it Year

3

Projections. Move it to the left of the INTEGRITY CHECK

worksheet.

(

if required

) . (1)

8 .

In the Consolidated Annual Sales worksheet, in cell I

7,

create a hyperlink to link within your workbook

to A

1

in the Year

3

Projections worksheet. Make sure the Text to Display makes sense to users.

(2)

9 .

In the Documentation worksheet, in cell B

10

create an email link to the administrator

-

use

Admin@gearup.com to ask any questions regarding this workbook. Fill in the necessary details.

(

Address, Text to Display, Subject and Screentip.

)

Increase the font size to

14 . (3)

10 .

In Year

3

Projections, in cell A

3

type Year

3

Projections and make it a Title Style.

11 .

In Cell A

4

type Year

1

Sales. In cell A

5

create a formula that will reference the Overall Annual Sales in

the Consolidated Annual Sales worksheet

(

54),

so the company can compare once the figures are in

for Year

2 .

Apply accounting number style. Widen the column to

16.5

points.

(2)

12 .

Select the Documentation worksheet, SAVE and upload it to the drop box.

(1)

13 .

Finally, save the workbook as a template file with the name Your Condor ID

-

Template into your exam

folder. In the template file delete all the financial data in the cells C

5

53

of the

4

location worksheets

to prepare it for Year

3

data. Select the Document worksheet and save the template file once again

and upload it to your drop box.

(4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1 . Begin in the Documentation worksheet: enter your name and date ( use a function for the current date ) . ( 1 mark ) 2 . Copy the Newton worksheet and re - name it Consolidated Sales Q 2 . Move it...

Create a new Excel worksheet as shown below to compute the payroll information for Oshawa Software company (Use Boldface for all the labels, draw the borders, and rotate the text as shown). Enter...

SynthesisProject1 Creating an order form in Excel Skills Required (all are covered in Modules 1-3): General spreadsheet layout and formatting VLOOKUP Simple IF function Conditional formatting Simple...

Case 4 Data File needed for this Case Problem: Cairn.xlsx Cairn Camping Supplies Diane Cho is the owner of Cairn Camping Supplies, a small camping store she runs out of her home in Fort Smith,...

Download the stuxent data file Gorecki(1).xlsx and Complete Case Problem 1 "Gorecki Construction", pages EX 182-EX 183, Questions 1-12. Escel odule 3 e forming lth oevolas and Functions 15. Use the...

how to solve in excel MB fa c 0 E F 0 H N 0 Points B Student Grade 1 1 42 42 Final Assignment GPA Calculations, PMT - Mortgage and Car Payment 1 Save the workbook as First Initial Last Name Student...

Case 1: Finding an Optimal Product Mix Objectives: Use the SUMPRODUCT function to sum the products of two ranges Use the IF function to return text Create scenarios using the Scenario Manager...

COMP 1 0 0 3 In Class Module 1 2 Actionzone Cricket Camp runs events for boys and girls in grades 1 through 5 . You need to automate the registration process for this camp. Complete the following: 1...

A1 - X - - for Collegiate Seminars S % ? Conditional Format Formatting as Table Call Styles Format A CI Collegiate Seminars 2 3 4 5 Author Date Purpose To track seminar bookings 8 Fuld 9 Seminar ID...

Answer this as if you were a financial advisor responding to this clients email. Be concise (bullet points preferred). Hi Advisor, It's been a few months, so hopefully things are going well with you....

Wilson engages Ruth to sell Wilsons antique walnut chest to Harold for $2,500. The next day, Ruth learns that Sandy is willing to pay $3,000 for Wilsons chest. Ruth nevertheless sells the chest to...

Which of the following is not shown in the balance sheet ? A fixed deposit B opening stock C mortgage on land D bank overdraft

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

(Appendices) Megan, age 24, recently graduated from college. She was insured as a dependent under her fathers group health insurance policy, which provided coverage for her as a student until she...

(Appendices) Ethics Some celebrities lend their names to products that later turn out to be ineffective or harmful to consumers. The celebrities are paid to endorse the product by claiming they have...

(Appendices) Jeremy, age 45, is the general manager of five fast-food restaurants. Each restaurant has a delivery service for customers who call in orders. Employees drive company cars to deliver the...