MS Excel MCQ – Computer

1. What is the symbol of multiplying?

  1. >
  2. /
  3. !
  4. *
Answer
Answer. d

2. What is the symbol for dividing?

  1. /
  2. %
  3. &
  4. #
Answer
Answer. a

3. Which of the following syntax is correct regarding SUM function in Excel?

  1. =SUM(A1,B1)
  2. =SUM(A1:B9)
  3. =SUM (A1:A9,B1:B9)
  4. All of the above
Answer
Answer. d

4. The software which contains rows and columns is called

  1. Database
  2. Drawing
  3. Spreadsheet
  4. Word processing
Answer
Answer. c

5. What do you mean by Workspace?

  1. Group of columns
  2. Group of worksheets
  3. Group of Rows
  4. Group of Workbooks
Answer
Answer. d

6. What is the shortcut key to highlight the entire column?

  1. Ctrl+ C
  2. Ctrl+ Enter
  3. Ctrl+ PageUp
  4. Ctrl+ Spacebar
Answer
Answer. d

7. To select an entire column in MS-Excel, press?

  1. Ctrl + C
  2. Ctrl + Arrow Key
  3. Ctrl + S
  4. None of the above
Answer
Answer. d

8. What is the shortcut key to replace a data within sheet?

  1. Ctrl + R
  2. Ctrl + Shift + R
  3. Ctrl + H
  4. Ctrl + F
Answer
Answer. c

9. A worksheet can have maximum ________ number of rows in Excel 2019?

  1. 256
  2. 10,48,576
  3. 32,000
  4. 65,535
Answer
Answer. b

10. What is the shortcut key to hide entire row?

  1. Ctrl + H
  2. Ctrl + R
  3. Ctrl + 9
  4. Ctrl + _
Answer
Answer. d

11. The name box

  1. Shows the location of previously active cell
  2. Appears to the left of the formula bar
  3. Appears below the status bar
  4. Appears below the menu bar
Answer
Answer. b

12. Excel displays the current cells address in the ____

  1. Formula bar
  2. Status bar
  3. Name box
  4. Title bar
Answer
Answer. c

13. The first cell in excel worksheet is labeled as

  1. AA
  2. A1
  3. Aa
  4. A0
Answer
Answer. b

14. To save a workbook, you:

  1. Click the Save option in File Menu
  2. Press Ctrl+F5
  3. Click Save on Windows Start button
  4. Select Edit Save
Answer
Answer. a

15. Ms-Excel is based on ___________?

  1. WINDOWS
  2. DOS
  3. UNIX
  4. OS/2
Answer
Answer. a

16. Which symbol must all formula begin with?

  1. =
  2. +
  3. (
  4. @
Answer
Answer. a

17. Which area in an excel window allows entering values and formulas?

  1. Title bar
  2. Menu bar
  3. Formula bar
  4. Standard toolbar
Answer
Answer. c

18. Which of the following is latest version of Excel?

  1. 2007
  2. 2019
  3. 2003
  4. 2016
Answer
Answer. b

19. An excel workbook is a collection of

  1. Workbooks
  2. Worksheets
  3. Charts
  4. Worksheets and Charts
Answer
Answer. d

20. Excel files have a default extension of

  1. Xlsx
  2. Xlw
  3. Wk1
  4. 123
Answer
Answer. a

21. Microsoft Excel is a powerful_______

  1. Word processing package
  2. Spreadsheet package
  3. Communication S/W package
  4. DBMS package
Answer
Answer. b