Question

1) Using the SUM function in column G, find the total number of pins of 5 games per each person. 2) Using the COUNT functionBowling Total Pins # Games Average Score Highest Score Lowest Score Name Benjamin Abigail Franklin Thomas Cynthia Game 1 225

0 0
Add a comment Improve this question Transcribed image text
Answer #1

B с D F H Game 1 # Games Game 2 225 141 Total pins 948 Game 3 122 157 233 187 E Game 4 182 134 200 159 A 1 Name 2 Benjamin 3

When you enter the below formulas, you will get the above answers.

B H K Game 1 225 141 с Game 2 122 157 D Game 3 182 E Game 4 237 134 220 A 1 Name 2 Benjamin 3 Abigail 4 Franklin 5 Thomas 6 C

You need to fill only one cell with the equation, then drop it down

For example, Find Benjamins SUM with the formula,

then press enter

click that cell, point the mouse to the bottom right of the cell

you will see + sign

Click that and drag down.

Add a comment
Know the answer?
Add Answer to:
1) Using the SUM function in column G, find the total number of pins of 5...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. Write a C programme by using visual Studio: a) Write a function with parameters that...

    1. Write a C programme by using visual Studio: a) Write a function with parameters that returen the largest of three integer arguments. So users could call your function (name: max3) to output the maximum of three input values. b) Make a function outside of the main routine. And in the main routine, please call this function and print the harmonic mean. The harmonic mean of two numbers is obtained by taking the inverses of the two numbers, averaging them,...

  • C or C++ Project Overview Wild, Wild, West! Dice Game The Wild, Wild, West! is an...

    C or C++ Project Overview Wild, Wild, West! Dice Game The Wild, Wild, West! is an elimination dice game. It can be played by any number of players, but it is ideal to have three or more players. Wild, Wild, West! Requires the use of two dice. At the start of the game, each player receives a paper that will track the number of lives that player has. Each player starts the game with 6 lives. In the first round,...

  • In Exercises 3-5, find the indicated probabilities using the geometric distribution, the Poisson distribution, or the...

    In Exercises 3-5, find the indicated probabilities using the geometric distribution, the Poisson distribution, or the binomial distribution. Then determine whether the events are unusual. If convenient, use a table or technology to find the probabilities. 3. Thirty-six percent of Americans think there is stil a need for the practice of changing their clocks for Daylight Savings Time. You randomly select seven Americans. Find the probability that the number of Americans who say there is still a need for changing...

  • ***C++ Code*** What this Assignment Is About: -Learn to define and call void & non-void functions...

    ***C++ Code*** What this Assignment Is About: -Learn to define and call void & non-void functions -Learn to use reference variables Coding Guidelines for All Labs/Assignments (You will be graded on this) -Give identifiers semantic meaning and make them easy to read (examples numStudents, grossPay, etc). -Keep identifiers to a reasonably short length. -Use upper case for constants. Use title case (first letter is upper case) for classes. Use lower case with uppercase word separators for all other identifiers (variables,...

  • PLEASE SOLVE USING BASIC C++ CODEING PRINCIPLES PLEASE USE BASIC ARRAY, FUNCTION, AND LOOPING PRINCIPLES PLEASE...

    PLEASE SOLVE USING BASIC C++ CODEING PRINCIPLES PLEASE USE BASIC ARRAY, FUNCTION, AND LOOPING PRINCIPLES PLEASE COMPLETE ALL ASPECTS OF PAPER THANK YOU!!! Objectives To learn to code, compile and run a program containing ARRAYS. . Assignment Plan and code a modular program utilizing arrays. Use at least three functions to solve the problem. Input numbers from a textfile. Input the numbers, one by one. Store the even numbers in one array. Store the odd numbers in a second array....

  • Option #1: Batting The batting average of a baseball player is the number of “hits” divided by the number of “at-bats.”...

    Option #1: Batting The batting average of a baseball player is the number of “hits” divided by the number of “at-bats.” Recently, a certain major league player’s at-bats and corresponding hits were recorded for 200 consecutive games. The consecutive games span more than one season. Since each game is different, the number of at-bats and hits both vary. For this particular player, there were from zero to five at-bats. Thus, one can sort the 200 games into six categories: 0...

  • Please solve only if you know how to do it. Write the code using C++ (not...

    Please solve only if you know how to do it. Write the code using C++ (not Python or Java). Show and explain everything neatly. COMMENTS (7.5% of programming assignment grade): Your program should have at least ten (10) different detailed comments explaining the different parts of your program. Each individual comment should be, at a minimum, a sentence explaining a particular part of your code. You should make each comment as detailed as necessary to fully explain your code. You...

  • Using basic c++ write 2 separate codes for this assignment. Program #1 Write a program that...

    Using basic c++ write 2 separate codes for this assignment. Program #1 Write a program that calculates the average of a group of test scores, where the lowest score in the group is dropped. It should use the following functions. • void getScore() should ask the user for a test score, store it in the reference parameter variable, and validate it. This function should be called by the main once for each of the five scores to be entered. •...

  • [USING RSTUDIO] I am having trouble already in step 3 of number 1. Im not sure...

    [USING RSTUDIO] I am having trouble already in step 3 of number 1. Im not sure why what I typed isn't working. I appreciate anybody that can help me out. Thanks 1. Recall the `iris` data set from last week's exercise. The `iris` data set is already pre-loaded in R - look at the help file using `?iris` for more information on this data set.    i) Check the structure of the data using the function `str(iris)`.    ii) Find...

  • 11. Given the function f(x) = 2sin(x). (11 pts total) NG -21 -5 -4 1 -6...

    11. Given the function f(x) = 2sin(x). (11 pts total) NG -21 -5 -4 1 -6 -3 -2 -1 Mće. @p1 (4 pts) a. Graph fon the axes above. How should the domain be restricted so that f is one-to-one? Write your answer using set-builder notation. (4 pts) b. Algebraically find the inverse function, f-1(x). Sketch the graph of f-1 on the axes above. Remember that the graphs off and f-1 are symmetric about the 45° line! (3 pts) C....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT