Excel Multiple Choices

What is the intersection of a column and a row on a worksheet called ?

• Column

• Address

• Cell

• Formula bar

Which one is not a Function in MS Excel ?

• VLOOKUP

• MAX

• SUM

• AVG

The Excel worksheet contains _______ columns.

• 16394

• 16384

• 16398

• 16388

What is the function used to find the highest value in a range of cells in MS Excel ?

• MIN

• MAX

• AVERAGE

• SUM

Which function is used to search for a value in the first column of a table and return a value in the same row from another column ?

• VLOOKUP

• HLOOKUP

• INDEX

• MATCH

What is the shortcut key to open the 'Format Cells' dialog box in MS Excel ?

• Ctrl + F

• Ctrl + Shift + F

• Ctrl + 1

• Ctrl + 2

What function is used to return the remainder after a number is divided by another number in MS Excel ?

• MOD

• ROUND

• CEILING

• FLOOR

How many worksheets can a workbook contain in MS Excel ?

• 256

• 255

• 257

• No Limit

Which function is used to count the number of cells that contain numbers in MS Excel ?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What is the function used to find the lowest value in a range of cells in MS Excel ?

• MIN

• MAX

• AVERAGE

• SUM