P6 Spreadsheets

Which image represents the function to sort data in ascending order in Google Sheets?

• 
• 
• 
• 

Identify the feature in Google Sheets represented by the image below.

• List validation

• Sorting

• Filtering

What does the "IF" function do in Google Sheets?

• Adds up a range of numbers

• Multiplies two numbers

• Checks a condition and returns one value if true and another if false

• Finds the average of numbers

How can you apply list validation to a cell in Google Sheets?

• Right-click on the cell and choose "List Validation"

• Use the "Data Validation" option in the Data menu

• Press Ctrl + L

Which feature shows only the data you want to see in your worksheet?

• Relative cell references

• Sort

• Filter

• Merge cells

In the "IF" function, what is the first argument that you need to provide?

• Logical test

• Value if true

• Value if false

• Data range

How is the "IF" function written in Google Sheets?

• IF(logical_test, value_if_false, value_if_true)

• IF(value_if_true, logical_test, value_if_false)

• IF(value_if_false, logical_test, value_if_true)

• IF(logical_test, value_if_true)

How can you quickly fill a series of numbers in a column in Google Sheets?

• Type the numbers manually

• Drag the fill handle at the bottom-right corner of the cell

• Use the "Insert" menu

In the formula "=IF(D4>100, "Yes", "No")" , what is the value if logical test is true?

• 100

• Yes

• No

In data validation, what happens if a user tries to enter data that violates the specified criteria?

• The data is automatically corrected

• An error message is displayed, or the input data is rejected

• The criteria are automatically adjusted

• The data is accepted without any notification