CPCT Objective Question and Answer

 Microsoft office related cpct objective question and answer 1) OpenOffice  Calc is an  Example of : A) Spreadsheet B) Word Processor C) Presentation Software D) Database Ans:- A)  Spreadsheet 2) Which of the following features is generally used to create lables that span multiple columns? A) Wrap Text B) Merge & Center C) Text Direction D) Shrink to Fit Ans:- B) Merge & Center 3) Assuming numeric values in the cells A1 and A2 as 10 and 15 respectively, the value of the excel expression =IF(A1-A2,”A” ,”B”)is: A) 5 B) 5 C) A D) B Ans: C) A 4) Press ---------------Key to Cancel the value of a cell being edited. A) Enter B) Tab C) Esc D) Ctrl Ans: C) Esc 5) The Display value of a cell containing the Excel expression =  10-10/2+8 is: A) 0 B) 9 C) 10 D) 13 Ans:- D) 13 6) Total  number of layers in OSI Reference Model is: A) 4 B) 5 C) 7 D) 9 Ans:-  C) 7 7) Which of the following is a web Search Engi...