Computer science study desk with a laptop, circuit board and network diagrams

Focused topic practice

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 ?
0

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?
0

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?
0

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.
0

A. Ctrl+!

B. Ctrl + Shift + ;

C. None of these

D. Ctrl+*

5. Excel displays the current cells address in the __________?
0

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 _________ ?
0

A. A3:G3

B. A3 to G3

C. A3?.G3

D. A3-G3

7. Move to Next Sheet in Ms Excel:
0

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 ?
0

A. /

B. *

C. =

D. $

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

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 __________ ?
0

A. workbook

B. row

C. column

D. cell

11. Which Excel function counts the cells containing numbers in a selected range?
0

A. COUNTA

B. COUNTIF

C. SUM

D. COUNT

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

A. Work

B. Work book

C. Work sheet

D. Account book

13. What is the maximum number of columns in a modern Microsoft Excel worksheet?
0

A. 16,384

B. 256

C. 65,536

D. 1,048,576

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

A. Decoration

B. Data appearance

C. Charting

D. Functions

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

A. Format number in currency format

B. Format number in time format

C. Formatnumber in dateformat

D. Formatnumber in commaformat

16. In Excel's default A1 reference style, how are worksheet rows identified?
0

A. Symbols

B. Letters

C. Numbers

D. Cell references

17. What is the default file extension for a standard Microsoft Excel 2019 workbook?
0

A. .xls

B. .xlsx

C. .excel

D. .xlsm

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

A. 300

B. 500

C. 100

D. 10

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

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?
0

A. Traversing

B. Deletion

C. Insertion

D. Retrieving

21. Microsoft Office Suite spreadsheet program is _________?
0

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?
0

A. Pressing the Esc key

B. Pressing the Tab Key

C. Both of these

D. None of above

23. Microsoft Office InterConnect is:
0

A. A scanning and OCR application

B. Business-relationship database

C. None of these

D. An application that supports editing scanned documents

24. Which items can Excel paste selectively with the Paste Special command?
0

A. Formulas

B. All of the above

C. Formats

D. Validation rules

25. An excel workbook is a collection of __________?
0

A. Worksheets

B. Charts

C. Worksheets and Charts

D. Workbooks

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

A. F4 Key

B. F3 Key

C. F2 Key

D. F1 Key

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

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?
0

A. Shift

B. Tab

C. Space

D. Esc

29. Which element is deficient in milk _________?
0

A. Sodium

B. Calcium

C. Phosphorus

D. Iron

30. If you press ___, the cell accepts your typing as its contents ?
0

A. Alt+Enter

B. Tab

C. Ctrl+Enter

D. Enter

31. In a computer spreadsheet, first part of number format describes __________ ?
0

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 ___________?
0

A. Referencing

B. Accessing

C. Functioning

D. Updating

33. What is the maximum number of rows in a modern Microsoft Excel worksheet?
0

A. 1,048,576

B. 65,536

C. 16,384

D. 1,000,000

34. What displays the content of active cell?
0

A. Row headings

B. None of these

C. Formula bar

D. Name box

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

A. Location

B. Workbook

C. Formula

D. Worksheet

36. Which function displays row data into column or column data into row?
0

A. Hyperlink

B. Rows

C. Transpose

D. Index

37. When you insert an Excel file into a word document, the data are?
0

A. linked

B. placed in a word table

C. Hyperlinked

D. embedded

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

A. label

B. All of these

C. Formula

D. Value

39. Move to next cell in row in Ms Excel:
0

A. Tab

B. Space

C. Shift

D. None of these

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

A. Insert

B. View

C. Home

D. Page Layout

41. Actual working area of Computers Microsoft Excel is ________ ?
0

A. Workbook

B. Notesheet

C. Notebook

D. Worksheet

42. The term chart wizard data in MS is refer to_________?
0

A. Horizontal axis

B. Vertical axis

C. Bar data

D. None of these

43. In a computer spreadsheet, block of cells is called __________ ?
0

A. Column

B. Range

C. Function

D. Workbook

44. Which of following is not an element of computer spreadsheet interface?
0

A. Workbook

B. Active cell

C. Menu bar

D. Pencil work

45. Which of these keys are used in Ms Excel to copy formula from above cell?
0

A. Ctrl+:

B. Ctrl+ ;

C. . Ctrl+

D. Ctrl+

46. In Ms Excel Ready made templates are available under _______ tab ?
0

A. Design

B. File

C. Insert

D. None of Above

47. Top open an existing workbook, click the open button on the___________toolbar?
0

A. Drawing

B. Formatting

C. standard

D. form

48. in MS-Excel__________ short cut key is used for hiding rows.
0

A. None of the above

B. Ctrl+7

C. Ctrl+9

D. Ctrl+H

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

A. 1.5

B. 2

C. 12

D. 7

50. Which of these will not select all the cells in a document ?
0

A. Clicking three times with the right mouse button in the spreadsheet

B. None of These

C. Pressing Ctrl + A on the keyboard

D. Using the Edit Select All menu

Previous Next

Showing 1 to 50 of 65 mcqs