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.
False u would figure out yourself if it's good or bad
Answer:
It automatically applies formatting based on specific rules or conditions being met. It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
Explanation:
Answer:
The sum of all positive even values in arr
Explanation:
We have an array named arr holding int values
Inside the method mystery:
Two variables s1 and s2 are initialized as 0
A for loop is created iterating through the arr array. Inside the loop:
num is set to the ith position of the arr (num will hold the each value in arr)
Then, we have an if statement that checks if num is greater than 0 (if it is positive number) and if num mod 2 is equal to 0 (if it is an even number). If these conditions are satisfied, num will be added to the s1 (cumulative sum). If num is less than 0 (if it is a negative number), num will be added to the s2 (cumulative sum).
When the loop is done, the value of s1 and s2 is printed.
As you can see, s1 holds the sum of positive even values in the arr