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

Marketing company introduction letter - Examples of government accounting journal entries - A black feminist statement - Quad d flip flop - Literary research paper example - Discrete mathematics lecture notes ppt - Covalent lewis dot structure worksheet - How does a van der graaff generator work - Sample proficient teacher accreditation report - Fitbit chatter messages - Hillsboro health department - Given two tables employee and department - Obama nobel peace prize speech analysis - Relative atomic mass mass spectrometry - Sodium tetrathionate oxidation number - Sdj inc has net working - Mixing two primary colors produces a ________ color - Aqa religious studies a level grade boundaries - Imageless thought controversy in psychology - Adam smith's 1776 book wealth of nations argued for - Course name: Info tech import in Strat Plan - Hlt 362 exercise 18 - Irr vs npv vs payback - Just two pages need done asap - Forest hill uct residence - Lcp phonics phase 6 - Artemisia gentileschi judith slaying holofernes analysis - Blockchain Development Discussion - General ability index gai - Sociology chapter 8 quiz answers - Writing help - Core Values Essay - Application questions bloom's taxonomy - Early childhood running record observation example - Preparation of smears and simple staining lab report answers - Algebra with pizzazz objective 5 e answers - 3820 #5&6 - Research Paper - Mol per litre to grams per litre - Expense reimbursement schemes red flags - E kala mai ia u translation - Aston park angling centre - Ads r us book - Sun travel path melbourne - How much is $105 in pounds - Diagnoses documented as probable suspected or questionable are - The edelweiss hotel in vail colorado has accumulated records - Nature vs nurture frankenstein essay - Grade 1 science curriculum - Activity level e business models - West coast transit case study - Who is the greek god of birds - Parts of ladder diagram - Capstone Research Companion - Zurich co uk mystatement - Clive peeters richmond store - Safe practices for motor vehicle operations ansi asse z15 1 - City bus mount gambier - Kn m to psi - Checklist model project selection - Homework market reviews - Hans eysenck personality traits - Civil code section 1101.3 - Dq response. - Coefficient of skewness using pearson's method calculator - Milestone Two: Draft of Billing, Marketing, and Reimbursement - Moral dimensions of information systems - Western arms shotgun serial numbers - An adjusting entry should never include - Shadow health musculoskeletal interview guide - Methods of soft engineering - Cultural identity essay outline - A food handler notices that the temperature - Meritor wabco spn 1070 fmi 10 - Write a 250-word response to the following question Then write two 100-word responses to your classmates' comments - Project management simulation pearson answers - 250 words - Sonia deol husband harry sangha - The ability to provide financial rewards sufficient to attract and retain financing is called - Bbc japanese language and people - Cushion stuffing crossword clue - Week 4 Discussion 1 Share Your Peer Reviewed Study - Hourly rounding and fall prevention - Safe work method statements examples - BE - Dis 4 - 90 days game plan network marketing - Hotel butler service training - How to make lambanog - Which theorist discovered the “risky shift phenomenon”? - Horngren's accounting the financial chapters 11th edition pdf - Which of the sdlc models is the most rigid in its use in developing an information system? - Pick up motors excel - Child discipline methods - Us history reflection about my answer with my group - Cryptography - A quadrilateral with 2 pairs of parallel sides - Aeronautical radio communication frequencies document - IDM W 2 D - A.1 Accounting/FInance - Attention getter for abortion speech