Remidi

Apa metode yang benar untuk mengisi nomor urut secara otomatis di kolom Microsoft Excel setelah memasukkan nomor pertama?

• Type the first two numbers, select them, and drag the fill handle.

• Type the first number, then in the next cell, enter a formula that adds 1 to the previous cell, and drag the fill handle.

• Use the SEQUENCE function.

• Manually type all numbers.

Rumus apa yang digunakan untuk menghitung jumlah total nilai mata pelajaran Matematika (MTK), Bahasa Indonesia (B INDO), dan Ilmu Pengetahuan Alam (IPA) untuk siswa pertama, dengan asumsi nilai mereka terdapat pada sel F3, G3, dan H3?

• =ADD(F3:H3)

• =TOTAL(F3,G3,H3)

• =SUM(F3:H3)

• =F3+G3+H3

How can you calculate the average of scores in cells F3, G3, and H3, and then display the result as a whole number without decimals?

• Use =AVG(F3:H3) and then decrease decimal places.

• Use =AVERAGE(F3:H3) and then change the cell format to "Number".

• Use =ROUND(AVERAGE(F3:H3),0).

• Manually calculate the sum and divide by 3, then round.

To classify a student's grade as "A" if their average score (in cell J3) is 90 or above, "B" if 80 or above, and "C" otherwise, which Excel formula should be used?

• =IF(J3>=90,"A",IF(J3>=80,"B","C"))

• =GRADE(J3,90,"A",80,"B","C")

• =LOOKUP(J3,{0,80,90},{"C","B","A"})

• =SWITCH(J3,90,"A",80,"B","C")

Are you enjoying the video lesson?

• Yes

• No

What function is used to count the number of cells within a range that meet a single criterion?

• SUMIF

• COUNTIF

• AVERAGEIF

• IF

What is the primary difference between VLOOKUP and HLOOKUP functions?

• VLOOKUP searches horizontally, HLOOKUP searches vertically.

• VLOOKUP searches vertically, HLOOKUP searches horizontally.

• VLOOKUP is for numbers, HLOOKUP is for text.

• VLOOKUP is for exact matches, HLOOKUP is for approximate matches.

What is the purpose of pressing the F4 key when selecting a range in a lookup function formula?

• To delete the selected range.

• To copy the selected range.

• To make the cell references absolute.

• To highlight the selected range.

Which argument should be used in VLOOKUP or HLOOKUP to ensure an exact match for the lookup value?

• TRUE

• APPROXIMATE

• FALSE

• PARTIAL