Microsoft Excel Section 1 Page 4


76.
In the formula, which sumbol specifies the fixed columns or rows?
$
*
%
&
Answer: Option

77.
A quick and easy way to see the data with some criteria is the …… option.
Consolidate
Sub Total
Sort
Filter
Answer: Option

78.
On the excel sheet the active cell is indicated by……
A dark wide border
A dotted boarder
A blinking boarder
None of the above
Answer: Option

79.
Data can be arranged in a worksheet in an easy to understand manner using ……
Auto Formatting
Applying Styles
Changing Fonts
All of the above
Answer: Option

80.
Filter option in excel is used to ……
Arrange data in alphabetical order
Arrange data in numerical order
Arrange data in chronological order
Get the data that meet certain criteria
Answer: Option

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

82.
MS Excel displays the current cell address in the ……
Formula Bar
Status Bar
Name Box
Title Bar
Answer: Option

83.
In MS Excel formula beings with which symbols?
=
+
(
)
Answer: Option

84.
The formula in cell C5 is =B4+D3. This is copied to cell E8. What will be the formula in D8?
=B4 + C3
=D7 + F6
=D4 + F3
=F7 + D5
Answer: Option

85.
Graphical presentation of worksheet data is called ……
Pivot Table
Graph
Goal Seek
Scenario
Answer: Option

86.
Which of the following is absolute cell reference
$A$1
&A1$
#A$1
#1A#
Answer: Option

87.
What is the shortcut key to select entire row in MS Excel?
Ctrl + Spacebar
Shift + Spacebar
Alt + Spacebar
Ctrl + Shift + Spacebar
Answer: Option

88.
Which language is used to create macros in excel?
Visual Basic
Visual
C++
Java
Answer: Option

89.
Excel displays the current cell address in the ……
Formula Bar
Status Bar
Name Box
Title Bar
Answer: Option

90.
How to display current date and time in MS Excel?
=Time()
=Date()
=Today()
=Now()
Answer: Option

91.
Red triangle at top right corner of a cell indicates…..
there is an error in the cell
the font color of the text in cell is red
there is a comment associated with the cell
the cell can't accept formula
Answer: Option

92.
Which excel diagram is used to compare values across the categories?
Bar Chart
Column Chart
Pie Chart
Line Chart
Answer: Option

93.
In MS Excel, comments put it cells are called ……
Smart Tip
Cell Tip
Web Tip
Soft Tip
Answer: Option

94.
Which of the following methods will not enter data in a cell?
Pressing the ESC key
Pressing an arrow key
Pressing the tab key
Clicking the enter button to the formula bar
Answer: Option

95.
How do you display current date and time in MS Excel?
=date()
=today()
=now()
=time()
Answer: Option

96.
To enter the number as text in MS Excel, we type …… before it.
Colon
Full Stop
Apostrophe
Comma
Answer: Option

97.
Which of the following function is used to paste the row of the MS Excel sheet as column?
Paste
Paste special and transpose
Both of above
None of the above
Answer: Option

98.
We can show the record of table graphically through……
Chart
Table
Formula
None of the above
Answer: Option

99.
Which of the following is the latest version of MS Excel?
Excel 2000
Excel 2003
Excel 2019
Excel 2013
Answer: Option

100.
Operator used to combine text from two cell into one cell.
Ampersand (&)
Equal Sign (=)
Space
All of the above
Answer: Option

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

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