Hello, I am having trouble with the following questions: Question 13 0 out of 1
ID: 3715773 • Letter: H
Question
Hello, I am having trouble with the following questions:
Question 13
0 out of 1 points
(Excel) Download the attached template file which contains employee data for a fictitious company to the PC Desktop and then open it in Excel. First, create a Table for this set of data and then use Sort, Filter, and Total eatures to answer the following four questions.
A) Apply an alphabetical sort (A to Z) to Department and then reverse chronological sequence to Age. What is the last name of the employee who appears at the top of the list? [A]
B) Apply a reverse alphabetical sort (Z to A) to Department and then ascending order for Total Sales. What is the last name of the employee who appears in the top row of the Large Appliances Department? [B]
C) How many males are employed by Cardinal Electronics that are at least 45 years old? [C]
D) Leaving this filter in place, what is the Average Sales (rounded to the nearest whole number) for the employees that meet the criteria in Part C)? [D]
CIS250-Cardinal-Empl-Data.xlsx
Specified Answer for: A
[None Given]
Specified Answer for: B
[None Given]
Specified Answer for: C
[None Given]
Specified Answer for: D
[None Given]
Question 18
0 out of 1 points
(Excel) A sparkline is
Selected Answer:
is a label that describes the chart.
Answers:
is a label that describes the chart.
is the value or name of a data point.
a miniature chart contained in a single cell.
is a label that describes either the category axis or the value axis.
Question 19
0 out of 1 points
(Excel) The Body Mass Index (BMI) is often used by health care professionals to determine whether a person is overweight or underweight. The BMI is calculated using the following sequence of steps:
Multiply the person's body weight in pounds by 0.45.
Multiply the person's height in inches by 0.025.
Square the answer from Step 2.
Divide the answer from Step 1 by the answer to Step 3.
Round the result of Step 4 to the nearest whole number.
Determine the BMI of a person with a weight of 180 pounds and a height of precisely six feet to the nearest whole number and then enter the resulting two-digit value into the answer space below.
Selected Answer:
[None Given]
Question 21
0 out of 1 points
(Excel) A local tire store is offering an "early bird" discount of 20% off for customers that arrive before 8am to purchase a set of four radial tires that cost $131 each. Note that a sales tax of 6% on the sub-total is due as well as an additional $40 fee (which should not be discounted or taxed) for balancing, installation, and disposal. What amount will an "early bird" customer pay for the new tires, rounded to the nearest whole dollar?
Selected Answer:
$476
Answers:
$476
$151
$484
$595
Question 22
0 out of 1 points
(Excel) An interstate tollway plaza is offering a discount on all fuel pumped based on the total quantity purchased. Which of the formulas below calculates the correct total price to charge a customer for the fuel they have pumped based on the following conditions:
no discount (zero dollars off the total amount due) if a person purchases less than 20 gallons of fuel
a 3% discount on all fuel purchased if the person dispenses at least 20 gallons of fuel into their tank
Assume that cell A1 shows the total quantity (in gallons) of fuel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that a person should pay, after the discount (if any) has been applied.
Selected Answer:
[None Given]
Answers:
=IF(A1>20, A1*B1*97%, A1*B1)
=IF(A1<20, 100%, 97%)*A1*B1
=IF(A1<20, A1*B1, A1*B1*3%)
=A1*IF(A1>20, B1*0.97, B1)
Question 23
0 out of 2 points
Each of these is a basic type of a touch screen, EXCEPT ________.
Selected Answer:
surface acoustic wave
Answers:
capacitive
surface acoustic wave
resistive
reflective
Question 27
0 out of 2 points
A ________ network can contain servers as well as individual computers.
Selected Answer:
peer-to-peer
Answers:
peer-to-peer
client/server
star
switch
Selected Answer:
protocol
Answers:
frame
packet
token
protocol
Question 30
0 out of 1 points
(Excel) A homeowner wants to build a koi pond in their backyard and is trying to determine how much water is required to fill it. Assume the following formula can be used for that type of rectangular pond to determine the total volume in gallons:
Length x Width x Average Depth x 7.5
The length of this pond is 25 feet and the width is 10 feet. The pond will have three different levels, split into equal portions by surface area (notvolume). The shallowest portion will be only one foot deep, with the middle portion set to a depth of two feet, and the remaining portion at four feet deep. Given these measurements, create a formula that will accurately determine how many gallons of water are needed to fill the empty pond to capacity.
Selected Answer:
[None Given]
Question 32
0 out of 1 points
(Excel) What appears to be a significant issue with the following nested function?
=IF(MEDIAN(B4:B9)<>AVG(B4:B9), "$C$10", "")
Assume that it is being entered into cell A1 of a new worksheet.
Selected Answer:
[None Given]
Answers:
Nothing is wrong with the nested function as it is written
The function denoted as "AVG" is not valid in an Excel worksheet
$C$10 is an absolute cell reference and should not be used as a text string
There is no text within the literal string ("") at the end of the function
Question 34
0 out of 1 points
(Excel) Review the accompanying worksheet image. What is the result of evaluating the following formula?
=SUM(MIN(A3:C5),MEDIAN(A2:C3),MAX(C1:D2))
Selected Answer:
[None Given]
Question 35
0 out of 1 points
(Excel) Review the spreadsheet image which shows names for property owners and the respective value of their residence. (2 points each)
A) Using absolute cell references only, what formula should be used in cell A16 to determine the statistical mean price for all homes listed?
[PartA]
B) What formula should be used in cell A17 to round the result from part A) that would be displayed in cell A16 to the nearest penny?
[PartB]
C) What formula should be used in cell A16 to determine the third most expensive home in the list ?
[PartC]
(Excel) Download the attached template file which contains employee data for a fictitious company to the PC Desktop and then open it in Excel. First, create a Table for this set of data and then use Sort, Filter, and Total eatures to answer the following four questions.
A) Apply an alphabetical sort (A to Z) to Department and then reverse chronological sequence to Age. What is the last name of the employee who appears at the top of the list? [A]
B) Apply a reverse alphabetical sort (Z to A) to Department and then ascending order for Total Sales. What is the last name of the employee who appears in the top row of the Large Appliances Department? [B]
C) How many males are employed by Cardinal Electronics that are at least 45 years old? [C]
D) Leaving this filter in place, what is the Average Sales (rounded to the nearest whole number) for the employees that meet the criteria in Part C)? [D]
CIS250-Cardinal-Empl-Data.xlsx
Specified Answer for: A
[None Given]
Specified Answer for: B
[None Given]
Specified Answer for: C
[None Given]
Specified Answer for: D
[None Given]
Question 18
0 out of 1 points
(Excel) A sparkline is
Selected Answer:
is a label that describes the chart.
Answers:
is a label that describes the chart.
is the value or name of a data point.
a miniature chart contained in a single cell.
is a label that describes either the category axis or the value axis.
Question 19
0 out of 1 points
(Excel) The Body Mass Index (BMI) is often used by health care professionals to determine whether a person is overweight or underweight. The BMI is calculated using the following sequence of steps:
Multiply the person's body weight in pounds by 0.45.
Multiply the person's height in inches by 0.025.
Square the answer from Step 2.
Divide the answer from Step 1 by the answer to Step 3.
Round the result of Step 4 to the nearest whole number.
Determine the BMI of a person with a weight of 180 pounds and a height of precisely six feet to the nearest whole number and then enter the resulting two-digit value into the answer space below.
Selected Answer:
[None Given]
Question 21
0 out of 1 points
(Excel) A local tire store is offering an "early bird" discount of 20% off for customers that arrive before 8am to purchase a set of four radial tires that cost $131 each. Note that a sales tax of 6% on the sub-total is due as well as an additional $40 fee (which should not be discounted or taxed) for balancing, installation, and disposal. What amount will an "early bird" customer pay for the new tires, rounded to the nearest whole dollar?
Selected Answer:
$476
Answers:
$476
$151
$484
$595
Question 22
0 out of 1 points
(Excel) An interstate tollway plaza is offering a discount on all fuel pumped based on the total quantity purchased. Which of the formulas below calculates the correct total price to charge a customer for the fuel they have pumped based on the following conditions:
no discount (zero dollars off the total amount due) if a person purchases less than 20 gallons of fuel
a 3% discount on all fuel purchased if the person dispenses at least 20 gallons of fuel into their tank
Assume that cell A1 shows the total quantity (in gallons) of fuel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that a person should pay, after the discount (if any) has been applied.
Selected Answer:
[None Given]
Answers:
=IF(A1>20, A1*B1*97%, A1*B1)
=IF(A1<20, 100%, 97%)*A1*B1
=IF(A1<20, A1*B1, A1*B1*3%)
=A1*IF(A1>20, B1*0.97, B1)
Question 23
0 out of 2 points
Each of these is a basic type of a touch screen, EXCEPT ________.
Selected Answer:
surface acoustic wave
Answers:
capacitive
surface acoustic wave
resistive
reflective
Question 27
0 out of 2 points
A ________ network can contain servers as well as individual computers.
Selected Answer:
peer-to-peer
Answers:
peer-to-peer
client/server
star
switch
Selected Answer:
protocol
Answers:
frame
packet
token
protocol
Question 30
0 out of 1 points
(Excel) A homeowner wants to build a koi pond in their backyard and is trying to determine how much water is required to fill it. Assume the following formula can be used for that type of rectangular pond to determine the total volume in gallons:
Length x Width x Average Depth x 7.5
The length of this pond is 25 feet and the width is 10 feet. The pond will have three different levels, split into equal portions by surface area (notvolume). The shallowest portion will be only one foot deep, with the middle portion set to a depth of two feet, and the remaining portion at four feet deep. Given these measurements, create a formula that will accurately determine how many gallons of water are needed to fill the empty pond to capacity.
Selected Answer:
[None Given]
Question 32
0 out of 1 points
(Excel) What appears to be a significant issue with the following nested function?
=IF(MEDIAN(B4:B9)<>AVG(B4:B9), "$C$10", "")
Assume that it is being entered into cell A1 of a new worksheet.
Selected Answer:
[None Given]
Answers:
Nothing is wrong with the nested function as it is written
The function denoted as "AVG" is not valid in an Excel worksheet
$C$10 is an absolute cell reference and should not be used as a text string
There is no text within the literal string ("") at the end of the function
Question 34
0 out of 1 points
(Excel) Review the accompanying worksheet image. What is the result of evaluating the following formula?
=SUM(MIN(A3:C5),MEDIAN(A2:C3),MAX(C1:D2))
Selected Answer:
[None Given]
Question 35
0 out of 1 points
(Excel) Review the spreadsheet image which shows names for property owners and the respective value of their residence. (2 points each)
A) Using absolute cell references only, what formula should be used in cell A16 to determine the statistical mean price for all homes listed?
[PartA]
B) What formula should be used in cell A17 to round the result from part A) that would be displayed in cell A16 to the nearest penny?
[PartB]
C) What formula should be used in cell A16 to determine the third most expensive home in the list ?
[PartC]
Explanation / Answer
Answers)
Q 13) Excel file information missing
Q 18) (Excel) A sparkline is
a miniature chart contained in a single cell.
Sparkline is a miniature chart which is contained in a excel worksheet cell which shows the visual representation of the data in the cell.
Q 19) BMI calculated as:
Weight = 180 pounds
Height= 72 inches
180 * .45 = 81
72 * .025 = 1.8
1.8 * 1.8 = 3.24
81/3.24 =25
According to the formula given the BMI of the person is 25
Q 20) During an early bird offer for the tires:
One tire = $131
4 tires = 524
Price after discount = 524 - 104.8 = 419.2
Price after sales tax = 25.152 + 419.2 = 444.352
Price after fee for balancing, installation, and disposal = 444.352+40 = 484.35 approx == 484
Answer is $484
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.