All physics qestions

no expiation needed (maybe shorth ones for the qestions maybe)

please don't be mean and cancel my qestions or report just leave if for another person to do

video link

https://youtu.be/xv8RXzUMTng?t=284

google sheets link

https://docs.google.com/spreadsheets/d/1IuXJcJiDytwaS_L6rWSVUaqUYncq_XuNoSa3ix9ONyQ/edit?usp=sharing

Instructions: In each question, you will be asked to do a simple task. Use the spreadsheet and code an equation that will automatically calculate the numbers as asked. Then add a screenshot of the spreadsheet under the question. If you get stuck, use google to figure out the correct way to code it. Remember! all equations start out with "=" PLEASE watch this video to show how to use equations to do all the hard work in this assignment! https://youtu.be/xv8RXZUMTng?t=284 1. Add the individual numbers in column A and B together using a code. Ex. 4+4 =8 could be written as =a2+b2 and then google sheets would calculate it for you. https://docs.google.com/spreadsheets/d/1KWD2ZiSw89GPw0qX786wGZPUEukoMmt_50W6P-z8mzo/ copy Don't forget to make a screenshot of your finished work below! 2. Go to the second tab in your sheet and multiply the individual numbers in column A and B together using a code. (Use shift 8, to multiply) Don't forget to make a screenshot of your finished work below! 3. Go to the third tab in your sheet and divide the individual numbers in column A and B together using a code. (use the / under the ? for division) Don't forget to make a screenshot of your finished work below! 4. Go to the 4th tab in your sheet and average the numbers in column B using a code. Don't forget to make a screenshot of your finished work below! 5 . Go to the 5th tab in your sheet and divide each number in column B by the average of column A using a code. Don't forget to make a screenshot of your finished work below! 6. Velocity or speed is distance divided by time. Go to the 6th tab in your sheet and calculate how fast each of these cars were going. Don't forget to make a screenshot of your finished work below! 7. You collected some data on wide different containers are. Since the mathematical model for the number of marbles that can fit inside the containers is Marbles = C*diameter^2, go to the 7th tab in your sheet and calculate how many marbles are in each container. Don't forget to make a screenshot of your finished work below! 8. Go to the 8th tab in your sheet and color code each speed that was over 100mph as red, and each one that was under as green. Hint, there is a way to have the sheet do it for you. Look up conditional formatting. Don't forget to make a screenshot of your finished work below