Answer:
Explanation:
Which of the following functions enables you to calculate the average number of on-site visits made by a particular sales representative
The function that enables you to calculate the average number of on-site visits made by a particular sales representative is AVERAGEIF. Therefore, the correct option is A.
What is AVERAGEIF function?The AVERAGEIF function calculates the average of the values of the range that meets the supplied criteria.
=AVERAGEIF(range, criteria, [average_range])
Where,
Range: The range of cells to be evaluated by the criteria.
Criteria: The condition or criterion that cells must meet to be included in the calculation of the average. This can be a number, text, logical expression, or a cell reference to a single cell containing any of these.
[average_range]: (Optional) The range of cells to be used in the calculation of the average. If, the range argument is used.
Hence, to calculate average AVERAGEIF is used. Therefore, the correct option is A.
Learn more about AVERAGEIF function, here:
https://brainly.com/question/14987350
#SPJ2
The question is incomplete, but most probably the complete question is,
Which of the following functions enables you to calculate the average number of on-site visits made by a particular sales representative:
A. AVERAGEIF
B. COUNTIF
C. AVEDEV
D. TEXTJOIN
What is the benefit of making an archive folder visible in the Outlook folder list?
This makes the folder available on the Office 365 website.
The folder can be password protected to increase security.
Archived items in the folder are accessible within the Outlook client.
Archived items in the folder can be shared with other Outlook users.
Answer:
a
Explanation:
describe email etiquette and netiquette when communicating electronically.
Answer:
Email etiquette refers to the principles of behavior that one should use when writing or answering email messages. It is also known as the code of conduct for email communication. Email etiquette depends upon to whom we are writing- Friends & Relatives, Partners, Customers, Superior or Subordinates
Difference Between Etiquette and Netiquette is that Etiquette is the simple requirements needs for social behavior while Netiquette, is the code of acceptable behaviors users should follow while on the Internet.
Use the drop-down menus to explain how to locate the Consolidate dialog box.
1. Select the ------------
tab on the ribbon.
2. Look in the ----------
group and select -----------
.
Answer:
data, data tools, consolidate
Explanation:
I just did it :)
Which range of values would result in 10 elements stored in an array?
1-11
0-9
0-10
2-12
Answer:
0-9
Explanation:
count 0 as 1
len(0,1,2,3,4,5,6,7,8,9)=10
LAB: Varied amount of input data
Statistics are often calculated with varying amounts of input data. Write a program that takes any number of integers as input, and outputs the average and max.
Ex: If the input is:
15 20 0 5
the output is:
10 20
Answer:
Answered below
Explanation:
#python program
#First get the number of inputs from user
num_inputs = int(input("Enter number of inputs:")
j = 0
sum =0
max = 0
while j < num_inputs:
num = int(input ("Enter numbers: ")
sum = sum + num
if num > max:
max = num
j++
#Compute the average
average = sum/num_inputs
print (average, max)
g Write an UPDATE statement that changes the address for the row with vendor_id 4 so the suite number (Ste 260) is stored in vendor address instead of vendor address 1. Then, use SQL Developer to verify the change (you may need to click the Refresh button at the top of the Data tab to see the change). If this works correctly, go back to the tab for the UPDATE statement and click the Commit button to commit the change.
Answer:
UPDATE 'Vendors' SET 'address' = 'Ste 260' WHERE 'vendor_id' = 4
Explanation:
Required
Write an update statement
The question is incomplete as the table name is not given.
So, I will make the following assumptions.
Table name = Vendors
So, the update statement is:
UPDATE 'Vendors' SET 'address' = 'Ste 260' WHERE 'vendor_id' = 4;
The above statement queries the vendors table and changes the address of vendor_id 4 from the initial value to Ste 260
Write the mostValuableNeighbor method, which compares the item in row r and column c to the items to its left and to its right. The method determines which of the three items has the greatest value and returns its name. If more than one of the values have a value that is greatest, then any of their names can be returned. If the item has no item to its left, it is compared only to the item to its right. If the item has no item to its right, it is compared only to the item to its left.
Answer:
Explanation:
The following method is written in Java, using the Item class and ItemGrid class found online we can use this method to grab the 2-dimensional array and compare the three neighbors in the same row. It saves the position of the neighbor with the greatest value in the variable greatest and then uses that position to call the getName() method from the object in that position to get the name of that Neighbor and returns the name.
public String mostValuableNeighbor(ItemGrid grid, int r, int c) {
int greatest = grid[r][c];
if (grid[r][c+1].getValue() > greatest.getValue()) {
greatest = grid[r][c+1];
}
if (grid[r][c-1].getValue() > greatest.getValue()) {
greatest = grid[r][c-1];
}
return greatest.getName();
}
In this exercise we have to use the knowledge of computational language in JAVA to write the code.
We have the code in the attached image.
The code in Java can be found as:
public String mostValuableNeighbor(ItemGrid grid, int r, int c) {
int greatest = grid[r][c];
if (grid[r][c+1].getValue() > greatest.getValue()) {
greatest = grid[r][c+1];
}
if (grid[r][c-1].getValue() > greatest.getValue()) {
greatest = grid[r][c-1];
}
return greatest.getName();
}
See more about JAVA at brainly.com/question/26104476
Information Technology
Answer:
information technologies
Explanation:
Information technology is the study, design, development, implementation, support or management of computer-based information systems—particularly software applications and computer hardware. IT workers help ensure that computers work well for people.
Nearly every company, from a software design firm, to the biggest manufacturer, to the smallest “mom & pop” store, needs information technology workers to keep their businesses running smoothly, according to industry experts.
Most information technology jobs fall into four broad categories: computer scientists, computer engineers, systems analysts and computer programmers. HR managers responsible for recruiting IT employees increasingly must become familiar with the function and titles of the myriad job titles in demand today.
Some of them are listed below:
Database administration associate
Information systems operator/analyst
Interactive digital media specialist
Network specialist
Programmer/analyst
Software engineer
Technical support representative
Answer:
Information technology is the use of computers to store, retrieve, transmit and manipulate data, or information, often in the context of business or other enterpise
Acróstico sobre mouse
The Fibonacci numbers are 0, 1, 1, 2, 3, 5, 8, 13, ......., where each number is the sum of the two preceding numbers. Write a program that declares an array of length 15 and fills the array with the first 15 Fibonacci numbers. Print the array to check if the array elements are correct. Use the sizeofoperator instead of 15 whenever you need to use the array length.
1 There are several applications to assist you to surf through the internet, mention
three (3 marks)
Many individuals and organizations are choosing cloud storage for their important files. Discuss the pros and cons of cloud storage for both personal files and business files. Many individuals and organizations are choosing cloud storage for their important files. Discuss the pros and cons of cloud storage for both personal files and business files. What inputs and outputs are needed to support the storage environment
Answer:
Pros of cloud storage
Files can be accessed remotely without having to be connected to a company's intranetSecurity and file backups are managed by the cloud storage company, frees up employees time applying updates and other maintenance tasks.Usually billed monthly which allows for a lower initial startup costCons of cloud storage
File security relies upon trust in the cloud storage providerLong term cost could be higher than storing files yourselfRequires an internet connection to access fileshe is trying to find information on the internet first he navigated to a search engine entered the keywords database administrator and clicked on search the results did not show what it was looking for
Answer:
b
Explanation:
b
9. Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula using the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations.
Let understand that a spreadsheet perform function such as getting the sum, subtraction, averages, counting of numbers on the sheet rows and columns.
Also, the image to the question have been attached as picture.Here, Lael wants to count the number of students who have been elected to offices in student organizations.Lael will used the COUNTIF Function in the Spreadsheet to achieve the count because function helps to count cells that contain numbers.In conclusion, the formulae that Lael should use on the Spreadsheet to count the number of students who are elected is "Q8 = COUNTIF(M2:M31, "Elected")"
Learn more about Excel function here
brainly.com/question/24826456/
Assume a manufacturing company which manufactures and sells several electronic
products. This company has a list of suppliers who supply various components for
different products. Several components assembled together form a product. A product
will be manufactured in many work centers. Each product contains several components.
A product has at least one component and may comprise of several components. A
component must belong to a product and the same component can be used in multiple
products. Also mention the quantity of the component which a product requires.
Company has a list of suppliers who supply various components. A supplier may not
be supplying any component and may supply several components. A component must
be supplied by at least one supplier or several suppliers may provide the same
component. A supplier supplies the quantity and unit price of the products. A supplier
also supplies the quantity and unit price of the components. Each product will be
manufactured in single or multiple work centers. A work center may not produce a
product and may produce several products. Each work center will have one or more
employees and an employee would be working in single work center only. A customer
may not place any order and may place multiple orders. But an order will belong to a
specific customer only. Each order may contain single product or multiple products and
the same product may be demanded in many orders.
Construct an ER diagram for the manufacturing company.
Answer:
reboot it
Explanation:
RAM IS often referred
to as
1 SECONDARY STORAGE
2 . READ ONLY MEMORY
3. RATIO ACTIVE MEMORY
4. PRIMARY STORAGE
Answer:
ratio active memory
Explanation:
ratio active memory because the rule of computer
Consider the following program:
def test_1():
test_3()
print("A")
def test_2():
print("B")
test_1()
def test_3():
print("C")
What is output by the following line of code?
test_1()
C
A
B
C
A
C
C
A
Answer:
this would be answer D
Explanation:
In this exercise we have to use the knowledge of computational language in python to write the code.
We have the code in the attached image.
The code in python can be found as:
def test_1():
test_3()
print("A")
def test_3():
print("C")
Back to test_1()
print("A")
What is program?A computer can run multiple programs simultaneously, and each program can be in a different state. There are three states a program can be in: running, blocked, and ready. If a program is running, it means that it is currently using the computer's resources, such as the processor, memory, and I/O devices, to perform its tasks.
On the other hand, if a program is blocked, it means that it is waiting for a resource to become available, such as a file, network connection, or input from the user. In the scenario you mentioned, "Program A" is in the running state, meaning it is actively using the computer's resources.
Therefore, Program B" is in the blocked state, meaning it is waiting for a resource to become available so it can continue to run.
Learn more about program on:
https://brainly.com/question/30613605
#SPJ3
Parts arrive at a two-machine system according to an exponential interarrival distribution with mean 20 minutes. Upon arrival, the parts are sent to Machine 1 and processed. The processing-time distribution is TRIA (4.5, 9.3, 11) minutes. The parts are then processed at Machine 2 with a processing-time distribution as TRIA (16.4, 19.1, 20.8) minutes. The parts from Machine 2 are directed back to Machine 1 to be processed a second time (same processing-time distribution but an independent draw from it). The completed parts then exit the system. Run the simulation for a single replication of 20,000 minutes to observe the average number in the machine queues and the average part cycle time with Arena Model
Answer:
I really don’t know computer science but I give u good luck in finding an answer to this question.
Explanation:
Write a modular program that accepts up to 20 integer test scores in the range of 0 to 100 from the user and stores them in an array. Then main should report how many perfect scores were entered (i.e., scores of 100), using a value-returning countPerfect function to help it. Hint: Have the program count the scores as they are entered. Your program may need this information later.
Answer:
The program in Java is as follows:
import java.util.*;
public class Main{
public static int countPerfect(int [] scores, int n){
int count = 0;
for(int i = 0;i<n;i++){
if(scores[i] == 100) {count++;} }
return count; }
public static void main(String[] args) {
Scanner input = new Scanner(System.in);
int n;
System.out.print("Number of scores: ");
n = input.nextInt();
if(n<1 || n>20){n=20;}
int [] scores = new int[n];
for(int i = 0;i<n;i++){
scores[i] = input.nextInt(); }
System.out.print("Perfect Scores: "+countPerfect(scores,n));
}
}
Explanation:
The countPerfect function begins here
public static int countPerfect(int [] scores, int n){
This initializes the count to 0
int count = 0;
This iterates through the array elements
for(int i = 0;i<n;i++){
If current score is 100, count is incremented by 1
if(scores[i] == 100) {count++;} }
This returns the value of count
return count; }
The main begins here
public static void main(String[] args) {
Scanner input = new Scanner(System.in);
This declares the number of scores, n
int n;
Prompt to enter the number of scores
System.out.print("Number of scores: ");
This gets input for n
n = input.nextInt();
If input is less than 1 or greater than 20, n is set to 20
if(n<1 || n>20){n=20;}
This declares the scores as an array
int [] scores = new int[n];
This iterates through the array and get inputs for each score
for(int i = 0;i<n;i++){
scores[i] = input.nextInt(); }
This calls the function and print the number of perfect scores
System.out.print("Perfect Scores: "+countPerfect(scores,n));
}
What is the creative strategy for music application.
Answer:
The City of Vancouver has allocated $300,000 to support the growth and development of the Vancouver Music Strategy, developed to address current gaps in the music ecosystem that support: Creating a sustainable, resilient, and vibrant music industry.
Explanation:
What are the purposes of a good web page design? The purpose of a good web page design is to make it and .
Answer:
responsiveness and intuitive
Explanation:
The two main purposes of a good web page design is responsiveness and intuitive. A webpage needs to be designed in such a way that the individual using it can easily find what they are looking for and understand what each function in the webpage does without having to ask for help or go through an extensive tutorial. They need to be able to use the website for the first time and immediately be able to use it as if they have used it countless times before. The webpage also needs to be designed with responsiveness in mind. So much so that the webpage runs fluently, loads images fast, and scales to the size of the monitor correctly. As a rule the webpage should not take longer than 2 seconds to load.
Use the drop-down menus to describe how to add a data bar to a report.
1. Open the table in view.
2. Click the column of the desired numerical field.
3. Click the conditional tab Format, then .
4. In the Rules Manager dialog box, click .
5. Select to “compare to other records,” and determine whether you want the value and bar to show at the same time.
6. Adjust the desired length of the bar and the color. Click OK.
7. Once satisfied with your rule, click and then OK.
Answer:
1. layout
3. conditional formatting
4. new rule
7. apply
Explanation:
just did it on edge
Which of the following describes the line spacing feature? Select all that apply. adds space between words adds space between lines of text adds space between paragraphs adds space at the top and bottom of a page adds bullet points or numerical lists
Answer:
adds space between lines of text
adds space between paragraphs
Explanation:
Derive the three-dimensional transformation matrix for scaling an object by a scaling factor s in a direction defined by the direction cosines alpha , beta , gamma
Answer:
i dont know
Explanation:
i dont knoe im doing this for the points hehe
The code below assigns the 5th letter of each word in food to the new list fifth. However, the code currently produces errors. Insert a try/except clause that will allow the code to run and produce of list of the 5th letter in each word. If the word is not long enough, it should not print anything out. Note: The pass statement is a null operation; nothing will happen when it executes.
food = ["chocolate", "chicken", "corn
fifth = []
for x in food:
fifth.append(x[4])
Answer:
Answered below
Explanation:
foods = ["chocolate", "chicken", "corn"]
fifth_char = []
for food in foods:
"""Add a try statement to add fifth character to fifth_char list. If word is not long enough, the except part executes the the pass and nothing is printed.""'
try:
fifth_char.append(food[4])
except:
pass
#print out elements in new list
for c in fifth_char:
print(c)
Consider the following recursive method.
public static String doSomething(String str)
{
if (str.length() < 1)
{
return "";
}
else
{
return str.substring(0, 1) + doSomething(str.substring(1));
}
}
Which of the following best describes the result of the call doSomething(myString) ?
A
The method call returns a String containing the contents of myString unchanged.
B
The method call returns a String containing the contents of myString with the order of the characters reversed from their order in myString.
C
The method call returns a String containing all but the first character of myString.
D
The method call returns a String containing only the first and second characters of myString.
E
The method call returns a String containing only the first and last characters of myString.
Answer:
A
The method call returns a String containing the contents of myString unchanged.
Explanation:
PLEASE HELP I REALLY NEED IT ASAP
Select the correct answer. Layla and her team have installed a fire alarm system in an office. The alarm system connects to a wireless network, so it can be monitored using smartphones and computers connected to the same network. Which wireless technology does the fire alarm system use?
OA satellite
OB. Bluetooth
O C. infrared
OD. WI-FI
Answer:
wifi
Explanation:
if it's running on the same network that's wifi
Answer:
The correct answer is D. Wi-Fi.
Explanation:
I got it right on the Edmentum test.
Explain the paging concept and main disadvantages of pipelined
approaches? Compare the superscalar and super pipelined approaches
with block diagram?
Answer:
PAGINACIÓN En la gestión de memoria con intercambio, cuando ... Debido a que es posible separar los módulos, se hace más fácil la modificación de los mismos. ... Ventajas y Desventajas de la segmentación paginada
Explanation:
Discuss with illustrations the
types and benefits of enterprise storage systems.
Answer:
An Enterprise Storage System is a centralized repository for business information. It provides a common resource for data sharing, management and protection via connections to other computer systems.
Enterprise storage systems are designed to process heavy workloads of business-critical information.
Benefits
High availability
Reliable backup and disaster recovery
Convenient data sharing
Centralized administration
Remote support.
A medium-sized highway construction company CST has chosen to constrain its investment in computing resources to laptop and desktop computers and the necessary networking hardware and software to access the Internet efficiently. All of CST's data is to be stored off-site through an Internet-enabled storage provider that is used by many different companies and organizations. The service model employed for the data storage capability of only CST is:
Answer:
The service model employed for the data storage capability of only CST is:
SaaS (Software as a Service).
Explanation:
The three cloud computing categories are Infrastructure as a Service (IaaS), Software as a Service (SaaS), and Platform as a Service (PaaS). The three cloud computing services provide different virtual computing resources. In the case of CST, it utilizes only the data storage software of a provider, who provides the data storage infrastructure, including cloud-based servers, while CST uses its own "laptop and desktop computers and other networking hardware and software to access the Internet efficiently."