You are calculating commissions for sales staff at work. Employees receive ten dollars for every item sold. Your boss also wants to know the grand total paid to all employees as commission. How would you set this up in an Excel workbook and would you use absolute references, relative references, or both?

Answers

Answer 1

Answer:

To find the grand total paid to all employees as commission, we note the following;

The amount received by employees as commission for each item sold, r = $10.00

The information the boss wants to know = The grand total paid to all employees as commission

Let 'n' represent the the total sales, we have;

The grand total commission = Total sales × Commission

1) On MS Excel, four columns are created, labelled, Serial number, Employee Name, Number of Items Sold, Commission

2) In the second row, in the cell under the Commission column heading, Input the formula '=(Cell reference of adjacent Number of Items Sold) × 10' in the cell

3) Copy the the above formula to all the cells in the Commission column by clicking on the cell containing the formula, moving the mouse to the bottom right corner of the cell, and when the mouse pointer changes to a cross sign, left click and hold and drag to all the cells in the column

4) Input the formula =SUM(Argument) in the blank cell below the created Commission list

Where;

Argument = The reference to the range of cells containing the values in the Commission column

5) The output of the =SUM formula is the grand total paid to employees as commission

Explanation:


Related Questions

Select the three reasons that the gaming industry is set to grow.

A) more colleges offering jobs in game design

B) a decrease in the average age of gamers

C) an expanding market on mobile phones

D) expanding markets in Asia

E) new accessories that will attract more players

Answers

The answers are A, C, E

Answer:

expanding markets in Asia, new accessories that will attract more players, an expanding market on mobile phones

Explanation:

. Create a java File call Sales.Java contains a Java program that prompts for reads in the sales for each of 5 salespeople in a company. It then prints out the id and amount of sales for each salesperson and the total sale. 2. Compute and print the average sale. 3. Find and print the maximum and minimum sale. 4. After the list, sum, average, max and min have been printed, ask the user to enter a value. Then print the id of each salesperson who exceeded that amount, and the amount of their sales. Also print the total number of salespeople whose sales exceeded the value entered. 5. Instead of always reading in 5 sales amounts, in the beginning ask the user for the number of sales people and then create an array that is just the right size. The program can then proceed as before

Answers

Answer:

The program is as follows:

import java.util.*;

public class Sales{

public static void main(String[] args) {

 Scanner input = new Scanner(System.in);

 int salesPeople;

 System.out.print("Number of Sales People: ");

 salesPeople = input.nextInt();

 int[] salesID = new int[salesPeople];

 float[] salesAmount = new float[salesPeople];

 float total = 0;

 for(int i = 0; i<salesPeople;i++){

     System.out.print("ID: ");      salesID[i] = input.nextInt();

     System.out.print("Amount: ");      salesAmount[i] = input.nextFloat();

     total+=salesAmount[i];  }

 System.out.println("ID\t\tAmount");

 for(int i = 0; i<salesPeople;i++){

     System.out.println(salesID[i]+"\t\t"+salesAmount[i]);  }

 System.out.println("Total Sales: "+total);

 System.out.println("Average Sales: "+total/salesPeople);

 Arrays.sort(salesAmount);

 System.out.println("Minimum Sales: "+salesAmount[0]);

 System.out.println("Maximum Sales: "+salesAmount[salesPeople-1]);

 float sales;

 System.out.print("Print records that exceed: ");      sales = input.nextFloat();

 System.out.println("\nID\t\tAmount");

 int count = 0;

 for(int i = 0; i<salesPeople;i++){

     if(salesAmount[i]>sales){

         System.out.println(salesID[i]+"\t\t"+salesAmount[i]);

         count++;      }  }

 System.out.print("Total sales records that exceed "+sales+" are: "+count);

}

}

Explanation:

See attachment for program source file where comments are used as explanation

Fill in the blanks
A dash is a human-readable description in the source code of a computer program
Python has dash standard data types
A dash contains items separated by commas and enclosed within square brackets
A dash consists of key-value pairs
dash cannot be changed and use parentheses

Answers

Answer:

1. Comment

2. Five (5).

3. Line.

4. Tuple; that

Explanation:

1. A comment is a human-readable description in the source code of a computer program. Thus, it's an annotation or description in the source code of a software program that is readable by humans.

2. Python has five (5) standard data types, these includes; number, string, list, dictionary and tuple.

3. A line contains items separated by commas and enclosed within square brackets i.e [ ]. Thus, it's simply an ordered collection of one or multiple data items.

4. A tuple consists of key-value pairs

that cannot be changed and use parentheses. For example, Newtuple = ("strawberry", "apple", "mango", "banana", "orange").

Describa las etapas del arranque de viruta

Answers

Answer:

Las virutas son partículas que se eliminan mecánicamente de una pieza de trabajo mecanizada. En el contexto de la tecnología de fabricación, especialmente el mecanizado, el término se refiere principalmente a virutas de metal; En principio, sin embargo, las virutas se crean en todo tipo de mecanizado de cuerpos sólidos. Las astillas de madera son el resultado de la carpintería. Cuando se mecanizan plásticos, se crean virutas, así como cuando se mecanizan materiales minerales, cristalinos o amorfos como el vidrio, que a menudo se realiza mediante esmerilado.

How Many types of application Software are there?​

Answers

Answer:

there are 2 types of application software

If a user has just added a simple triangle shape into a diagram, how can the triangle be adjusted? Check all that
apply.

O by making it bigger

O by adjusting it to be SmartArt

O by making it smaller

O by adjusting it to be different style

O by making it thinner

O by making it thicker

O by adjusting it to be a different color

O by rotating it

Answers

Mark Brainliest please

Answer :

By making it bigger
By adjusting it to be SmartArt

Drag each tile to the correct box.
Albert has some software on his system. Help him identify the software based on its functions.

database software
word processor
spreadsheet software
multimedia software
can be used to create tables with embedded calculations
arrowRight
can be used to edit .doc files
arrowRight
can be used to store data in ordered form
arrowRight
can play .mpg and .mp3 files
arrowRight

Answers

Answer:

1. Spreadsheet software.

2. Word processor.

3. Database software.

4. Multimedia software.

Explanation:

A software can be defined as a set of executable instructions (codes) or collection of data that is used typically to instruct a computer on how to perform a specific task and solve a particular problem.

Simply stated, it's a computer program or application that comprises of sets of code for performing specific tasks on the system.

Basically, the various type of softwares used on computers to perform specific functions include the following;

1. Spreadsheet software: it can be used to create tables with embedded calculations. A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems.

2. Word processor: it can be used to format or edit .doc files. Some examples of word processors are Notepad, Microsoft Word, Sublime text, etc.

3. Database software: it can be used to store data in ordered form. Thus, it allows computer users to efficiently retrieve and manage their data with an appropriate level of security. These records are stored and communicated to other data user when required or needed.

4. Multimedia software: it can play .mpg and .mp3 files. A multimedia software refers to a software that is designed and developed to accept, utilize and combine various file formats such as audio, video, text, animation effects, etc.

When visiting or learning about other places, what new things have you experienced? Choose all that apply.
food and drink
music and art
languages
values and ideas
technology

Answers

This is a question that’s has no wrong or right answer, basically you just click whatever you’ve experienced.

Answer:

All of these answers

Explanation:

What is the next line?
>>>
tupleB = (5, 7, 5, 10, 2,5)
tupleB.index(5,3)
>>>
A. 0
B. 5
C. 3
D. 1

Answers

The right answer is option 4: 2

Explanation:

Lists are used in Python to store elements of same or different data types.

Different functions are used in Python on List. One of them is count.

Count is used to count how many times a specific value occurs in a list.

The syntax for count is:

listname.count(value)

In the given code,

The output will be 2

Hence,

The right answer is option 4: 2

5.2
Explain ONE reason why the special equipment is used when
testing eyesight for a driver's licence.
(2)​

Answers

Answer:

In order to reduce the risk of accidents on the roads.

Explanation:

The special equipment is used when  testing eyesight for a driver's license in order to reduce the risk of accidents on the roads. Good eyesight is very important for good and safe driving so to find out the eyesight of the driver, the license officer used special equipment in order to check driver's eyes. If the eyesight is good, the officer provide license to the person otherwise not so that no accidents happen on the road.

How are sensors and microprocessors used to control a central heating system which uses an oil burner as the source of heat

Answers

Answer:

sensors are used to measure physical quantities such as temperature, light, pressure, sound, and humidity. They send signals to the processor . a security alarm system may have an infrared sensor which sends a signal when the beam is broken.

Explanation:

im just smart lol

Diana has created a graphic design portfolio for a major project. What kind of portfolio would increase Dlana's chances of getting selected?
OA
a portfolio with some case studies of her graphic design work
OB.
a portfolio with graphic designs in her favorite theme
Ос.
a portfolio containing contact numbers of references
OD.
a portfolio that emphasizes large images and many colors
OE. a portfolio that emphasizes her qualifications and experience

Answers

Answer:

Hello There!!

Explanation:

I believe the answer is O A. a portfolio with some case studies of her graphic design work.

hope this helps,have a great day!!

~Pinky~

The smallest piece of information a computer can store is

Answers

Answer:

bit

Explanation:

confia

A bit is the smallest piece of information in a computer, a single value storing either 0start text, 0, end text or 1start text, 1, end text. A byte is a unit of digital information that consists of 8 of those bits.

Identify the error and write correct HTML program 5 Cyber Bullying Tips<\head>Don't Respond Talk to a trusted adult <|html>

Answers

Answer:

<html>

<head> Cyber Bullying Tips </head>

<body>

Don't Respond, Talk to a trusted adult

</body>

</html>

Have you searched Buzz Ch.at on playstore​

Answers

Answer:

Reorder terms.

y=52x−1

Cancel the common factor of 22.Factor 22 out of −2-2.

y−4=5x2+52⋅(2(−1))y-4=5x2+52⋅(2(-1))

Cancel the common factor.

y−4=5x2+52⋅(2⋅−1)y-4=5x2+52⋅(2⋅-1)

Rewrite the expression.

y−4=5x2+5⋅−1y-4=5x2+5⋅-1

Multiply 55 by −1-1.

y−4=5x2−5

A ____ is an icon that does not directly represent a file, folder or application but serves as a link to it?​

Answers

Answer:

Shortcut

Explanation:

A file can be defined as a computer resource that avails end users the ability to store or record data as a single unit on a computer storage device.

Generally, all files are identified by a name, icon, size, and type (format) such as audio, image, video, document, system, text, etc.

Furthermore, files are organized or arranged in directories. These directories are paths that describes the location wherein a file is stored on a computer system.

A software can be defined as a set of executable instructions (codes) or collection of data that is used typically to instruct a computer on how to perform a specific task and solve a particular problem. Thus, it's a computer program or application that comprises of sets of code for performing specific tasks on the system.

In Computer science, it's possible to create a shortcut in several directories (locations) on a computer, so as to reference a file, folder or software application and serve as an executable link.

Hence, a shortcut is an icon that does not directly represent a file, folder or application but serves as a link to it.

Additionally, deleting the shortcut of a data file, folder or software application would not permanently delete or uninstall the main data file respectively.

todas las computadoras son controladas por hardware?

Answers

Answer:

"La placa base está compuesta de más partes que alimenten y controlen el equipo. A diferencia del software, el hardware es una entidad física. ... Sin embargo, sin la creación de hardware para realizar tareas dirigidas por software a través de la unidad central de procesamiento, el software sería inútil."

Explanation:

(Sorry, I don't know much Spanish, so there might be mistakes. I hope this helps you.)

¿Por qué es importante usar adecuadamente el celular?

Answers

Answer:

to stop it from breaking

Explanation:

who established computer​

Answers

Answer:

Charles Babbage

Explanation:

I studied abt him

A folder has been shared with other users and set to read-only. What does this mean for users?
Users can only read the name of the shared folder.
Users cannot add new folders or files.
Users can read and edit files.
Users can add new files but not new folders.

Answers

Answer:

It means that users can only read or, depending on that platform, read and edit files in the folder

How did Avery and Garth most likely create their
diagrams?

O Avery used SmartArt and added a shape, whereas
Garth used four shapes.

O Avery used four shapes, whereas Garth used
SmartArt and added a shape.

O Both Avery and Garth used SmartArt and added a
shape.

O Both Avery and Garth used four shapes.

Help!!!

Answers

Avery used smartart and added shake

Why did Stephen Hawking stop playing hide and seek?

Answers

Answer:

because she keeps using a metal detector.

Kiko loves to surf the internet and check on different websites. One day he received an email from unknown source. When he opens it, he was directed to a site and logged using his credit card number. After a few days,he learned that his card was use by someone in purchasing an expensive item. What internet threat did Kiko experience and what can you do to avoid it.​

Answers

He experienced phishing

Phishing is a method of trying to gather personal information using deceptive e-mails and websites.

Here are some measures to avoid phishing. You can pick up the one you liked the most

Always check the spelling of the URLs in email links before you click or enter sensitive informationWatch out for URL redirects, where you're subtly sent to a different website with identical designIf you receive an email from a source you know but it seems suspicious, contact that source with a new email, rather than just hitting reply. Don't post personal data, like your birthday, vacation plans, or your address or phone number, publicly on social media

What do you call a commercial transaction beyween a buisness and buisness thatis transactedd online?
A.B2B - commerce
B.B2.B commerce
C. B2b digital transaction
D.B2B e - commerce

E. Non of the above

Answers

Answer:

c.B2b digital transaction

Explanation:

yan lang po sana makatulong

Please help me with my question ​

Answers

Answer:

1. Template

2. Name of the website

3. Signature of the instructor

Edhesive lesson practice 8.3, question 5

Answers

Answer:

3

Explanation:

Following are the correct python code to find the length of the given parameter value.

Python code to find length:

print(len("stuff"))#printing length

Output:

please find the attached file.

Program Explanation:

In the given python code a print method is used inside this a "len" method is used that accepts a string value in the parameter.Python has a built-in function called len(). It determines an object's length. A character length of a text string is returned by LEN.

Find out more about the length method here:

brainly.com/question/13527881

define client and.server​

Answers

Answer:

Client-server model is a model is a distributed application structure that partitions

tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients.

what do you understand by the terms:
I)input
ii)process
iii)storage
iv)output

Answers

an output device translate information processed by the computer into a form which you can understand.

input device are used to enter information such as letters, numbers, sounds or picture into a computer.

what is the most improved Android robot​

Answers

Answer:

They are the humanoid robots.

Full from of Computer
: )​

Answers

Answer:

COMPUTER full form or meaning is Common Operating Machine Purposely used for Technological and Educational research.

Explanation:

In you question, it isn't from! it is form(;

Some people think that Computer's full form is Common Operating Machine Purposely Used for Technological and Educational Research.

But actually computer is not a full form type word. It is made from the word "compute" which means "calculate". Computer means something that computes or calculates, because initial computers were used for calculating only.

Other Questions
help pls ? heusnwkq bsjnsjjw What achievement are you proudest of? PLS HELP ASAP !!!! PLS !! will mark whoever gets it right as brainliest ! Item 7Which indirect object pronoun correctly completes the sentence?Luis da flores a Raquel.Luis ______ da flores.teleselavv plant store _____ and other essential nutrients in the vacuole The following information pertains to Trenton Glass Works for the year just ended. Budgeted direct-labor cost: 70,000 hours (practical capacity) at $16 per hour Actual direct-labor cost: 80,000 hours at $17.50 per hour Budgeted manufacturing overhead: $997,500 Actual selling and administrative expenses: 439,000 Actual manufacturing overhead: Depreciation $ 233,000 Property taxes 23,000 Indirect labor 80,000 Supervisory salaries 202,000 Utilities 58,000 Insurance 32,000 Rental of space 301,000 Indirect material (see data below) 79,000 Indirect material: Beginning inventory, January 1 48,000 Purchases during the year 95,000 Ending inventory, December 31 64,000 Calculate the overapplied or underapplied overhead for the year. (Round your intermediate calculations to 2 decimal places.) help!! An atomic number of 4, an atomic mass of 8 and a charge of +1. Explain how power corrupts the king in the story. Use at least two pieces of evidence with examples from the text to support your answer. Read the excerpt from The Crisis, Number I by Thomas Paine.I once felt all that kind of anger, which a man ought to feel, against the mean principles that are held by the Tories: a noted one, who kept a tavern at Amboy, was standing at his door, with as pretty a child in his hand, about eight or nine years old, as I ever saw, and after speaking his mind as freely as he thought was prudent, finished with this unfatherly expression, Well! give me peace in my day. Not a man lives on the continent but fully believes that a separation must some time or other finally take place, and a generous parent should have said, If there must be trouble, let it be in my day, that my child may have peace; and this single reflection, well applied, is sufficient to awaken every man to duty.Which is a central idea of this excerpt?Paine feels that everyone should be able to speak freely, which is why he supports independence.Paine believes that colonists should fight for independence so their children can live in peace.Paine believes that some people are selfish and place their needs above others.Paine felt anger for the first time when he saw an interaction between a Tory and a child. Give me formula for 1)Aluminium chloride2) Copper sulphate3) Zinc Nitrate3) Ammonium Carbonate Sintagma nominal 1: mis sentidos___1. El modificador mis es:a. determinante demostrativob. adjetivoc. determinante artculod. determinante posesivoSintagma nominal 2: ningn apuro___2. El modificador ningn es:a. determinante numeral ordinalb. adjetivoc. determinante indefinidod. determinante artculoSintagma nominal 3: las paredes de tu laberinto___3. El modificador laberinto es:a. determinante posesivob. adjetivoc. determinante artculo d. nombre (complementa como modificador indirecto)Sintagma nominal 4: mi boca___4. El modificador mi es:a. determinante demostrativob. adjetivoc. determinante posesivod. nombre (complementa como modificador indirecto)Sintagma nominal 5: tus lugares favoritos___5. El modificador favoritos es:a. determinante numeral cardinalb. adjetivoc. determinante indefinidod. nombre (complementa como modificador indirecto)Sintagma nominal 6: tus zonas de peligro___6. El modificador peligro es:a. determinante numeral cardinalb. adjetivoc. determinante artculod. nombre (complementa como modificador indirecto)Sintagma nominal 7: esa destreza___7. El modificador esa es:a. determinante demostrativob. adjetivoc. determinante artculod. nombre (complementa como modificador indirecto)Sintagma nominal 8: malicia con delicadeza___8. El modificador delicadeza es:a. determinante numeral cardinalb. adjetivoc. determinante artculod. nombre (complementa como modificador indirecto)Sintagma nominal 9: esa belleza___9. El modificador esa es:a. determinante posesivob. adjetivoc. determinante artculod. determinante demostrativoSintagma nominal 10: una playa___10. El modificador una es:a. determinante numeral cardinalb. adjetivoc. determinante artculod. nombre (complementa como modificador indirecto) Clark's Chemical Company received refundable deposits on returnable containers in the amount of $100,000 during 2018. Twelve percent of the containers were not returned. The deposits are based on the container cost marked up 20%. What is cost of goods sold relative to this forfeiture? a. $0. b. $2,000. c. $10,000. d. $14,400. Will rank the correct answer brainliest! can someone help me match these too? The use of Jim Crow laws to separate African Americans from Southern whites was called why are three Challenges in development of human resources in nepal? how can they be solved? A man bought a car for $8200 and sold it for 80% of the price two years later. How much did he lose? This graph represents a population of molecules in a gas versus the distribution of the average velocity(speed) of its molecules in that population. Assume all molecules to be of the same mass. In reading the graph, it is important to note three things. One, is the most probable speed is at the peak of the curve. Secondly, the most probable speed increases as the temperature increases (so shift to the right), and the distribution broadens as it increases.On the graph, indicate the average kinetic energy of the population.Explain your answer.What part of the graph indicates the temperature of the sample?Explain your answer.Sketch a curve that represents the distribution of molecules at a temperature below the one shown. Label it as T2. Describe both T and T2 in terms of their average kinetic energy. Be specific and detailed.Submit your answer below. the angle of elevation of the top of an elevator pole to a man standing 10m from it is 60. find the height of the pole Name the kind or kinds of symmetry the following figure has: point, line, plane, or none. (o)