Question

What is the function and argument to count the number of cells in the range B1:B50...

  1. What is the function and argument to count the number of cells in the range B1:B50 that equal “B”?
  2. What is the function and arguments to retrieve the value located in the fifth row and second column of the data in the range A10:G50?
Math   Advanced-Math   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Q1) What is the function and argument to count the number of cells in the range B1:B50 that equal “B”?

Ans)

In text form:

=countif(B1:B50,"B")

Q2) What is the function and arguments to retrieve the value located in the fifth row and second column of the data in the range A10:G50?

In text form:

=INDEX(A10:G50,5,2)

Hope this was helpful. Please do leave a positive rating if you liked this answer. Thanks and have a good day!

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
COUNTIF excel function Count number of cells based on filtered data. for example counting number of...
COUNTIF excel function Count number of cells based on filtered data. for example counting number of orange sold on the 1/1/2010 Look at filtered data below Data Item Sold OrangesSold 1/1/2010 Oranges 1/1/2010 Oranges 1/1/2010 Apples Question a)What excel function would you use to count the number of oranges sold.Show work
THIS PROGRAM HAS TO BE WRITTEN IN C single function to count the number of leading...
THIS PROGRAM HAS TO BE WRITTEN IN C single function to count the number of leading zeroes in the 32-bit input argument passed to the function (leading zeroes are the zeroes that occur in the most significant bit positions of the number until a bit value of ‘1’ is found).
Define and test a function myRange. This function should behave like Python’s standard range function, with...
Define and test a function myRange. This function should behave like Python’s standard range function, with the required and optional arguments, but it should return a list. Do not use the range function in your implementation! Study Python’s help on range to determine the names, positions, and what to do with your function’s parameters. Use a default value of None for the two optional parameters. If these parameters both equal None, then the only provided argument should be considered the...
Excel searches for an exact match of the first argument in the first column of the...
Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is a. EXACT. b. TRUE. c. FALSE. d. NULL. The function of Trace Precedents and Trace Dependents is to a. highlight errors in copying and formula construction. b. investigate the cell calculations in great detail. c. ascertain how model parts are segregated. d. trace the range of cells included in the Watch Window box list.
1. What are the inputs to Excel’s RAND function? a.There is one argument to put into...
1. What are the inputs to Excel’s RAND function? a.There is one argument to put into the function – the distribution from which to generate random numbers. b.There are two arguments to put into the function – the number of random values to generate, followed by the number of decimal places. c.The RAND function has no arguments, just parentheses with nothing in between. 2. What do you actually type into a spreadsheet cell to use the RAND function? a. =RAND()...
Write a function to find the indices of a time series in which the absolute value...
Write a function to find the indices of a time series in which the absolute value of the derivative is above a particular threshold. This is somewhat based on work we’ve done in this chapter. The function: (a) should be named where_deriv_large. (b) should take two arguments: times, data (in that order). (c) (509 only) should have a third argument in which the value of the threshold can be passed. (d) should return a tuple. The first element is the...
Arrays, loops, functions: Lotto Element Repeated Function Write a function that that takes as parameters an...
Arrays, loops, functions: Lotto Element Repeated Function Write a function that that takes as parameters an array of ints, an int value named element, and an int value named end. Return a bool based on whether the element appears in the array starting from index 0 and up to but not including the end index. Generate Random Array Write a function that takes as parameters an array of integers and another integer for the size of the array. Create a...
1. Write a function to find the indices of a time series in which the absolute...
1. Write a function to find the indices of a time series in which the absolute value of the derivative is above a particular threshold. This is somewhat based on work we’ve done in this chapter. The function: (a) should be named where_deriv_large. (b) should take two arguments: times, data (in that order). (d) should return a tuple. The first element is the indices of the derivative that exceed a particular threshold. The second element is the count of the...
Problem 10.3: For each of these computations, say what R function is the most appropriate: 1.Count...
Problem 10.3: For each of these computations, say what R function is the most appropriate: 1.Count the number of cases in a data table. 2.List the names of the variables in a data table. 3.For data tables in an R package, display the documentation (“codebook”) for the data table. 4.Load a package into your R session. 5.Mark a data table as grouped by one or more categorical variables.
a fixed point of a function f is a number c in its domain such that...
a fixed point of a function f is a number c in its domain such that f(c)=c. use the intermediate value theorem to prove that any continious function with domain [0,1] and range a subset of [0,1] must have a fixed point.[hint: consider the function f(x)-x] “Recall the intermediate value theorem:suppose that f is countinous function with domain[a,b]and let N be any number between f(a)and f(b), where f(a)not equal to f(b). Then there exist at least one number c in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT