Write the command and explain about each formula in MS Excel


1. SUM

2. AVERAGE

3. MAx

4. MIN

5. COUNT

Answer:

1. SUM  --- The SUM function is used to sum all the values that are in a given range. Thus, for example, if you want to add the values between cells A1 and A3, you must write the following command: =SUM(A1:A10)

2. AVERAGE  --- The AVERAGE function allows you to average a range of values, throwing the average of these values in the cell where the function is typed. For example, if you want to average the values included between B1 and B3, you should write the following function: =AVERAGE (B1: B3).

3. MAX --- The MAX function, for its part, returns the maximum value of the values included in the function. For example, if the maximum value included between the values C1 and C3 is known, the following function must be written: =MAX (C1: C3).

4. MIN  --- The MIN function, in turn, allows to identify the minimum value of the range of values included in the function. For example, if the minimum value included between the values D1 and D3 is known, the following function must be written: =MIN (D1: D3).

5. COUNT --- The COUNT function, finally, is used to count all the cells that have numbers, which have been included in the range of the function. For example, if you want to count all cells that contain numbers between the values E1 and E3, you must write the following function: =COUNT (E1: E3).

A technician who is managing a secure B2B connection noticed the connection broke last night. All networking equipment and media are functioning as expected, which leads the technician to question certain PKI components. Which of the following should the technician use to validate this assumption? (Choose two)
a. PEM
b. CER
c. SCEP
d. CRL
e. OCSP
f. PFX

41. Which is NOT a valid statement to initialize a variable?
a. int =100;
b. long population=15000;
C. char n[]="Hello word";
d. const int N=100;

Consider the following class designed to store weather statistics at a particular date and time:
public class WeatherSnapshot
{
private int tempInFahrenheit;
private int humidity; // value of 56 means 56% humidity
private int dewPoint; // in degrees Fahrenheit
private String date; // stores the date as a String
private int time; // in military time, such as 1430 = 2:30 pm
private boolean cloudy; // true if 25% or more of the sky is covered
// constructor not shown, but it initializes all instance variables
// postcondition: returns temperature
public int getTemp()
{
return tempInFahrenheit;
}
// postcondition: returns date
public String getDate()
{
return date;
}
// postcondition: returns true if precipitation is likely; false otherwise
public boolean precipitationLikely()
{
// implementation not shown
}
// other methods not shown
}
Suppose a WeatherSnapshot object named currentWeather has been correctly instantiated in a client class. Which of the following will correctly call the precipitationLikely method?
A. boolean couldRain = precipitationLikely();
B. boolean couldRain = currentWeather.precipitationLikely();
C. boolean couldRain = currentWeather.precipitationLikely(true);
D. double percentChanceOfRain = precipitationLikely();
E. double percentChanceOfRain = currentWeather.precipitationLikely();

A Consider the following method definition. The method printAllCharacters is intended to print out every character in str, starting with the character at index 0. public static void printAllCharacters (String str) for (int x = 0; x< str.length(); x++) // Line 3 System.out.print(str.substring(x, x + 1)); The following statement is found in the same class as the printAllCharacters method. printAllCharacters ("ABCDEFG"); Which choice best describes the difference, if any, in the behavior of this statement that will result from changing x < str.length() to x <= str.length() in line 3 of the method?
Α) The method call will print fewer characters than it did before the change because the loop will iterate fewer times.
B) The method call will print more characters than it did before the change because the loop will iterate more times.
C) The method call, which worked correctly before the change, will now cause a run-time error because it attempts to access a character at index 7 in a string whose last element is at index 6.
D) The method call, which worked correctly before the change, will now cause a run-time error because it attempts to access a character at index 8 in a string whose last element is at index 7.
E) The behavior of the code segment will remain unchanged.

Write a program that takes a first name and a major as the input and outputs a message with that name and major as shown below Ex. If the input is Nithya and Art the output is Nithya 18 majoring in Art. Use the names and majors of students in your breakout room to test your code. Note that to separate the name from the major as part of the input, you need to place these inputs on separate lines. For the example above, we would provide the input as follows: Nithya Art Hint If you directly add the names and majors inside the print statement, then the code would not work correctly since it is relying on the contents of the provided variables. You need to use these variables inside your print statement, so that regardless of the provided input, the output will always use those values and be as expected Hint. If your code does not pass the tests, make sure you do not have an extra space in your output. Remember. Python automatically adda a blank space between expressions separated by a comma LAD ACTIVITY 1161 LAB: Breakout Room Activity 0/15 main.py Load default template 1 username input() 2 najor - input() 5 6 7. the comments below, listing the names and majors of the students who were in the breakout room with you 9.1. May Finance 10. 2. Ronnte Econ 11.). Preston Accounting

what time is spellrd the same forwards and backwards​

Lesson 3 - Calling All Operators
Exit
37 of 42
Test
Reset
order
75
do
create variable amount ToCoupon
75 +
order
print
"To receive a coupon, you will need to spend $ >
amount ToCoupon
print
Code
Check the customer's order amount. If it is less than $75, determine how much more
needs to be spent to reach $75 and give the customer that information.
< PREV

Assume that you are asked to develop a C++ program that help an elementary school teacher to

calculate his students total and average score of the following five courses ( Amharic, English,

Mathematics, Science and Sport). The program should ask the teacher to enter all subject scores

from the key board and the output of the program looks like:

***********************************

Amharic…………………………………67

************************************

English………………………………….76

************************************

Mathematics ……………………………78

************************************

Science ………………………………….87





please answer it

************************************
Sport…………………………………….89

************************************

Total ………………………………….397

************************************

Average …………………………….79.4

************************************
​

Write a class called Person that has two data members - the person's name and age. It should have an init method that takes two values and uses them to initialize the data members.Write a separate function (not part of the Person class) called std_dev that takes as a parameter a list of Person objects (only one parameter: person_list) and returns the standard deviation of all their ages (the population standard deviation that uses a denominator of N, not the sample standard deviation, which uses a different denominator).

why are players givin more carbohydrates a day before a game?​

An object's state is defined by the object's
methods and instance variables
instance variables and their values
access modifiers of the instance variables
O
methods and their return values

Ways information technology does not make us productive

Write a program that calculates the shipping charges for parcel. The program should ask the user to enter two floating point values:
The weight of a parcel in pounds
The shipping rate per pound
The program calculates and displays the total shipping charges based on the parcel’s weight and shipping rate per pound.
Your program should print dollars and cents with two decimal places such as 32.85, and not 32.8467777.
Hint: Until we learn how to format output, we will use this little trick. You can round a floating-point value to the nearest hundredth by adding 0.005, multiplying by 100, converting the result to an integer, and then dividing by 100. This trick is not perfect but works well with most values.
Here is a sample of what a typical run of this program looks like where the user entered the values 4.75 for the weight and 2.55 for the shipping rate per pound:
Shipping Charges Calculator
Enter the weight of your parcel in pounds: 4.75
Enter the shipping price per pound: 2.55
The weight of your parcel is 4.75 pounds
The shipping price per pound is $ 2.55
The shipping charges for your parcel is $ 12.11
NOTE: Please remember that your program will be graded in terms of:
correctness: it performs the calculations correctly and uses proper arithmetic expressions: 75% (graded by Zybooks)
code style: good variable names, comments, proper indentation and spacing: 25% (grade by the TAs)
This program code is Python

1.16 LAB: Input and formatted output: House real estate summary Sites like Zillow get input about house prices from a database and provide nice summaries for readers. Write a program with two inputs, current price and last month's price (both integers). Then, output a summary listing the price, the change since last month, and the estimated monthly mortgage computed as (currentPrice * 0.051) / 12 (Note: Output directly. Do not store in a variable.).
Ex: If the input is:
200000 210000
the output is:
This house is $200000. The change is $-10000 since last month.
The estimated monthly mortgage is $850.0.
Note: Getting the precise spacing, punctuation, and newlines exactly right is a key point of this assignment. Such precision is an important part of programming.
import java.util.Scanner;
public class LabProgram {
public static void main(String[] args) {
Scanner scnr = new Scanner(System.in);
int currentPrice;
int lastMonthsPrice;
currentPrice = scnr.nextInt();
lastMonthsPrice = scnr.nextInt();
/* Type your code here. */
}

The power relationship on a transformer states that O Power in = power out + loss O Power in = 1/2 power out (Power in = 2 x power out O All of the above None of the above​

Your task is to implement a function replace_once(t, d), that takes a text t and a replacement dictionary d, and returns the result of replacing words according to the dictionary: if a word appears as a key, replace it with the dictionary value, and if a word does not appear in the dictionary, leave it alone.

Given a list of words, you can concatenate them together with spaces in between as follows:
word_list = "I love eating bananas".split()
print("Word list:", word_list)
back_together = " ".join(word_list)
print("Back together:", back_together)
# You can also join them in other ways, btw. Just DON'T do it for this homework.
print("You can also put commas:", ", ".join(word_list))

/* missing precondition */

public String getChar(String str, int n) {

return str.substring(n, n 1); }

Write down the most appropriate precondition for the method so that it does not throw an exception.

VEE Physics 2006 E.C
466
4.
A transverse sinusoidal wave is travelling on a string. Which
statement is correct a point on the string?
A. The point moves in the same direction as the wave.
B. The point moves in simple harmonic motion with a different
frequency than that of the wave.
C. The point moves in simple harmonic motion with the same
angular frequency as the wave.
D. The point moves I uniform circular motion with a different
angular speed than the wave.​

Any1??
Write the names of atleast 22 high-level programming languages

The game world plays a crucial role in bringing the game story to life and often acts as a bridge between what two elements?

A) the game title and resolution
B) characters and their powers
C) internal conflict and external conflict
D) game mechanics and game story

A specification can be a written document, a set of graphical, a formal mathematical model, a collection of usage scenarios (or, use cases), a prototype, or any combination of these.
A. True
B. False

can you answer this question?

ve phenotypk percentages of the offspring​

Write a public static method named insert. The insert method should have the signature insert(String[] words, String newWord, int place), should return a boolean, and should function as described below.
When called, if place does not represent a valid index for words, then the method will return false to indicate the insertion could not be performed and do nothing else. Otherwise the method will insert the String newWord into the array words at the index place, moving each subsequent entry one place further and losing the final String in the array. The method will then return true to indicate the insertion has taken place.
Use the runner class to test this method: do not add a main method to your code in the U6_L4_Activity_One.java file or it will not be scored correctly.
Here is the runner code:
import java.util.Scanner;
public class runner_U6_L4_Activity_One{
public static void main(String[] args){
Scanner scan = new Scanner(System.in);
System.out.println("Enter array length:");
int len = scan.nextInt();
scan.nextLine();
String[] wordList = new String[len];
System.out.println("Enter values:");
for(int i = 0; i < len; i++){
wordList[i] = scan.nextLine();
}
System.out.println("Enter new String:");
String insWord = scan.nextLine();
System.out.println("Enter place:");
int pos = scan.nextInt();
System.out.println("Method return: " + U6_L4_Activity_One.insert(wordList, insWord, pos));
System.out.print("Array contents: {");
for(int i = 0; i < len-1; i++){
System.out.print(wordList[i] + ", ");
}
System.out.println(wordList[len-1]+"}");
}
}

Describe an example of a very poorly implemented database that you've encountered (or read about) that illustrates the potential for really messing things up. Include, in your description, an analysis of what might have caused the problems and potential solutions to them. Be sure to provide citations from the literature.

sadfsdfsdfasdfsafdsafaf

A user reports slow performance on a computer. A technician checks the computer and finds the RAM utilization Is very high. The technician restarts the computer, and the RAM use is still high. The technician discovers a program running in the background Is using most of the RAM. The user only uses this program once at the end of the year to produce a report. What steps should the technician take to improve the computer's performance?

1. If you have the following device like a laptop, PC and mobile phone. Choose one device
and write down the specification according to?

*Operating System
*Storage capacity
*Memory Capacity
*Wi-Fi connectivity
*Installed application
​

An algorithm requires numbers.
O True
O
False

Which function in Excel tells how many numeric entries are ther​