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

What is the output of:

print (8 % 4)

Answers

Answer:

0

Explanation:

The statement, print(8 % 4) will produce the output 0 ;

The print statement is an inbuilt function which is used to output a typed string or display result of a Mathematical calculation and so on.

The expression in the print statement gives 0;

8%4 means, the remainder when 8!is divided by 4 ; 8 /4 gives 2 without a remainder. Meaning that :

8%4 = 0

Hence, print(8 % 4) = 0

1. Ngangingazi Ukuthi Ukulalela Abazali Nothisha Bami Kuletha Impumelelo
Enhle Kangaka.
[50]​

Answers

Answer:

yebo kumele ubalalele ngoba ayikho into yakho eyophumelela ungabalalelanga abazali

An investment bank has a distributed batch processing application which is hosted in an Auto Scaling group of Spot EC2 instances with an SQS queue. You configured your components to use client-side buffering so that the calls made from the client will be buffered first and then sent as a batch request to SQS. What is a period of time during which the SQS queue prevents other consuming components from receiving and processing a message

Answers

Answer: Visibility timeout

Explanation:

The period of time during which the SQS queue prevents other consuming components from receiving and processing a message is known as the visibility timeout.

It is the length of time when a message will be hidden after such message has been grabbed by a consumer. It is essential as it prevents others from processing such message again.


A file format refers to the background in a presentation.
True
False

Answers

Answer:

False

Explanation:

Required

Describe file format

Literally, file format means file extension and it describes the type of file.

For instance:

. d o c is a file format of word documents

. j p g is a file format of  images

etc.

Hence, the statement is false

Answer: The answer is false

Explanation: File formats are linked to certain programs

1 punto
María tiene una empresa de mercancia
seca, dicha empresa brinda su servicio de
ventas de estas mercancías al por mayor y
menor para su clientela. ¿De qué tipo de
Comercio hablamos en este ejemplo?: *

Answers

Answer:

Retailing.

Explanation:

La venta al por menor o retailing es el suministro de bienes físicos a los consumidores para uso personal, sea en pequeña o grandes cantidades, siempre que esté destinado a consumidores finales. Es un sector que consta de diferentes ramas (como la industria alimentaria, la industria de la moda, la industria del mobiliario para el hogar, etc.). El comercio minorista es el último eslabón de la cadena de suministro que va desde el fabricante hasta el consumidor.

Kirstie needs a computer for word processing, emailing, downloading high definition TV
series from an online store and basic photo editing.
Which computer would you recommend for Kirstie? Give reasons for your answer.

Answers

NmmkkjdijdjrjrjdjirjrkdidiL028

In 2011, a company called RSA, which provides security services, acknowledged its proprietary authentication system, which is employed by some defense contractors and other high-security industries, was compromised. As a result, the attackers were also able to log into systems at Lockheed Martin, and other companies, using the stolen credentials of legitimate users. This is an example of violation of ___________________.

Answers

Answer:

The answer is "Authentication"

Explanation:

The attacker had the opportunity to log into the legitimate users' stolen credentials in Boeing systems and other firms in this question. That's an example of a verification violation.

This is a recognition of the identification of a user. Various students typically require various kinds of certificates in order to create the identity of the user. The credentials are frequently a passcode that only people and the computer know and seem to be confidential.

3 Negative ways of using the Internet​

Answers

Answer:

1. It rots the mind of children

2. It's to too addicting

3. can show bad things.

Explanation:

1. Cyber bullying.
2. Gambling (playing games where you win money)
3. Identity theft, hacking.


Which tab is used to create a
new e-mail?

O File
O View
O Folder
O Home

Please help!!!!!!!!!!!!!

Answers

Answer:

Mail tab

Explanation:

Please mark as brainliest answer as it will also give you 3 points

File , brainliest answer. Hope this helps

What information is automatically generated from the company identifier and product name?

A.
project name
B.
class prefix
C.
bundle identifier
D.
organization name

Answers

I think it’s project name, but I’m not 100% positive


After you have figured out your storyline, what should be the next thing to
focus on?
1.character devlopment
2. What you want to name your video​

Answers

Answer: 2

A storyline figured out means you should already know the plot, setting, conflict, theme and characters (character development)
Figure out the story line, plan things out

Select the correct answer.
Carter, a graphic artist, is trying to apply color and tonal adjustments to an image without permanently changing pixel values. Which Image
editing tool or technique should Carter use?
OA the Color Replacement tool
ОВ.
an Adjustment layer
c. a vector Mask
OD.
a Curve adjustment
OE the Dodge tool

Answers

Answer: Adjustment layer

Explanation:

The image editing tool or technique that should be used by Carter use is an adjustment layer.

The adjustment layer that can be seen in Photoshop refers to an editing tool that's non-destructive image which can be used in adding color and tonal adjustments to a particular image without the pixels changing permanently.

By using the adjustment layers, one can be able to edit and then discard the adjustments. One can also be bake to restore the original image anytime that the person wants.

Answer: B: an Adjustment Layer

Explanation: Correct for Edmentum/Plato

como se genera la electricidad con energias no renovables
porfa alguien me ayuda llevo muchas horas buscando la respuesta
doy corona y todos lo puntos que pueda

Answers

Answer:

efeiueur eiuube erferve

Explanation:

Answer:

La energia no renovable proviene de fuentes que se agotaran o no se repondran durante miles o incluso millones de años.

Los combustibles fósiles se queman para generar energía y electricidad. Por ejemplo, carbón.

C. Assessment Application
MATCHING TYPE
Directions: Match column A with column B. Write the letter of your
answer on the space provided.
А
B В
1. Disk Cleanup
A. Repairs and cleans the Windows Registry
2. ASC
3. Scandisk
B. Repairs registry errors, remove "junk" files,
and ensure your PC is fully protected
C. Creates and deletes disk partitions
D. Accesses various information's about your
computer
E. Tunes up and maintains your PC automatically
F. Optimizes use of space on a disk.
4. ASC Pro
5. Format
6. CPU-Z
7. Defrag
G. Tunes up and maintains your PC, with anti-
spyware, privacy protection, and system
cleaning functions
H. Prepares a hard drive prior to use.
I. Checks for physical errors on the disk surface
J. Removes unused files.
8. ARO 2013
9. Fdisk
10. RegDoctor
--00 End of the Module 00--​

Answers

Answer:

[tex]\begin{array}{lll}&A&B\\1&Disk \ cleanup& Removes \ unused \ files\\2&ASC&Tunes \ up \ and \ mantains \ your \ PC \ automatically\\3&Scan \ disk &Checks \ and \ removes \ errors \ on \ the \ disk \ surface\\4&ASC \ Pro& Tunes \ up \ and \ maintains \ your \ PC, \ with \ anti-spyware, \ privacy \ prot \\\\\end{array}[/tex][tex]\begin{array}{lll}\\5&Format&Prepares \ the \ hard\ drive\ prior \ to \ use\\6&CPU-Z&Accesses \ various \ informations \ about \ your \ computer\\7&De-frag&Optimizes \ use \ of \ space \ on \ disk\\8&ARO \ 2013& Repirs \ registry \ errors, \ removes \ "junk" \ files\\9&Fdisk&Creates \ and \ deletes \ disk \ partitions\\10&RegDoctor&Repair \ and \ cleans \ the \ windows \ registry \end{array}\right][/tex]

Explanation:

Hi there!
I am writing a research paper on Satellite internet. I have about 4 out of 6 pages of information written down. What are some topics to talk about regarding satellites? It does not have to be specifically about satellites. Just some things to add to the paper. I am not sure what subject it fall under, so i'm going to post it twice.
Thank you in advance.

Answers

Answer:hi there

Explanation:

Satellite Internet access is Internet access provided through communication satellites. Modern consumer grade satellite Internet service is typically provided to individual users through geostationary satellites that can offer relatively high data speeds

Read the integer numbers in the text file "1000 Random Number from 0 to 100.txt" into a list

PLEASE HELP THANK U!!

Answers

Answer:

random_number_file = open("1000 Random Number from 0 to 100.txt", 'r')

random_number_list = random_number_file.readlines()

print('random_number_list)

Explanation:

The name of the file containing the random integer text is ; "1000 Random Number from 0 to 100.txt"

The random_number_file variable stores the opened file ("1000 Random Number from 0 to 100.txt") using the open keyword and reads it ('r')

This file stored in the random_number_file variable is the read into a list by using the readlines() method on the random_number_file

what is the effect of flattening layers in image editing?
you can reduce file size by flattening layers. this operation mergers all ___ layers into the background and discards hidden layers.
all ___ areas that remain are filled with white.

first blank
a. black
b. colored
c. transparent

second blank
a. dark
b. visible
c. bright

Answers

The answer to this blanks are black and visible

Answer:

Hello There!!

Explanation:

I believe the answers are:

-First blank=>c. transparent

-Second blank=>b. visible.

hope this helps,have a great day!!

~Pinky~

You are going to create multiple functions that will take in the appropriate measurements as parameters and calculate the area of the specific shape.

The following shapes must be included:
Square, Triangle, Circle, and Trapezoid

Feel free to add on more shapes if you want!!

Answers

Answer:

circle

Explanation:

Answer:

circle

Explanation:

Which statement is true? Select 3 options.
1. Deques can be created empty.
2. Deques are lists.
3. Lists are deques.
4. Deques can contain lists.
5. A deque is a type of collection.

Answers

Answer:

2nd statement is True dear!!!

Answer:

Deques can contain lists.

A deque is a type of collection.

Deques can be created empty.

Explanation:

Answers can be found in Edge instructions

"You can make a deque whose members are lists."

"You can create an empty deque or create a deque with a list or a string."

"You have used lists and deques, which are two types of collections used by Python. "

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.

Select three advantages to using digital video.

A) Digital video appears to have more depth.

B) Digital video can capture a greater range of brightness.

C) Digital video is much less expensive than film.

D) Digital video be easily edited and shared.

E) Digital video can be viewed in real time where it was taken.

Answers

C. E and D, I believe. I apologize if I’m incorrect!

Answer:

Digital video be easily edited and shared., Digital video is much less expensive than film., Digital video can be viewed in real time where it was taken.

Explanation:

what type of data type is 1+78-5​

Answers

Answer:

Integer

Explanation:

Given

[tex]1 + 78 - 5[/tex]

Required

The datatype

1, 78 and -5 are all numbers and they are without decimal points,

When a number is without decimal, such number is referred to as integer.

Hence, the datatype is integer

how much video does a 10gb video hold i will give brainliest for first correct answer

Answers

Answer:

2,000 songs

Explanation:

Can anyone help me solve this?

Answers

Answer:

what should be basically be done in this question?

that’s not a question

Transferring data from a remote computer to a local computer is .....​

Answers

The answer is uploading

You should not photograph where unless you have permission?
O A public park
O Your backyard
O A parade
O Into someone's window
PLZ HELP ME

Answers

Answer:

Into someone's window

Explanation:

We should not photograph into some one's window, unless we have permission

Answer:

Hello There!!

Explanation:

I believe the answer is O Into someone's window.

hope this helps,have a great day!!

~Pinky~

Byte pair encoding is a data encoding technique. The encoding algorithm looks for pairs of characters that appear in the string more than once and replaces each instance of that pair with a corresponding character that does not appear in the string. The algorithm saves a list containing the mapping of character pairs to their corresponding replacement characters.
For example, the string "THIS_IS_THE_BEST_WISH" can be encoded as "%#_#_%E_BEST_W#H" by replacing all instances of "TH" with "%" and replacing all instances of "IS" with "#".
Which of the following statements about byte pair encoding is true?
A. Byte pair encoding is an example of a lossy transformation because it discards some of the data in the original string.
B. Byte pair encoding is an example of a lossy transformation because some pairs of characters are replaced by a single character.
C. Byte pair encoding is an example of a lossless transformation because an encoded string can be restored to its original version.
D. Byte pair encoding is an example of a lossless transformation because it can be used to transmit messages securely.

Answers

Answer:

C. Byte pair encoding is an example of a lossless transformation because an encoded string can be restored to its original version.

Explanation:

Byte pair encoding is a form of encoding in which the most common pairs of consecutive bytes of data are replaced by a single byte which does not occur within the set of data.

For example, if we has a string ZZaaAb, it can be encoded if the pairs of string ZZ are replaced by X and the second pair by Y. So, our data now becomes XYAb.

To get our original data, that is decode it, we just replace the data with the keys X = ZZ and Y = aa thus allowing our original data to be restored.

Since our original string is restored without loss of data, it implies that byte pair encoding is an example of a lossless transformation because an encoded string can be restored to its original version.

What is a number that refers to the position of an item on a list?
variable
parameter
operator
index
PLZ HELP IM TIMED

Answers

Answer:

Parameter

Explanation:

a parameter is an argument that is used to call something, for example in an array when 0 is referenced as the first element in the array.

Suppose a large group of people in a room were all born in the same year. Consider the following three algorithms, which are each intended to identify the people in the room who have the earliest birthday based on just the month and day. For example, a person born on February 10 is considered to have an earlier birthday than a person born on March 5. Which of the three algorithms will identify the correct people?
I. All the people in the room stand up. All standing people form pairs where possible, leaving at most one person not part of a pair. For each pair, the person with the earlier birthday remains standing, while the other person in the pair sits down. If there is a tie, both people sit down. Any individual not part of a pair remains standing. Continue doing this until only one person remains standing. That person has the earliest birthday.
II. All the people in the room stand up. All standing people form pairs with another standing person that they have not previously been paired with where possible, leaving at most one person not part of a pair. For each pair, the person with the earlier birthday remains standing, while the other person in the pair sits down. If there is a tie, both people in the pair remain standing. Any individual not part of a pair remains standing. Continue doing this until only one person remains standing or all persons standing have the same birthday. Anyone still standing has the earliest birthday.
III. Beginning with the number 1, ask if anyone was born on that day of any month. Continue with the numbers 2, 3, and so on until a positive response is received. If only one person responds, that person has the earliest birthday. If more than one person responds, determine which person was born in the earliest month, and that person or those persons have the earliest birthday.

Answers

Answer:

II is correct.

Explanation:

Algorithm is a computer program which solves complex problems within minutes. The algorithms has different variants which are used according to user demand. In the given scenario the choice no II is correct. All standing people can form a pair with another standing person and the person standing in the last will have the earliest birthday.

Nina visited an area that receives a large amount of precipitation during all twelve months and is typically warm year round. The area also has a large variety of organism diversity. What biome did Nina most likely visit?

Answers

Answer: Rainforest

Explanation:

A rainforest is an area that typically has tall, green trees and also has a high amount of rainfall. Rainforest can be found in the wet tropical uplands and lowlands. The largest rainforests can be seen in the Amazon River Basin.

Since the area visited by Nina has a large amount of precipitation during all twelve months, typically warm year round and has a large variety of organism diversity, then the biome thatcNina most likely visited is the rainforest.

Other Questions
After the Industrial Revolution, how did European imperialism affect Africa? PLEASE HELP There is no solution to the following system of equations.x < 3y > 3TrueFalse Mcdormand inc reported a 3400 unfavorable price variance for variable overhead and a $34,000 nfavorable price variance for fixed overhead. The flexible budget had variable overhead based on 36,100 direct labor-hours; only 34,100 hours were worked. Total actual overhead was $1,810,400. The number of estimated hours for computing the fixed overhead application rate totaled 37,500 hours. Required: a. Prepare a variable overhead analysis. b. Prepare a fixed overhead analysis. Instead of investing a lump of sum of $25000,Brittany Royer decides to svae the money in a vault for 2years. Assuming the inflation being 2.5%per year,how much will her purchasing power decline in 2years WILL GIVE BRAINLIEST (Right angle) Trigonometry please help! Find the surface area of a cube shaped jewelry gift box with a side length of 7 meters use 6s 2 to help A.147 square centimeters B.441 square centimeters C.686 square centimeters D.294 square centimeters Read Unit 6. Read the words given in the list. Consult a dictionary and then write the part of speech and the meaning of each word. First one is done for you. (10) Word Order Part of Speech Meaning Abandon Verb leave Access Bandage Beak Damage Deaf Fake Faint Gather Jealous Pickle Choose the from of the verb that best complete the sentence Khi nim phm tr kh nng v hin thc? Mi quan h bin chng gia kh nng v hin thc? ngha phng php lun? cho v d lm r cp phm tr ny attachment below or above square root of 64 by division method 1.If the measures of three angles of a quadrilateralare 30, 70, and 110, find the measure of the fourthangle. According to rational expectations theory, Question 7 options: every day is a new day and yesterday's occurrences have no bearing on today's decisions. when making decisions a person will consider only information based on past experience. even though a person considers information related to future events as potentially important for decision making, he realizes that such information is unreliable and worthless. past experience is a good guide for decision making, but so is information related to possible future outcomes. PLEASE HELP THIS IS DUE NOWwill mark brainliest! 10 points CAN SOMEONE GIVE ME THE REAL ASNWER TO THIS IM IN A RUSH You are given a 250 ml sample of HCI and asked to find out what its concentration is. You have a 0 118 M Ca(OH)2 solution and it takes 13.7 ml toneutralize the acid sample. What is the concentration of the HCI? Show explanation Please help this is urgent How much fabric did Daria use to make this number cube? How do you think Madison's and Jefferson's views were used to justify secession and the Civil War about 60 years later? Given that tan almost equal to 2.773 where 0 PLEASE PLEASE HELP ME