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
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)
Shamira Laundry has designed a new calculation system for their shop. The price for each
type is as follows:
10
Туре
Price
Clothes
RM 15 for 1 kilogram
blankets / towels
RM 6 for 1 kilogram
RM 10 for 1 kilogram
comforter
Only one type can be washed at a time. This laundry shop also provides discounts to its
customers as follow:
Total price
>= RM30
Discount
10% from total price
>= RM20 dan = RM15 dan
In cell L16, enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects.
Knowledge Booster
Similar questions
- Matlabarrow_forwardIn Saudi Arabia, the Kudai Parking Area is a parking lot that is next to the Ajyad Police Station and close to the Power Plant. Kudai is a well-known parking space near Masjid al-Haram. After parking there, you can take a taxi to Masjid al-Haram for 10-15 Riyals for a 10-minute drive. The parking is usually heavily occupied, and the following formula is used to compute the parking lot uțilization: Percentage of Parking Lot Utilized - Number of lots occupied + Total number of lots Write a program that calculates the occupancy rate for each zone of a massive parking lot like Kudai. The program should start by asking for the number of zones in the parking lot. A loop should then iterate once for each zone. During each iteration, the loop should ask the user for the number of lots in the zone and the number of them that are occupied. After all the iterations, the program should display the number of lots the parking has, the number of them that are occupied, the number that is vacant, and…arrow_forwardContext: Measuring Air Quality Levels of various air borne pollutants such as Nitrogen Monoxide (NO), Nitrogen Dioxide (NO2) and particulate matter (also called particle pollution) are all major contributors to the measure of overall air quality. For instance, NO2 is measured using micrograms in each cubic metre of air (㎍/m3). A microgram (㎍) is one millionth of a gram. A concentration of 1 ㎍/m3 means that one cubic metre of air contains one microgram of pollutant. To protect our health, the UK Government sets two air quality objectives for NO2 in their Air Quality Strategy The hourly objective, which is the concentration of NO2 in the air, averaged over a period of one hour. The annual objective, which is the concentration of NO2 in the air, averaged over a period of a year. The following table shows the colour encoding and the levels for Objective 1 above, the mean hourly ratio, adopted in the UK. Index 1 2 3 4 5 6 7 8 9 10 Band Low Low Low Moderate Moderate Moderate High…arrow_forward
- Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit and surcharge of 15% of bill is added. •If the units consumed are more than 1000, then the cost is Rs 15/- per unit and surcharge of 25% of bill is added. Trace the production rules for the sample execution of the system given below;Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit…arrow_forwardThe SUMPRODUCT function calculates the total of the cells that satisfy a given condition True Falsearrow_forwardQuestion-related to R code The English Premier League (EPL) is a major soccer league in Great Britain consisting of 20 teams. The season begins in August and concludes in May with each team playing each other team exactly twice (home and away). Each team plays 38 games in a season while the total number of games is 380. A team receives 3 points for a win and if the game is tied, both teams receive 1 point; no points are awarded for a loss. The EPL game results are found at http://www.football-data.co.uk/englandm.php under the heading Premier League. Your Question: Develop a function with the inputs of date and season that returns the league standings for the date and season specified. The season specified should, at a minimum, accept the current seasons and both of the two most recently completed seasons in order for your submission to be eligible for full credit. Data: The csv data files available via the weblink provided above contain a lot of information that is not needed…arrow_forward
- The United States federal personal income tax is calculated based on filing status and taxable income. There are four filing statuses: single filers, married filing jointly, married filing separately, and head of household. The tax rates vary every year. Table 4.2 shows the rates for 2009. If you are, say, single with a taxable income of $10,000, the first $8,350 is taxed at 10% and the other $1,650 is taxed at 15%. So, your tax is $1,082.50. TABLE 4.2 2009 U.S. Federal Personal Tax Rates Marginal Tax Rate 10% 15% 25% 28% 33% 35% Single $0-$8,350 $8,351-$33.950 $33,951-$82,250 $82,251 - $171,550 $171,551-$372,950 $372,951+ Married Filing Jointly $0-$16,700 $16,701-$67,900 $67.901-$137,050 $137,051 - $208,850 $208,851-$372,950 $372,951+ Married Filing Separately $0-$8,350 $8,351-$33,950 $33,951 - $68,525 $68,526-$104,425 $104,426-$186,475 $186,476+ Head of Household $0-$11,950 $11,951-$45,500 $45,501-$117,450 $117.451-$190,200 $190,201-$372,950 $372.951+ You are to write a program to…arrow_forwardAssignment Write a program that calculates the revenue of a trip of a train composed of several train-cars. For the train, the user will give the total allowed train- car count (int), total allowed weight (double), and base speed (double). Then, the user will give train-car information for ALL train-cars that will TRY TO BE ADDED to the train. First, the number of train-cars will be given (int). For each train-car, three information will be given: type of the cargo (std:string), weight of the train-car (double), and how full the train-car is (int). After getting all this information, the program will TRY TO ADD each train-car to the train according to the train-car count and total allowed weight values. You CANNOT ADD a train-car to a train if it exceeds its train-car count. You CANNOT ADD a train-car to a train if by adding this train-car, the total weight of the train exceeds the train's total allowed weight. Each added train-car reduces the speed of the train by half its weight.…arrow_forwardA 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_forward
- - For all the employees supervised by KING, give them a salary increase, which is equal to the 2% of the company’s average salaryarrow_forwardPERL programming: sort the data according to the employees salary (the last column). Use the Schwartzian transform method.arrow_forwardUsing excel: A telecom company needs to build a set of cell towers to provide signal coverage for the inhabitants of a given city. A number of potential locations where the towers could be built have been identified. The towers have a fixed range, and due to budget constraints only a limited number of them can be built. Given these restrictions, the company wishes to provide coverage to the largest percentage of the population possible. To simplify the problem, the company has split the area it wishes to cover into a set of regions, each of which has a known population. The goal is then to choose which of the potential regions the company should build cell towers on in order to provide coverage to as many people as possible. The table below shows which of the regions are covered when a tower is build in that region. Note "-" means the tower build cannot serve the region. Region 0 Region 1 Region 2 Region 3 Region 4 Region 5 Region 0 1 1 - - - 1…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