EXCEL QUIZ (ROUND 2)

What is the name of the Last column in Excel?

• XFC
• XFD
• XFE
• XFG

What is the correct syntax of IF() function?

• =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
• =IF (logical_test, {[value_if_true]}, {[value_if_false]})
• =IF (logical_test: #REF!, #REF!)
• =IF (logical_test, #REF!, #REF!)

Which function is used to get days, months, or years between two dates?

• DATE()
• CURDATE()
• DATEVALUE()
• DATEDIF()

Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

• Styling
• Conditional Formatting
• Special Formatting
• Compare Formatting

Which of the following is not the correct method of editing the cell content

• Press the Alt key
• Press the F2 key
• Double click the cell
• Click the formula bar

The number of rows in an Excel 2007 worksheet is:

• 1048579
• 1048578
• 1048576
• 1048577

In Excel, what does the acronym "CTP" stand for in relation to add-ins?

• Create Task Pane
• Custom Tool Part
• Customize Tab Panel
• Custom Task Pane

Which of the following is a volatile function in Excel (i.e., it recalculates every time Excel recalculates)?

• VLOOKUP
• SUM
• CONCATENATE
• NOW

Which function can you use to retrieve the last non-blank cell in a column?

• =LOOKUP(2,1/(A:A<>""),A:A)
• =MAX(A:A)
• =HLOOKUP("*",A:A,1,FALSE)
• =VLOOKUP(1E+30,A:A,1)

_____ can be used as a keyboard shortcut key to check spelling in MS Excel

• F4
• F5
• F6
• F7