To return the value of the cell D8, the formula should be OFFSETA1=________.

Answers

Answer 1

Answer:

The formula is =OFFSET( A1, 7,3,1,1 )

Explanation:

Microsoft excel is a statistical and analytical tool for data management and analysis. Its working environment is called a worksheet. The worksheets are made up of rows and columns also known as records and fields respectively.

Functions like OFFSET in excel is used to return a cell or group of cells. It gets the position to turn by start getting a starting port, then the number of records below it and the fields after, then the length and width of cells to return.

syntax:   =OFFSET( "starting cell", "number of rows below", "number of columns after", "height of cells to return", "width of cells to return" )


Related Questions

What is a topographical map? Select all that apply:

-shows roads
-shows the types of soil
-shows altitude
-shows the contours and physical features of an area
-shows population density

Answers

Answer:

1.Shows roads

2.shows the contours and physical features of an area

Explanation:

Answer:

A.shows roads

D.shows the contours and physical features of an area

Explanation:

Write a program that prompts the user to enter positive integers (as many as the user enters) from standard input and prints out the maximum and minimum values.Here is an example of how your program should behave.Enter a positive integer: 2 Enter a positive integer: 9 Enter a positive integer: 3 Enter a positive integer:-1 The maximum integer is 9 and minimum is 2. Note: • Zero: 'O' is not a positive integer. • You must include code to deal with any exceptions that may arise in your program. • Insert 'import' statement(s) at the beginning • Copy the entire class, including the public static main method, 1 import java.util.*; 2 public class Ex0603 { 3 public static void main(String[] args) { 4 Scanner in = new Scanner(System.in); 5Write a program that prompts the user to enter an integer N, then reads N double values, and prints their mean (average value) and sample standard deviation (square root of the sum of the squares of their differences from the average, divided by N-1). Enter an integer: 5 Enter a number: 1 Enter a number: 2 Enter a number: 3 Enter a number: 4 Enter a number: 5 Average value is: 3.00 and the standard deviation is: 1.58 Note: • You must include code to deal with any exceptions that may arise in your program • Write the entire program in the answer box below. For example: Input Result 5 Enter an integer: Enter a number: Enter a number: Enter a number: Enter a number: Enter a number: Average value is: 3.00 and the standard d eviation is: 1.58 123452 Enter an integer: Enter a number: Enter a number: Invalid input!1b

Answers

Answer:

Here is the JAVA program that prompts the user to enter positive integers from standard input and prints out the maximum and minimum values:

import java.util.*;

public class Ex0603 {

   public static void main(String[] args) { //start of main function

   Scanner in = new Scanner(System.in); //creates Scanner class object to take input from user

   int minimum = 0; //stores the minimum of the integers

   int maximum = 0; //stores the minimum of the integers

   int num; //stores the positive integer values

   System.out.println("enter a positive integer: ");//prompts user to enter a positive integer

   num = in.nextInt();//scans and reads the input integer value from user

   minimum = num;  //assigns value of num to minimum

   while(true) {//while loop keeps prompting user to enter a positive integer

       System.out.println("enter a positive integer: ");//prompts user to enter a positive integer

       num = in.nextInt();//scans and reads the input integer value from user

       if(num <=0)//if the user inputs a negative integer or 0

           break; //breaks the loop

       if (num > maximum) {//if the value of positive integer is greater than the maximum of value

           maximum = num; } //assigns that maximum value of num to maximum variable

       if (num < minimum) {//if the value of positive integer is less than the minimum of value

           minimum = num; //assigns that minimum value of num to minimum       }    }            

   System.out.println("The maximum integer is : " + maximum); //displays the maximum of the positive integers

   System.out.println("The minimum integer is : " + minimum); }}   //displays the minimum of the positive integers

Explanation:

Here is the JAVA program that that prompts the user to enter an integer N, then reads N double values, and prints their mean (average value) and sample standard deviation:

import java.util.*;  

public class Ex0603 {  

public static void main(String[] args) { //start of main function

Scanner in = new Scanner(System.in);  //creates Scanner class object to take input from user

double integer= 0;  //to store the number of input values

double sum = 0;  //to store the sum of input numbers

double mean = 0;  //to store the average of numbers

double sd = 0;  //to store the standard deviation result

double variance = 0;  //to store the variance result

double sumSquare = 0;  //to store the sum of (num-mean)^2

int n = 0;  //to store the sample size N

   System.out.println("Enter an integer: ");  //prompts user to enter an integer that is how many elements user wants to input

   integer = in.nextInt();  //reads the value of integer from user

   double size=integer; // declares a double type variable and assigns value of int type variable integer to this double type variable size

   int i=0;  //used to point each element of the num array

   double num[] = new double[(int)size];  //declares an array to hold the numbers input by user

   while(integer>0){  //loop executes until value of integer is greater than 0

   System.out.println("Enter a number: "); // prompts to enter a number

   num[i] = in.nextDouble(); //reads double values

   sum += num[i];  //adds the values stored in num array

   i++;  //increments i to point to the next element in num array

   n++;  //increments n to count the total number of elements

  integer--; //decrements integer value at each iteration

   mean = sum / n;    }  //compute the average of values

   i=0;  

    while(size>0){  //loop executes until value of size exceeds 0

       sumSquare += Math.pow(num[i]-mean,2); //takes the sum of square difference between each element of num array and value of mean

       i++; //increments i

      size--;   }  //decrements size

variance = sumSquare / (n-1);  //compute variance by dividing the result of sum of the squares of their differences from the mean by n-1

   sd = Math.sqrt(variance);  //computes standard deviation by using sqrt function which takes the sqrt of the result of variance computed above

System.out.println("Average value is: " + mean+ " and the standard deviation is " + String. format("%.2f", sd));   }} //displays the average of numbers stored in mean variable and value of standard deviation is displayed up to 2 decimal places

Screenshots of both programs and their outputs is attached.

What are the drawbacks of electronic and web-based output?

Answers

Need to know the how to read circuits

Help me with A,b and c

Answers

Answer:

The Following are the answer to the given statement:

Explanation:

Given value:

[tex]a) \ Y= \bar{A}BC+\bar{B\bar{C}} +BC \\\\b) \ Y= \bar{(A+B+C)}D+AD+B \\\\c) \ Y= ABCD+\bar{A} B \bar{C} D + \bar (\bar{B} + D) \ \ E[/tex]

In latex code, in typing there is some error so, please find the question.

Solve point a:

[tex]a) \ Y= \bar{A}BC+\bar{B\bar{C}} +BC \\\\[/tex]

        [tex]= (\bar{A} + 1 ) BC+\bar{B\bar{C}} \\\\= (\bar{B} + C ) +BC\\\\= \bar{B} + C +BC\\\\= \bar{B} + C(B+1) \\\\= \bar{B} + C \\\\[/tex]

Solve point b:

[tex]b) \ Y= \bar{(A+B+C)}D+AD+B \\\\[/tex]

[tex]Y= \bar{A}+\bar{B}+\bar{C}D+AD+B \\\\[/tex]

   [tex]= \bar{C}D+AD+B \\\\[/tex]

Solve point c:

[tex]c) \ Y= ABCD+\bar{A} B \bar{C} D + \bar (\bar{B} + D) \ \ E[/tex]

        [tex]=ABCD+\bar{A}B\bar{C}D+ B\bar{D}E\\\\=(AC+\bar{A}\bar{C} )BD+ B\bar{D}E\\\\=(A \circ C)BD+ B\bar{D}E\\\\[/tex]

 please find the circuits attachment for the above point.

The fractional_part function divides the numerator by the denominator, and returns just the fractional part (a number between 0 and 1). Complete the body of the function so that it returns the right number. Note: Since division by 0 produces an error, if the denominator is 0, the function should return 0 instead of attempting the division. 1 point  1 2  3 4 5 6 7 8 9 10 11 def fractional_part(numerator, denominator): # Operate with numerator and denominator to # keep just the fractional part of the quotient return 0 print(fractional_part(5, 5)) # Should be 0 print(fractional_part(5, 4)) # Should be 0.25 print(fractional_part(5, 3)) # Should be 0.66... print(fractional_part(5, 2)) # Should be 0.5 print(fractional_part(5, 0)) # Should be 0 print(fractional_part(0, 5)) # Should be 0

Answers

Answer:

part a

Explanation:

Create class SavingsAccount. Use a static variable annualInterestRate to store the annual interest rate for all account holders. Each object of the class contains a private instance variable savingsBalance indicating the amount the saver currently has on deposit. Provide method calculateMonthlyInterest to calculate the monthly interest by multiplying the savingsBalance by annualInterestRate divided by 12- this interest should be added to savingsBalance. Provide a static method setInterestRate that sets t

Answers

Answer:

Class SavingsAccount( ):

annual_interest_rate

def.__init__(self, savings_balance):

self.savingsBalance = savings_balance

def calculatMonthlyInterest( ):

self.savingsBalance += (self.savingsBalance * annual_interest_rate) /12

return self.savingsBalance

def setInterestRate_(self, value):

self.annual_interest_rate = value

Explanation:

The python class above is used to create a savings account data for a customer, with methods to change the static interest rate and to calculate the monthly interest rate.

Create the code that will find
the longest word of the given
string. You are not allowed to
use split() method

(python)

Answers

Answer:

function findLongestWord(str) {

 var longestWord = str.split(' ').sort(function(a, b) { return b.length - a.length; });

 return longestWord[0].length;

}

findLongestWord(InputHere);

Explanation:

Replace InputHere with the input

A dual-core system requires each core has its own cache memory.
a. true
b. false

Answers

Answer:

true

Explanation:

How is Moore’s Law relevant to programmers?

Answers

Answer:

Moore's law is currently dead

Explanation:

But it was relevant to give a metric of the computational power that will exist, allowing programmers to make software that lasts longer, Moore's law said that a chip's transistors would be doubled every 18 months for the same price

Compilers can have a profound impact on the performance of an application. Assume that for a program, compiler A results in a dynamic instruction count of 1.0E9 and has an execution time of 1.1 s, while compiler B results in a dynamic instruction count of 1.2E9 and an execution time of 1.5 s. a. Find the average CPI for each program given that the processor has a clock cycle time of 1 ns. b. Assume the compiled programs run on two different processors. If the execution times on the two processors are the same, how much faster

Answers

Answer:

1.1

1.25

Clock rate A = 0.733 clock rate B

Explanation:

Given the following :

Clock cycle time = 1ns = 10^-9 s

COMPILER A:

Instruction count = 1.0E9

Execution time = 1.1 s

COMPILER B:

Instruction count = 1.2E9

Execution time = 1.5 s

Using the relation :

CPI = [Execution time / (instruction count × cycle time)]

CPI for compiler A :

[1.1 / (10^9 × 10^-9)] = 1.1 / 10^0 = 1.1 / 1 = 1.1

CPI for compiler B:

[1.5 / (1.2 ×10^9 * 10^-9)]

(1.5 / 1.2 * 1) = 1.5 / 1.2 = 1.25

b. Assume the compiled programs run on two different processors. If the execution times on the two processors are the same, how much faster

Since, execution time is the same on both processors

Execution time = [(Instruction count × CPI) / clock rate] ;

[(Instruction count × CPI) / clock rate] A = [(Instruction count × CPI) / clock rate] B

Make clock rate of A the subject of the formula :

(Instruction count A * CPI A * clock rate B) / (instruction count B * CPI B)

= (10^9 * 1.1 * clock rate B / 1.2 × 10^9 * 1.25)

1.1 × 10^9 clock rate B / 1.5 × 10^9

Clock rate A = 0.733 clock rate B

Which of the following statements best represents the impact vaudeville had on the film industry? Early silent films were more realistic than vaudeville shows and less expensive for audiences to see, therefore, silent films became more popular than vaudeville shows. Early silent films used many of the same storylines as vaudeville performances and incorporated vaudeville music. Early silent film producers used many of the same acting techniques popularized in vaudeville performances, even using popular vaudeville stars as actors in their productions. Early silent films were poorly produced and audiences did not enjoy the lack of sound, therefore, it would be some time before films overtook the popularity of vaudeville.

Answers

Answer:

Answer is B: Early silent film producers used many of the same acting techniques popularized in vaudeville performances, even using popular vaudeville stars as actors in their productions.

Explanation:

Answer:

Early film used elements of vaudeville to draw in audiences.

Explanation:

edg2021

Vaudeville were silent films and came first so they did not use early film stars in their theatre.

_________ graphic applications are used today on a variety of devices, including touch-screen kiosks and mobile phones.

Answers

Answer:

Explanation:

Adobe Illustrator is the graphic application, that can be used to smartphones to design graphical projects.

Write a program that gets five integer test scores from the user, calculates their average, and prints it on the screen. Test your program with the following data: Run 1: 40, 80, 97, 32, 87 Run 2: 60, 90, 100, 99, 95 Run your program and copy and paste the output to a file. Create a folder named, fullname_program2. Copy your source code and the output file to the folder. Zip the folder and upload it to Blackboard.

Answers

Answer:

total = 0

for i in range(5):

   score = int(input("Enter a score: "))

   total += score

average = total / 5

print("The average is " + str(average))

Explanation:

*The code is in Python.

Initialize the total as 0

Create a for loop that iterates five times. Inside the loop, ask the user to enter a score. Add the score to the total (cumulative sum)

After the loop, calculate the average, divide the total by 5

Print the average

What is a half note + a 8th note in band? plz helppp

Answers

One quarter note plus one eighth note equals one and a half beats. So a dotted quarter note lasts for one and a half beats.

Answer:

A half note is a note that lasts two quarter notes. For most songs, it does last half a measure, but this is not always the case. An 8th note is a note that lasts half of a quarter note, and is usually (but again not always) an 8th of a measure. A quarter note is the most common type of note in a measure.

If you want to find out what exactly that stuff means, well, you're out of luck here, but it's probably better to just look that up anyways.

Create a conditional expression that evaluates to string "negative" if userVal is less than 0, and "non-negative" otherwise. Ex: If userVal is -9, out

Answers

Answer:

import java.util.Scanner;

public class Main

{

public static void main(String[] args) {

 Scanner input = new Scanner(System.in);

 

 System.out.print("Enter a number: ");

 int userVal = input.nextInt();

 

 String aString;

 if(userVal < 0)

     aString = "negative";

 else

     aString = "non-negative";

     

 System.out.println(aString);

}

}

Explanation:

Ask the user to enter a number and set it to userVal

Check the value of userVal. If it is smaller than 0, set the string as "negative". If it is not, set it as "non-negative"

Print the string

Blackbaud is a company that supplies services and software designed for nonprofit organizations. Which type of e-commerce website will Blackbaud have?

Answers

Explanation:

Blackbaud's software products are specially designed to support the unique needs of nonprofit and social good organizations.

Explore our software solutions that can help you advance your organization's mission.

Which of the following statements about Scheme is correct?
A. Scheme is not fully curried and it supports delayed evaluations.B. Scheme is a fully curried language that does not do delayed evaluation.C. Scheme is a fully curried and lazy language.D. Scheme does not support higher-order functions.

Answers

Answer:

B. Scheme is a fully curried language that does not do delayed evaluation.

Explanation:

Scheme is a functional programming language that accepts first or higher-order functions and is a family of the LISP programming language. The syntax in scheme supports both curring and uncurring.

It also supports delayed evaluation and lazy evaluation of its coding statements

a range of cells from the fifth row in column A to the twelfth row in column G is written as​

Answers

Answer:

A5:G12

Hope it helps yuh

2

What combination of keys turns the value in a cell into a percentage?

Answers

Answer:

Ctrl + Shift +%

Explanation:

A Microsoft Excel, which is a Microsoft Office software application that allows the computation of data in tables for analysis amongst other functions.

Hence, in Microsoft Excel, in order to turn the entered figure data to percentage without using a mouse to access the menu button on the application window page, a combination of keys can be used to turn the value in a cell into a percentage. This combination is simply "Ctrl + Shift +%." This will be pressed simultaneously.

Which of the following is NOT a result of use of the assembly line?A. More security B.higher productivity C. Greater efficiency D. Lower prices

Answers

Answer: D

Explanation:

An assembly line is where many people work together to make products. Like for a wooden toy train, one group carves the wood, another group glues the wood together, etc.

Answer: More Security.

Explanation: You're Welcome.

Why was PC-A unable to access R1 via ssh?

Answers

Answer:

It could be that an ssh virtual terminal has not been configured for the port connected to PC-A

Explanation:

The computer network is an interconnection and intercommunication of computer devices to share resources. Intermediate devices like the Router and Switches are used to create physical and virtual connections between networks and nodes.

virtual connections like the default Telnet and the and more secure SSH are used to remotely communicate with intermediate devices for management purposes. For example, to use the ssh, the line vty and the specified virtual port range must be configured with a username, a password, an encryption key and other ssh features before a connection can be made.

What are some skills many CTSOs help their members develop? Check all that apply.

Answers

I've had this question before.

The answers are 2 & 4.

Leadership & career specific skills.

Answer:

2. Leadership

4. Career-specific skills

Explanation:

Just took the assignment

Hope this helps! :)

What is the length of the following array: byte[] data = { 12, 34, 9, 0, -62, 88 };a. 1b. 5c. 6d. 12

Answers

Answer:

C: 6

Explanation:

The values are separated by ` ,`  with this it is enough to count all the numbers that are separated by ` , ` making it have 6 elements

Following are the program to calculate the length of the array:

Program Explanation:

Defining a header file.Defining the main method.Defining an integer type array "data" that holds a given value.In the next step, a print method is declared that uses the sizeof method that calculates the length of the array.

OR

In the given array all the element is separated by the "," symbol, and when the user counts the array value that is equal to 6.

Program:

#include <iostream>//header file

using namespace std;

int main()//main method

{

   int data[] = { 12, 34, 9, 0, -62, 88 };//defining an integer array that hold given value

   cout<<sizeof(data)/sizeof(data[0])<<endl;//using print method calculate and print the size of array

   return 0;

}

Output:

Please find the attached file.

Therefore, the final answer is "Option c".

Learn more:

brainly.com/question/4506055

What are the examples of shareware?

Answers

An example of shareware a compression program like Stuffit for Macs or Windows. An example of shareware is a budgeting software program that only allows you to use three categories instead of having the ability to create a full budget

Which of the following is an example of a specialty search engine? a. NexTag b. Wolfram Alpha c. Bing d. Google

Answers

Answer:

b. Wolfram Alpha

Explanation:

A specialty search engine can be defined as a type of database query engine which searches for informations and indexes them based on a particular content, subject or focus such as location, topic, government, industry etc. A specialty search engine is different from the general-purpose search engines such as Bing, Google or Yahoo because it gives results that are tailored or more relevant to a particular user.

Wolfram Alpha is an example of a specialty search engine. A Wolfram Alpha is an answer search engine which gives answers to specific questions such as computational, arithmetic, geometric mathematics or calculus.

Also, note that a specialty search engine is commonly referred to as a topical or vertical search engine.

Wolfram Alpha is an example of a specialty search engine. Thus, option B is correct.

A specialty search engine can be defined as a type of database query engine which searches for informations and indexes them based on a particular content, subject or focus such as location, topic, government, industry etc. A specialty search engine is different from the general-purpose search engines such as Bing, Yahoo because it gives results that are tailored or more relevant to a particular user.

Wolfram Alpha is an example of a specialty search engine. A Wolfram Alpha is an answer search engine which gives answers to specific questions such as computational, arithmetic, geometric mathematics or calculus.

Also, note that a specialty search engine is commonly referred to as a topical or vertical search engine.

To know more about search engine visit:

https://brainly.com/question/32419720

#SPJ6

______ is used to ensure that data is organized most efficiently in a database. A) Consistency checking. B) Validation C) Normalization D) Range checking

Answers

Answer:

C) Normalization

Explanation:

Normalization is an approach that is to be done in a systematic manner in order to remove the data duplicity and there are non-desirable attributes such as insert, update, delete, etc. In this the process should be followed in multi step that contains the data in a tabular form so that it could eliminate the repetition of data to maintain the efficiency of the data

Therefore according to the given situation, the option C is correct

The process of ensuring that data values are ordered such that the values in the columns confirms to a certain range and expunged duplicate values is called Normalization.

Data Normalization ensures that the data values are efficiently arranged and ordered, while also getting them ready for analytical purpose.

A normalized data will usually be rid of duplicates and the weight of the values in the columns would be even.

Hence, the process is known as Normalization.

Learn more : https://brainly.com/question/21986997

13 POINTS! Which option is used to ensure the integrity and authenticity of a Word document but requires additional services to be available on the internal network? A. digital encryption B. digital signature C. password protection D. protected view.

Answers

A. digital encryption

Answer:

the answer is a for all u edg users

Explanation:

Arman takes a picture with his smartphone which he subsequently posts online. Beatrice finds the picture online and posts a copy of it on her website with an attached Creative Commons license. Which of the following best describes who owns the photo? A. Beatrice owns the photo because only holders of a Creative Commons license can own works online. B. Arman owns the photo because he was the original creator and did not license the work. C. Arman owns the photo because it was granted a Creative Commons license by another person online. D. Both own the photo because creating a copy makes it her intellectual property.

Answers

Answer:C

Explanation:

Explain the difference between an attribute and a value set.

Answers

An attribute is a characteristic. ... For example, Attributes in the invoice can be price, number, date etc. A value set specifies the set of values that may be assigned to that attribute for each individual entry.

The difference between an attribute and a value set is:

An attribute holds values, while a value set are those things which are contained in a class

In programming, there are some terms that are useful for a person that wants to write a code that works.

Some of these terms include:

AttributeValueClassFunctionMethod, etc

As a result of this, an attribute is the name that  is given to the property of a class.  On the other hand, a value set are those things that are used to represent an object in a given class.

For example, an attribute can have the name "Apples" and can hold the value of "abc" while the value set are those things that can be attributed to a class.

Read more here:

https://brainly.com/question/14477157

Why is timbre an important musical element?

Answers

it’s used to define the color or sound of a tone .

The timbre is important musical element because different timbres can create different emotions in the listener.

Other Questions
write down 54300 in standard form PhysicalFeaturesHumanFeatures?LocationEarth Dota inc stock has a 25% chance of producing a 30% return, a 50% chance of producing a 12% return and a 25% chance producing a 18%. What is the firm expected rate return? An auto dealership is advertising that the cost of leasing a new car is $450 per month with a $1,500 down payment. The equation used to find c, the total cost of the lease, is c=450m+1,500,c=450m+1,500, where m is the number of months the car is leased. What is the cost, in dollars, of leasing a car for 32 months? Find an equation of the line that has a slope of 5 and a Y intercept of 3. Write your answer in the form of Y=mx+b. Were the colonists' reaction to the Stamp Act justified (reasonable) or were they overreacting? Plz help me need to write a paragrapg about this qustion HELP ME PLS I NEED THIS RIGHT NOW !! Ten more than the quotient of a number and 3 is 12 Jacob wanted to know what the most popular sneakers brand was for his classmates. His class had 30students. To save time he asked the first 10 boys he met. Is this a random sampling for the brand of sneakers? Why or why not? Add. Be sure to simplify and have your answer in CORRECT scientific notation. (1.63 x 107) + (2.4 x 107) Question 1 options: 1.87 x 107 4.03 x 107 40.3 x 107 4.03 x1014 I need this ASAP! Thank you! About 80% of Colombia's population is under what age?a. 45b. 65c. 25d. 30 0.400 mole of sucrose, C 12H 22O 11, contains ________ C atoms. Find class boundaries, midpoint, and width for the class. 57-61 Which of the following employees is most likely to be a hub? Multiple Choice Before his next project starts, Joseph wants his boss to explain the rewards for a good job. Lila values efficiency and precision in coworkers. Magdala tries hard to give everyone credit for their contributions. Khadija urges her team to be flexible and to consider all available options. Robert's coworkers see him as rigid and nit-picky. -6x+4y=-18 -x-y=2 solve by subsitution what would happen to a British official accused of a crime? Vladimir buys 1.20 pounds of Skittles, 7/2 pounds of M&Ms, and 5.2 pounds of pretzels. If the candy cost $1.20 a pound and the pretzels cost $1.10 a pound, how much did Vladimir spend? Without using a calculator, choose the statement that best describes the value of the square root of 86The value of squre root 86 is between 9 and 9.5The value of squre root 86 is between 9.5 and 10The value of squre root 86 is between 10 and 10.5The value of squre root 86 is between 10.5 and 11 What is 1 6/8 of 16