Answer:
=IF(D3>50; E3; F3) and =IF(A1>60;"Pass";"Fail") are valid IF formulas.
Explanation:
P.S - The exact question is -
To find - Select the correct answer from each drop-down menu. Which IF formulas are valid? _____ and _____ are valid IF formulas.
FIRST BLANK
=IF(D3>50; E3; F3)
=IF(D3>50);( E3; F3)
=IF(10<5;23);("Incorrect")
SECOND BLANK
=IF(A1>60;"Pass";"Fail")
=IF(A1>60); ("Pass"; "Fail")
=IF(A1>60; ("Pass"; "Fail"))
Solution -
An IF structure is built following this pattern:
IF(TEST;IF TRUE;IF FALSE)
So,
The correct option is -
=IF(D3>50; E3; F3) and =IF(A1>60;"Pass";"Fail") are valid IF formulas.
Answer:
#include <iostream>
using namespace std;
double DrivingCost(int drivenMiles,double milesPerGallon,double dollarsPerGallon)
{
double dollarsperMile=dollarsPerGallon/milesPerGallon;//calculating dollarsperMile.
return dollarsperMile*drivenMiles;//returning thr driving cost..
}
int main() {
double ans;
int miles;
cout<<"Enter miles"<<endl;
cin>>miles;
ans=DrivingCost(miles,20.0,3.1599);
cout<<ans<<endl;
return 0;
}
Output:-
Enter miles
10
1.57995
Enter miles
50
7.89975
Enter miles
100
15.7995
Explanation:
In the function first I have calculated the dollars per mile and after that I have returned the product of dollarspermile and driven miles.This will give the cost of the Driving.
Answer:
Check the explanation
Explanation:
# Step 1
the first thing to execute will be......
f = open("states.txt")
# Step 2
the second step is......
states = []
for line in f:
states.append(line.strip())
# Step 3:
the third step is to......
for state in sorted(states):
print(state)
f.close()
Here is a Python program:
tmp = input().split(' ')
c = tmp[0]; s = tmp[1]
ans=0
for i in range(len(s)):
if s[i] == c: ans+=1
# the ans variable stores the number of occurrences
print(ans)
Answer:
formula bar
Explanation:
The formula bar in Excel is located next to the name box
and above the worksheet area. It displays the data stored in
the active cell. The formula bar is used to view, enter, and
edit values and formulas in cells.