C. =IF(LogicalTest , TrueResult) (LogicalTest, FalseResult)
D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)
51.
What is the intersection of a column and a row on a worksheet called ?
A. Column
B. Value C. Address
Cell
52.
Which functionin Excel tells how many numeric entries are there ?
A. NUM
O. COUNT C. SUM D. CHKNUM
53.
A features that displays only the data in column (s) according to specified crite
Formula B. Sorting
(C. Filtering|P. Pivot
Statistical colomlations and pronaration of tables and generalis can be done using
A. Adobe Photoshop B. Excel
C. Notepad D. Power Point
55. In Excel, Columns are la belled as
AJA, B, C, eto B. 1,2,3 etc 6. A1, A2, etc. D. $A$1, $A$2, etc.
56. The Greater Than sign (>) is an example of operator.
A. Arithmatic B. Logical
C. Conditional Greater
57. What type of chart is useful for showing trends or changes over time ?
A. Pie Chart B. Column Chart (C. Line Chart D. Dot Graph
58. The process of arranging the items of a column in some sequence or order
is known as : Oui
A. Arranging Test 1 B. Autofill Q. Sorting D. Filtering
59. The feature of MS Excel quickly completes a series of data
A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting
60. In Excel, Rows are labelled as
6. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc.