=SUMPRODUCT(--(A1:A2="z"),B1:B2,C1:C2) for the data in rows 1 and 2: A B C z 2 5 y 3 4

Which worksheet function returns the probability associated with a Student's t-test?

What does SHIFT+DELETE do?

Which worksheet function returns the serial number of a particular time?

Which worksheet function returns the inverse of the Student's t-distribution?

The shortcut for transpose is

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Names must be no more than 255 characters long, you can also use any single letter as a range name except the following?

In Excel, the Insights panel displays online information and images about the text you highlighted. What is that specific control that hold the insights panel when you right click on your highlighted text?

All 2-D and 3-D charts have an x-axis known as the horizontal axis and a y-axis known as the vertical axis. Which of the following charts don't have x-axis and y-axis?

What are Information Functions in Excel?

A worksheet range is as following?