MS Excel MCQ Questions And Answers

MS Excel MCQ Questions And Answers

11. How many characters can be typed in a single cell in Excel?

  1. 1024
  2. 256
  3. 65535
  4. 32000

Answer : C
Explanation: None.

12. What type of chart is useful for comparing values over categories?

  1. Pie Chart
  2. Line Chart
  3. Dot Graph
  4. Column Chart

Answer : D
Explanation: None.

13. Which function in Excel tells how many numeric entries are there?

  1. COUNT
  2. NUM
  3. SUM
  4. CHKNUM

Answer : A
Explanation: COUNT function in excel is used to tell how many numeric entries are there.

14. You can set page border in excel from?

  1. From Border tab in Format Cells dialog box
  2. You can not set page border in Excel
  3. From Border tool in Formatting toolbar
  4. From Line Style tool in Drawing toolbar

Answer : B
Explanation: You can’t set page border in Excel.

15. Where can you set the shading color for a range of cells in excel?

  1. Choose required color form Patterns tab of Format Cells dialog box
  2. Choose required color on Fill Color tool in Formatting toolbar
  3. Choose required color on Fill Color tool in Drawing toolbar
  4. All of above

Answer : D
Explanation: The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell So all of the above are correct.

16. The default font size in the excel worksheet is?

  1. 11
  2. 14
  3. 15
  4. 16

Answer : A
Explanation: The default font size in the excel worksheet is 11 and you can change the default font in Excel, by default, Microsoft Excel uses Calibri font 11 as Body Font when you type data in a worksheet, header, or footer, or text box. You can change the default font and font size for all new workbooks that you create.

17. Which of the following identifies a cell in Excel?

  1. Address
  2. Formula
  3. Label
  4. Name

Answer : A
Explanation: None.

18. _______is the best alternative to MS Excel offered by Google Inc.

  1. Google Slides
  2. Google Sheets
  3. Google Files
  4. Google Keep

Answer : B
Explanation: Google Sheets

19. Which key is used to “goto” tab in MS Excel?

  1. F9
  2. F7
  3. F5
  4. F6

Answer : C
Explanation: None.

20. A file that contains one or more worksheets to organize data is known as _____

  1. Excelbook
  2. Workbook
  3. Datasheet
  4. Spreadsheet

Answer : B
Explanation: A file that contains one or more worksheets to organize data is known as Workbook.

Pages: 1 2 3

This Post Has One Comment

Leave a Reply