Microsoft Excel Section 1 Page 5


101.
What is the shortcut key to highlight the entire column?
Ctrl + C
Ctrl + Enter
Ctrl + Page Up
Ctrl + Spacebar
Answer: Option

102.
Which of the following is correct to add the numbers A2 and A10?
=SUM(A2,A10)
=SUM(A2:A10)
=SUM(A2 and A10)
=SUM(A2 to A10)
Answer: Option

103.
To see the daily movement of NEPSE index which chart is more useful?
Column Chart
Pie Chart
Row Chart
Line Chart
Answer: Option

104.
Which type of field is incremented automatically?
Auto Elevate
Auto Number
Auto Increment
Auto Value
Answer: Option

105.
When the formula bar is activated in MS Excel, you can see……
Edit Formula Button
Cancel Button
Enter Button
All of the above
Answer: Option

106.
You can create hyperlinks from the excel workbook to……
A webpage on company internet
A webpage on the internet
Other Office Application Documents
All of the above
Answer: Option

107.
What function changes row data in a column or column data in row?
Transpose
Index
Rows
Hyperlink
Answer: Option

108.
The cell reference for cell range of A1 to A10 is ……
=A1.A10
=A1;A10
=A1:A10
=A1-A10
Answer: Option

109.
…… is known as drop down list.
List
Combo List
Text Box
None of the above
Answer: Option

110.
In excel a numeric value can be treated as a label value if it precedes with ……
Apostrophe (')
Exclamation (!)
Hash (#)
Ampersand (&)
Answer: Option

111.
Which of the formula is an absolute cell reference?
!C!!
$C$1
#C#1
C1
Answer: Option

112.
The cell reference for a range of cell that starts in Cell A1 and goes over to column C and down to row 10 is……
A1:10C
A1:C10
A1:C-10
A1:C:10
Answer: Option

113.
We use …… operator to multiply in MS Excel.
*
x
/
<=
Answer: Option

114.
To merge a cell which tab do you use from the format cell menu?
Number Tab
Alignment Tab
Font Tab
Merge Tab
Answer: Option

115.
In MS Excel, if you press …… excel accepts your typing as cell contents?
Insert
Ctrl + Enter
Enter
Insert
Answer: Option

116.
OR operator shows True value when……
All conditions are false
Any one condition is true
Both Condition are true
None of the above
Answer: Option

117.
Getting data from another sheet in MS Excel is called ……
Functioning
Referencing
Updating
Accessing
Answer: Option

118.
In MS Excel what do you mean by a workspace?
Group of workbooks
Group of columns
Group of worksheets
Group of rows
Answer: Option

119.
A character that is raised and smaller above the base is called……
Outlined
Raised
Subscript
Superscript
Answer: Option

120.
…… is an example of relative cell reference?
A10
A$10
$A10
$A$10
Answer: Option

121.
The advantage of using the spreadsheet is……
Calculation can be done automatically
Changing data automatically updates calculation
More Flexibility
All of the above
Answer: Option

122.
In excel, by default numeric values appears in ……
Left aligned
Right Aligned
Centered
Can be anywhere
Answer: Option

123.
A logical if function inside another logical if function is called…..
Nested if function
If function
Formula
nested function
Answer: Option

124.
How can we view a cell comment in MS Excel?
Position the mouse pointer over the cell
Click the comment command on the view menu
Click the edit comment commands on the insert menu
Click the display comment command on the window menu
Answer: Option

125.
The ……feature of MS Excel quickly completes a series of data.
Autocomplete
Autofill
Fill handle
Sorting
Answer: Option

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

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