(A) Goal Seek
(B) Percentage
(C) Square
(D) Divide
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.
Which can be paste selectively using paste special command?
(A) Formulas
(B) Formats
(C) Validation
(D) All of the above
Which series type is not valid for Fill Series dialog box?
(A) Time
(B) AutoFill
(C) Growth
(D) Linear
Command edit>>fill across worksheet is active only when?
(A) When many sheets are selected
(B) When one sheet is selected
(C) When no sheet is selected
(D) None of the above
Ctrl+R short cut key is used for?
(A) Right align the content of cell
(B) Remove the cell content of selected cells
(C) Fill the selection with active cells to the left
(D) Fill the selection with active cells to the right
Ctrl+D short cut key is used for?
(A) Fill down in the selection
(B) Apply double underline for the active cell
(C) Open the font dialog box
(D) None of the above
MS Excel provides default value for step in Fill series dialog box?
(A) 0
(B) 1
(C) 5
(D) 10
Long text can be broken down into many lines within a cell. You can do this through?
(A) Justify in edit>>Cells
(B) Wrap text in format>>Cells
(C) Text Wrapping in Format>>Cells Layout Tab
(D) All of the above