Answer:
1. Pie chart.
2. Goal seek.
3. Relative reference cell.
4. Data marker.
5. Chart sheet.
6. What-If-Analysis.
7. [tex] Rate = \frac {Amount \; of \; increase}{Base} [/tex]
8. Order of operations.
9. Formula AutoComplete.
10. Axis.
11. Category axis.
12. Value axis
13. [tex] Value \; after \; increase = Base * Percent \; for \; new \; value [/tex]
Explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.
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.
Some of the terminologies and features of the Microsoft Excel software includes the following;
1. Pie chart: a chart that shows the relationship of each part to a whole.
2. Goal seek: a what-if-analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
3. Relative reference cell: in a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to in the formula.
4. Data marker: a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
5. Chart sheet: a workbook sheet that contains only a chart.
6. What-If-Analysis: the process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
7. [tex] Rate = \frac {Amount \; of \; increase}{Base} [/tex]: The mathematical formula to calculate a rate of increase.
8. Order of operations: the mathematical rules for performing multiple calculations within a formula.
9. Formula AutoComplete: the excel feature which, after typing - and the first letter of a function, displays a list of function names.
10. Axis: a line that serves as a frame of reference for measurement and that borders the chart plot area.
11. Category axis: the area along the bottom of a chart the identifies the categories of data, also referred to as the x-axis.
12. Value axis: a numerical scale on the left side of a chart that shows the range of numbers for the data points, also referred to as the y-axis.
13. [tex] Value \; after \; increase = Base * Percent \; for \; new \; value [/tex]: the formula for calculating the value after an increase by multiplying the original value the base by the percent for new value.
Name 4 components of a components system
You need to write a menu driven program. The program allows a user to enter five numbers and then asks the user to select a choice from a menu. The menu should offer the following four options – 1. Display the smallest number entered 2. Display the largest number entered 3. Display the sum of the five numbers entered 4. Display the average of the five numbers entered
Answer:
In Python:
nums = []
for i in range(5):
num = int(input("Num: "))
nums.append(num)
print("1 - Smallest")
print("2 - Largest")
print("3 - Sum")
print("4 - Average")
menu = int(input("Select menu: "))
if menu == 1:
print("Smallest: ",min(nums))
elif menu == 2:
print("Largest: ",max(nums))
elif menu == 3:
isum = 0
for i in range(5):
isum+=nums[i]
print("Sum: ",isum)
elif menu == 4:
isum = 0
for i in range(5):
isum+=nums[i]
print("Average: ",isum/5)
else:
print("Invalid Menu Selected")
Explanation:
This program uses a list to get inputs for the 5 numbers
Here, the list is initialized
nums = []
This iterates from 1 to 5
for i in range(5):
This gets input for the 5 numbers
num = int(input("Num: "))
This appends each number to the list
nums.append(num)
The next 4 lines represents the menu
print("1 - Smallest")
print("2 - Largest")
print("3 - Sum")
print("4 - Average")
This prompts the user for menu
menu = int(input("Select menu: "))
If menu is 1, print the smallest
if menu == 1:
print("Smallest: ",min(nums))
If menu is 2, print the largest
elif menu == 2:
print("Largest: ",max(nums))
If menu is 3, calculate and print the sum of all inputs
elif menu == 3:
isum = 0
for i in range(5):
isum+=nums[i]
print("Sum: ",isum)
If menu is 4, calculate and print the average of all inputs
elif menu == 4:
isum = 0
for i in range(5):
isum+=nums[i]
print("Average: ",isum/5)
If menu is not 1 to 4, then print invalid menu
else:
print("Invalid Menu Selected")
Read the scenario and then answer the question using only the information provided.
A report titled “Dog Breeds” contains information about four breeds of dogs. Information about each breed is contained in a separate table. Which best describes how the report is organized?
The report is grouped and sorted.
The report is sorted only.
The report is grouped only.
Answer:
The report is grouped and sorted.
Answer:
C. the report is grouped only
Explanation:
Describe a problem you’ve solved or a problem you’d like to solve. It can be an intellectual challenge, a research query, an ethical dilemma — anything of personal importance, no matter the scale. Explain its significance to you and what steps you took or could be taken to identify a solution.
Answer:
Explanation:
I run an online e-commerce store and lately its been very difficult keeping track of customer detail, incoming orders, keyword generation etc. One solution that I thought about would be an application that controls all of that for me. In order to accomplish this I would first need to design and create a GUI that contains all of the necessary buttons and displays for the information. Then I would need to code a webscraper using Python to grab all of the data from e-commerce store as soon as it becomes available, organize it, and display it within the GUI.
Best monitor cofficiant modern warfare
Answer: Monitor coefficient only determines your vertical sens with respect to your horizontal. It should be your horizontal pixels divided by your vertical. E.g. for a 1920 x 1080 monitor it should be 1.33. For a 2560 x 1440 it should be 1.78.
Explanation:
Answer:
1920 x 1080 monitor or 2560 x 1440
if your looking for a smooth gaming experience also depends on the graphic card and processer you use
Explanation:
what is this....... Iam booking train to patna.
An electronics technician who enjoys working "at the bench" would most likely want to work
Answer: for a manufacturer
Explanation:
The options include:
A. for a manufacturer.
B. as a microwave technician.
C. as a central office technician.
D. for a TV or radio station.
An electronics technician who enjoys working "at the bench" would most likely want to work with a manufacturer.
In this case, if the person wants to work at the bench since he or she enjoys it, then the person should work for a manufacturer.
When adding delegates to his mailbox, which role should Joel use if he would like the user to be able to read and create items in a particular folder?
- editor
- publishing editor
- author
- manager
Answer:
publishing editor
Explanation:
In this scenario, the role that he should choose for the delegates would be publishing editor. This role will allow them to create, read, modify, and delete all items within a given folder, and create subfolders. The other options listed either do not give access to create/modify existing files or simply only give all these rights with files that the user creates but not files that already existed in the folder. Therefore, this would be the best role for what Joel wants to accomplish.
1. What are the main features of IEEE 802.3 Ethernet standard?
Answer:
Single byte node address unique only to individual network. 10 Mbit/s (1.25 MB/s) over thick coax. Frames have a Type field. This frame format is used on all forms of Ethernet by protocols in the Internet protocol suite.
Explanation:
802.3 is a standard specification for Ethernet, a method of packet-based physical communication in a local area network (LAN), which is maintained by the Institute of Electrical and Electronics Engineers (IEEE). In general, 802.3 specifies the physical media and the working characteristics of Ethernet.
Mathilda’s computer has been running slow the past few months. She observed that the system unit becomes too hot. What does she need to do to fix this issue?
A.
She needs to make sure that the keyboard and mouse are properly connected.
B.
She needs to install antivirus software.
C.
She needs to delete unwanted files from her hard disk.
D.
She needs to clean the dust from the system unit fan.
Answer:
The answer is D
Explanation:
5.10 (Find the highest score) Write a program that prompts the user to enter the number of students and each student's score, and displays the highest score.
Please help me!
Answer:
Python Program for the task.
#Ask the user to input the number of students
n = int(input("Please enter the number of students:\n"))
print()
#Get students' scores
for i in range(n):
score_list = [ ] #placeholder for score
i = float(input("Please enter student's score:"))
score_list.append(i) # append student score
#print the highest score
print("The highest score is",max(score_list))
What was software for modems that connected through phone lines called?
virtual-emulation software
terminal-emulation software
bulletin-board software
baud modem software
Answer:
Best Regards to all of the people who have met you in the class
market trends on products made of bamboo, wood, and metal
Answer:
market trends on products made of bamboo, wood, and metal
Quail eggs, popcorns, hotdogs, sandwiches, ice creams, fries, sodas, juice, you name it. It can all be found near school community. Also, fun and exciting stuff can be found and are sold near schools. Keychains, pretty and fashionable headbands, ponytails, ribbons, and so much more are sold there.
How is an interpreter different from a compiler?
An interpreter translates and executes code line by line, while a compiler translates all code at once so that it is ready to be executed at any time.
An interpreter translates all code at once so that it is ready to be executed at any time, while a compiler translates and executes code line by line.
An interpreter translates programming code into binary language, while a compiler does not.
An interpreter translates binary language into programming language, while a compiler translates programming language into binary language.
Answer:
An interpreter is quite different from a complier due to the following statement below:
O. An interpreter translates and executes code line by line, while a compiler translates all code at once so that it is ready to be executed at any time.
Explanation:
For an interpreter, it works in translating and execution of the codes line after another line. In a situation where there is a mistake in the code, the next line would not be able to be executed, but rather display error message. On the other hand, compiler translate all codes at once and execute them as a single work.
During its translation of the codes in compiler, should there be any error, it would not be able to execute despite the fact that, the error might be in the last line of the code.
Answer:
a
Explanation:
taking test right now
The Painting Company has determined that for every 112 square feet of wall space:
One gallon of paint at $9.53 per gallon is required if total square feet is 2000 or less. If square footage is greater than 2000, paint is $10.50 per gallon.
8 hours of labor at $35 per hour is required.
A hazardous material disposal fee of 7.5% of the total paint cost is required.
Create a function called paintJobCost which allows the user to provide the total number of square feet for the paint job and produces an itemized list of charges that includes:
Number of gallons of paint required.
Total Cost of the Paint (Paint Cost x Gallons Required)
Hours of labor required to paint (8 hrs per 112 sq ft)
Total Cost of the Labor.
The hazardous material fee.
The total cost of the paint job. (Paint Cost + Labor Cost + Hazardous Material fee)
Your function, when called, must display all the above information exactly as shown below.
Expected Output
Call the paintJobCost function where the total square footage of the paint job is 1800. Square Footage Paint Required Paint Cost 16.07 gal $153.16 Labor Hours 128.57 hrs Labor Cost $4,500.00 Hazard Fee $11.49 TOTAL COST OF PAINT JOB $4,664.65 Call the paintjobCost function where the total square footage of the paint job is 2700. Square Footage Paint Required 2700 24.11 gal Paint Cost $253.12 Labor Hours 192.86 hrs Labor Cost $6,750.00 Hazard Fee $18.98 TOTAL COST OF PAINT JOB $7,022.11 Call the paintJobCost function where the total square footage of the paint job is 3200. Square Footage Paint Required Paint Cost 3200 28.57 gal $300.00 Labor Hours 228.57 hrs Labor Cost $8,000.00 Hazard Fee $22.50 TOTAL COST OF PAINT JOB $8,322.50
Answer:
Answered below
Explanation:
#Program is written in Python.
sq_feet = int(input ("Enter paint area by square feet: ")
gallons = float(input (" Enter number of gallons: ")
paint_job_cost(sq_ft, gallons)
#Function
def paint_job_cost(sq_ft, gal){
gallon_cost = 0
cost_per_hour = 35
if sq_ft <= 2000:
gallon_cost = 9.53
else:
gallon_cost = 10.50
paint_cost = gal * gallon_cost
labour_hours = 8 * (sq_ft/112)
total_labour_cost = labour_hours * cost_per_hour
hazard_fee = 0.075 * paint_cost
total_cost = paint_cost + total_labour_cost + hazard fee
print (paint_cost)
print(labour_hours)
print (total_labour_cost)
print (hazard_fee)
print(total_cost)
}
HLOOKUP is used for Horizontal Data look ups while VLOOKUP is for Vertical Data look ups
Select one:
True
False
Answer:
True
Explanation:
Both HLOOKUP and VLOOKUP are excel functions used for searching through tables for a specified lookup value to either get an exact or approximate match. The VLOOK and HLOOKUP functions have identical syntax which only differs with the HLOOKUP requiring the row index number to search through the rows while, VLOOKUP requires the column index number to search through the columns. Other than this difference, the other syntax values are the same.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Variable Labels:
Examine the following variable names for formatting errors.
If it is not usable, correct it. If there are no errors, write good.
10. studentName
11. Student Address
12.110 Room
13. parentContact
14. Teachers_name
Answer:
10. 13. and 14. Correct
11. Incorrect
12. Incorrect.
Explanation:
The programming language is not stated. However, in most programming languages; the rule for naming variables include:
Spacing not allowedUnderscore is allowedVariable names cannot start with numbersUsing the above rules, we can state which is correct and which is not.
10. 13. and 14. Correct
11. Incorrect
Reason: Spacing not allowed
Correct form: StudentAddress
12. Incorrect.
Reason: Numbers can't start variable names
Correct form: Room110
Consider the key success factors of B2C. Is it only IT? What is most important?
Jsjfu zzer jsusuc888 kksss
Consider the following incomplete method. Method findNext is intended to return the index of the first occurrence of the value val beyond the position start in array arr. I returns index of first occurrence of val in arr /! after position start; // returns arr.length if val is not found public int findNext (int[] arr, int val, int start) int pos = start + 1; while condition '/ ) pos++ return pos; For example, consider the following code segment. int [ ] arr {11, 22, 100, 33, 100, 11, 44, 100); System.out.println(findNext (arr, 100, 2)) The execution of the code segment should result in the value 4 being printed Which of the following expressions could be used to replace /* condition */ so that findNext will work as intended?
(A) (posarr.length) &&(arr [pos]- val)
(B) (arr [pos] != val) && (pos < arr. Îength)
(C) (pos
(D) (arr [pos} == val) && (pos < arr. length)
(E) (pos
Answer:
B)
Explanation:
The while loop runs as long as two conditions are satisfied, as indicated by the && logical operator.
The first condition- arr[pos] != val
checks to see if the value in the array index, pos, is equal to the given value and while it is not equal to it, the second condition is checked.
The second condition(pos < are.length), checks to see if the index(pos) is less than the length of the array. If both conditions are true, the program execution enters the while loop.
The while loop is only terminated once arr[pos] == Val or pos == arr.length.
10.11 LAB: Pet information (derived classes) The base class Pet has private data members petName, and petAge. The derived class Dog extends the Pet class and includes a private data member for dogBreed. Complete main() to: create a generic pet and print information using PrintInfo(). create a Dog pet, use PrintInfo() to print information, and add a statement to print the dog's breed using the GetBreed() function.
Answer:
Answered below.
Explanation:
//Program in Java
Class Test{
public static void main (String[] args){
//create a pet object
Pet pet = new Pet();
//call pet object's printInfo method
pet.printInfo();
//create a new Dog object
Dog dog = new Dog();
//dog can access the printInfo method of the Pet class because it derives from it
dog.printInfo();
//dog can also call it's private method.
dog.getBreed();
}
}
Write a function named word_beginnings that has two parameters line a string ch a character Return a count of words in line that start with ch. For the purposes of this exercise a word is preceeded by a space. Hint: add a space to the beginning of line For example if line is 'row row row your raft' and ch is 'r' the value 4 will be returned. Note: You can use lists in this question but try to solve it without lists.
Answer:
The function in Python is as follows:
def word_beginnings(line, ch):
count = 0
lines =line.split(" ")
for word in lines:
if word[0] == ch:
count+=1
return count
Explanation:
This defines the function
def word_beginnings(line, ch):
This initializes count to 0
count = 0
This splits line into several words
lines =line.split(" ")
This iterates through each word
for word in lines:
This checks if the first letter of each word is ch
if word[0] == ch:
If yes, increment count by 1
count+=1
Return count
return count
Iconic designs are inspirational and are often copied.
True
False
This is absolutely true. A shining example of this is with smartphones. Before Apple introduced the world to the iPhone, most smartphones had actual keyboards, zero touchscreen capabilities, could barely browse the internet, and had very small displays. After the iPhone was released in 2007, companies immediately scrambled to come out with phones that looked uncannily similar to Apple's. Why? Because Apple's phone was designed well. It's pretty amazing how immediate the shift was. In fact, I recomend you look up "Smartphones before and after iPhone" online. It's pretty cool. Here's an image example: https://www.redmondpie.com/image-showing-phones-before-and-after-iphone-x-revisits-how-android-market-still-tends-to-copy-iphone/
Hope this helps!
8. What's the output of this code?
1
def sum(x, y):
return(x+y)
print(sum (sum(1,2), sum(3,4)))
Answer:
10
Explanation:
[tex]sum(1,2) = 3\\sum(3,4) = 7\\sum(3,7) = 10\\[/tex]
Basically, sum((1+2) + (3+4)) = sum(3,7) = (3+7) = 10
Ask the user to input a country name. Display the output the message “I
would love to go to [country]”
Answer:
Explanation:
The following code is written in Python, it asks the user for an input saves it to a variable called country, and then prints out the sentence example in the question using the user's input. The output can be seen in the picture attached below
country = input("input country")
print('I would love to go to ' + country)
Many companies use telephone numbers like 555-GET-FOOD so the number is easier for their customers to remember. On a standard telephone, the alphabetic letters are mapped to numbers in the following fashion: A, B, and C = 2 D, E, and F = 3 G, H, and I = 4 J, K, and L = 5 M, N, and O = 6 P, Q, R, and S = 7 T, U, and V = 8 W, X, Y, and Z = 9 Write a program that asks the user to enter a 12-character telephone number in the format: XXX-XXX-XXXX. Acceptable characters (X's) are A-Z and a-z. Your program should check for: The length of the phone number is correct. The dashes are included and are in the correct positions. There are no characters in the illegal characters in the string. The application should display the telephone number with any alphabetic characters that appeared in the original translated to their numeric equivalent. If the input string is not entirely correct then you should print an error message. For example, if the user enters 555-GET-FOOD the program should display 555-438-3663. If the user enters 123-456-7890, the program should display 123-456-7890. Rules: You must have one function (in addition to main()) that converts an alphabetic character to a digit. Or you can have one function that coverts all characters to digits. You can make your own function or use a built-in function if one exists.
Answer:
The program in Python is as follows:
def convertt(phone):
splitnum = phone.split ('-')
valid = True
count = 0
err = ""
numphone = ""
if len(phone) != 12:
err = "Invalid Length"
valid = False
elif phone[3] != '-' or phone[7] != '-':
err = "Invalid dash [-] location"
valid = False
while valid== True and count < 3:
for ch in splitnum[count]:
if ch.isdigit():
numphone += ch
elif ch.upper()in 'ABC':
numphone += '2'
elif ch.upper()in 'DEF':
numphone += '3'
elif ch.upper()in 'GHI':
numphone += '4'
elif ch.upper() in 'JKL':
numphone += '5'
elif ch.upper()in 'MNO':
numphone += '6'
elif ch.upper()in 'PQRS':
numphone += '7'
elif ch.upper()in 'TUV':
numphone += '8'
elif ch.upper()in 'WXYZ':
numphone += '9'
else:
valid = False
err = "Illegal character in phone number"
if count!=2:
numphone += '-'
count += 1
if valid == False:
print (err)
else:
print ("Phone Number", numphone)
phone = input("Phone number: ")
convertt(phone)
Explanation:
See attachment for complete source code where comments are used for explanation
Which of these are examples of a bug?
A. Feedback telling you the game is boring. B. Players can get to the river, but nothing they click gets them over the river. C. The game crashes during game play. D. B & C
Which of these skills are used in game design?
Writing, Project Management, Drawing and artistic visualization, all of the above
Answer:
I think the answer is Writing but am not sure
As of Spring 2020, in otder to get into the CS major, you must have a 3.0 GPA or better in cs120, cs210, and cs245. In this problem, you should write one function named get_gpa, which will calculate this GPA. This function should have one parameter, which will be a dictionary of grades in computer science courses. You can assume that the dictionary will always have the keys 'cs120', 'cs210', and 'cs245', but it also might contain some names of other courses too. The values associated with each key will be a float representeing the GPA-style grade for that class. For instance, the parameter dictionary might look like: {'cs120':4.0 'cs245':3.0, 'cs210':2.0}. Some examples:
get_gpa({'cs110': 4.0, 'cs245':3.0, 'cs335':4.0, 'cs120':3.0, 'cs210':3.0}) should return 3.0.
get_gpa({'cs110': 4.0, 'cs120':3.0, 'cs245':2.0, 'cs210':1.0}) should return 2.0.
get_gpa({'cs245':4.0, 'cs120':3.0, 'cs245':2.0}) should return 3.0.
Make sure to include only the one function in your file.
Answer:
The function is as follows:
def get_gpa(mydict):
gpa = 0
kount = 0
for course_code, gp in mydict.items():
if course_code == 'cs120' or course_code == 'cs210' or course_code == 'cs245':
gpa += float(gp)
kount+=1
return (gpa/kount)
Explanation:
This defines the function
def get_gpa(mydict):
This initializes gpa to 0
gpa = 0
This initializes kount to 0
kount = 0
This iterates through the courses
for course_code, gp in mydict.items():
If course code is cs120 or cs210 or cs245
if course_code == 'cs120' or course_code == 'cs210' or course_code == 'cs245':
The gpa is added
gpa += float(gp)
And the number of courses is increased by 1
kount+=1
This returns the gpa
return (gpa/kount)
Suppose we define a WaitlistEntry as follows:
typedef struct{
int iPriority; /* Priority of the student to be enrolled */
int iStudentID; /* ID of the student */
}
WaitlistEntry;
Below are different implements of a function to create a WaitlistEntry from given iPriority and iStudentID data. Some of these implementations are flawed. Identify them and describe what is wrong with them briefly:
WaitlistEntry createWL( int iPriority, int iStudentlD )
WaitlistEntry w,
w.iPriority iPriority;
w.iStudentlD iStudentlD;
return w;
a. correct
b. incorrect, leaks memory
c. incorrect, syntax error
d. incorrect, data will be overwritten by next function call
Answer:
You have syntax errors, but I don't know if it happened when you posted this question, nevertheless
Explanation:
Correct code:
WaitlistEntry createWL( int iPriority, int iStudentID ) { // Opening Brace
WaitlistEntry w; // Should be ; not ,
w.iPriority = iPriority; // Assign Missing
w.iStudentID = iStudentID; // Assign Missing
return w;
} // Closing Brace
// Also note: iStudentID this actually has an 'l' which is LD. Not ID, this is why I assume these errors happened when posting the question.
HW3: Write a program in C language by using if statement for a lift control
system, for your information
nation the maximum weight is 240kg and for five floors.