ENGLISH Microsoft Excel Lanjutan

What does a cell in Excel represent?

• A single row of data

• A single column of data

• A box where you type data

• The result of a formula

Which formula is used to sum the numbers in cells A1 to A5?

• =AVERAGE(A1:A5)

• =SUM(A1:A5)

• =MAX(A1:A5)

• =COUNT(A1:A5)

Which formula shows the smallest number in the range C1:C5?

• =MIN(C1:C5)

• =MAX(C1:C5)

• =LOWER(C1:C5)

• =SUM(C1:C5)

The teacher at Kalam Kudus School wants to sort the students' scores from highest to lowest. Which option should they choose?

• Ascending

• Descending

• Filter

• Random

What is the result of =LEN("Excel 2025")?

• 8

• 9

• 10

• 11

Which function can count how many numbers are in the range E1:E10?

• =MAX(E1:E10)

• =COUNT(E1:E10)

• =SUM(E1:E10)

• =AVERAGE(E1:E10)

What is the result of the formula =LEFT("RESPECT",4)?

• SPEC

• RESP

• PECT

• ESPE

Which IF formula is correct to display "Passed" if G2 ≥ 80, otherwise "Not Passed"?

• =IF(G2>=80,"Passed","Not Passed")

• =IF(G2>80,"Passed","Not Passed")

• =IF(G2>=80;"Passed";"Not Passed")

• =IF(G2>80,Passed,Not Passed)

To display only students with a score of ≥ 80, what feature should be used?

• Sort

• Filter

• Count

• Average

When you sort names from A to Z, what order is used?

• Descending

• Filtering

• Ascending

• Manual typing