"IF" IN EVERYDAY LIFE

Explain how to display and hide formulas in a spreadsheet.

• By using the 'Show Formulas' option in the Formulas tab.

• By pressing Ctrl + F.

• By clicking on the 'View' tab and selecting 'Hide Formulas'.

• By using the 'Data' tab and selecting 'Display Formulas'.

The difference between absolute and relative references in a spreadsheet is:

• Absolute references remain constant when copied, while relative references change based on the position.

• Relative references remain constant when copied, while absolute references change based on the position.

• Both absolute and relative references remain constant when copied.

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

The IF function in a spreadsheet is used to:

• Perform logical tests and return different values based on the result

• Format cells based on conditions

• Sort data in ascending or descending order

• Calculate the sum of a range of cells

Which functions in a spreadsheet are used to perform conditional summing, averaging, and counting?

• SUMIF, AVERAGEIF, COUNTIF

• SUM, AVERAGE, COUNT

• SUMIFS, AVERAGEIFS, COUNTIFS

• SUMPRODUCT, AVERAGEA, COUNTA

What are the steps to copy a formula with absolute and relative references in a spreadsheet?

• Use the fill handle to drag the formula across cells.

• Copy the formula and paste it into the desired cell.

• Use the 'Copy' and 'Paste Special' options.

• Manually re-enter the formula in each cell.

How do you correct or ignore error messages in a spreadsheet, as appropriate?

• By clicking on the error icon and choosing an option to correct or ignore.

• By restarting the spreadsheet application.

• By deleting the spreadsheet and starting over.

• By ignoring all error messages.

An Absolute Reference in a spreadsheet is:

• A cell reference that remains constant, even if the formula is copied to another cell.

• A cell reference that changes when the formula is copied to another cell.

• A reference to a cell in another worksheet.

• A reference to a range of cells.

Maya is using a spreadsheet to track her monthly expenses. She wants to calculate the average of her grocery expenses that are above $50. Which function should she use?

• Calculate the average of cells that meet a specified condition.

• Find the maximum value in a range of cells.

• Count the number of cells that contain numbers.

• Sum all the cells in a range.

Anika is organizing a school event and needs to count the number of students who have submitted their permission slips. She uses the COUNTIF function in spreadsheets to:

• Count the number of cells that meet a specific condition

• Sum the values in a range of cells

• Find the average of a range of cells

• Sort data in ascending order

The purpose of the IF function in a spreadsheet is to:

• perform calculations

• sort data

• evaluate a condition and return a value based on whether the condition is true or false

• format cells