microsoft excel MCQs – Page 2

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

microsoft excel Mcqs
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 items can Excel paste selectively with the Paste Special command?
comments icon0

A. Formulas

B. All of the above

C. Formats

D. Validation rules

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. What is the maximum number of rows in a modern Microsoft Excel worksheet?
comments icon0
A. 1,048,576

B. 65,536

C. 16,384

D. 1,000,000

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