MS Excel MCQ Practice Questions PDF

## MS Excel MCQ ### Multiple Choice Questions: 1. Which of the following keys is pressed in order to move between the cells in MS-Excel? * Tab key * Enter key * Arrow key * All of these **Answer**: D - All of these 2. What combination/short cut keys will help you select the...

## MS Excel MCQ ### Multiple Choice Questions: 1. Which of the following keys is pressed in order to move between the cells in MS-Excel? * Tab key * Enter key * Arrow key * All of these **Answer**: D - All of these 2. What combination/short cut keys will help you select the entire row of the active cell? * Ctrl + F1 * Alt + Space bar * Ctrl + Space bar * Shift + Space bar **Answer**: D - Shift + Space bar 3. In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented? * A10/A12 * A2:A10 * A2:A12 **Answer**: D - A2:A12 4. Which shortcut key will access the entire column of an active cell? * Ctrl + Spacebar * Alt + Spacebar * Ctrl + F1 * Alt + F1 **Answer**: A - Ctrl + Spacebar 5. Which key should be pressed to activate extend indicator (EXT) in status bar? * F5 * F7 * F8 * F11 **Answer**: C - F8 6. The Intersection of rows and columns is known as * Cell * Grid lines * Header * Footer **Answer**: A - Cell 7. An Excel workbook is an collection of: * Workbook * Worksheet * Charts * Cells **Answer**: B - Worksheet 8. Select the correct example of a cell address: * 3611 * A25 * 901 * 498 **Answer**: B - A25 9. Which is an example of function? * =add (A1: A2) * A1+A2 * =sum (B1: B5) * B1+B2 **Answer**: C - =sum (B1: B5) 10. Formulas in Excel start with: * % * / * = * +/- **Answer**: C - = 11. The Name Box: * Shows the location of the previously active cell. * Appears to the left of the formula bar. * Appears below the starts bar. * Appears above the menu bar. **Answer**: B - Appears to the left of the formula bar. 12. Which area in an excel window allows entering values and formulas? * Formula Bar * Status Bar * Menu bar * Title Bar **Answer**: A - Formula Bar 13. Excel displays the current cell address in the * Formula bar * Name box * Title bar * Menu bar **Answer**: B - Name box 14. A _____ is a grid with labelled columns and rows. * Dialog box * Worksheet * Toolbar * Standard toolbar **Answer**: B - Worksheet 15. Short cut keys will help you to go to top of the work sheet ? * SHIFT + HOME * ALT + HOME * CTRL + HOME * None of these **Answer**: C - CTRL + HOME 16. Short cut keys will help you to go to end of the work sheet ? * SHIFT + END * ALT + END * CTRL + END * None of these **Answer**: C - CTRL + END 17. Short cut keys will help you to apply number format in ms excel? * CTRL + SHIFT +3 * CTRL + SHIFT + 1 * CTRL + SHIFT +2 * None of these **Answer**: B - CTRL + SHIFT + 1 18. Default column width in excel is * 8.43 * 8.34 * 8.41 * 8.21 **Answer**: A - 8.43 19. Default row height in excel is * 12.55 * 11.85 * 12.65 * 12.75 **Answer**: D - 12.75