Bengkel Google Spreadsheet

What color should be used to highlight absent students in the attendance checklist?

• Green

• Red

• Blue

• Yellow

Which formula is used to calculate the total number of absences for each student?

• =SUMIF()

• =VLOOKUP()

• =COUNTIF()

• =AVERAGE()

What should be added to the bottom of the attendance data to calculate total class absences?

• A new column

• A new chart

• A new row

• A new sheet

What is the function of $ sign in Spreadsheet?

• The $ sign locks cell references in formulas.
• The $ sign adds a comment to the cell.
• The $ sign changes the cell color.
• The $ sign indicates a formula is being used.

What formula calculates the average number of absences per student?

• =COUNTIF()

• =AVERAGE()

• =SUM()

• =VLOOKUP()

What is the purpose of the Data Validation feature in the attendance checklist?

• To calculate totals

• To create dropdown

• To create charts

• To format cells

In the invoice sheet, which function is used to retrieve the unit price of an item?

• AVERAGE

• COUNTIF

• VLOOKUP

• SUMIF

What formula is used to calculate the price in the invoice sheet?

• =SUM(D2:D[last_row])

• =VLOOKUP()

• =B2*C2

• =A2+B2

The arterisk function (AI*A2) is for

• Addition

• Substraction

• Multiplication

• Division

What is the purpose of the IFERROR function in the VLOOKUP formula?

• To calculate totals

• To format data

• To handle errors

• To create charts