All categories

3 years ago

Which function adds values from multiple cells and returns a specific numeric value?

Computers and Technology

1 answer:

Zielflug [23.3K]3 years ago

7 0

The function sum() adds values from multiple cells and returns a specific numeric value.

Explanation:

The sum() function is used to add many values that are specified within the function. the values that are in need to be summed up must be given as an argument to this function. This function returns the specific value which is the summed up result. The specification =SUM(A2:A10) is used to sum up the values of the cells A2 to A10.

The argument of this function may be an array, range of cells, values etc. This function will ignore the cells that are empty and cells that has text values. If an error occurs in the argument then the result returned will also have error. The function Aggregate is used to ignore these errors.

You might be interested in

Displays information a bout drivers, network connections, and other program-related details.

slava [35]

Answer:

library

Explanation:

hope you like it

6 0

3 years ago

Which devices are often used inside of tablets to store data on these devices?

My name is Ann [436]

Answer:

Explanation:

Current tables such as the new iPads use solid state drives to store data.

6 0

2 years ago

What set of code correctly initializes all elements of the array ar to the value 0, given the declaration

Veronika [31]

Answer:

The correct answer is:

C. ndx = 0;

while (ndx < 3) {

ar[ndx] = 0;

ndx++;

}

Explanation:

The declaration given is:

int ar[3];

This means the array consists of three locations and is named as ar.

We know that the indexes are used to address the locations of an array and the index starts from 0 and goes upto to 1 less than the size of the array which means the indexes of array of 3 elements will start from 0 and end at 2.

Now in the given options we are using ndx variable to run the while loop.

So the code to assign zero to all elements of array will be

ndx = 0;

while(ndx<3)

{

ar[ndx] = 0;

ndx++;

}

Hence, the correct answer is:

C. ndx = 0;

while (ndx < 3) {

ar[ndx] = 0;

ndx++;

}

7 0

2 years ago

Which kind of device is a printer? A. an output device B. an input device

Andrew [12]

Well a printer takes data and puts it on a piece of paper so it would be an output device

5 0

3 years ago

Read 2 more answers

There has been something I had to ask but I have to type this so it goes through: creeper?

VMariaS [17]

Answer:

awwwwwwwwwwwwwwwwwww man

Explanation:

So we back in the mine

Got our pickaxe swinging from side to side

Side-side to side

This task, a grueling one

Hope to find some diamonds tonight, night, night

Diamonds tonight

Heads up

You hear a sound, turn around and look up

Total shock fills your body

Oh, no, it's you again

I can never forget those eyes, eyes, eyes

Eyes-eye-eyes

'Cause, baby, tonight

The creeper's tryna steal all our stuff again

'Cause, baby, tonight

You grab your pick, shovel, and bolt again (Bolt again-gain)

And run, run until it's done, done

Until the sun comes up in the morn'

'Cause, baby, tonight

The creeper's tryna steal all our stuff again (Stuff again-gain)

Just when you think you're safe

Overhear some hissing from right behind

Right-right behind

That's a nice life you have

Shame it's gotta end at this time, time, time

Time-time-time-time

[Pre-Chorus: TryHardNinja]

Blows up

Then your health bar drops and you could use a one-up

Get inside, don't be tardy

So, now you're stuck in there

Half a heart is left, but don't die, die, die

Die-die-die

'Cause, baby, tonight

The creeper's tryna steal all our stuff again

'Cause, baby, tonight

You grab your pick, shovel, and bolt again (Bolt again-gain)

And run, run until it's done, done

Until the sun comes up in the morn'

'Cause, baby, tonight

The creeper's tryna steal all our stuff again

(Creepers, you're mine, haha)

Dig up diamonds and craft those diamonds

And make some armor, get it, baby

Go and forge that like you so MLG pro

The sword's made of diamonds, so come at me, bro, huh

Training in your room under the torchlight

Hone that form to get you ready for the big fight

Every single day and the whole night

Creeper's out prowlin', hoo, alright

Look at me, look at you

Take my revenge, that's what I'm gonna do

I'm a warrior, baby, what else is new?

And my blade's gonna tear through you, bring it

'Cause, baby, tonight

The creeper's tryna steal all our stuff again

(Gather your stuff, yeah, let's take back the world)

Yeah, baby, tonight (Haha)

Grab your sword, armor and go (It's on)

Take your revenge (Woo), oh-oh, oh-oh

So fight, fight, like it's the last, last night

Of your life, life, show them your bite (Woo)

'Cause, baby, tonight

The creeper's tryna steal all our stuff again

'Cause, baby, tonight

You grab your pick, shovel and bolt again (Bolt again-gain, woo)

And run, run until it's done, done

Until the sun comes up in the morn'

'Cause, baby, tonight (Come on, swing your sword up high)

The creeper's tryna steal all our stuff again (Come on, jab your sword down low)

(Woo)

3 0

3 years ago