111. What is the function of the IF function in Excel?

A. To perform a logical test and return a value based on the result
B. To add up a range of cells
C. To find the average of a range of cells
D. To count the number of cells in a range

112. In assembly languages symbols are used instead of binary code, these symbols are called?

A. Mnemonics
B. ALGOL
C. Procedures
D. None of these

113. Window 9 main features are __?

A. Windows 9 Has a New Look
B. Windows 9 Snap Layouts
C. Multiple Desktops in Windows 9
D. Window 9 Not launched

114. What is the function of the VLOOKUP function in Excel?

A. To perform a vertical lookup and return a value based on a specified criteria
B. To perform a horizontal lookup and return a value based on a specified criteria
C. To add up a range of cells
D. To find the average of a range of cells

115. Storage is also known as __?

A. Secondary storage
B. Auxiliary storage
C. Mass storage
D. All of above

116. What is the function of the SUM function in Excel?

A. To add up a range of cells
B. To find the average of a range of cells
C. To count the number of cells in a range
D. To find the maximum value in a range of cells

117. An excel workbook is a collection of __?

A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts

118. What is the intersection of a column and row called in Excel?

A. A cell
B. A range
C. A column header
D. A row header

119. The first cell in excel worksheet is labeled as _?

A. AA
B. A1
C. Aa
D. None of these

120. Title bar in MS-Excel displays name of the __ ?

A. Worksheet
B. Workbook
C. Formula
D. Location