Q9. Complete the table with the name of the functions

1. Excel function to lookup data in a table organized
Vertically.
2. Is a function to sum cells that meet criteria.
3. Function to find the total number of entries in a
Column.
4. Runs a logical test and returns one value for a TRUE result, and another for a FALSE result
5. Excel function to lookup data in a table organized
Horizontally.

Answers

Answer 1

Answer:

1. VLOOKUP function.

2. SUMIF function.

3. COUNT function.

4. IF function.

5. HLOOKUP function.

Explanation:

Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents. There are different types of functions used in Microsoft Excel to perform specific tasks and these includes;

1. VLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized vertically. Thus, it's typically used for searching values in a column.

2. SUMIF function: it is an Excel function to sum cells that meet criteria such as text, dates and numbers. This function can be used with the following logical operators; <, >, and =.

3. COUNT function: it's an Excel function to find the total number of entries in a column. For example, to count the number of entries in B1:B15; COUNT(B2:B15).

4. IF function: runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to fail scores that are below 40; IF (A1 < 40, "Fail", "Pass").

5. HLOOKUP function: it's an Excel function that avails end users the ability to lookup data in a table organized horizontally. Thus, it's typically used for searching values in a column.


Related Questions

Ravi is writing an essay on the impact of the internet on business. Help him classify the scenarios he sees around him as positive and negative effects of the internet on business. He recently bought a second-hand camera online, which he hadn't been able to find in any store. A bookstore down the road shut down because people preferred the cheaper online bookstores. Ravi's sister complains that her boss always knows when she is late, but rarely greets her if their paths cross in office. His friend sells printed T-shirts online, storing them in his basement and promoting them on social media. One of his friend's printed T-shirts got wet and stained in the delivery truck and the buyer wrote a nasty review.

Answers

Answer: See explanation

Explanation:

Based on the options given, the positive effects of the internet on business will be:

• He recently bought a second-hand camera online, which he hadn't been able to find in any store.

• His friend sell printed T-shirts online, storing them in his basement and promoting them on social media.

The negative effects of the internet on business will be:

• A bookstore down the road shut down because people preferred the cheaper online bookstores.

• Ravi's sister complains that her boss always knows when she is late, but rarely greets her if their paths cross in office.

• One of his friend's printed T-shirts got wet and stained in the delivery truck and the buyer wrote a nasty review.

The diamond shape is used exclusively for
_signs.
A. School crossing
B. Yield
C. Warning
D. Regulatory

Answers

Answer is C. warning signs

The diamond shape is used exclusively for warning signs.

Which sign is a warning sign?

Diamond-shaped signs indicate warnings. Rectangular signs with a longer direction horizontal supply direction information. Pentagons characterize school zones.

The form of a diamond sign stands utilized only for warning signs (For example: cross the road ahead, end/begin divided road, merging traffic, curves, and construction warning signs).

Therefore, the correct answer is option C. Warning.

To learn more about warning signs

https://brainly.com/question/26105318

#SPJ2

whats your favorite tv show/ movie
please help for school project

Answers

Answer: an anime called one piece.

hope that helped ☺️

Explanation:

My favorite movie would have to be The Lion King, as the movie represents a family bondage and how courage and boldness should not be hidden. Strength, and the power of love is also represented in this movie. Plus, I love lions! :D

In a forest ecosystem, which of the following is the best example of a limiting factor for a rabbit population?

Answers

Answer:

A rise in the population of predators is followed by a decrease in the population of prey.

A __________________ is the amount of something that occurs in a given unit of time.

Answers

Answer:

A  system time is the amount of something that occurs in a given unit  of time.

Explanation:


Which slide should you change so that it reflects on all the slides of your presentation?
Any change that you make to the
will reflect throughout the slides of your presentation.

Answers

It’s monika here to help okay

Answer: Slide Master is the slide at which you made any change, the change will reflect on all slides. Explanation: In power point, slide master is the toll that is used to control change the font size, font style , themes, colors and background of the slide.

Answer:

SLIDE MASTER

Explanation:

When you apply _______ you insert a number slightly above the the line of text

A. Subscript
B. Underlining
C. Superscript
D. Text effects

Answers

Subscript 2020 on the edge

what part of the meat help you identify the less tender cuts​

Answers

If a muscle gets a lot of exercise in an animal it will be a less tender cut of meat.

Se le conoce así cuando el analista mismo desarrolla el software necesario para implementar el diseño

Answers

Answer:

Desarrollo de software.

Explanation:

El método clásico de desarrollo de software se denomina modelo en cascada, lo que significa que cada fase de desarrollo del programa debe completarse antes de que comience la siguiente, y que se lleva a cabo un extenso trabajo de especificación antes de que comience el desarrollo real del programa. La especificación es tradicionalmente de arriba hacia abajo y el desarrollo se basa en una programación estructurada, es decir, se formula primero un objetivo final para el proyecto, y luego el programa se divide gradualmente en partes funcionales más pequeñas.

Los métodos más nuevos son ágiles y basados ​​en pruebas. Se basan en el desarrollo gradual de muchas entregas parciales del programa y permiten que las distintas fases de desarrollo se lleven a cabo de forma cíclica o en paralelo. Los clientes y usuarios ganan influencia a lo largo del proceso de desarrollo. El desarrollo y las pruebas de prototipos comienzan lo antes posible, antes de que estén listos todos los detalles de la especificación de requisitos. Las decisiones sobre la especificación de requisitos de las versiones de entrega se toman lo más tarde posible, cuando los usuarios han probado y comprendido lo que realmente quieren y existe un buen conocimiento de las necesidades, posibilidades técnicas y dificultades. Cambia entre el método de arriba hacia abajo (para comenzar desde el propósito y el objetivo) y el método de abajo hacia arriba (para comenzar con lo que ya tiene y puede reutilizar, y comenzar con casos especiales simples pero gradualmente hacer que el programa sea cada vez más general).

question no.3 a. Can someone pls help me

Answers

Answer:

A=1

B=1

C=0

X= OR

Explanation:

A is XOR

B is NOT

C is AND

X is OR

Pls answer this
The figure above is a type of thread known as
A. Acme thread B. Buttress thread
C. Square thread D. Vee thread

Answers

Answer:

It looks like an Acme thread.

Explanation:

A device that records images of text, or converts printed text into machine-readable form is called a? ​

Answers

Answer:

Its called a scanner

Explanation:

Its a device that helps enable in the reading of daya and info printed on paper like a text, image, photos, and drawing by using optical tech

Why is https used in every link of a website?

Answers

Answer:

As a request-response protocol, HTTP gives users a way to interact with web resources such as HTML files by transmitting hypertext messages between clients and servers. HTTP clients generally use Transmission Control Protocol (TCP) connections to communicate with servers.

Prompt: Create a program that asks the user continuously the dollar amount of their recent Amazon purchases until they say done. Store those numbers in a list. Afterwards calculate the following:
Total Amount Spent
Maximum amount spent on a single purchase
Minimum amount spent on a single purchase
Number of purchases
Amount of money spent on taxes. (Sales tax in NY is 8.875 percent).

Things to keep in mind:
Input is stored as string so you need to convert to float.
If you or your family use Amazon, try using your own data!

Pls Dont scam me

Answers

Answer:

oh sorry I don't know that but...

Explanation:

Thanks for the points hehe

The names of the governing body or organizationds that creates rules for information technology and information communication technology

Answers

Answer:

Alliance for Telecommunications Industry Solutions

Explanation:

Alliance for Telecommunications Industry Solutions  is the main body that creates rules for information technology and information communication technology.

This agency create solutions to supports the release of new products and services into the communications marketplace. It also act as an agency that standardizes the  wireless and wireline networks activities. It is accredited by the American National Standards Institute (ANSI).

what are network services?​

Answers

Answer: A networking service is a low-level application that enables the network to perform more than basic functions.

Summary

In this lab, you complete a partially written C++ program that includes a function requiring multiple parameters (arguments). The program prompts the user for two numeric values. Both values should be passed to functions named calculateSum(), calculateDifference(), and calculateProduct(). The functions compute the sum of the two values, the difference between the two values, and the product of the two values. Each function should perform the appropriate computation and display the results. The source code file provided for this lab includes the variable declarations and the input statements. Comments are included in the file to help you write the remainder of the program.
Instructions

Write the C++ statements as indicated by the comments.
Execute the program by clicking the Run button at the bottom of the screen.

Grading

When you have completed your program, click the Submit button to record your score.



++// Computation.cpp - This program calculates sum, difference, and product of two values.
// Input: Interactive
// Output: Sum, difference, and product of two values.

#include
#include
void calculateSum(double, double);
void calculateDifference(double, double);
void calculateProduct(double, double);
using namespace std;

int main()
{
double value1;
double value2;

cout << "Enter first numeric value: ";
cin >> value1;
cout << "Enter second numeric value: ";
cin >> value2;

// Call calculateSum

// Call calculateDifference

// Call calculateProduct

Answers

Answer:

The functions are as follows:

void calculateSum(double n1, double n2){

   cout<<n1+n2<<endl; }

void calculateDifference(double n1, double n2){

   cout<<n1-n2<<endl; }

void calculateProduct(double n1, double n2){

   cout<<n1*n2<<endl; }

Call the functions in main using:

calculateSum(value1,value2);

calculateDifference(value1,value2);

calculateProduct(value1,value2);

Explanation:

This defines the calculateSum() function

void calculateSum(double n1, double n2){

This prints the sum

   cout<<n1+n2<<endl; }

This defines the calculateDifference() function

void calculateDifference(double n1, double n2){

This prints the difference

   cout<<n1-n2<<endl; }

This defines the calculateProduct() function

void calculateProduct(double n1, double n2){

This prints the product

   cout<<n1*n2<<endl; }

This calls each of the function

calculateSum(value1,value2);

calculateDifference(value1,value2);

calculateProduct(value1,value2);

See attachment for complete program

Explain two ways by which the calendar meets or fails to meet the criteria of showing the correct data

Answers

Answer:

The two ways the calendar meets the criteria of showing the correct date are;

1) The calendar can give dates in the 12 months in a year

2) The calendar can show up to the 31 different days in a month

Explanation:

The two ways in which the calendar meets the criteria of showing the correct date are;

1) The number number of long blocks with 4 different months each = Three

Therefore, the total number of months the blocks can hold = 3 × 4 months = 12 months = The number of months in a year

2) The number of faces on each dice = 6 faces

The number of dice = 2 dice

The total number of faces = 12

The number of identical faces = 2 (11th and 22nd of the month)

The number of unique faces = 10

The number of combinations of the dices = ₁₀C₂ = 45

The number of combination of faces required to show = 1 to 31 = 31 combination

Therefore, there are adequate combinations on the dice to show all the dates of month

Liam and his team developed a social networking group site for their company. They launched the site, and more than 100 users have already
joined, with the number of users growing each day. Above all else, which critical user requirement must Liam and his team meet?
ОА.
ability to access old messages posted by users
OB.
free access to the site
Ocability to upload user videos
OD.
user privacy and confidentiality issues

Answers

Answer:

D. user privacy and confidentiality issues

Explanation:

Software development life cycle (SDLC) can be defined as a strategic process or methodology that defines the key steps or stages for creating and implementing high quality software applications.

There are seven (7) main stages in the creation of a software and these are; planning, analysis, design, development (coding), testing, implementation and execution, and maintenance.

Basically, the two (2) essential privacy concerns in the field of cybersecurity are knowing how personal data are collected and essentially how they're used by the beneficiaries or end users.

Above all else, the critical user requirement Liam and his team must meet is user privacy and confidentiality issues.

Confidentiality refers to the act of sharing an information that is expected to be kept secret, especially between the parties involved. Thus, a confidential information is a secret information that mustn't be shared with the general public.

Which can be used to create a poll on a web page?
CSS
HTML
JavaScript
Text editor​

Answers

Answer:

HTML can be used to create a poll on a web page.

Answer:

HTML

Explanation:

What is part of the third step in troubleshooting a computer problem?
O locating the problem and identifying it
O trying a number of simple fixes initially
O researching ways to solve the problem
O seeking help to solve the problem

Answers

Answer:

locating the problem and identifying it.

An engineer learns a new security threat mitigation technique. The technique maps an IP address to a non-existent host, and is useful in stopping denial of service attacks. Traffic heading to these IPs can be captured for analysis or discarded. Considering the given strategies, which does this technique relate to? Select all that apply.
A. Black hole
B. Sinkhole
C. Forward proxying
D. Reverse proxying

Answers

A. In network architecture, a black hole drops traffic before it reaches its intended destination, and without alerting the source. A simple example is traffic sent to an IP address that an admin mapped to a non-existent host.
B. A sinkhole is similar to configuring a black hole, and often used interchangeably. With sinkholing however, an admin usually retains some ability to analyze and forward the captured traffic.

Below are the possible answer to each question write your answer in the space provided before each number

Answers

Answer:

Please find the complete question in the attached file:

Explanation:

1. primary memory

2. secondary memory

3. dynamic ram

4. HDD

5. SSD

6.Rom

7. video card

8. VRAM

9. random access memory  

10. processor

Give five examples of top level domain​

Answers

Answer:  .com — Commercial businesses.

.org — Organizations (generally charitable).

.net — Network organizations.

.gov — U.S. government agencies.

.mil — Military.

.edu — Educational facilities, like universities.

Explanation:

ANSWER BELOW.com — Commercial businesses.  .org — Organizations (generally charitable). .net — Network organizations. .gov — U.S. government agencies. .edu — (Educational facilities, like universities.)

Hope this helps!!! :)

Match the feature to its function.
1. Normal view
displays thumbnails
provides filename and Minimize
2. Notes view
icon
provide rows of icons to perform
3. Slide pane
different tasks
the place where information for
4. Title bar
handouts can be added
the working window of a
5. toolbars
presentation

Answers

Answer:

Match the feature to its function.  The answers are as below:

1. Normal view the place where creating and editing occurs  

2. Notes view an area in which information for handouts can be added  

3. Slide pane the place where the slide order can be changed

4. Menu bar contains lists of commands used to create presentations  

5. toolbars provide rows of icons to perform different tasks  

Explanation:

It is the normal view where the editing and the creation of the slides occur. And it's the notes view where you can add the information for handouts. You can arrange the slides in the slide pane. And you can get a list of commands for creating the presentation in the Menu bar. Also, Toolbar is the rows of icons which helps in performing a various set of tasks. And all these are definitions and prove our above selections are correct.

ANSWER IN C++ PLEASE!!!!!
Driving is expensive. Write a program with a car's miles/gallon and gas dollars/gallon (both doubles) as input, and output the gas cost for 20 miles, 75 miles, and 500 miles.

Output each floating-point value with two digits after the decimal point, which can be achieved by executing
cout << fixed << setprecision(2); once before all other cout statements. Note: End with a newline.

Answers

Answer:

#include <iostream>

#include <iomanip>  

using namespace std;

int main()

{

   double mpg, ppg;

   cout << "Enter your car's gas mileage (miles/gallon): ";

   cin >> mpg;

   cout << "Enter the gas price (dollars/gallon): ";

   cin >> ppg;

   cout << fixed << setprecision(2);

   for (int miles : { 20,75,500 }) {

       cout << miles << " miles will cost $" << miles * ppg / mpg << endl;

   }

}

Explanation:

I really like the new for(x:y) construct!

The program, with a car's miles/gallon and gas dollars/gallon (both doubles) as input, is written below.

What is programming?

Writing code to support certain activities in a computer, application, or software program and giving them instructions on how to do is known as computer programming.

#include <iostream>

#include <iomanip>  

using namespace std;

int main()

{

  double mpg, ppg;

  cout << "Enter your car's gas mileage (miles/gallon): ";

  cin >> mpg;

  cout << "Enter the gas price (dollars/gallon): ";

  cin >> ppg;

  cout << fixed << setprecision(2);

  for (int miles : { 20,75,500 }) {

      cout << miles << " miles will cost $" << miles * ppg / mpg << endl;

  }

}

Therefore, the programming codes are written above.

To learn more about programming, refer to the link:

https://brainly.com/question/11023419

#SPJ2

why should one avoid noise in the computer room​

Answers

is this a joke bc if so why?
This one not a joke hi it’s monika here

Do not make noise in the computer room.
I love to help

Which phrases suggest that Bob is a web administrator?
Bob logs in to his computer. He checks his email. He then researches online for a system upgrade of a new machine. He fills his timesheet at
his organization detailing the tasks completed during the week. Later in the day, Bob creates a weekly backup from a remote web server.

Answers

"creates a weekly backup from a remote web server"

This implies that he is the owner of the server since, one, he backs it up every week, and two, he has access to create a backup.

Which is the default data type of Ms-Access? (i) Memo (ii) Number (iii) Text (iv) Auto number​

Answers

Answer:

(iii) Text

Explanation:

A database management system (DBMS) can be defined as a collection of software applications that typically enables computer users to effectively and efficiently create, store, modify, retrieve, centralize and manage data or informations in a database. Thus, it allows computer users to efficiently retrieve and manage their data with an appropriate level of security.

Generally, a database management system (DBMS) acts as an intermediary between the physical data files stored on a computer system and any software application or program.

Hence, a software that enables the organization to centralize data, manage the data efficiently while providing authorized users a significant level of access to the stored data, is called a Data Base Management System (DBMS).

Text is the default data type of Microsoft Access (Ms-Access).

A car dealership only sells cars that have fewer than 10 000 miles and are 5 years old or less. (i) Write an algorithm that will: • ask the user to enter the number of miles and the age of a car • validate the input to check that only sensible values that are in the given range are entered • output True if valid data has been entered or False if invalid data has been entered.

Answers

Answer:

Algorithm:

ValidateCarData (milesDrives, age)

Start

Prompt the user to enter the number of miles and the age of a car.Get the input from the user.Store the number of drives in the variable named milesDrives and the age of the car in the variable named age.if ( milesDrives < 10000 and age <= 5)

               Display true.

else

              Display false.

Stop

Explanation:

Algorithm: An algorithm is a step-by-step solution to a problem in a finite number of steps.

A car dealer sells only the car that

drives less than 10000 milesand the age of the car is equal to or less than 5 years.

Prompt the user to enter the number of miles and the age of a car.

Validate the user-entered data.

when the user-entered data is valid (car drive fewer than 10000 miles and 5 years or less old)

Display true (user enters the valid data).

else (car drives more than 10000 miles or more than 5 years old)

Display false (user enters the invalid data).

Other Questions
Which of the following graphs is the solution set of -10 < 3x - 4 < 8? Writein function notation: h=x-2 Which best describes the purpose of the bulleted subheadings in the document? write any two things you learn from community help please!!.......... The following describes production activities of Mercer Manufacturing for the year.Actual direct materials used18,000 lbs. at $4.15 per lb.Actual direct labor used5,555 hours for a total of $106,656Actual units produced30,060Budgeted standards for each unit produced are 0.50 pound of direct material at $4.10 per pound and 10 minutes of direct labor at $20.20 per hour.AH = Actual HoursSH = Standard HoursAR = Actual RateSR = Standard RateAQ = Actual QuantitySQ = Standard QuantityAP = Actual PriceSP = Standard Price(1) Compute the direct materials price and quantity variances and classify each as favorable or unfavorable. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance. Round "Cost per unit" answers to 2 decimal places.)(2) Compute the direct labor rate and efficiency variances and classify each as favorable or unfavorable. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance.) 50 POINTSFind the approximate values of the five-number summary for the data set represented by this box plot. Does anyone know what types of elements of art is in this picture? How can having a mentor help individuals achieve their goals? A. Mentors can increase accountability. B. Mentors can increase motivation. C. Mentors can identify areas that need additional work. D. all of the above Please select the best answer from the choices provided. A B C DTHE ANSWER IS D EDGE 2021 You are a botanist studying a rare flower. The center of the flower is a regular polygon. The petals coming off the flower are roughly triangular in shape.a. What is the name of the center polygon?b. What is the sum of the interior angles of the center?c. What is the measure of each interior angle of the center?d. In order to compare the size of the petals to other flowers of the same species you need to determine the exterior angle of the polygon. What is the measure of the exterior angle of the polygon? Mrs. Easton plans to hire a balloon artist for her daughter's birthday. The graph shows the cost per hour to hire the artist.If there are more than 10 children at the party, the balloon artist charges an additional supply fee of $35. There will be 15 children at the Easton party. How much will the balloon artist charge Mrs. Easton for a party that is 4.5 hours long?Multiple choice question.A)$60.25B)$67.50C)$98.75D)$102.50Help ASAP The rate to rent a small moving van is $30 per day, plus $2 per mile. Jada rented a van to drive to her new home. It tooktwo days, and the total cost was $360. How many miles did she drive? Which is developed during the process of technological design? What are some fun memorization methods? Ones that arent boring like flashcards or repeating a word over and over at your desk please haha 11. What is the perimeter of the garden? Highlight the larger value.[H+] = 4.3 x 10^-4[H+] = 4.3 x 10^-6 my heart gives a flutter but i dont dare utter a wordddd~? A car traveling at a speed of 30 m/s encounters an emergency and comes to a complete stop (vf = 0 m/s). How much time will it take for the car to stop if its acceleration is -4 m/s2? Why did hunter gatherers migrate What is the quotient?