Computer Skills MCQs

By: Prof. Fazal Rehman Shamil

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.