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

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

53. 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
54. User developed instruction for excel are called__________?
comments icon0

A. All of these

B. Procedured

C. Progrms

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

A. Currency

B. Percent

C. Comma

D. Normal
56. 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.
57. Which one is example of spreadsheet software?
comments icon0

A. None of these

B. MS POWERPOINT

C. MS EXCEL

D. MS WORD

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

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

A. F3

B. None of these

C. F2

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

B. Formatting

C. Layout

D. Tools

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

A. Aa

B. AA

C. A1

D. None of these

62. 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
63. Which function calculates the largest value in a set of numbers?
comments icon0
A. Maximum

B. Count

C. Average

D. Minimum

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

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

B. Greater

C. Conditional

D. Arithmetic

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