Solved MCQs of Computer Skills in PDF.
Which button is used on the toolbar To open a current workbook;
(A) StandardSelect the option which of the following will not cut information;
(A). Clicking the Cut button on the standard
(B). Selecting Edit>Cut from the menu
(C). Pressing Ctrl + c
(D). Pressing Ctrl+X
Answer; Pressing Ctrl + C
Select a method that cannot be used to enter data in a cell;
(A). Pressing an arrow key
(B). Pressing the Esc key
(C). Pressing the Tab key
(D). Clicking on the formula bar
Answer: Pressing the Esc key
In Select a key is used for format number in time format;
(A).Ctrl+Shift+2
(B).Ctrl+Shift+3
(C).Ctrl+Shift+5
(D).Ctrl+Shift+2
Answer ;Ctrl+Shift+2
In Which of the following key is used for format number in scientific format;
(A).Ctrl+Shift+5
(B).Ctrl+Shift+3
(C).Ctrl+Shift+6
(D).Ctrl+Shift+4
Answer ; Ctrl+Shift+6
Select a key is used for format number in percentage format;
(A).Ctrl+Shift+5
(B).Ctrl+Shift+3
(C).Ctrl+Shift+6
(D).Ctrl+1
Answer ;Ctrl+Shift+5
Select a key is used for format number in date format?
(A).Ctrl+Shift+3
(B).Ctrl+Shift+4
(C).Ctrl+Shift+6
(D).Shift+1
Answer ;Ctrl+Shift+3
Select a key in Excel is used for format number in currency format;
(A).Ctrl+Shift+4
(B).Ctrl+Shift+1
(C).Ctrl+1
(D).Shift+1
Answer ;Ctrl+Shift+4
Select a key is used for format number in comma format;
(A).Shift+1
(B).Ctrl+Shift+4
(C).Ctrl+1
(D).Ctrl+Shift+1
Answer ;Ctrl+Shift+1
select a key is used for create a formula to sum all of the above cells in MS Excel;
(A).Alt+=
(B).Alt+-
(C).Ctrl+=
(D).Ctrl+-
Answer: Alt+=
Which of the following key is used to open the excel formula in MS Excel;
(A).Shift+F3
(B).Shift+F6
(C).Alt+Shift+F3
(D).Alt+Shift+F6
Answer: Shift+F3
Select a key which is used to insert new worksheet in excel;
(A).Alt+Shift+F1
(B).Alt+F1
(C).Alt+F2
(D).Alt+Shift+F2
Answer ;Alt+Shift+F1
Select a key which is used for find in excel;
(A).CTRL+F
(B).CTRL+C
(C).ALT+SHIFT+D
(D).ALT+SHIFT+F
Answer: CTRL+F
Select a key That is used to create a chart from selected data in excel;
(A). F10
(B). F1
(C). F11
(D). Both A & B
Answer; F11
Select a key which is used to Open the Format Cells window;
(A).Ctrl+1
(B).Ctrl+6
(C).Ctrl+F1
(D).Ctrl+F10
Answer: Ctrl+1
Select a key which is used to edit the selected cell in excel;
(A).F4
(B).F2
(C).F10
(D).Edit
Answer: F2
Select a key Which is used to enter the current date in Excel;
(A).Ctrl+;
(B).Ctrl+:
(C).Ctrl+Shift+:
(D).Ctrl+Shift+;
Answer: Ctrl+;
Select a key that is used to select an entire row In Excel;
(A).Shift+Space
(B).Ctrl+Space
(C).Alt+Space
(D).None of these
Answer: Shift+Space
Select a key that is used to select the entire column in Ms. Excel;
(A).Shift+Space
(B).Ctrl+Space
(C).Alt+Space
(D).None of these
Answer: Ctrl+Space
Select a Shortcut key to quit Microsoft Word, Powerpoint, Access, Excel etc is ______________.
(A).Shift + F4
(B). Ctrl + W
(C).Alt + F4
(D).Alt + W
Answer: Alt + F4
Select a key that is used to display an active cell in Excel;
(A). Shift + Backspace
(B). Alt + Backspace
(C).Ctrl + Backspace
(D). None
Answer: Ctrl + Backspace
The comment put on Excel cell which is displayed by taking the Mouse Pointer there, knowns as_________
A.Cell Tip
B.Soft Tip
C.Web Tip
D.Smart tip
Answer: Cell Tip
which menu is used In MS Excel to delete duplicate values;
A.Formatting
B.Tools
C.Data
D.Layout
Answer: Data
Select a number of rows are in one Microsoft Excel sheet;
A.16,384
B.65,536
C.1,048,576
D.None of Above
Answer: 1,048,576
MCQs collection of solved and repeated MCQs with answers for the preparation of competitive exams, admission test and job of PPSC, FPSC, UPSC, AP, APPSC, APSC, BPSC, PSC, GOA, GPSC, HPSC, HP, JKPSC, JPSC, KPSC, KERALAPSC, MPPSC, MPSC, MPSCMANIPUR, MPSC, NPSC, OPSC, RPSC, SPSCSKM, TNPSC, TSPSC, TPSC, UPPSC, UKPSC, SPSC, KPPSC, BPSC, AJKPSC ALPSC, NPSC, LPSC, SCPSC, DPSC, DCPSC, PSC, UPSC, WVPSC, PSCW, and WPSC.
