COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN: 9780357392676
Author: FREUND, Steven
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Table 1 shows some commonly used electrical formulas.
Table 1: Electrical Formulas
Quantity
Charge
Capacitance
Voltage
Current
Resistance
Power
Conductance
Impedance
Resonant Frequency
Formula
Q=CXV
C = Q÷V
V = IR
I=V÷R
R=V÷I
P = VI
G = 1+R
Z² = R² + (XL-Xc)²
f=
1
2n√LC
Unit
Coulomb (C)
Farad (F)
Volt (V)
Ampere (A)
ohm (2)
Watt (W)
mho (mho)
ohm (2)
Hertz (Hz)
Develop a complete C++ program using functions to calculate all quantity as
listed in Table 1. Prompt the user to choose what quantity they want to calculate,
then ask them to input the values. Show all the function declarations,
function definitions and function call in your program. Terminate the
program only if the user wants to stop.
Find the h °g and g °h for following:
a. If g(x) = Vx – 4 and h(x) = x³ + 4
b. If g(x) = x² +1 and h(x) = x +2
Q7:The electricity accounts of residents in a very small town are
calculated as follows:
if 500 units or less are used the cost is 2 cents per unit;
> if more than 500, but not more than 1000 units are used, the cost is
$10 for the first 500 units, and then 5 cents for every unit in excess of
500;
> if more than 1000 units are used, the cost is $35 for the first 1000 units
plus 10 cents for every unit in excess of 1000;
in addition, a basic service fee of $5 is charged, no matter how much
electricity is used.
Q8:Write a program which enters the following five consumptions into a
vector, and uses a for loop to calculate and display the total charge for
each one: 200, 500, 700, 1000, 1500. (Answers: $9 $15, $25, $40, $90)
Knowledge Booster
Similar questions
- 6. What function and formula was used in cell E13?a. =MEAN(E3:E12)b. =AVERAGE(E3:E12)c. =SUM(E3:E12)d. =TOTAL(E3:E12)arrow_forward6. Given single-character codes for the colored bands that mark a resistor, compute its resistance. The color codes are as follows: Color Code Character Code Black 'B' Brown 'N' 1 bandı Red 2 | banda bands Orange Yellow 3 4 band4 Green Blue 6 Violet Gray White 7 'V' 'A' 9 "W' Figure 1: Resistor Color Bands Table 1: Resistor Color Codes The resistance (2) value of a resistor can be found using the integer value for each color band as follows: R = (bandl * 10 + band2) * 10band3 Write C++ program that finds the resistor value from its color code and output the answer as a numerical format. Remember to use function(s)! P.S.: Use the character code in shown in Table 1 order to represent each color. Sample output Input three color codes: YVO Resistance is: 47000 Ohms.arrow_forwardIn cell L16, enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects.arrow_forward
- The SUMPRODUCT function calculates the total of the cells that satisfy a given condition True Falsearrow_forwardA three stage amplifier is to have an overall noise temperature no greater than 7O K. The overall gain of the amplifier is to be at least 45 dB. The amplifier is to be built by adding a low-noise first stage to an existing two-stage amplifier that has the gains and noise figures shown below. The stage number refer to locations in the new amplifier. Stage Power Gain Noise Figure 20 dB 3 dB 13 15 dB 6 dB a. What is the minimum gain in decibels that the first stage can have? b. Using the gain you calculated in part (a), calculate the maximum noise figure in decibels that the first stage can have. Express answer with two decimal places. c. Suppose the gain of the first stage could be increased by 3 dB without affecting its noise figure. What would be the effect on the noise temperature of the complete amplifier?arrow_forward–+l ls=405 1RGEarrow_forward
- A software company sells a package that retails for $100. Quantity discounts are given according to the following tables. Quantity 10-19 Discount 20% 30% 40% 50% 20-49 50-99 100 or more Asks for the number of units sold and computes the total cost of the purchase.arrow_forwardProblem: Assume that you have been hired at Oman Investment and Finance Co. SAOG (OIFC) to write a java program that prints a summary of customers' bills for water and electricity. Each bill has type, account number, consumption amount (kilowatt/gallon) and the month of the bill. Each bill charges an amount of 16.78 OMR as supply service charges. Electricity bill is either industrial or residential. The electricity total energy charge is computed based on the type of the usage. For industrial each kilowatt consumed costs 12 Baisa while for residential it costs 10 Baisa per kilowatt consumed. The total amount is the sum of the energy charges plus the bill charges. Water bill applies different rates based on the water consumption where the first 5000 gallons cost 2 Baisa per gallon and any gallon more than 5000 costs 2.5 Baisa. Water bill also includes sewage charges which is one third the water charges. The total amount is the sum of the water charges, sewage charges and the bill…arrow_forwardSample Run 1 Enter the material: metal- Enter the number.of units::700- Cost per metal: 5.00- Shipping cost: 50.00- Total cost::3550.00- Sample Run 2 Enter the material: bricke Enter the number.of units::10- Cost per metal: 1.00- Shipping cost: 20.00- Total cost::30.00- Sample Run 3 Enter the material: paint- Enter the number.of units::100- Error- Sample Run 4 Enter the material: wood- Enter the number.of units:-23- Error- Additional Notes: Regarding your code's standard output, CodeLab will check for case errors and will check whitespace (tabs, spaces, newlines) exactly. O Interactive Session ? O Visible newlines O Visible whitespace O Display stdin O Display stdout wood 278 Cost per wood: 8.00 Shipping cost: 25.00 Total cost: 2249.00arrow_forward
- Let a DFA M = (Q, E, 8, 9,, F) as shown in below figure. 93 9,arrow_forward1) Given the percentages below; [e: 13%, a: 8%, o: 7%, i: 7%, u: 3%] a) Give the value of Pr(x is a vowel) b) Give the value of Pr(x = ‘e’ |x is a vowel) c) Give the value of Pr(x is a vowel |x is not ‘a’)arrow_forwardThe average daily temperature for an area can be approximated using the following equation: T = Tmean + (Tpeak – Tmean) cos (@(t – tpeak) %3D where Tmean is the mean temperature over a year, Tpeak is the highest daily mean temperature, w is the frequency of annual variation, tpeak is the day that the peak temperature occurs, and t represents the days 33 to 400 (inclusive, increments of 1). w has the value 2n/365. A. Write a function that takes Tpeak, tpeak, Tmean and t as inputs (4 inputs) and outputs the following 3 return values: The temperature for for each day The minimum temperature for the year The day with the minimum temperature B. In 2008, Melbourne's temperature statistics were: Tpeak = 25.9°C, tpeak = 13 and Tmean = 19.8°C Use the function you wrote in part A to plot on a single figure the following: Temperature for every day of the year as a black continuous line Use fprintf() to print the minimum temperature and the day it occurred. Then use a red asterisk to mark it on…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
C++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr