Use formula autocomplete to enter a sum function in cell B7 to calculate the total of cells in B2:B6

Answers

Answer 1

Excel enables the users to perform mathematics basic and advanced function with just one formula.

The formula for sum of entire row or column can be done with just entering a single formula and results are shown in seconds.

The formula for sum of few column cells is,

=SUM(B2:B6)

The spreadsheet allows the user to enter various formula and results are displayed withing seconds.

There are formulas for basic math functions and there are also formulas for advance mathematics calculations. For addition of values of many cells sum formula is used and range is assigned for reference.

The formula adds all the values of selected cells and displays the results in different cell.

Learn more at https://brainly.com/question/24365931


Related Questions

Write a linear equation in point-slope form for the line that goes through (1, -3) and (3,9).
A. y+3 = -6(x-1)
B. y- 9 = 6(x - 3)
C. y- 9 = 2(x-3)
D. y + 3 = 6(x-1)​

Answers

The slope of the line is 6, meaning that you can eliminate A,C. Since the point slope formula is y-y1=m(x-x1) you just need to see if the points are correct.

B. (3,9)
D. (1,-3)

While these do contain one point, substitute the coordinates to see which contain both.

B.

(1,-3): -3-9=6(1-3): -12=-12
(3,9): 9-9=6(9-3): 0= 6(6)

D.

(1,-3): -3+3=6(1-1): 0=6(0); 0=0
(3,9): 9+3=6(3-1): 12=6(2): 12=12

D is correct since the coordinate are on the line.

The answer would be six

If total sales are $54000 your food service total is 42% of your total sales what is your dollar target for food service

Answers

Answer:

Your dollar target for food service is $22,680

Step-by-step explanation:

It is given in the question that total sales are = $54,000

your food service is 42% of your total sales = 42% × $54,000

=  × 54,000

= 0.42 × 54,000

= $22,680

What are the solutions of this quadratic equation?

4x2 + 3 = 4x + 2

Answers

Answer:

A. x = 1/2

General Formulas and Concepts:

Pre-Algebra

Equality Properties

Algebra I

Terms/CoefficientsFactoringStandard Form: ax² + bx + c = 0Solving quadratics

Step-by-step explanation:

Step 1: Define

Identify

4x² + 3 = 4x + 2

Step 2: Solve for x

[Equality Property] Rewrite in standard form:                                                 4x² - 4x + 1 = 0Factor:                                                                                                               (2x - 1)² = 0Solve:                                                                                                                x = 1/2

Natalie Jenny, Steve and Jatin paid $12 for their taxi. They shared this equally between them. What fraction did each pay?

Answers

Answer:

1/4

Step-by-step explanation:

12/4= 3

Each paid $3 but as a fraction 3/12=1/4

Answer:

[tex] \frac{1}{4} [/tex]

Step-by-step

12÷4=3

3/12=1/4-each pay this fraction

In an accelerated failure test, components are operated under extreme conditions so that a substantial number will fail in a rather short time. In such a test involving two types of microchips, 580 chips manufactured by an existing process were tested, and 125 of them failed. Then, 780 chips manufactured by a new process were tested, and 130 of them failed. Find a 90% confidence interval for the difference between the proportions of failures for chips manufactured by the two processes. (Round the final answers to four decimal places.) The 90% confidence interval is

Answers

Answer:

The 90% confidence interval is (0.0131, 0.0845).

Step-by-step explanation:

Before finding the confidence interval, we need to understand the central limit theorem and subtraction of normal variables.

Central Limit Theorem

The Central Limit Theorem establishes that, for a normally distributed random variable X, with mean [tex]\mu[/tex] and standard deviation [tex]\sigma[/tex], the sampling distribution of the sample means with size n can be approximated to a normal distribution with mean [tex]\mu[/tex] and standard deviation [tex]s = \frac{\sigma}{\sqrt{n}}[/tex].

For a skewed variable, the Central Limit Theorem can also be applied, as long as n is at least 30.

For a proportion p in a sample of size n, the sampling distribution of the sample proportion will be approximately normal with mean [tex]\mu = p[/tex] and standard deviation [tex]s = \sqrt{\frac{p(1-p)}{n}}[/tex]

Subtraction between normal variables:

When two normal variables are subtracted, the mean is the difference of the means, while the standard deviation is the square root of the sum of the variances.

Old process:

125 out of 580, so:

[tex]p_O = \frac{125}{580} = 0.2155[/tex]

[tex]s_O = \sqrt{\frac{0.2155*0.7845}{580}} = 0.0171[/tex]

New process:

130 out of 780. So

[tex]p_N = \frac{130}{780} = 0.1667[/tex]

[tex]s_N = \sqrt{\frac{0.1667*0.8333}{780}} = 0.0133[/tex]

Distribution of the difference:

[tex]p = p_O - p_N = 0.2155 - 0.1667 = 0.0488[/tex]

[tex]s = \sqrt{s_O^2+s_N^2} = \sqrt{0.0171^2 + 0.0133^2} = 0.0217[/tex]

Confidence interval:

[tex]p \pm zs[/tex]

In which

z is the z-score that has a p-value of [tex]1 - \frac{\alpha}{2}[/tex].

90% confidence level

So [tex]\alpha = 0.1[/tex], z is the value of Z that has a p-value of [tex]1 - \frac{0.1}{2} = 0.95[/tex], so [tex]Z = 1.645[/tex].

The lower bound of the interval is:

[tex]p - zs = 0.0488 - 1.645*0.0217 = 0.0131[/tex]

The upper bound of the interval is:

[tex]p + zs = 0.0488 + 1.645*0.0217 = 0.0845[/tex]

The 90% confidence interval is (0.0131, 0.0845).

find the missing length indicated​

Answers

Answer:

Step-by-step explanation:

192

Answer:

Step-by-step explanation:

Convert 15,000 meters to centimeters.
15,000 centimeters
150,000 centimeters
15,000,000 centimeters
1,500,000 centimeters

Answers

Answer:

1500000

Step-by-step explanation:

1 metre = 100 cm

15000metre =15000*100

=1500000

Frances bought a new dress that was discounted by 24%. she used the following expressions to find the price of the dress after the discount was applied

Answers

Answer:

[tex]0.76d[/tex]

Step-by-step explanation:

Given

[tex]Formula = d - (0.24)d[/tex]

Required

Equivalent expression

We have:

[tex]Formula = d - (0.24)d[/tex]

Open bracket

[tex]Formula = d - 0.24d[/tex]

[tex]Formula = 0.76d[/tex]

Bridgette bought 1 pack of white T-shirts and 5 packs of blue T-shirts for her basketball team. The white T-shirts come in packs of 2, and the blue T-shirts come in packs of 6. How many T-shirts did Bridgette buy in all?

Answers

Answer:  32

Work Shown:

1 pack of white = 2 shirts = A

1 pack of blue = 6 shirts

5 packs of blue = 5*6 = 30 shirts = B

A+B = 2 white shirts + 30 blue shirts = 32 shirts total

Answer:

32 T-shirts in total

Step-by-step explanation:

1 white has 2

1 blue has 6

1*2=2 white T

5*6=30  blue T

30+2=32

A triangle has base of 7 1/8 feet and height 6 1/4 feet. Find the area of a triangle as a mixed number.

Answers

Answer: The area is 22 17/64.

Step-by-step explanation:

base = 7 1/8 = 57/8

height = 6 1/4 = 25/4

area = 1/2*b*h

= 1/2*57/8*25/4

= 1425/64

= 22 17/64

Solve for x

X/6 = 10

A) X = 4
B) X = 10
C) X = 16
D) X = 60

Answers

hi  

x/6 = 10

In a equation , you can use every math operation you know as long as you do the same thing on both sides.  

Here we have   x/6 = 10  

But what I want is  x .  

Here X is split in 6.  So  I 'm going to multiplicate all by 6 to find the original amount of X  

In bold operation that are often not written but that you must understand to do that kind of exercices.

So  :  x/6 = 10

      (x/6) *6  = 10 *6

        6x/6 =  60

             x = 60

I need to know this answe ASAP

Answers

Answer:

The function is always increasing

Step-by-step explanation:

To be increasing, the y value needs to be getting bigger as x gets bigger

This is true for all values of x

The function is increasing for all values of x

Which graph represents the function f(x) = x-2?

Answers

Answer:

click in photo

nejdjjd

nxndjdbbdjf

lấy x=0 ta có y= -2 => A(0;-2)

lấy y=0 ta có x=2 => B(2;0)

nối 2 điểm A và B ta có đồ thị:

Can anyone help please?

Answers

Answer:

part 1:

a) After 37.72 years, there will be $270,183.29421

b) After 11.9 years, there will be double the amount originally put in the account(60,015.17148)

part 2:

38 years

Step-by-step explanation:

a)

30000(1.06)^t

t=37.72

30000(1.06)^37.73 = 270,183.29421

b)

30000(1.06)^t

t=11.9

30000(1.06)^11.9 = 60,015.17148

part 2)

37.72 rounded to the nearest tenth is 38

... select this as the brainliest please!!...

Graph the inequality in the coordinate plane. y<6

Answers

Answer:

Simpler equations and inequalities as such could be typed into an online graphing calculator such as Desmos! Remember this because you'll need it for future harder math classes :)

Step-by-step explanation:

i would like some help please i am stuck ​

Answers

Answer: -2(d) is the answer.

Step-by-step explanation:

x1 = 3

y1 = -5

x2 = -2

y2 = 5

slope (m) = rise/run = (y2 - y1)/(x2-x1)

                                =(5-(-5))/(-2-3)

                                 =   10/-5

                                 = -2

The one-to-one functions g and h are defined as follows.

Answers

Answer:

Step-by-step explanation:

The one-to-one functions g and h are defined as follows.

g={(-7,-6), (-5,4), (4,-7)(7,6)}

h(x)= 3x-14

Find the following.

g-1(4)=

"g-1(4)" just says "Find the pair of coordinates that has 4 for its

y-coordinate, and the answer is its x-coordinate".  So we look through those

and find (-5,4) is the only one of those up there that has a 4 for it's y-

coordinate, and so its x-coordinate is -5 and we write:

g-1(4)=-5  

The Required value for the function are:

1. g⁻¹(-3) = -1.

2. h⁻¹(x) = (x - 2) / 7.

3. (h o h⁻¹)(0) = -16/49.

1. g⁻¹(-3):

Looking at the pairs in g, we can see that (-1, -3) is the pair where the output is -3.

Therefore, g⁻¹(-3) = -1.

2. h⁻¹(x):

To find h⁻¹(x), we need to solve the equation h(y) = x for y.

The given function h(x) = (x - 2) / 7.

So, let's substitute y for h⁻¹(x):

(x - 2) / 7 = y

x - 2 = 7y

Now, solve for y by dividing both sides by 7:

y = (x - 2) / 7

Therefore, h⁻¹(x) = (x - 2) / 7.

3. (h o h⁻¹)(0):

To find (h o h⁻¹)(0), we need to evaluate the composition of h and h⁻¹ at 0.

First, we find h⁻¹(0):

h⁻¹(0) = (0 - 2) / 7 = -2/7

Now, we substitute h⁻¹(0) into h:

h(h⁻¹(0)) = h(-2/7) = (-2/7 - 2) / 7 = (-2 - 14) / 49 = -16/49

Therefore, (h o h⁻¹)(0) = -16/49.

Learn more about Function here:

https://brainly.com/question/30721594

#SPJ2

Convert the improper fraction to a whole or mixed number. (Enter your answer as a simplified mixed number.)
25
7

Answers

The answer to this question is 3 4/7

***URGENT***
PLEASE HELP ME ASAP, ITS DUE TODAY!!!
............................................................

T is the point on AB such that AT:TB = 5: 1. Show that ot is parallel to the vector a + 2b.

Answers

Step-by-step explanation:

SO, OT is parallel to the vector a+2b

Please help!! Given the recursive formula shown, what are the first 4 terms of the sequence?

Answers

Answer:

C

Step-by-step explanation:

the fibrin definition tells us that the first term of the sequence a1 = 6

so, B is out.

and for every following term we always add 7 to every previous term to create the next one.

so, when I add 7 to 6, what is my second term in the sequence ? 7+6 = 13

not 42, not -7

therefore, only C is correct.

and 13+7 = 20

and 20+7 = 27

it all fits

PLEASEEEEEE HELPPPPPPPPP

what are the zeros for this?
f(x) = 2x^2 + 6x + 2

Answers

Answer:

-3/2 ±1/2 sqrt(5) = x

Step-by-step explanation:

f(x) = 2x^2 + 6x + 2

Set the function equal to 0

0 = 2x^2 + 6x + 2

Factor out 2

0 = 2(x^2 + 3x + 1)

Divide by 2

0 = (x^2 + 3x + 1)

Subtract 1 from each side

-1 = x^2 +3x

Complete the square by dividing the x coefficient by 2 and then squaring

(3/2)^2 = 9/4

-1 +9/4 = x^2 +3x+9/4

-4/4+9/4 = (x+3/2) ^2

5/4 = (x+3/2) ^2

Taking the square root of each side

± sqrt(5/4) = sqrt( (x+3/2) ^2)

±1/2 sqrt(5) =  (x+3/2)

Subtract 3/2 from each side

-3/2 ±1/2 sqrt(5) = x

1
What is the perimeter of a rectangle
whose length is 5 feet and whose width
is 3.5 feet?
O 8.5 ft.
O 16.5 ft.
O 17 ft.
O 17.5 ft.

Answers

Answer:

17ft

Step-by-step explanation:

5*2 + 3.5*2=17

Answer 17 ft.

Explanation
Perimeter of rectangle = 2(l+b)
As length = 5 ft and breadth/width = 3.5 ft

So,
=2 ( 5+3.5)
=2 ( 8.5 )
= 17 feet


I hope it helps!
pls mark me brainliest :)

Solve the equation.
1. For parentheses:
Distribute
4-2(x+7) = 3(x+5)
2. If necessary:
Combine Terms
3. Apply properties:
Add Subtract
Multiply
Divide
4. To start over:
Reset

Answers

Answer:

x = -5

Step-by-step explanation:

4-2(x+7) = 3(x+5)

Distribute

4 - 2x-14 = 3x+15

Combine like terms

-2x-10 = 3x+15

Add 2x to each side

-2x-10 +2x =3x+2x+15

-10 = 5x+15

Subtract 15 from each side

-10-15 = 5x+15-15

-25 = 5x

Divide by 5

-25/5 = 5x/5

-5 =x

Police estimate that 25% of drivers drive without their seat belts. If they stop 6 drivers at random, find theprobability that more than 4 are wearing their seat belts.

Answers

Answer:

%17.80

Step-by-step explanation:

17.8% is the probability that more than 4 are wearing their seat belts.

What is Probability?

It is a branch of mathematics that deals with the occurrence of a random event.

Given that Police estimate that 25% of drivers drive without their seat belts.

If they stop 6 drivers at random we need to find the probability that more than 4 are wearing their seat belts.

For each driver stopped, there are only two possible outcomes. Either they are wearing their seatbelts, or they are not.

he drivers are chosen at random, which mean that the probability of a driver wearing their seatbelts is independent from other drivers.

Police estimate that​ 25% of drivers drive without their seat belts.

This means that 75% wear their seatbelts, so P=0.75

If they stop 6 drivers at​ random, find the probability that all of them are wearing their seat belts.

[tex]P(X=x)=C_{n,x} p^{x} (1-p)^{n-x}[/tex]

[tex]P(X=6)=C_{6,6} 0.75^{6} (1-0.75)^{0} =0.1780[/tex]

Hence, 17.8% is the probability that more than 4 are wearing their seat belts.

To learn more on probability click:

https://brainly.com/question/11234923

#SPJ5

The lengths of the parallel sides of
a trapezium are 12cm and 26cm
If Its area is 228cm square Find the
perpendicular distance between the
Parallel sides​

Answers

Answer:

12 cm

Step-by-step explanation:

12+26/2 ×x =228

19x =228

X=12cm

can somboby help me please​

Answers

Answer:

x = 8

Step-by-step explanation:

The question had specified that x is equal to 8.

Answer

x=8

explanations

please mark this answer as brainlist

How many hours will it take to complete a 45-km bike ride if you go 12km per hour the whole time?

Answers

Answer:

3.75 hours

Step-by-step explanation:

d = rt

where d is the distance, r is the rate and t is the time

45 = 12 t

Divide each side by 12

45/12 = t

3.75 hours = t

11

find the number of ways of forming
an executive Committee of four in a
social club consisting of 15 members,
If a particular man must be in
the comittee

Answers

There are 365 ways of forming an executive Committee of four in a social club consisting of 15 members

Understanding Permutation and Combination

If a particular man must be in the committee, we can choose the remaining 3 members from the remaining 14 members. The number of ways to choose 3 members from 14 is given by the combination:

14Cr3 = [tex]\frac{14!}{3! 11!}[/tex] = [tex]\frac{14x13x12}{3x2x1}[/tex] = 364

Therefore, there are 364 ways of forming an executive committee of four in a social club consisting of 15 members, if a particular man must be in the committee.

Learn more about combination here:

https://brainly.com/question/28065038

#SPJ1

Find COS Instructions: Find the value of the trigonometric ratio. Make sure to simplify the If needed

Answers

Answer:

Sin X = 12 / 37

Step-by-step explanation:

Given a right angled triangle, we are to obtain the Sin of the angle X ;

Using trigonometry, the sine of the angle X , Sin A is defined as the ratio of the angle opposite X to the hypotenus of the right angle triangle.

In the right angle triangle :

Sin X = opposite / hypotenus

Opposite = 12 ; hypotenus = 37

Sin X = 12 / 37

Which of the following expressions are equivalent?

I. 5a6
II. 30a
III. a6 + a6 + a6 + a6 + a6
IV. 6a5

Answers

Answer:

5а⁶=а⁶+а⁶+а⁶+а⁶+а⁶

~~~~~~~~

Other Questions
2. Apply the laws of indices and simplify. h) [tex]3 \sqrt{x {?}^{2} {y}^{2} } [/tex] 1. First, practise ________ a basketball with your right hand.1. to bounce2. bouncing3. to kick4. kicking2. I couldnt attend the seminar because I _______ (register) before. 1. didn't register2. hadn't registered3. wasn't registering3. I'm sure Britain will _______ Italy tomorrow. 1. win2. to win3. beat4. to beat4. It was raining when the Olympic Opening Ceremony _________ (start). *1. started2. had started3. was starting5. Diane was already at the gym when she realised she ________ (forget) her towel. *1. forgot2. had forgotten3. was forgetting6. Bert Trautmann ________ (play) for Manchester City in his first FA Cup final when he ______ (dive) for the ball in the seventy-fifth minute. 1. played / dived2. had played / dived3. was playing / dived4. was playing / was diving On the basis of an eyewitness description, a student was arrested in connection with the murder of a security guard who was killed during a protest at a college. The police brought the student to the police station and gave him his Miranda warnings. The student then asked to speak with his attorney. Before the attorney could arrive, the eyewitness walked into the station, saw the student, and told the police that this was the person she had seen kill the security guard. The prosecution sought to introduce at trial evidence of the eyewitness identification. The defense moved to have evidence of the identification suppressed.The court should ______________ Can you please help me Four friends go out for lunch three of them Order cheeseburgers at a cost of 4.75each one friend orders. A slice of pizza for 2.55 and all of them purchase a drink for 1.20each they decided to split the bill equally how much is each friends share i need help asap, tysm! :) Describe three ways in which recycling materialsis important for the sustainable use of resources. Hlo gd evening allwhat is non-public proprietary The speaker in "Harlem" contemplatesRecord any details that relate to the topic of American identity. Curfews are silly and slow that dont think Im a responsible and mature person Which audience would be most moved by this type of appeal The Global war on terror waged by the United States has been accompanied by wanton human rights abuses. Despite the strong opposition of the international community, the United States has held a large number of people for a long time in violation of the judicial process, including many civilians who have no connection to terrorism. Ignoring basic human rights, the United States tracks, monitors and listens to Muslims around the world, and even bans entire Muslim communities and deprives them of the freedom to travel. In the anti-terrorism operation, the wrong killing, mistakenly caught more everywhere, so that many innocent people innocent, even lost their lives. A manufacturer of potato chips would like to know whether its bag filling machine works correctly at the 421 gram setting. It is believed that the machine is underfilling the bags. A 43 bag sample had a mean of 414 grams. Assume the population standard deviation is known to be 19. Required:a. Is there sufficient evidence at the 0.1 level that the bags are underfilled?b. Find the P-value of the test statistic. Which verb form correctly completes this sentence? Il vaut mieux que tu _________ du lait avec des crales.A. prennentB. prenneC. preniezD. prennes a) You can turn off the radio. I ..(not/listen) to it. (Use correct tense of the verb given in the brackets) b) It.........be Sita knocking on the door. She had promised to come today. (Put the correct modal) 0.5008 g of an unknown triprotic acid, H3A, is dissolved in 47.3 mL of water and then titrated with 0.315 M NaOH. It takes 25.72 mL of the NaOH solution to completely neutralize the acid. What is the molar mass of this acid Explain briefly fourwhy, peasantfarmers find it diffcult to getfarm credit Labor productivity is? Write any 1 disadvantage of the houses you see in the picture functions f and g are defined asf(x) = 5x - 10x + 7where x > 1g(x) = 7x - 6Find fg(2) Work out how many more skirts were sold on Friday than on Thursday ?