Mastering Spreadsheet Formulas

What is the purpose of the SUM function in spreadsheets?

• To calculate the average of numbers.

• To count the number of cells in a range.

• To add numbers together.

• To find the maximum value in a range.

How do you create a formula to calculate the average of a range of cells?

• COUNT(range)

• SUM(range)

• MAX(range)

• AVERAGE(range)

What symbol is used to start a formula in an electronic spreadsheet?

• -

• =

• *

• +

Explain the difference between relative and absolute cell references.

• Relative references adjust based on the position of the formula; absolute references do not change.

• Relative references are used for text, while absolute references are used for numbers.

• Relative references are fixed and do not change; absolute references adjust based on the formula's position.

• Both relative and absolute references change based on the formula's position.

How can you use the IF function to perform conditional calculations?

• The IF function can only return numeric values.

• Use the IF function to evaluate conditions and return different results based on whether the condition is true or false.

• Use the IF function to format text strings without conditions.

• Use the IF function to create loops in calculations.

What does the VLOOKUP function do in a spreadsheet?

• The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.

• The VLOOKUP function calculates the sum of a column.

• The VLOOKUP function formats cells in a spreadsheet.

• The VLOOKUP function deletes rows in a table.

How can you combine text from multiple cells into one cell?

• Apply the VLOOKUP function for merging data.

• Use the SUM function to add values.

• Use CONCATENATE function or the ampersand (&) operator.

• Utilize the IF function to combine text.

What is the function of the COUNT function in spreadsheets?

• The COUNT function calculates the average of a range of cells.

• The COUNT function counts numeric entries in a range of cells.

• The COUNT function formats text entries in a range of cells.

• The COUNT function retrieves the maximum value from a range of cells.

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

• Use 'CellReference:SheetName' format.

• Use 'SheetName.CellReference' format.

• Use 'SheetName!CellReference' format.

• Reference cells by using 'CellReference@SheetName'.

What is the purpose of the CONCATENATE function?

• To extract a substring from a string.

• To join multiple text strings into one string.

• To format dates in a specific style.

• To calculate the sum of numbers.