(A) Go to Tools>>Options>>View tab and mark or remove the check box named Gridline
(B) Click Gridline tool on Forms toolbar
(C) Both of the above
(D) None of the above
Category: MS Excel Mcqs
MS Excel Mcqs for NTS, PPSC, FPSC, SPSC, KPPSC, AJKPSC, PMS, PTS, Data Entry Operator, Computer Operator and all computer related exams.
Where we can change automatic or manual calculation mode in Excel?
(A) Go to Tools>>Options>>Calculation and mark the corresponding radio button
(B) Double CAL indicator on status bar
(C) Both of the above
(D) None of the above
We can merge the main document with data source in excel. In mail merge operation word is usually?
(A) Client
(B) Source
(C) Server
(D) None of the above
Which of the following is not the correct method of editing the cell content?
(A) Press the F2 key
(B) Press the Alt key
(C) Click the formula bar
(D) Double click the cell
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
(A) Module sheet
(B) Chart sheet
(C) Data sheet
(D) Worksheet
Name box on to the left of formula bar?
(A) Shows the name of worksheet currently working on
(B) Shows the name of workbook currently working on
(C) Shows the name of cell or range currently working on
(D) None of the above
Tab scroll buttons are place on excel screen?
(A) Towards the top left corner
(B) Towards the top right corner
(C) Towards the bottom left corner
(D) Towards the bottom right corner
Which tool you will use to join some cells and place the content at the middle of joined cells?
(A) From format cells dialog box select the centered alignment.
(B) From format cells dialog box click on merge cells check box.
(C) Click on merge and center tool on formatting toolbar.
(D) All of the above