All categories

3 years ago

Why are formulas used in spreadsheets?

Computers and Technology

1 answer:

cluponka [151]3 years ago

7 0

Answer:

The answer to this question is given below in the explanation section.

Explanation:

The correct answer to this question is B.

The formulas in the spreadsheet are used to do the automatic calculation when data is changed in the spreadsheet.

For example, if you add numbers in a column and then get average. you can use sum() and average() formula to calculate the sum and average of numbers in a column. If you will change any number in the column, the calculation for sum and average automatically done. So, the answer to this question is B. i.e.

so that calculations are automatically redone when data is changed.

While the other options are not correct because:

To ensure data is entered correctly is done by validation not by using formula.
To ensure data is properly formated is done in the formatting section.
The error can be easily identified using validation features in excel.

You might be interested in

If you cannot find a template on your computer that was appropriate for your task, what should you do?

DanielleElmas [232]

Answer:

The correct option for this question is File.

Explanation:

5 0

3 years ago

Write code to assign the number of characters in the string rv to a variable num_chars.

kramer

Answer:

rv = "hello"

num_chars = len(rv)

print(num_chars)

Explanation:

*The code is in Python.

Initialize the string rv, in this example I set it to "hello"

Use the len() method to get the number of characters in the rv and set it to the num_chars

Print the num_chars

Note that the result will be 5 in this case, because <em>hello</em> consists of five characters

6 0

4 years ago

Which property do you use to align an element horizontally with the left or right edge of its parent element?

Ugo [173]

A thank me later:) give me hearts

3 0

3 years ago

6. Consider a circle of diameter d cm.

blagie [28]

Circles

Area of Circle is $\pi d^{2} /4$

Total percentage increase in the area of the modified circle is 69%

Explanation:

(a) Given the diameter of the circle be d

Then the radius of the circle = r = d/2

and the area of the circle is given by:

Area(A) = $\pi r^{2}$

A = $\pi (d/2)^{2}$

A = $\pi d^{2} /4$

The area of circle is $\pi d^{2} /4$

(b)

The increase in percentage while changing the dimensions is given by the formula :

Total % increase = a% + b% - (a% * b%)/100

Where ,

a% is the percentage increase in side a

b% is the percentage increase in side b

Let the percentage increase in radius is : a%

Since a% = b%

So the formula is

Total increase % = a% + a% + (a% * a%)/100

Given here the diameter of the circle increases by 30% so a =30

Therefore, putting the value of a in the formula

Total increase % = 30% + 30% + (30% *30%)/100

Total increase % = 60% + 9%

Total increase % =69%

Therefore the total percentage increase in the area of the modified circle is 69%

8 0

3 years ago

Design and implement a structured program for manipulating arrays data structures, as follow:

tekilochka [14]

#include <stdio.h>

struct student {

char firstName[50];

int roll;

float marks;

} s[5];

int main() {

int i;

printf("Enter information of students:\n");

// storing information

for (i = 0; i < 5; ++i) {

s[i].roll = i + 1;

printf("\nFor roll number%d,\n", s[i].roll);

printf("Enter first name: ");

scanf("%s", s[i].firstName);

printf("Enter marks: ");

scanf("%f", &s[i].marks);

}

printf("Displaying Information:\n\n");

// displaying information

for (i = 0; i < 5; ++i) {

printf("\nRoll number: %d\n", i + 1);

printf("First name: ");

puts(s[i].firstName);

printf("Marks: %.1f", s[i].marks);

printf("\n");

}

return 0;

}

#◌⑅⃝●♡⋆♡Nåmřāthā ♡⋆♡●⑅◌

6 0

2 years ago