Enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018. use relative cell references and copy the formula to the range h6:h11.

To determine the percentage of the attendees that went to the Altamonte springs job fair, we just have to divide the number of the attendees who went to the job fair (x) by the total number of attendees (y) and multiply the quotient by 100%.
= (x/y)(100)

Answer Link

tifanihayyu tifanihayyu · Answer 2 · 2019-08-23T11:10:43+02:00

The percentage of attendees that went to the altamonte springs job fair in 2018 is 7.05%

Further explanation

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. Microsoft Excel can do calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

A cell reference refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a formula's variable. The simplest cell reference appears as a simple mention of the referred cell after an equal sign.

According to the picture below, the percentage of attendees that went to the altamonte springs job fair in 2018 can be calculated as follows:

Put this formula on H5:

=(F5:F12)*100

The results is 7.05%

Whereas on the H6:H11 we can put these equations:

=(F6:F12)*100

=(F7:F12)*100

=(F8:F12)*100

=(F9:F12)*100

=(F10:F12)*100

=(F11:F12)*100

Hope it helps!

Learn more

Learn more about relative cell references https://brainly.com/question/8780462
Learn more about microsoft excel https://brainly.com/question/10615434
Learn more about percentage of attendees https://brainly.com/question/7263532

Answer details

Grade: 9

Subject: business

Chapter: microsoft excel

Keywords: relative cell references, percentage of attendees, microsoft excel, range of columns, formulas on excel