Microsoft Excel Section 1 Page 2


26.
The greater than sign (<) is an example of ….. Operator.
Arithmetic
Logical
Conditional
Greater
Answer: Option

27.
In excel sheet the active cell is indicated by……
Dotted Border
A blinking border
A dark wide border
None of the above
Answer: Option

28.
The default row height in a MS Excel worksheet is ……. Points.
10.75
12.75
13.75
15.75
Answer: Option

29.
What is the shortcut key to paste in MS Excel?
Ctrl + Z
Ctrl + V
Ctrl + P
Ctrl + X
Answer: Option

30.
…… is used to join some cells and place the content at the middle of joined cell.
Merge & Center
Merge & Justify
Center & Merge
All of the above
Answer: Option

31.
What is the shortcut key to insert current date in a cell?
Ctrl + D
Ctrl + T
Ctrl + ;
Ctrl + /
Answer: Option

32.
To start data on a new line within a cell, enter a line break by pressing……
Alt + Enter
Shift + Enter
Ctrl + Enter
None of the above
Answer: Option

33.
Absolute reference to cell A4 is given by ……
"@A$4"
"@A4"
"A$4"
"$A$4"
Answer: Option

34.
By default in MS Excel, the number format will be …… aligned in excel.
Justify
Right
Left
Center
Answer: Option

35.
Select the correct formula for addition……
"=SUM(A1:A3)"
"=ADD(A1+A2+A3)"
"=MAX(A1:A3)"
None of the above
Answer: Option

36.
Which symbol is used before a number to make it into a label in MS Excel?
Quote (")
Equal Sign (=)
Underscore
Apostrophe (')
Answer: Option

37.
What is the shortcut key for creating a standalone chart from the selected range of cell?
F2
F4
F8
F11
Answer: Option

38.
Formatting a cell in excel, we can set……
Decimal Place
Currency Symbol
Number Format
All of the above
Answer: Option

39.
What does =COUNTA() function in MS Excel do?
counts cells having alphabets
count empty cells
counts cell having number
counts non-empty cells
Answer: Option

40.
How do you rearrange the data in ascending or descending order
Data. Sort
Data, Form
Data, Table
Data, Subtotals
Answer: Option

41.
In MS Excel what happen when dollar sign are entered in a cell address $A$1:$A&10.
The status bar doesn't display the cell address
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
Answer: Option

42.
The maximum number of rows in MS Excel worksheet is……
65586
32000
1048576
256
Answer: Option

43.
What do you mean by a workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Answer: Option

44.
In MS Excel A7:A9 indicates……
Cell A8
Cell A7 & Cell A9 only
Cell A7 through A9
None of the above
Answer: Option

45.
To insert three columns between column D and column E, we would ……
Select Column D
Select Column E
Select Column E,F and G
Select D, E and F
Answer: Option

46.
The cell labeled F7 refers to……
Function Key F7
Row F, Column 7
Column F, Row 7
Functions available in cell
Answer: Option

47.
Red triangle on the top right corner of a cell shows……
an error
font color
comment
wrong formula
Answer: Option

48.
Which function will calculate the number of workdays between 11/11/2021 and 12/12/2022?
=Workday
=Date
=Networkdays
All of the above
Answer: Option

49.
Which is the text direction option in MS Excel?
Left to Right
Right to Left
Context
All of the above
Answer: Option

50.
Which options can be used to bold all the negative values within the selected cell range?
If sum formula
Page formatting
Data analysis tab
Conditional Formatting
Answer: Option

#buttons=(Ok, Go it!) #days=(20)

Our website uses cookies to enhance your experience. Check Now
Ok, Go it!