microsoft excel MCQs – Page 3

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

microsoft excel Mcqs
41. Actual working area of Computers Microsoft Excel is ________ ?
comments icon0

A. Workbook

B. Notesheet

C. Notebook

D. Worksheet
42. 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

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

A. Column

B. Range

C. Function

D. Workbook

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

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?
comments icon0

A. Ctrl+:

B. Ctrl+ ;

C. . Ctrl+

D. Ctrl+

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

A. Design

B. File

C. Insert

D. None of Above

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

A. Drawing

B. Formatting

C. standard

D. form

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

49. 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
50. Which of these will not select all the cells in a document ?
comments icon0
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

51. In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?
comments icon0

A. you will be in the cell A1

B. you will be in the cell B5

C. you will be in the cell B3

D. you will be in the cell B6

52. Which of the following is the latest version of MS Excel?
comments icon0

A. Excel 2017

B. Excel 2016

C. Office 365

D. Excel 2019
53. User developed instruction for excel are called__________?
comments icon0

A. All of these

B. Procedured

C. Progrms

D. Macros
54. The default style for new data keyed in a new workbook is ___________?
comments icon0

A. Currency

B. Percent

C. Comma

D. Normal
55. In excel columns are labelled as____________?
comments icon0

A. 1, 2, 3,etc.

B. $A$1, $A$2, etc.

C. A1,A2,A3, etc.

D. A,B, C,etc.
56. Which one is example of spreadsheet software?
comments icon0

A. None of these

B. MS POWERPOINT

C. MS EXCEL

D. MS WORD

57. Microsoft Office Accounting is:
comments icon0

A. None of these

B. A tool for managing business finances

C. Diagram and flow-charting software

D. Project management software to keep track of events and to create network charts and Gantt charts

58. Which key is used for help in Ms Excel?
comments icon0

A. F3

B. None of these

C. F2

D. F1
59. In MS Excel to delete duplicate values which menu is used?
comments icon0
A. Data

B. Formatting

C. Layout

D. Tools

60. The first cell in excel worksheet is labeled as _________?
comments icon0

A. Aa

B. AA

C. A1

D. None of these