Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Independent project 7 6 excel

23/11/2021 Client: muhammad11 Deadline: 2 Day

The Hamilton Civic Center is developing a template for member exercise and off-site seminars. You create the template, set validation, enter formulas, and insert a combo box control. You then create a new workbook from the template.

[Student Learning Outcomes 7.1, 7.2, 7.3, 7.4, 7.6]

File Needed: HamiltonCC-07.xlsx (Available from the Start File link.)

Completed Project File Names: [your name]-HamiltonCC-07.xlsx

Skills Covered in This Project
Set data validation to use a list.
Set validation to restrict dates.
Create an error alert message.
Insert a combo box control.
Check accessibility and add alt text.
Protect a worksheet.
Open the HamiltonCC-07 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
Select cell D2 on the Data sheet and review the formula. The formula divides calories by time and rounds the results to three decimal places.ImagesFigure 7-69 Custom format for values
Select cells D2:D10 and open the Format Cells dialog box.
Select the Custom category on the Number tab and build a format to display three decimal places (Figure 7-69).
Select cell D2 and click the Format Painter button [Home tab, Clipboard group]. Click the Calorie Tracking tab and paint the format to cells E3:E33.ImagesFigure 7-70 VLOOKUP formula
Select cell E3 on the Calorie Tracking sheet. Start a VLOOKUP function to lookup the label in cell C3. For the array, use an absolute reference to cells A2:D10 on the Data sheet. The Col_index_num is 4 for the calories per minute column. Leave the Range_lookup argument empty; the array (A2:D10) is sorted in ascending order. The result of the VLOOKUP formula is calories per minute for the exercise (Figure 7-70).
Edit the formula in cell E3 to multiply the results by the number of minutes in cell D3.
Copy the formula in cell E3 to cells E4:E33. The #N/A error message displays in rows where no data displays.
Select cells C3:C33 and set data validation to use the list of activity names on the Data sheet. Do not use an input message or an error alert.
Select the Calorie Tracking sheet and delete the data in cells A3:D23.ImagesFigure 7-71 Data validation for dates
Select cells B3:B33 and set data validation to use a Date that is less than or equal to TODAY (Figure 7-71). Include a Stop error alert with a title of Check Date and a message of Date must be today or in the past. including the period.
Select cells A3:D33 and remove the Locked cell property. Select cell A3 to position the insertion point.
Display the Developer tab on the Ribbon and click the Data worksheet tab.ImagesFigure 7-72 Combo box settings
Draw a combo box control to cover cell F8 and open its Format Control dialog box. Select cells G8:G11 for the Input range and type f8 in the Cell link box (Figure 7-72).
Deselect the control and then select Second from the control. The linked cell is under the control and hidden from view.
Click the Hospital Seminars tab and select cell D4. This cell has Center Across Selection alignment applied.
Select cell D4 and use CONCAT and INDEX to display the result from the combo box, concatenating the Index results to the word “Quarter.”
Start a CONCAT function [Text group].
Use the INDEX function with the first arguments list as the Text1 argument.ImagesFigure 7-73 INDEX is nested within CONCAT
Choose cells G8:G11 on the Data sheet for the Array argument and cell F8 for the Row_num argument. You can select the combo box control or type f8 after the sheet name (Figure 7-73). When the array is one column, a Column_num argument is not necessary.
Click between the two ending parentheses in the Formula bar to return to the CONCAT arguments and type a comma (,) to move to the Text2 argument. (If you accidentally click OK, click the Insert Function button to re-open the Function Arguments dialog box.)ImagesFigure 7-74 Space character is included with Text2 argument
Click the Text2 box, press Spacebar, type Quarter, and click OK. (Figure 7-74).
Format cell D4 as bold italic 16 pt.
Select the Data sheet, select Third from the combo box control, and return to the Hospital Seminars sheet to see the results.
Select cell D4 and cells D6:G10 on the Hospital Seminars sheet and remove the Locked property.
Delete the contents of cells D6:G10 and select cell D6.
Check accessibility and add the alternative text Hamilton Civic Center Logo to both pictures in the workbook.
Select cell D6 on the Hospital Seminars sheet and cell A3 on the Calorie Tracking sheet.
Protect the Hospital Seminars sheet and the Calorie Tracking sheet, both without passwords.
Save and close the workbook (Figure 7-75).
Upload and save your project file.
Submit project for grading.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Academic Mentor
Instant Homework Helper
Homework Tutor
Finance Homework Help
Quick Finance Master
Top Class Engineers
Writer Writer Name Offer Chat
Academic Mentor

ONLINE

Academic Mentor

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$25 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$35 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$17 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$25 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$44 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$36 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Business monash course map - Modigliani and miller - English short story 300 words - Caught plagiarizing at university of phoenix - How to calculate ripple factor of half wave rectifier - Volume to Value: Executive Brief - 3m marketing strategy case study - Joint commission national safety goals 2018 - Car rental management system in java - Adams water cartage bendigo - Toy stencil pigeon genetics - Week 2 homework - Standard chartered bank reward points - Predict my future bra size quiz - Moreton bay council land subdivision - International business competing in the global marketplace pdf - Jb hi fi product warranty - Michael douglas wall street quotes - Capital acquisition and repayment cycle - Features of a newspaper report - Wilson wonder's bonds have years remaining - Allianz oshc bulk billing - Margaret newman nursing theory - A red red rose literary devices - Verizon custom tv infotainment & drama - How to solder resistors together - Topic: [Revision] The Last Duel by - History of naa luro pdf - Chateau of the ravenous rodent light all the heirlooms - Social mobile and local marketing - Consequences of the Fall and Contemporary Response - Which platonic solid has eight faces that are equilateral triangles - Melissa theuriau miss france 2000 - 119.5 kg to lbs - Solar system simulation opengl source code - Baker duties and responsibilities resume - Statutory report in tally - Student information system sequence diagram - The pitcher by robert francis - Starbucks mission social responsibility and brand strength - Jack rothman approaches to community intervention - Reaction between silver nitrate and sodium hydroxide - Rogers model of the science of unitary man - Sultan qaboos university physics - Quantitative business analysis text and cases - Construction Methods - Alternate form reliability definition - Periodic trends pogil answers - Mackillop family services wollongong - Best linear unbiased estimator ppt - Which of the following is true regarding depreciation recapture - Literature for moral ethical issues encountered by a pmhnp - Liteonte liteon technology corporation - Spreader slide blood smear - Intelligence from secrets to policy pdf - 3 reasons why education should be free for everyone - Implementation Plan - Btec assessment plan example - Cocktail sugar syrup woolworths - Usana proflavanol c100 side effects - Adjectives ending in ish - Economic Issues in Public Health - Psychodynamic model of personality worksheet answers - Lee doyle solicitors glasgow - How do crumple zones save lives - Common veterinary medical abbreviations - I ask my mother to sing analysis - In cell j4 calculate the actual increase - Catholic prayer oh my god i am heartily sorry - Term paper - Amps to watts conversion - Below are incomplete financial statements for bulldog inc - Longriver homework - Wingate company a wholesale distributor - Wwnorton com studyspace give me liberty - Ccna 4 chapter 6 - Superordinate goals psychology definition - Importance of protozoa in agriculture - Simnet office 2016 integrated applications project 3 - Download the file below - Are online casino winnings taxable - Flowers for algernon movie review - Medical law and ethics chapter 5 answers - What is defined in osha standard 1926.32 f - Assignment 300 words - Target market for skin care - Imposter codes among us - Information governance - Dietary fats and blood cholesterol levels worksheet answers - Team Management Assignment -1 - Uml diagram final variable - Po box 535 braeside vic 3195 - Fanuc load program from rs232 - Research Paper - 318 badgerup road gnangara - Essentials of psychology - William h turner technical arts high school uniform - What is a subordinated debenture - Incident Response - Form 119 evidence of australian citizenship