Toggle navigation
Login / Register
Ask Questions
Study
Current Affairs
Previous Papers
Kerala PSC
IBPS
UPSC
RBI
TNPSC
MPSC
SSC
CBSE
United States
Model Tests
News
More
Answers
Coaching Centres
Careers
Downloads
Colleges
Kuwait News & Classifieds
Classic Jhumka Earrings Silver
INR 113.00
Free Shipping
Buy Now
Black Jhumka Earrings & Studs
INR 94.00
Free Shipping
Buy Now
Classic Jhumka Earrings Silver
INR 207.00
Free Shipping
Buy Now
Beautiful stud earing
INR 93.00
Free Shipping
Buy Now
Different Size Hoop and Stud Earrings Set
INR 243.00
Free Shipping
Buy Now
Golden Hoop Earing
INR 70.00
Free Shipping
Buy Now
×
Create account with Openguide
Sign Up
By clicking Sign Up, you agree that you have read and accepted the
Open Guide Online User Agreement.
Already have an account?
Log in
×
Login to OpenGuide
Login
Forgot password?
Reset it
New user?
Register
×
Reset your password
Reset Password
Registered user?
Log in
New user?
Register
Home
Questions & Answer
Technology Questions & Answers
MS Office Questions & Answers
MS Office Questions & Answers
(Compiled from UPSC, SSC ,PSC ,IBPS previous question papers)
In Paste Special dialog box, which of the following option is not available ?
A
Divide
B
Add
C
Subtract
D
Square root
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
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
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
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
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
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
One cell format can be copied to another cell by using ?
A
Format Painter
B
Format Setting
C
Format Showing
D
Format Checking
Which dialogue box we can use to name a constant ?
A
Create Name
B
Define Name
C
Get Name
D
Create Constant
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
The intersection of row and column is called a ?
A
dataset
B
cell
C
data
D
set
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
When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors.
A
True
B
False
C
Answer And Explan
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
We can cancel marquee by pressing ?
A
Ctrl + Esc
B
Alt + Esc
C
Shift + Esc
D
Esc
What term refers to a specific set of values saved with the workbook ?
A
Range
B
File set
C
Data set
D
Scenario
Insert picture option is in which of the following toolbars ?
A
Standard
B
Formatting
C
Drawing
D
Picture
Where are the status indicators located ?
A
Horizontal Scroll
B
Vertical Scroll
C
Formula bar
D
Address bar
Entire worksheet can not be selected in one time.
A
True
B
False
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
How many recent files you can display on File menu at maximum ?
A
3
B
7
C
9
D
15
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
Which function will you use to enter current time in a woksheet cell ?
A
=time()
B
=nowtime()
C
=now()
D
=currentTime()
Style sheet formats can be applied from ?
A
Table >> Autoformat
B
Format >> Autoformat
C
Table >> Cells
D
Fromat >> Cells
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
Shortcut to enter current date ?
A
Home + ;
B
Shift + ;
C
Alt + ;
D
Ctrl + ;
Shortcut to delete the selected column ?
A
Ctrl + -
B
Alt + -
C
Shift + -
D
Insert + -
Which shortcut can be used to Switch between open workbooks ?
A
Ctrl + F2
B
Ctrl + F6
C
Ctrl + F8
D
Ctrl + F10
Each excel can contain many sheets including worksheets and chart sheets.
A
True
B
False
Shortcut to edit the selected cell ?
A
F3
B
F8
C
F4
D
F2
1
2
3
4
5
Categories
Android
C programming
C++ programming
Cloud Computing
Computer
Computer System Architecure
Data Base
Data Structure
Internet & Social Media
Java programming
Manual Testing
MS Office
MySQL
Networking
Operating System
PHP
Programming
Software Engineering
Software Testing
Help & Support
About Us
Contact Us
Terms of Service