microsoft excel MCQs

Practise focused microsoft excel questions with marked answers for exam preparation and subject revision.

microsoft excel Mcqs
1. How we can view a cell comment ?
comments icon0

A. click the comment command on the view menu

B. click the edit comment commands on the Insert menu

C. click the Display comment command on the window menu

D. position the mouse pointer over the cell
2. Which among following is not associated with spelling dialogue box?
comments icon0

A. Change

B. Edit

C. Ignore All

D. Ignore

3. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
comments icon0

A. Pivot Table List

B. HTML

C. Pivot Table Report

D. Pivot Table Field List

4. Which of these key are used in ms excel to insert current time In workbook.
comments icon0

A. Ctrl+!

B. Ctrl + Shift + ;

C. None of these

D. Ctrl+*

5. Excel displays the current cells address in the __________?
comments icon0

A. Formula bar

B. Title bar

C. Status bar

D. Name box
6. In a computer spreadsheet, cell range A3 through G3 should be keyed in as _________ ?
comments icon0
A. A3:G3

B. A3 to G3

C. A3?.G3

D. A3-G3

7. Move to Next Sheet in Ms Excel:
comments icon0

A. None of these

B. Ctrl + Page Down

C. Page Down

D. Shift + Page Down

8. With which of the following all formulas in excel starts ?
comments icon0

A. /

B. *

C. =

D. $

9. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?
comments icon0

A. Calculations

B. Formulas

C. Functions

D. Relative addressing

10. Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?
comments icon0

A. workbook

B. row

C. column

D. cell
11. In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?
comments icon0
A. Counting

B. Length

C. Counter

D. Count

12. Main window in a computer spreadsheet is called ___________ ?
comments icon0

A. Work

B. Work book

C. Work sheet

D. Account book

13. How many columns are in one Microsoft Excel sheet?
comments icon0
A. 16,384

B. 65,536

C. None of Above

D. 1,048,576

14. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?
comments icon0

A. Decoration

B. Data appearance

C. Charting

D. Functions

15. Ctrl+Shift+1 shortcut Keys in excel are used to __________?
comments icon0

A. Format number in currency format

B. Format number in time format

C. Formatnumber in dateformat

D. Formatnumber in commaformat
16. In a computer spreadsheet rows are labeled ________ ?
comments icon0

A. by symbols

B. by letters

C. by numbers

D. by cell references

17. Microsoft Excel 2019 files have a default extension of___________?
comments icon0

A. .Xls

B. .Xlsx

C. .excel

D. 0.123

18. which of the following is not a valid Zoom percentage in Excel?
comments icon0

A. 300

B. 500

C. 100

D. 10

19. You can set page border in excel from: __________?
comments icon0

A. From Border tab in Format Cells dialog box

B. From Line Style tool in Drawing toolbar

C. You can not set page border in Excel

D. From Border tool in Formatting toolbar

20. Which Operation cant be performed by Queue?
comments icon0
A. Traversing

B. Deletion

C. Insertion

D. Retrieving

21. Microsoft Office Suite spreadsheet program is _________?
comments icon0

A. Microsoft PowerPoint

B. Microsoft Excel

C. Microsoft Word

D. None of these

22. Which of the following will not enter data in a cell?
comments icon0
A. Pressing the Esc key

B. Pressing the Tab Key

C. Both of these

D. None of above

23. Microsoft Office InterConnect is:
comments icon0

A. A scanning and OCR application

B. Business-relationship database

C. None of these

D. An application that supports editing scanned documents

24. Which of the following you can paste selectively using Paste Special Command?
comments icon0

A. mulas

B. l of above

C. mats

D. idation

25. An excel workbook is a collection of __________?
comments icon0

A. Worksheets

B. Charts

C. Worksheets and Charts

D. Workbooks

26. You can edit existing Excel data by pressing the:________ key?
comments icon0

A. F4 Key

B. F3 Key

C. F2 Key

D. F1 Key

27. Which Shortcut keys are used to strikethrough highlighted selection in Excel?
comments icon0

A. None of the above.

B. Ctrl+5

C. Ctrl+4

D. Ctrl+6

28. In Ms Excel, which of the following special function keys allow the content in cell?
comments icon0

A. Shift

B. Tab

C. Space

D. Esc

29. Which element is deficient in milk _________?
comments icon0

A. Sodium

B. Calcium

C. Phosphorus

D. Iron
30. If you press ___, the cell accepts your typing as its contents ?
comments icon0

A. Alt+Enter

B. Tab

C. Ctrl+Enter

D. Enter
31. In a computer spreadsheet, first part of number format describes __________ ?
comments icon0
A. Positive number

B. Negative number

C. Text values

D. Zero values

32. Getting data from a cell located In a different sheet is called ___________?
comments icon0
A. Referencing

B. Accessing

C. Functioning

D. Updating

33. How many rows are in one Microsoft Excel sheet?
comments icon0
A. 1,048,576

B. 65,536

C. None of Above

D. 16,384

34. What displays the content of active cell?
comments icon0

A. Row headings

B. None of these

C. Formula bar

D. Name box

35. Title bar in MS-Excel displays name of the __________ ?
comments icon0

A. Location

B. Workbook

C. Formula

D. Worksheet

36. Which function displays row data into column or column data into row?
comments icon0

A. Hyperlink

B. Rows

C. Transpose

D. Index

37. When you insert an Excel file into a word document, the data are?
comments icon0
A. linked

B. placed in a word table

C. Hyperlinked

D. embedded

38. In a computer spreadsheet, each cell contain a __________ ?
comments icon0

A. label

B. All of these

C. Formula

D. Value

39. Move to next cell in row in Ms Excel:
comments icon0
A. Tab

B. Space

C. Shift

D. None of these

40. In MS Excel, Conditional Formatting is in ______ tab?
comments icon0

A. Insert

B. View

C. Home

D. Page Layout

41. Which of these keys are used in Ms Excel to copy value from above cell?
comments icon0

A. Ctrl+ E

B. Ctrl +

C. Ctrl+ D

D. Ctrl+ E

42. Actual working area of Computers Microsoft Excel is ________ ?
comments icon0

A. Workbook

B. Notesheet

C. Notebook

D. Worksheet
43. The term chart wizard data in MS is refer to_________?
comments icon0
A. Horizontal axis

B. Vertical axis

C. Bar data

D. None of these

44. In a computer spreadsheet, block of cells is called __________ ?
comments icon0

A. Column

B. Range

C. Function

D. Workbook

45. Which of following is not an element of computer spreadsheet interface?
comments icon0

A. Workbook

B. Active cell

C. Menu bar

D. Pencil work
46. Which of these keys are used in Ms Excel to copy formula from above cell?
comments icon0

A. Ctrl+:

B. Ctrl+ ;

C. . Ctrl+

D. Ctrl+

47. In Ms Excel Ready made templates are available under _______ tab ?
comments icon0

A. Design

B. File

C. Insert

D. None of Above

48. Top open an existing workbook, click the open button on the___________toolbar?
comments icon0

A. Drawing

B. Formatting

C. standard

D. form

49. in MS-Excel__________ short cut key is used for hiding rows.
comments icon0

A. None of the above

B. Ctrl+7

C. Ctrl+9

D. Ctrl+H

50. In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ?
comments icon0

A. 1.5

B. 2

C. 12

D. 7