STS Junior Officer Associate Past Paper Dated: 29-07-2018 81- _____ is a feature of MS excel and can also be used in PowerPoint . A. chartB. merge cellsC. functionD. none of these View Answer Answer : A. chart Description 82- Excel’s ______ function allows you to add the numbers in multiple cells. A. MINB. SUMC. MAXD. AVERAGE View Answer Answer : B. SUM Description 83- Which is the correct syntax of IF statement in Excel. A. =IF (test, result if True, result if False).B. =IF (result if True, result if False, test).C. =IF (result if False, test, result if True).D. = (test, result if True, result if False). View Answer Answer : A. =IF (test, result if True, result if False). Description 84- Left, Centred, Right and Justified in MS Word are all ______. A. font stylesB. paragraph alignmentsC. paragraph stylesD. none of the above View Answer Answer : B. paragraph alignments Description 85- Which Command line tool is used in Windows environment to check the IP Configuration in detail ______? A. JPB. IPConfig/allC. PingD. Telnet View Answer Answer : B. IPConfig/all Description 1 2 3 4 5
