All categories

3 years ago

Enter a formula in cell b7 to calculate the average value of cells b2:b6

1 answer:

7 0

The answer is =AVERAGE(B2:B6)
Or, you can just go to "HOME" tab, then click the arrow down next to AutoSum, click the AVERAGE, then select B2:B6.
Average, which is also called arithmetic mean,can be calculated manually by adding all the numbers in a set, then dividing the count of the numbers in a set. But, in excel, there are shortcut formulas to calculate it.

You might be interested in

Several steps are involved in creating a presentation. What is the last step in the process before preparing to present it?

kupik [55]

The answer to this is B.

8 0

3 years ago

Read 2 more answers

Background information

Ber [7]

Well I guess no breathing for you lol

6 0

3 years ago

Read 2 more answers

Consider the following statements: #include #include class Temporary { private: string description; double first; double second;

Anna007 [38]

#include <iostream>

#include <iomanip>

using namespace std;

class temporary

{

public:

void set(string, double, double);

void print();

double manipulate ();

void get (string&, double&, double&);

void setDescription(string);

void setFirst(double);

void setSecond(double);

string getDescription() const;

double getFirst () const;

double getSecond () const;

temporary(string = "", double = 0.0, double = 0.0);

private:

string description;

double first;

double second;

};

void temporary::set(string a, double dblA, double dblB)

{

description = a;

first = dblA;

second = dblB;

}

void temporary::print()

{

cout << "\nDescription: " << left << setw(20) << description << endl <<

" first: " << fixed << setw(10) << setprecision(2) << first << endl <<

" second: " << fixed << setw(10) << setprecision(2) << second << endl;

}

double temporary::manipulate()

{

return first / 3.0 + second / 4.0;

}

void temporary::get(string& strDesc, double& dblFirst, double& dblSecond)

{

strDesc = description;

dblFirst = first;

dblSecond = second;

}

temporary::temporary(string d, double a, double b) : description(d), first(a), second(b) {}

void temporary::setFirst(double dblFirst){first = dblFirst;}

void temporary::setSecond(double dblSecond){second = dblSecond;}

void temporary::setDescription(string desc){description = desc;}

string temporary::getDescription() const {return description;}

double temporary::getFirst () const{return first;}

double temporary::getSecond () const {return second;}

int main()

{

cout << "temporary a;";

temporary a;

a.print();

cout << "a.setFirst(3.0): ";

a.setFirst(3.0);

a.print();

cout << "a.setSecond(4.5): ";

a.setSecond(4.5);

a.print();

cout << "a.setDescription(\"Picture Frame\") ";

a.setDescription("Picture Frame");

a.print();

cout << "a.print(): ";

a.print();

return 0;

}

6 0

4 years ago

) Consider the array called myArray declared below that contains and negative integers. Write number of positive integers in the

grigory [225]

Answer:

#include <iostream>

using namespace std;

int main()

{

int arr[]={3,-9,9,33,-4,-5, 100,4,-23};

int pos;

int n=sizeof(arr)/sizeof(arr[0]);

for(int i=0;i<n;i++){

if(arr[i]>=0){

pos++;

}

cout<<"Number of positive integers is "<<pos<<endl;

return 0;

}

Explanation:

create the main function in the c++ programming and declare the array with the element. Then, store the size of array by using the formula:

int n=sizeof(arr)/sizeof(arr[0]);

after that, take a for loop for traversing the array and then check condition for positive element using if statement,

condition is array element greater than or equal to zero.

if condition true then increment the count by 1.

this process happen until the condition true

and finally print the count.

6 0

3 years ago

Given an int variable n that has already been declared and initialized to a positive value, and another int variable j that has

OLEGan [10]

Answer:

#include<iostream>

using namespace std;

//main function

int main(){

//initialize the variables

int n = 5;

int j=1;

// for loop

for(;j<=n;j++){

cout<<"*"; //print the '*'

}

Explanation:

Create the main function and declare the variable n with the value 5 and initialize the variable j with zero.

take a for loop for executing the statement again and again until a condition is not false.

Syntax for loop:

for(initialize; condition; increment/decrement)

{

statement;

}

we can initialize the variable outside as well but the semicolon always present in the loop otherwise compiler gives the error.

for example:

int i=0;

for(; i<4; i++){

statement;

}

The condition put in the original code is j <= n and n has the value 5. so, the loop executes 5 times and inside the loop, write the print statement for print the character '*'.

6 0

4 years ago