MENU
MENU
Engineering
Mechanical Engineering
Electrical Engineering
Chemical Engineering
Aeronautical Engineering
Agriculture Engineering
Civil Engineering
Maths
Reasoning
GK
India GK
World GK
Rajasthan GK
Science
Biology
Chemistry
General Science
Physics
Computer
Basic computer
Internet and email
MS excel
MS word
MS Power point
English
Entrance exams
Online Tests
Articles
Ask Questions
MS excel
Exam Town
>
Questions
>
Computer
>
MS excel
MS excel
MS excel - Section 1
Q1. It is acceptable to let long text flow into adjacent cells on a worksheet when
1
data will be entered in the adjacent cells
2
no data will be entered in the adjacent cells
3
there is not time to format the text
4
there is no suitable abbreviation for the text
Q2. Which command will you choose to convert a column of data into row?
1
Edit >> Paste Special >> Transpose
2
Cut and Paste
3
Both (1) and (2)
4
None of above Answer
Q3. Which of the following option is not available in Paste Special dialog box?
1
SQRT
2
Divide
3
Subtract
4
Add
Q4. What happens when you press Ctrl + X after selecting some cells in Excel?
1
The selected cells are deleted and cells are shifted up
2
The selected cells are deleted and the cells are shifted left
3
The cells selected are marked for cutting
4
The cell content of selected cells disappear from cell and stored in clipboard
Q5. How can you show or hide the gridlines in Excel Worksheet?
1
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
2
Click Gridline tool on Forms toolbar
3
Both (1) and (2)
4
None of above
Q6. Where can you change automatic or manual calculation mode in Excel?
1
Double CAL indicator on status bar
2
Go to Tools >> Options >> Calculation and mark the corresponding radio button
3
Both (1) and (2)
4
None of above
Q7. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
1
Fill Series
2
Fill Across Worksheet
3
Auto Fill Options
4
Custom List
Q8. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
1
{ F }_{ 7 }
2
{ F }_{ 8 }
3
{ F }_{ 9 }
4
{ F }_{ 10 }
Q9. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
1
client
2
source
3
server
4
none
Q10. Which of the following is not the correct method of editing the cell content?
1
Double click the cell
2
Click the formula bar
3
Press the F2 key
4
Press the Alt key
Page 1 of 2
1
2
Contact us if you have any query.
Contact Us
Sign in
New account
E-mail
Password
Remember me
Login
Username
E-mail
Password
I agree to the
Terms
Create Account