microsoft excel MCQs – Page 2

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

microsoft excel Mcqs
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

61. Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?
comments icon0

A. Web Tip

B. Smart tip

C. Soft Tip

D. Cell Tip
62. Which function calculates the largest value in a set of numbers?
comments icon0
A. Maximum

B. Count

C. Average

D. Minimum

63. Computer spreadsheet cell that is highlighted with a heavy border is a _________ ?
comments icon0

A. Cell containing a formula

B. Active cell

C. Cell

D. Locked cell

64. The Greater Than sign is an example of ________ operation ?
comments icon0
A. Logical

B. Greater

C. Conditional

D. Arithmetic

65. In a computer, element which is not a part of chart is ___________ ?
comments icon0

A. Plot area

B. Chart area

C. Fill handler

D. Series