What function returns a reference to a cell (or cell range) that is a specified number of row and columns from a base cell?

Answers

Answer 1

Answer:

The offset function

Step-by-step explanation:

In Microsoft Excel, the offset function or formula returns reference to a particular cell.

The syntax is:

= OFFSET(reference, rows, cols)

Where:

reference = the base cell

rows and cols are the direction to move

For instance:

OFFSET(A1, 3, 1) will return cell B4

Because:

3 will shift down the reference from A1 to A4

1 will shift right the reference from A4 to B4


Related Questions

determine the equation of a circle with the center (8,10) and radius 6​

Answers

Answer:

(x - 8)² + (y - 10)² = 36

General Formulas and Concepts:

Pre-Algebra

Order of Operations: BPEMDAS

Brackets Parenthesis Exponents Multiplication Division Addition Subtraction Left to Right

Algebra I

Coordinates (x, y)

Pre-Calculus

Circle Center Formula: (x - h)² + (y - k)² = r²

(h, k) is centerr is radius

Step-by-step explanation:

Step 1: Define

Identify

(h, k) = (8, 10)

r = 6

Step 2: Find Equation

Substitute in variables [Center Circle Formula]:                                             (x - 8)² + (y - 10)² = 6²Evaluate exponents:                                                                                         (x - 8)² + (y - 10)² = 36

PLEASE HELP ME ON MY FIRST QUESTION!, SHOW WORK PLEASE!!

Answers

Answer:

Solution given:

radius [r]=2cm

height [h]=8cm

total surface area of cylinder=?

we have

total surface area of cylinder=2πr²+2πrh

2πr(r+h)2π*2(2+8)40π or 125.66cm²

total surface area of cylinder40π or 125.66cm².

Question :-

Find the surface area of the cylinder.

___________________

Solution :-

Given Information :-

Radius of the Cylinder ➢ 2 cmHeight of the Cylinder ➢ 8 cm Value of π (pi) (not given) ➢ 3.14

To Find :-

Surface Area of the Cylinder

Formula Used :-

Area of cylinder = 2πr( r + h )

Calculation :-

Substituting the values given in the formula, We get,

⇒ Area of Cylinder = 2 × 3.14 × 2 ( 2 + 8 )

⇒ Area of cylinder = 2 × 3.14 × 2 ( 10 )

⇒ Area of cylinder = 2 × 3.14 × 20

Calculating further, We get,

Area of cylinder = 125.66 cm²

___________________

Final Answer :-

Area of cylinder = 125.66 cm²

____________________

what is 25% of 50 pls help

Answers

Answer:

12.5 is your answer buddy

Answer:

Step-by-step explanation:

So, lets think of this a simpler way.

What is 1/2 of 50?

Well, thats 25. That is 50%. We want 25%, which is 1/4 of 50.

So lets divide the 25 we got in half:

25/2

=

12.5

So this is your answer!

Hope this helps!

at which value of x does the function have a jump discontinuity 50 Points !!!! dang I don't need answer file​

Answers

Answer:

b

Step-by-step explanation:

there's 2 open point lying on x equals 0

BEST GETS BRAINLIST! 16 POINTS! Help please, attached below, please do a step by step of The SohCahToa method. I help to find the height, round to the nearest hundred decimal.

Answers

Answer:

Perimeter of ΔABC = 16.46 units

Step-by-step explanation:

By applying cosine rule (CAH) in the given triangle ADB,

cos(∠BAC) = [tex]\frac{\text{Adjacent side}}{\text{Hypotenuse}}[/tex]

cos(55°) = [tex]\frac{3}{AB}[/tex]

AB = 5.23 units

Since, ΔABC is an isosceles triangle

AB = BC = 5.23 units

AD = DC = 3 units [Perpendicular drawn from a vertex of an isosceles triangle is a perpendicular bisector of the opposite side]

Therefore, AC = AD + DC = 6 units

Now perimeter of ΔABC = AB + BC + AC

                                          = 5.23 + 5.23 + 6

                                          = 16.46 units

On a ship the ratio of crew members to passengers is 1:15. There are 540 passengers. How many crew members are there?​

Answers

Answer: 36

Step-by-step explanation: Keep multiplying 15 until you get 540. 36 * 15 is 540

Answer:

36 Crew members

Step-by-step explanation:

Divide 540 by 15, to find how much the new amount of passengers had increased. It should be 36.

Now to keep the ration even, you need to multiply the amount of Crew members by 36 too.

Double checking your answer:

1/15=0.06666666667...

36/540=0.06666666667...

There's probably other ways to solve this, this is just how I did it.

GIVING AWAY 20 POINTS!!
HURRY PLEASE!!

QUESTION:
What is mBDG?

Answers

Answer:

242

Step-by-step explanation:

Circles have a total of 360°

mDBG does not include mBA or mGA

This means that mDBG = 360 - ( mBA + mGA )

mBA = 28° ( this is given )

mGA = 90° ( this is also given; it's indicated by the right angle )

Thus, mDBG = 360 - ( 28 + 90 )

28 + 90 = 118

mDBG = 360 - 118

360 - 118 = 242

Hence, mDBG = 242

distance on a street map is proportional to actual distance when the distance on the map is (1)/(2) cm, the actual distance is 3 km. shannas house is 16(1)/(2)km from the riding stables what is the distance on the map
a) 2 (3)/(4) cm
b) 5 (1)/(2) cm
C) 6cm
D) 11 cm

Answers

Answer:

b) 5 (1)/(2) cm

Step-by-step explanation:

please answer correctly !!!!! Will mark Brianliest !!!!!!!!!!!!!!

Answers

Answer:

44.1

Step-by-step explanation:

Cosine = Adjacent over Hypotenuse

Adjacent of ∠T = 28 and hypotenuse = 39

Which means that  [tex]cos(x)=\frac{28}{39}[/tex]

Now we solve for x

To get rid of the "cos" we take the inverse of cos ( which is [tex]cos^-^1[/tex] ) and apply it to each side

[tex]cos^-^1((cos)x) = x\\cos^-^1(\frac{28}{39} )=44.11461855[/tex]

We're left with x = 44.11461855

Our last step is to round to the nearest tenth and we get that the answer is 44.1

PLEASE HELP! DUE AT 11:59 PST

Amanda earns $30 per week for her allowance, plus $15 dollars per hour babysitting. She wants to earn at least $150 each week.?

Write a function F(h) to represent the situation.

How many hours must Amanda babysit each week?​

Answers

Answer:

Y = 15x + 30 and 8 hours

Step-by-step explanation:

She gets $15 per hour so her income is based on her hours, but we don't know what that is yet so, 15x.

She gets a solid $30 every week that is straight forward

To solve the function

150 = 15x + 30

subtract 30 from both sides

120 = 15x

divide 15 from both sides

8 = x

or

x = 8

You got this :)

which is the pattern for factoring the sum of cubes​

Answers

Answer:

4th option

Step-by-step explanation:

The factors of a³ + b³ are

a³ + b³ = (a + b)(a² - ab + b² )

Answer:

4th option

Step-by-step explanation:

PLEASE HELP ME ASAP

Complete the statement with a situation and a unit of your choice. Then answer the question and draw a diagram.

A small bucket holds 75% as much as a large bucket.

1. If the small holds 36 , how much does the large hold?

Answers

Answer:

???

Step-by-step explanation:

Answer:

48

Step-by-step explanation:

36          75%

----     =   -----

?            100%

36 * 100 = 3600

3600 / 75 = 48

I need help please solve for x and y rectangles

Answers

Answer:

x=4

y=103 degree

Step-by-step explanation:

8 oranges are divided equally into 2 baskets what is 1/2 of 8 oranges?

Answers

I’m pretty sure the answer is 4

I hope I’m right

Hope this helps :D

A dirt bike has been marked down 12% and now costs $4286.70. What was the original cost?

Answers

Answer:

$4871.25

Step-by-step explanation:

You know that the dirt bike has been "marked down," so to find the percentage of the original cost, subtract 0.12 from 1 to get 0.88. Then, define x as the original cost, and set up an equation:

0.88x = 4286.70

You know that 4286.70 is 88% of the original cost, so 0.88 times the original cost will equal the marked down cost. Now, divide both sides by 0.88 to get the answer:

x = 4871.25

A={1, 2, 3, 4, 5} e B = {2, 3, 7}, determine o conjunto A - B, ou seja, os elementos que pertencem somente a A e não a B .

Answers

Responder:

A - B = {1, 4, 5}

Explicação passo a passo:

Conjunto A - Conjunto B; Isso significa que queremos um conjunto que contém apenas elementos que estão no conjunto A, portanto, os elementos do conjunto A que também estão presentes no conjunto B estão isentos.

A = {1, 2, 3, 4, 5}

B = {2, 3, 7}

A - B = {1, 4, 5}

Portanto, apenas] 1, 4, 5} são elementos do conjunto A e não do conjunto B

You are preparing for a breakfast party and enough milk for 20 people. Each person will drink about 200 mL of milk. Which is the best estimation of a amount of milk you should prepare: 400 mL or 4 L? Why?

Answers

Answer:

4 l

the total ml of milk for 20 people is 4000ml and not 400 ml. 4000ml converted to litres is 4l

Step-by-step explanation:

total amount of milk for 20 people = 200 x 20 = 4000ml

1000 ml = 1 liter

4000ml /1000 = 4 l

hello please help i’ll give brainliest

Answers

Your answer is the last one!
It is going to be the last one

Start at the school. Go 6 units left and 4 units down to arrive at the library. Enter the coordinates of the library.

Answers

Answer:5,4

Step-by-step explanation:

Answer:

I think the answer is 4,5.

Step-by-step explanation:

in a coordinate grid your suppose to start X axis then the y axis so if you go 6 units left and going 4 units down then I think your answer might be 4,5. i really hope this helps out and this is right!-

Write the equation in standard form for the circle with center (-7,0) and radius 4 7

Answers

Answer:

x² + y² - 8x -14y - 105 = 0

Step-by-step explanation:

The centre of the circle is (-7,0) and the radius is (4,7) . Firstly let's find the radius using Distance formula .

=> D = √{ (-7-4)²+(0-7)²}

=> D = √ 11² + 7²

=> D = √ 121 +49

=> D = 170

Now using the standard equation of circle ⭕ ,

=> ( x - h)²+(y-k)² = r²

=> ( x - 4)²+(y-7)²= (√170)²

=> x² + 16 -8x + y² + 49 -14y = 170

=> x² + y² -8x -14y = 170 -65

=> + - 8x -14y - 105 = 0

Hence the equation of circle is x² + y² - 8x -14y - 105 = 0 .

What is the best way to gather information for each of the scenarios? Select Survey, Experiment, or Observational study for each scenario. Survey Experiment Observational study A director wants to know what his singers do before a performance. A director wants to know who his best soprano is. O A director wants to know how verbally disciplining a singer affects the group. A director wants to know what musical is the most popular in the community.​

Answers

Answer:

1. A director wants to know what his singers do before a performance. - Survey

2. A director wants to know who his best soprano is. - Observational Study

3. A director wants to know how verbally disciplining a singer affects the group. - Observational Study

4. A director wants to know what musical is the most popular in the community. - Survey

Step-by-step explanation:

I just took the same quiz :)

a zoologist hides in a bush 200 feet away from a tree inhabited by a family of monkeys. if the zoologist is looking up at an angle.of 15°, how high in the tree ate monkeys?

Answers

Answer:

[tex] \displaystyle 53.6ft[/tex]

Step-by-step explanation:

refer the attachment

let the height be h

since we are given the adjacent side and want to figure out opposite side we'll use tan function

so our equation is

[tex] \displaystyle \tan( {15}^{ \circ} ) = \frac{h}{200} [/tex]

cross multiplication:

[tex] \displaystyle h = 200\tan( {15}^{ \circ} ) [/tex]

by using calculator we acquire:

[tex] \displaystyle h \approx 53.6ft[/tex]

hence,

about 53.6ft high in the tree ate monkeys

Que es la desviación estándar?

Answers

La desviación estándar es un índice numérico de la dispersión de un conjunto de datos (o población). Mientras mayor es la desviación estándar, mayor es la dispersión de la población. La desviación estándar es un promedio de las desviaciones individuales de cada observación con respecto a la media de una distribución.

Find the width of a cereal box that has a volume of 5,440 cm3 and is 34 cm long and 20 cm high.

Answers

Answer:

8 cm wide.

Step-by-step explanation:

5440/34/20=8 .

WILL GIVE BRAINIEST FOR CORRECT ANSWER

Answers

Answer:

1) 113.1

Step-by-step explanation:

6 x 6 = 36 x Pi(3.14)

Answer:

2) 49.135

Step-by-step explanation:

The area of the triangle is 24. The area of the "half circle" is 25.1.

Add them together, and get 49.135.

Hope this Helps!

-kiniwih426

jocelyn has a sample space s= { 2,2,4,6,8,8,8,10,10,12,14,16,16,16,16,18,18,20} she creates the following subsets a= { 2,6,8,8,10,18} b = { 2,8,10,14,18,20} use the information above to find the complement of the union of a and b

Answers

Answer:

{aUb}' = {4, 12, 16}

Step-by-step explanation:

GIven S= { 2,2,4,6,8,8,8,10,10,12,14,16,16,16,16,18,18,20}

a= { 2,6,8,8,10,18}

b = { 2,8,10,14,18,20}

Required

(aUb)'

aUb = {2, 6, 8, 10, 14, 18, 20}

{aUb}' are values of the set S that are not in aUb. The required values are;

{aUb}' = {4, 12, 16}

Ally sold 18 boxes of girl scout cookies. This was 40% of the number of boxes that Kayla sold. How many boxes did Kayla sell?

Answers

Answer:

Kayla sold 90 boxes of cookies.

Step-by-step explanation:

let's have X be the number of boxes Kayla sold.

x⇒100%

18⇒20%

Find x,

x=100/20 × 18

x=90

A theater's maximum capacity is 450 people. The cost of
admission to a play at the theater is $22. The revenue
function R = 22n, in which n is the number of tickets sold,
represents the amount of income from admissions for one
performance. What values of n represent a reasonable
domain for the revenue function in this situation?

Answers

Answer:

Any real number

Step-by-step explanation:

Which of these items weighs about 1 gram?
A horse
A paper clip

Answers

Answer:

the answer is paper clip

Answer:

a paper clip

Step-by-step explanation:

Which model BEST represents each of the following scenario:
You deposit $500 into a bank account that pays 3% interest compounded annually.

Answers

Which of the following statements regarding low interest rates is true? a. They encourage investors to search for investments like Treasury bills. b. They encourage the substitution of equity by debt. They encourage investors to search for stocks paying high dividends. d.

Other Questions
PLEASE HELP THIS IS DUE IN AN HOUR!!!This is authoritarian and dictatorial power and total control over theirpeople.FascismSocialismMarxismNationalism What is the measure of 4? Please and thank you :) Simone is designing a piece of artwork for a hotel. The artwork is in the shape of a square pyramid as shown. She wants to cover the pyramid with decorative glass. Use a net to find how many square feet of glass needs to cover the entire pyramid.HELP ME!!!! I WILL GIVE YOU 50 POINTS!!!!!!! Simplify: 7x + 5y - 6x - yA. x + 5B. x + 4yC. 13x + 5D. 13x + 6y Which references and reference formats are you most likely to use? Why? A sample of 64 observations has been selected to test whether the population mean is smaller than 15. The sample showed an average of 14.5 and a standard deviation of 4.7. You want to test this hypothesis at 95% level of confidence using the critical value approach. First, compute the critical value and the test statistics associated with this test. Second, compute the difference between the test statistic and the critical value (test statistic - critical value). What is this difference The collapse of agriculture due to crop destruction, low prices, and mortgage foreclosures led to blank. A. an increase in migration from the northern United States to the southern United StatesB. an increase in demand for agricultural goods C. A mass exodus by white and black South Carolinians from the state to look for job opportunities elsewhere On the map, which letter identifies the Grand Canal?STUW platypus is considered as a bridge animal Is (x + 2) a factor of x + 6x2 + 3x 10? Read the excerpt from act 3, scene 2, of Julius Caesar.[ANTONY.] For Brutus is an honourable man,So are they all, all honourable menCome I to speak in Caesars funeral.He was my friend, faithful and just to me.But Brutus says he was ambitious,And Brutus is an honourable man.He hath brought many captives home to Rome,Whose ransoms did the general coffers fill.Did this in Caesar seem ambitious?When that the poor have cried, Caesar hath wept.Ambition should be made of sterner stuff.Yet Brutus says he was ambitious,And Brutus is an honourable man.You all did see that on the LupercalI thrice presented him a kingly crown,Which he did thrice refuse. Was this ambition?Yet Brutus says he was ambitious,And sure he is an honourable man.How is the word honourable used in the context of Antonys speech?It is used as a public expression of praise toward Brutus.It is used as a negative and ironic word to describe Brutus.It is used to show Brutus that Antony thinks more highly of him than Antony does of Cassius.It is used to explain how necessary and noble both the conspirators cause and Caesars death were11 A cell phone company advertises that their data plan costs "0.02 cents" for every kilobyte of data. Corinne used 1000 kilobytes of data. Using the advertised price, determine how much Corinne owes on the data plan. what is the most metallic item on the pterotic table Rewrite the parts of the sentence below in the correct order- add capital letters as needed: What do scientists use the term light-year to describe? You have just gotten your first job. You have decided you want to take your parents out for dinner to celebrate and you have anticipated it will cost approximately $120 for the three of you to go out for dinner. At your job, you make an hourly wage of $11. How many hours would you need to work to pay for the dinner? What if you wanted to add a 15% tip? Could your strategy also allow you to find out how much money you made for any number of hours? Use the following rectangle to solve for the values of X. Solve the varible :1: -5z + 8 = 33 2: -4b - 7 = 37 3: 8x + (-9) = 454: 6c + 7 = -29 .(04.03 LC)Lee y escoge la opcin con la forma correcta del verbo en subjuntivo para completar la frase.Read and choose the option with the correct form of the subjunctive to complete thesentence.Rodrigo les pide a los vecinos que noruido. (1 point)O haganO hacenO haceO haca Japan launches the surprise attack on Pearl Harbor in 1941 after the United States had done what?