41. Which among following wildcard characters are recognized by
excel ?
A. + and -
B. ! and ^
C.
* and ?
D. < and >
Answer: Option C
Explanation:
42. Which among following is divide symbol in excel ?
A. /
B. D
C.
Div
D. \
Answer: Option A
·
43. Which function in excel counts the numbers of characters in
a cell ?
A.
LENGHT
B.
LGT
C.
LT
D.
LEN
Answer: Option D
Explanation:
44. Which function converts miles to kilometers ?
A. Change
B. Covnert
C.
Shift
D. Conv
Answer: Option B
Explanation:
45. What is shortcut to enter current date in cell in excel ?
A. Ctrl + ;
B. Alt + ;
C.
Shift + &
D. Ctrl + $
Answer: Option A
Explanation:
46. Shortcut to edit the selected cell ?
A. F3
B. F8
C.
F4
D. F2
Answer: Option D
Explanation:
47. Each excel can contain many sheets including worksheets and
chart sheets.
A. True
B. False
Answer: Option A
Explanation:
48. Which shortcut can be used to Switch between open workbooks
?
A. Ctrl + F2
B. Ctrl + F6
C.
Ctrl + F8
D. Ctrl + F10
Answer: Option B
Explanation:
49. Shortcut to delete the selected column ?
A. Ctrl + -
B. Alt + -
C.
Shift + -
D. Insert + -
Answer: Option A
·
50. Shortcut to enter current date ?
A.
Home + ;
B.
Shift + ;
C.
Alt + ;
D.
Ctrl + ;
Answer: Option D
Explanation:
51. When the formula bar is activated, you can see
A. The Edit Formula button
B. The Cancel button
C.
The Enter button
D. All of above
Answer: Option D
Explanation:
52. Style sheet formats can be applied from ?
A. Table >> Autoformat
B. Format >> Autoformat
C.
Table >> Cells
D. Fromat >> Cells
Answer: Option B
Explanation:
53. Which function will you use to enter current time in a
woksheet cell ?
A. =time()
B. =nowtime()
C.
=now()
D. =currentTime()
Answer: Option C
Explanation:
54. Merge cells option can be applied from ?
A. Formatting toolbar
B. Format Cells dialog box
Alignment Tab
C.
Both of above
D. None of above
Answer: Option B
Explanation:
55. How many recent files you can display on File menu at
maximum ?
A. 3
B. 7
C.
9
D. 15
Answer: Option C
Explanation:
56. The name box appears at the ?
A. left of the formula bar
B. right of the formula bar
C.
below the status bar
D. below the menu bar
Answer: Option A
·
57. Entire worksheet can not be selected in one time.
A.
True
B.
False
Answer: Option B
Explanation:
58. Where are the status indicators located ?
A. Horizontal Scroll
B. Vertical Scroll
C.
Formula bar
D. Address bar
Answer: Option C
Explanation:
59. Insert picture option is in which of the following toolbars
?
A. Standard
B. Formatting
C.
Drawing
D. Picture
Answer: Option D
Explanation:
60. What term refers to a specific set of values saved with the
workbook ?
A. Range
B. File set
C.
Data set
D. Scenario
Answer: Option D
Explanation:
61. We can cancel marquee by pressing ?
A. Ctrl + Esc
B. Alt + Esc
C.
Shift + Esc
D. Esc
Answer: Option D
Explanation:
62. Which of the following methods cannot be used to edit the
content of cell ?
A. Pressing F2
B. Clicking the formula bar
C.
Pressing the Alt key
D. Double clicking the cell
Answer: Option C
Explanation:
63. When you use multiplication, division or exponentiation in a
formula then there is chance of occurring rounding errors.
A. True
B. False
Answer: Option A
·
64. Which among following can't be considered as worksheet
criterion ?
A. Efficiency
B. Auditability
C.
Clarity
D. Description
Answer: Option D
Explanation:
65. When creating a vertical page break ?
A. The active cell must be in row
1
B. The active cell must be A1
C.
The active cell must be in row 10
D. The active cell must be in
column A
Answer: Option A
Explanation:
66. The intersection of row and column is called a ?
A. dataset
B. cell
C.
data
D. set
Answer: Option B
Explanation:
67. You will use which feature in excel, if you want to work
with one record at a time ?
A. Auto Complete
B. Auto Filter
C.
Sub Totals
D. Data Form
Answer: Option D
Explanation:
68. Which dialogue box we can use to name a constant ?
A. Create Name
B. Define Name
C.
Get Name
D. Create Constant
Answer: Option B
Explanation:
69. One cell format can be copied to another cell by using ?
A. Format Painter
B. Format Setting
C.
Format Showing
D. Format Checking
Answer: Option A
Explanation:
70. Which among following is types of excel data types ?
A. Numbers, Formulas, Labels
B. Data, Words, Numbers
C.
Words, Number, Labels
D. Equations, Data, Numbers
Answer: Option A
·
71. To join some cells and place the content at the middle of
joined cell, which tool you will use?
A.
From Format Cells dialog box choose Merge and Center check box
B.
Click on Merge and Center tool on formatting toolbar
C.
From Format Cells dialog box select the Centered alignment
D.
From Format Cells dialog box click on Merge Cells check box
Answer: Option B
Explanation:
72. On Excel screen, Tab scroll buttons are
A. towards the top left corner
B. towards the top right corner
C.
towards the bottom right corner
D. towards the bottom left corner
Answer: Option D
Explanation:
73. Choose from the following, which is not the correct method
of editing the cell content ?
A. Press the Alt key
B. Press the F2 key
C.
Double click the cell
D. Click the formula bar
Answer: Option A
Explanation:
74. In Excel Worksheet how can you show or hide the gridlines ?
A. Click Gridline tool on Forms
toolbar
B. Go to Tools -> Options ->
View tab and mark or remove the check box named Gridline
C.
Both of above
D. None of above
Answer: Option C
Explanation:
75. When you press Ctrl + X after selecting some cells in Excel,
what will happen then
A. The cell content of selected
cells disappear from cell and stored in clipboard
B. The selected cells are deleted
and cells are shifted up
C.
The selected cells are deleted and the cells are shifted left
D. The cells selected are marked
for cutting
Answer: Option D
Explanation:
76. In Paste Special dialog box, which of the following option
is not available ?
A. Divide
B. Add
C.
Subtract
D. Square root
Answer: Option D
Explanation:
77. To convert a column of data into row, which command will you
choose
A. Edit -> Paste Special -> Transpose
B. Cut and Paste
C.
Both of above
D. None of above
Answer: Option A
78. Using Paste Special command which of the following you can
paste selectively
A.
Formulas
B.
Validation
C.
Formats
D.
All of above
Answer: Option D
