G7 Excel Quiz 1

What does the number represent?

• Data number

• Column number

• Row number

• Table number

What does the letter represent?

• Data letter

• Column letter

• Row letter

• Table letter

What is not an Excel formula?

• SUM

• TOTAL

• MIN

• MAX

Adding a group of numbers and then dividing by the count of those numbers is the math formula of...

• AVERAGE

• MAX

• SUM

• MIN

This is an accounting number format.

• CORRECT

• FALSE

Answer explanation

This is a currency format. Accounting format has "Rp" line up on the left side of the cells.

V in VLOOKUP stands for...

(a)  

H in HLOOKUP stands for...

(a)  

VLOOKUP formula contains 4 arguments. "FALSE" goes to the ... argument.

• 1st

• 4th

• 2nd

• 3rd

HLOOKUP formula also contains 4 arguments. Number count/Index number of the row of the data we want to return (for example "2") is in the ... argument.

• 4th

• 3rd

• 2nd

• 1st

To make a drop-down list from a selection of cells/tables, we go to menu...

• Data information

• Data validation

• Data confirmation