Microsoft Excel

Question 1

What is a formula in Excel?

Answer 1

An expression that calculates the value of a cell, e.g., =A1+B1.

Question 2

What is the IF function in Excel?

Answer 2

A logical function that returns one value if a condition is true and another if false, e.g., =IF(A1>10,”Yes”,”No”).

Question 3

What is a range in Excel?

Answer 3

A selection of two or more cells, e.g., A1:A10.

Question 4

Name three common spreadsheet functions.

Answer 4

SUM: Adds numbers
AVERAGE: Finds the mean
IF: Performs a logical test