In the range D5:D9 on all five worksheets, Gilberto wants to project next year's sales for each accessory, rounded up to zero decimal places so the values are easier to remember. In cell D5, enter a formula using the ROUNDUP function that adds the sales for batteries and chargers in 2021 (cell B5) to the sales for the same accessories (cell B5) multiplied by the projected increase percentage (cell C5). Round the result up to 0 decimal places. Fill the range D6:D9 with the formula in cell D5.
I just need the formula!!
A B C D
5
Batteries and chargers $ 123,274.42 1.50% $ 125,124

Answers

Answer 1

Answer:

Enter the following in D5:

=ROUNDUP((SUM(B5,B5)*C5),0)

Explanation:

Required

Add up B5 and B5, then multiply by C5.

Save result rounded up to 0 decimal places in D5

The required computation can be represented as:

D5 = (B5 + B5) * C5 [Approximated to 0 decimal places]

In Excel, the formula is:

=ROUNDUP((SUM(B5,B5)*C5),0)

Analyzing the above formula:

= ---> This begins all excel formulas

ROUNDUP( -> Rounds up the computation

(SUM(B5,B5) ---> Add B5 to B5

*C5) --> Multiply the above sum by C5

,0) ---> The computation is rounded up to 0 decimal places

To get the formula in D6 to D9, simply drag the formula from D5 down to D9.

The resulting formula will be:

=ROUNDUP((SUM(B6,B6)*C6),0)

=ROUNDUP((SUM(B7,B7)*C7),0)

=ROUNDUP((SUM(B8,B8)*C8),0)

=ROUNDUP((SUM(B9,B9)*C9),0)

Answer 2

Answer:

=ROUNDUP((SUM(B5)+(B5)*C5),0)

Explanation:

I followed Mr. Royal's explanation but the numbers just would not match.

I adjusted and used the formula above in cell D5 and I was able to get the correct sum.


Related Questions

When it comes to paying bills at restaurants, Wallace always leaves a 15% tip based on the pretax price. However, Wallace is tired of computing tips every time, please construct a function total_bill, which takes a numerical argument pretax and returns the total bill by 1) calculating the tip, 2) the after-tax price, and 3) adding the tip to the after-tax price. Assume the sale tax is 9%. Below is how the function would be used:
pretax = 15
print('The total bill is ${}'.format(total_bill(pretax)))
The output should be:
The total bill is $18.6

Answers

Answer:

where are the answers.

Explanation:

PLZZ HELP HELP EL
SMMSNSM

Answers

Answer:

jfhhdbdbfjdjdvebbebzbdbd

king(a. has eaten b.ate c.had eaten) when Airah called​

Answers

Answer:

c

Explanation:

king had eaten when Airah called

When is blue for when the instance in which the directory of compulsion in the air!

Answers

I think it’s what the other person said

How many cycles would it take to complete these multicycle instructions after pipelining assuming: Full forwarding 1 Adder that takes 2 cycles (subtraction uses the adder) 1 Multiplier that takes 10 cycles 1Divider that takes40 cycles 1 Integer ALU that takes1cycle(Loads and Stores) You can write and read from the register file in the same cycle. Begin your your cycle counting from 1 (NOT 0)

Answers

js downs djdknsekmnd

How can you create the first row of the table as the header of the table?
In the Insert Table dialog box, you select the ______
checkbox to create the first row as the header of the table.

Answers

Answer:

table style option

Explanation:

Answer: table style

Explanation:


Imaging a computer is part of what phase of conversion?
a. Backup
b. Configuration
c. Procurement

Answers

B. Because the computer can rearrange itself when it is in a phase of conversion

HELP PLEASE
What will be printed to the console after this program runs?
var numbers = [2, 5, 3, 1, 6]
function changeNums(numList, addNum, subtractNum) {
for(var i=0; i if(numList[i] % 3 == 0){
numList[i] = numList[i] + addNum;
} else {
numList[i] = numList[i] - subtract Num;
}
}
}
changeNums (numbers, 3, 2);
console.log(numbers);

Answers

The output that will be printed to console after the program runs is (b) [0, 3, 6, -1, 9]

When the program is analyzed, we have the following highlights

The program increases numbers that are divisible by 3, by the value of variable addNumOther numbers are reduced by the value of variable subtractNum

In the program, the values of addNum and subtractNum are 3 and 2, respectively.

In the list, 3 and 6 are divisible by 3

2, 5 and 1 are not divisible by 3

When the program runs, 3 and 6 are replaced by 6 and 9.

While 2, 5 and 1 are replaced by 0, 3 and -1

Hence, the output that will be printed to console after the program runs is (b) [0, 3, 6, -1, 9]

Read more about similar programs at:

https://brainly.com/question/24833629

3.5.6 Introduce Yourself, Part 2


please hellllpp it keeps saying the code is wrong

Answers

Answer:

In Python:

name = "Arthur"

age = "62"

print("Hi! My name is "+name+" and I am "+age+" years old")

Explanation:

Given

See attachment

Required

Write a code to introduce yourself

Initialize name

name = "Arthur"

Initialize age

age = "62"

Print introduction

print("Hi! My name is "+name+" and I am "+age+" years old")

See the picture and answer the coding question

Answers

Answer:

Actually I don't know computer so I can't help you sorry bro

Take a better picture please

29. Write a program in a script file that calculates the cost of renting a car according to the following price schedule: The program asks the user to enter the type of car (sedan or SUV), the number of days, and the number of miles driven. The program then displays the cost (rounded to cents) for the rent. Run the program three times for the following cases: (a) Sedan, 10 days, 769 miles. (b) SUV, 32 days, 4,056 miles. (c) Sedan, 3 days, 511 miles.

Answers

Answer:The price for renting a car at a car rental company is according to the following schedule: Write a MATLAB program in a script file that calculates the cost of renting a car based on the shown price schedule. The program must ask the user to enter the type of car (Sedan or SUV), the number of days, and the number of miles driven. The program then displays the cost (rounded to cents) for the rent in a sentence that reads: "The cost of the rent is XXX $." where XXX is the cost value in $. Run the program three times for the following cases: Sedan, 10 days, 769 miles. SUV, 32 days, 4, 056 miles. Sedan, 3 days, 511 miles. Use fprintf () to display the text and data. The data should be displayed in f format with two decimal digits.

Explanation:

Where should a photographer place lights for a headshot? Headshot lighting is more important with darker backgrounds. The light should be at a 45-degree angle from the subject. The light should be in front of the subject. The third light should be the subject to form a ring of light around the subject’s hair.

Answers

Answer:

Headshot lighting is more important with darker backgrounds. The  

(key)  light should be at a 45-degree angle from the subject. The  

(fill)  light should be in front of the subject. The third light should be  

(behind) the subject to form a ring of light around the subject’s hair.

Explanation:

i searched it up individually and thats what i got

Can someone help me calculate this Multimedia math:

A monochrome sequence (black and white) uses a frame size of 176 x 144 pixels and has 8 bits/pixels. Registered with Frame Rate 10 frames/sec. Video is transmitted through a 64 Kbit/sec bandwidth line.
(a) Calculate Compression Ratio (Crude Bit Speed / Compressed Bit Speed) which will be needed.
(b) What will happen if the Ratio compression is higher than it in (a)?
(c) What will happen if the Ratio compression is lower than it in (a)?

Answers

Answer:

I will try to help you answer this. it seems really confusing but I'll do my best to solve it and get it back to you. Hope I'm able to help!

please help
Consider the following code segment.

int a = 0;
int b = 3;

while ((b != 0) && ((a / b) >= 0)
{
a = a + 2;
b = b - 1;
}
What are the values of a and b after the while loop completes its execution?

a = 4, b = 1
a = 0, b = 3
a = 6, b = 0
a = 8, b = -1

Answers

Answer:

a = 6, b = 0

Explanation:

The loop ran 3 times before b == 0. The statement "while ((b != 0)" is essentially saying: 'While b is not equal to 0, do what's in my loop'. Same general thing with "&& ((a / b) >= 0)". The "&&" is specifying that there should be another loop condition. The final part of the while loop states: 'as long as a ÷ b is greater than 0, do what's in my loop'. If all of these conditions are met, the loop will run. It will continue to run until at least one of the conditions are not met.

Side note: I can't help but notice you posted the same question a while ago, so I just copied and pasted my previous response with some tweaking here and there. Hope this helps you! :)


Question 12 of 30
In Alienware systems, errors are indicated via the tricolor Power Button LED.
True
False

Answers

Answer:

False.

Explanation:

Bought the latest Alienware 15 r3 with i7 7th gen, 1060gtx, etc. Next day laptop wont post, turns on, reboots, then does the same thing, meanwhile the power led button blinks 6 times. So making a little research and its seems like a video card is kaput, dont know if its the intel or the nvidia. Aynway, I bought this laptop from a company in Canada, and it seems it was alredy registered so I cand procced with a transfership ownership.

Answer:

I think the answer

is true.

Write Inheritance program for the following scenario. Employee is super class where as Manager and Regular are the sub class. Partial Employee class is created, you have to complete the Employee class and implement Manager and Regular class. The main is class is given that creates objects of all classes and displays the output.
• The subclasses uses super keyword in the constructor to assigned the data.
• All the classes implements toString() method.

Answers

Answer:

Explanation:

public class Employee{

//Existing employee code

public String getName(){

return Name;

}

public double getSalary(){

return salary;

}

public int getId(){

return id;

}

public void setName(String name){

this.name = name;

}

//Manager Class

public class Manager extends Employee{

private double bonus;

public Manager(int id,String name,double salary,double bonus){

super(id,name,salary);

this.bonus = bonus;

}

public void setBonus(double bonus){

this.bonus = bonus;

}

public double getBonus(){

return bonus;

}

}

//Regular Class

public class Regular extends Employee{

private double overtime;

public Manager(int id,String name,double salary,double overtime){

super(id,name,salary);

this.overtime = overtime;

}

public void setOvertime(double overtime){

this.overtime = overtime;

}

public double getOvertime(){

return overtime;

}

}


Please help meeee , you will get 20 points

Answers

Answer:

true

Explanation:

true trueee 3uehehehdgeyeyehhehehegegegrhrtggrevegrgrhehehru

I THINK IT FALSE

#Carry on learning

A restaurant recorded the ages of customers on two separate days. You are going to write a program to compare the number of customers in their twenties (ages 20 to 29). What is the missing line of code to count the number of customers in their twenties? customerAges = [13, 3, 11, 24, 35, 25, 15, 18, 1] count20s = 0 if 20 <= item <= 29: count20s = count20s + 1

Answers

Answer:

You will need to implement a for loop ( I am assuming this is java)

Explanation:

int count20s = 0;

for(int x =0; x< customerAges.length;x++){

if(20 <= customerAges[x] && customerAges[x] <= 29){

     count20s++;

}

What are the characteristics of a good text-based adventure game? In other words, what are some features that should be in the game to make it appealing to players?

Answers

Answer:

spelling and good format

Explanation:thats all i know

An administrative assistant is responsible for scheduling appointments at a doctor’s office. Which component would allow the administrative assistant to enter each patient’s name, date of birth, doctor’s name, and appointment date and time?

Answers

Answer: Form

Explanation:

Answer:

A on edge

Explanation:

How do most benchmark tests measure the performance of a graphic card​

Answers

Answer:

Using Frame Rate

Explanation:

Most benchmark tests measure the performance of a graphic card​ by using "Frame Rate"

This is because using Frame Rate assesses and then measures the number of images a GPU (graphic processing unit) can render and at the same time the number of images that are being shown on a monitor or screen per second.

Hence, in this case, the correct answer is "Frame Rate"

is the trust necessary to use an emerging technology platform? why?​

Answers

Answer:

Emerging technologies can provide improved accuracy, better quality and cost efficiencies for businesses in every sector. They can enhance trust in the organization's operations and financial processes, which is crucial for sustainable success.

Emerging technologies included a range of technology like education, IT, nanotechnology, biotech, computer neuroscience, robotic devices, and artifact intellectual ability.

It could working capital in all sectors with better accuracy, quality, and cost-efficiency.It can build confidence in the accounting and business processes of the organization, which is critical for sustainable success.

Therefore, these technical innovations represent the progressives of competitive advantage converging technologies, that in some ways represent bigger and more powerful interconnections and similar goals.

Learn more:

brainly.com/question/1144539

During what stage of problem solving is information gathered in order to see if the plan produced the intended outcome?
A. implement the solution
B. Define the problem
C. Identify solutions
D. evaluate results ​

Answers

Identify solutions is  to see if the plan produced the intended outcome.

Hence, option C is correct answer.

What is problem solving?

Diagnose the circumstance to keep your attention on the issue and not merely its symptoms. Use cause-and-effect diagrams to establish and examine root causes, and flowcharts to show the anticipated steps of a process while solving problems.

Key problem-solving steps are explained in the sections that follow. These actions encourage the participation of interested parties, the use of factual information, the comparison of expectations with reality, and the concentration on a problem's underlying causes. You ought to start by:

reviewing and capturing the functioning of current processes (i.e., who does what, with what information, using what tools, communicating with what organisations and individuals, in what time frame, using what format).

assessing the potential effects of new resources and updated regulations on the creation of your "what should be"

Read more about problem solving:

https://brainly.com/question/23945932

#SPJ1

The Binary Search algorithm works by testing a mid-point, then eliminating half of the list.

a. True
b. False

Answers

Answer:

a. True

Explanation:

The Binary Search algorithm works by testing a mid-point, then eliminating half of the list.

If you get your foot stuck in a cloud how many colors can you smell with you ears

Answers

Answer: 42 is the answer to everything and just remember, Don,t panic.

For i am the hitch hikers guide to the galaxy.

 

Explanation:

Create two functions (with appropriate names) that produce the output below. Both functions must use a prototype. All that should be present in main() is the call to these two functions and a blank line of output between the function calls. This is a very easy exercise. Focus on the fundamentals. Make sure you review my solution file to make sure your syntax and name choice is good. Output: This is the first part of my program. It was created with a function. <-- These two lines are output by the first function This is the second part of my program. It was created with a different function. <-- These two lines are output by the second function

Answers

Answer:

In C++:

#include <iostream>

using namespace std;

void function1(); void function2();

int main(){

   function1();    function2();

   return 0;}

void function1(){

   cout<<"This is the first part of my program."<<endl<<"It was created with a function"<<endl;}

void function2(){

   cout<<"This is the second part of my program."<<endl<<"It was created with a different function.";}

Explanation:

This defines the function prototypes

void function1(); void function2();

The main begins here

int main(){

This calls the two functions from main

   function1();    function2();

   return 0;}

This calls function1()

void function1(){

   cout<<"This is the first part of my program."<<endl<<"It was created with a function"<<endl;}

This calls function2()

void function2(){

   cout<<"This is the second part of my program."<<endl<<"It was created with a different function.";}

In JavaScript what is the resulting value of answer for answer = 5 + 3 * 2? Explain why the answer is not 16.

Answers

Answer:

with this type of math , you actually multiply first before you add

Explanation:

2×3 =6.

6+5=11.

JavaScript is the resulting in the value are the of answer for answer = 5 + 3 × 2 = 11. It was not the 16.

What is JavaScript?

The word JavaScript refers to a text-based programming language, and the server-side is what allows users to make web pages interactive. HTML and CSS are two programming languages that are used to make web pages dynamic.

According to the JavaScript, are the resulting the values, and they define are the answer.

As per the rule of the bod mas rule.

5 + 3 × 2 = ?

3 × 2 = 6

5 + 6 = 11

As a result, the JavaScript are the based on the resulting in the value 5 + 3 × 2 = 11.

Learn more about on JavaScript, here:

https://brainly.com/question/28448181

#SPJ2

please help me on this coding problem :)

Consider the following code segment.

int a = 0;
int b = 3;

while ((b != 0) && ((a / b) >= 0)
{
a = a + 2;
b = b - 1;
}
What are the values of a and b after the while loop completes its execution?

a = 4, b = 1
a = 0, b = 3
a = 6, b = 0
a = 8, b = -1

Answers

Answer:

a=4 , b=1

Explanation:

I'm not a computer science major at all but I think I can help you with this code.

Our program wants us to add 2 to a get new a value while also subtracting 1 from b value to obtain new b value. We we want to for for as long b is not 0 and a/b is nonnegative.

One round we get:

New a=0+2=2

New b=3-1=2

Let's see if we can go another round:

New a=2+2=4

New b=2-1=1

We can't go another round because b would be negative while a is positive which would make a/b negative. So our loop stops at this 2nd round.

a=4 , b=1

Other notes:

2nd choice makes no sense because a is always going to increase because of the addition on a and b was going to decrease because of the subtraction on it.

Third choice makes no sense because a/b doesn't even exist.

Fourth choice a/b is negative not nonnegative.

.
T
Which of the following objects are not contained within
an Access database?
Select one:
a Tables and forms,
b. Queries and reports.
c. Macros and Modules
d. Web sites and worksheets​

Answers

Answer:

17 38 ay

Explanation:

a

what is the perpose of the boolean variable swaps in this buble sort algorithm

Answers

Answer:

“Bubble Up” algorithm will move largest

value to its correct location (to the

right/end of array)

• Repeat “Bubble Up” until all elements are

correctly placed:

– Maximum of N-1 times

– Can finish early if no swapping occurs

• We reduce the number of elements we

compare each time one is correctly placed

Other Questions
BRAINLESTWhich statement BEST explains why Sammies mother immediately apologized for not reminding Tucker about Sammies appointment? A) She forgot to pick him up from school because she was at the vet. B) She was running late getting home from work. C) He was supposed to go to the vet with his mom. D) She knows Tucker might have been worried about Sammie. Given the side measurements, classify the triangle as acute, right, obtuse, or not a triangle.9, 15, 19A) acuteB) obtuseC) rightD) not a triangle choose all items where the equation matches the given table Given the geometric sequence tn with t1=96 and r=1/4, find t4.Give your answer as a fraction, if necessary. Do not include "t4=" in your answer. For example, if you found t4=9, you would enter 9. Please help me with my hw thank you so much What is the correct term for a large number of species in an ecosystem? An ecosystern with a large number of species is said to have _________ Question 2 of 5A right cone has a slant height of 17 feet, and the diameter of the base is 16feet. What is the height, h, of the cone?h17 ft16 ft This Question: 1 pt17 of 29Emma has $160 cash to spend at a music store. How much can she spend on items if there is a 7% sales tax?Emma can spend on items.(Round to the nearest cent as needed.) What is one way that the kidneys help maintain homeostasis in the body? A They regulate the temperature of the body B They regulate the distribution of energy in the bodyC They regulate the amount of oxygen in the bodyD They regulate the amount of water in the body HELP ME PLSSSSSPart CRead the following poem by Li Bai:To Tan ChiuMy friend is lodging high in the Eastern Range,Dearly loving the beauty of valleys and hills.At Green Spring he lies in the empty woods;And is still asleep when the sun shines on high.A pine-tree wind dusts his sleeves and coat;A pebbly stream cleans his heart and ears.I envy you, who far from strife and talkAre high-propped on a pillow of blue cloud.Why does the speaker in the poem envy his friend? Support your answer with evidence from the poem. 8. Do you believe tle United States, throughout its history, followed Washington's 3 piecesof advice? Choose at least one piece of advice and explain.WILL GIVE BRAINLIEST!!!!! Please help due soon. Priya ran 1 miles today, and Tyler ran 3 miles today. How many times the length of Tyler's run was Priya's run? What was the result of the Great Leap Forward:Group of answer choicesChina grew to become the 2nd largest GDP in the worldMillions died from starvationThe Nationalist took control of the nation after the economy failed examples of digital dedicated line Ryan is outside playing basketball. He is 5 ft tall and at this time ofday is casting a 12 ft shadow. The basketball hoop is 10 ft tall. Howlong is the basketball hoop's shadow? how can you make your teacher less annoying?? WILL GIVE BRAINLIEST FOR BEST ANSWER The Hiking Club is taking another trip. The hike leader's watch shows that they gained 296 feet in altitude from their starting position.Their altitude is now 285 feet, but there is no record of their starting altitude.Write and solve an equation to represent this situation and find their starting altitude. There are 20 pieces of fruit in a basket and 12 of them are oranges. What percentage of the pieces of fruit in the basket are oranges? Show your work in the box and circle your answer 16 cm to 44.2 cm increase or decrease