Mastering Spreadsheet Formulas

What function would you use to find the average of a range of cells?

• SUM

• AVERAGE

• MAX

• COUNT

How do you create a formula that adds the values in cells A1 and B1?

• =A1+B1

• =A1*B1

• =A1-B1

• =SUM(A1,B1)

What is the purpose of the IF function in spreadsheets?

• To format text in bold or italics.

• To create charts and graphs from data.

• To calculate the sum of a range of cells.

• To perform conditional logic by returning different values based on whether a condition is true or false.

Which function would you use to count the number of cells that contain numbers?

• COUNT

• AVERAGE

• MAX

• SUM

How can you reference a cell from another sheet in a formula?

• Use 'SheetName!CellReference' format.

• Use 'CellReference:SheetName' format.

• Use 'CellReference/SheetName' format.

• Reference cells by their row and column numbers only.

What does the VLOOKUP function do?

• It sorts a list of values in ascending order.

• It creates a chart based on selected data.

• It looks up a value in a table and returns a corresponding value from another column.

• It calculates the sum of a range of cells.

How do you create a formula that multiplies the values in cells C1 and D1?

• =C1*D1

• C1+D1

• C2*D1

• C1*D2

What is the difference between absolute and relative cell references?

• Both absolute and relative references are the same in function.

• Absolute references remain constant; relative references change based on their position.

• Relative references are fixed; absolute references change with position.

• Absolute references are used for text; relative references are for numbers.