Computer Skills MCQsBy: Prof. Dr. Fazal Rehman | Last updated: April 30, 2025 22 Score: 0 Attempted: 0/22 Subscribe 1. : Which method 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 2. : Which key is used to format number in time format in Excel? (A) Ctrl + Shift + 2 (B) Ctrl + Shift + 3 (C) Ctrl + Shift + 5 (D) Ctrl + Shift + 2 3. : Which key is used to format number in scientific format in Excel? (A) Ctrl + Shift + 5 (B) Ctrl + Shift + 3 (C) Ctrl + Shift + 6 (D) Ctrl + Shift + 4 4. : Which key is used to format number in percentage format in Excel? (A) Ctrl + Shift + 5 (B) Ctrl + Shift + 3 (C) Ctrl + Shift + 6 (D) Ctrl + 1 5. : Which key is used to format number in date format in Excel? (A) Ctrl + Shift + 3 (B) Ctrl + Shift + 4 (C) Ctrl + Shift + 6 (D) Shift + 1 6. : Which key is used to format number in currency format in Excel? (A) Ctrl + Shift + 4 (B) Ctrl + Shift + 1 (C) Ctrl + 1 (D) Shift + 1 7. : Which key is used to format number in comma format in Excel? (A) Shift + 1 (B) Ctrl + Shift + 4 (C) Ctrl + 1 (D) Ctrl + Shift + 1 8. : Which key is used to create a formula to sum all of the above cells in Excel? (A) Alt + = (B) Alt + – (C) Ctrl + = (D) Ctrl + – 9. : Which key is used to open the formula dialog box in Excel? (A) Shift + F3 (B) Shift + F6 (C) Alt + Shift + F3 (D) Alt + Shift + F6 10. : Which key is used to insert a new worksheet in Excel? (A) Alt + Shift + F1 (B) Alt + F1 (C) Alt + F2 (D) Alt + Shift + F2 11. : Which key is used to find in Excel? (A) Ctrl + F (B) Ctrl + C (C) Alt + Shift + D (D) Alt + Shift + F 12. : Which key is used to create a chart from selected data in Excel? (A) F10 (B) F1 (C) F11 (D) Both A & B 13. : Which key is used to open the Format Cells window in Excel? (A) Ctrl + 1 (B) Ctrl + 6 (C) Ctrl + F1 (D) Ctrl + F10 14. : Which key is used to edit the selected cell in Excel? (A) F4 (B) F2 (C) F10 (D) Edit 15. : Which key is used to enter the current date in Excel? (A) Ctrl + ; (B) Ctrl + : (C) Ctrl + Shift + : (D) Ctrl + Shift + ; 16. : Which key is used to select an entire row in Excel? (A) Shift + Space (B) Ctrl + Space (C) Alt + Space (D) None of these 17. : Which key is used to select the entire column in Excel? (A) Shift + Space (B) Ctrl + Space (C) Alt + Space (D) None of these 18. : Which shortcut key is used to quit Microsoft Word, PowerPoint, Access, Excel etc.? (A) Shift + F4 (B) Ctrl + W (C) Alt + F4 (D) Alt + W 19. : Which key is used to display the active cell in Excel? (A) Shift + Backspace (B) Alt + Backspace (C) Ctrl + Backspace (D) None 20. : What is the comment put on Excel cell which is displayed by taking the mouse pointer there known as? (A) Cell Tip (B) Soft Tip (C) Web Tip (D) Smart Tip 21. : Which menu is used in MS Excel to delete duplicate values? (A) Formatting (B) Tools (C) Data (D) Layout 22. : How many rows are there in one Microsoft Excel sheet? (A) 16,384 (B) 65,536 (C) 1,048,576 (D) None of the Above 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.Related Posts:Programming Skills MCQsCommunication Skills MCQs (Psychological assessment)Communication skills MCQsLeadership Traits and Skills MCQsBasic Skills Instruction (Special Education) MCQsPast Papers Basic Communication Skills