Microsoft Excel Assessment

What is the result of the following formula?

=10+2*10

• 10

• 30

• 123

• 402

Which of the following functions counts all cells (both with numbers or text)?

• COUNTOUS

• SUMIFS

• COUNT

• COUNTA

Which of the following formulas can combine two strings together

• Textjoin

• Concat

• Concatenate

• All of the above

What would be the result of the following formula on Table A?

=VLOOKUP("AA1", Table_A,2,0)

• AA1

• Good

• 200

• BB1

What is the result of the following formula?

=COUNTIF($K$67:$K$70,"Good")

• 300

• 2

• 3

• A

What is the result of the following formula?

=SUMIF($K$80:$K$83,"Good",$J$80:$J$83)

• 454

• 3

• 300

• 697

How can I keep only unique values in my Excel?

• TRANSPOSE function

• Unique function

• Sort&filter

• Answers 1 and 2

What does the following mean when it appears in a cell?

#########

• Not enough space for the cell's content

• Division by 0

• Not found

• Excel is about to crash

Which word is used for declaration of variables in VBA?

• var

• dim

• let

• lambda

Please rate your level of confidence in Excel Functions

• Beginner

• I know some formulas

• I know many Functions

• I am an expert