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)
What is shortcut to enter current date in cell in excel ?
A
Ctrl + ;
B
Alt + ;
C
Shift + &
D
Ctrl + $
Which function converts miles to kilometers ?
A
Change
B
Covnert
C
Shift
D
Conv
Which function in excel counts the numbers of characters in a cell ?
A
LENGHT
B
LGT
C
LT
D
LEN
Which among following is divide symbol in excel ?
A
/
B
D
C
Div
Which among following wildcard characters are recognized by excel ?
A
+ and -
B
! and ^
C
* and ?
D
< and >
Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.
A
True
B
False
C
Answer An
3-D reference in a formula ?
A
Spans worksheets
B
Can not be modified
C
Only appears on summary worksheets
D
Limits the formatting options
The accounting style shows negative numbers in ?
A
Bold
B
Italics
C
Parentheses
D
Quotes
Which function is used for creating a data table ?
A
Sum
B
Table
C
Add
D
Count
What excel feature can you use if you want to work with one record at a time ?
A
Auto Complete
B
Data Form
C
Set Form
D
Auto Text
A function inside another function is known as ?
A
Round function
B
Sandwich function
C
Switch function
D
Nested function
You can activate a cell by ?
A
Pressing the Tab key
B
Clicking the cell
C
Pressing an arrow key
D
All of above
To drag a selected range of data to another worksheet in the same workbook, use the ?
A
Ctrl key
B
Shift key
C
Alt key
D
Tab key
To insert three columns between columns A and B you would
A
Select column A
B
Select A and B
C
Select B
D
All of above
How do you change column width to fit the contents ?
A
Single-click the boundary to the left to the column heading
B
Double click the boundary to the right of the column heading
C
Press Alt and single click anywhere in the column
D
All of above
Gridlines may be turned off for display but turned on for printing.
A
True
B
False
VLOOKUP function used to ?
A
Finds related records
B
Looks up text that contain "v"
C
Check if two cells are identical
D
None of above
How is data organized in a spreadsheet ?
A
Rows and columns
B
Layers and planes
C
Lines and spaces
D
Height and width
Which types of charts can excel produce ?
A
Line graphs and pie charts only
B
Bar charts, line graphs and pie charts
C
Bar charts and line graphs only
D
Only line graphs
Which function calculates your monthly mortage payment ?
A
PV
B
NPER
C
PMT
D
All of above
How can we set Page Border in Excel ?
A
From Edit menu
B
From Home
C
You can not set page border in Excel
D
From Tools menu
You can check the conditions against ____ when applying conditional formatting ?
A
Cell Value
B
Formula
C
Both of above
D
None of above
Which of the following is not a valid Zoom percentage in Excel ?
A
10
B
100
C
300
D
500
Protection and the Protect Sheet options can be selected from ?
A
Data
B
Tools
C
Edit
D
Format
Macros can be executed from the which of the following menu ?
A
Format
B
Home
C
Insert
D
Tools
Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
A
NOT
B
OR
C
IF
D
AND
E
Answer And Explana
What function displays row data in a column or column data in a row ?
A
Transpose
B
Index
C
Rows
D
Hyperlinks
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?
A
HTML
B
Pivot Table Field List
C
Pivot Table Report
D
Pivot Table List
You can convert existing Excel worksheet data and charts to HTML document by using the ?
A
Internet Assistant Wizard
B
Intranet Wizard
C
Import Wizard
D
Export Wizard
The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?
A
C1:10H
B
C1:H10
C
C1:H-10
D
C1:H:10
E
Answer And
‹ First
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