MS EXCEL TEST

It is a spreadsheet program that is used to record and analyze numerical data. 

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

• Microsoft Publisher

It is a tab used to group similar commands together.

• Title tab

• Menu Tab

• Ribbon tab

• Microsoft Publisher

In Excel Worksheet is identified using letters from A to XFD. From A to XFD

• Column Letter

• Row Letter

• Active Cell

• Worksheet

There are total of __________ columns available

• 16884

• 16384

• 16484

• 16584

Each Row in Excel Worksheet is identified using numbers from 1 to_________.

• 2,048,576

• 1,048,586

• 1,048,576

• 2,049,576

Returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE.

• VLOOKUP Function

• OR Function

• AND IF Function

• AND Function

 Evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE.

• IF Function

• OR Function

• AND IF Function

• AND Function

The easiest way to make a proper formula is to write down the condition first, and then incorporate it in the logical test argument of the IF function.

• IF Function

• OR Function

• AND IF Function

• AND Function

 Returns TRUE if at least one of the arguments evaluates to TRUE, and returns FALSE if all arguments are FALSE.

• IF Function

• OR Function

• AND IF Function

• VLOOKUP Function

An Excel function to lookup and retrieve data from a specific column in table. 

• IF Function

• OR Function

• AND IF Function

• VLOOKUP Function