The value that would be returned based on the formula [=COUNTIF(A43:A47, "NP*")] in cell A49 is 4.
Microsoft Excel can be defined as a software application that is designed and developed by Microsoft Inc., so as to avail its end users the ability to analyze and visualize spreadsheet documents.
In Microsoft Excel, there are different types of functions (predefined formulas) and these include:
A count function is typically used to to calculate the number of entries in a cell or number field that meets a specific (predefined) value set by an end user.
In this scenario, "NP*" is the specific (predefined) value that was set and as such the value that would be returned based on the formula in cell A49 is 4 because A43, A44, A45 and A46 contain the value "NP."
Read more on Excel formula here: brainly.com/question/25219289
Answer:
The explanation is for 10 inputs though. You'd have to follow these steps to find input 50 numbers.
Explanation:
This is how I wrote it in the Plain English programming language which looks like pseudo-code but compiles and runs (to save you all the rest of the steps):
To run:
Start up.
Write "Enter 10 numbers separated by spaces: " on the console.
Read a reply from the console.
Loop.
If the reply is blank, break.
Get a number from the reply.
Add 1 to a count.
Add the number to a total.
Repeat.
Write "The total is: " then the total on the console.
Put the total divided by the count into an average.
Write "The average is: " then the average on the console.
Refresh the screen.
Wait for the escape key.
Shut down.
Answer:
See explaination for the program code
Explanation:
The Programming code:
inFile = open("stuff.txt", "r")
num = []
Sum = 0
for val in inFile.readlines():
value = val.split(",")
Sum = Sum + int(value[1])
print("Sum of second number on every line in the file is: ", Sum)
inFile.close()
Please kindly check attachment for output
Answer:
See explanation
Explanation:
Given
if(fish > 400) {
Required
What is the condition checking?
The above statement is an if conditional statement. Analysing the statement in bits:
if -> This represents the beginning of the conditional statement
fish -.> The variable that is being checked
> 400 -> The condition which the variable is being measured by.
So, the statement above is checking if the value of variable fish is greater than 400.
<em>If the condition is true, the instructions associated to that if statement will be executed.</em>
