Advanced MS excel questions and answers for competitive exams for Banking, IBPS, RRB, RBI, SBI Exams, Patwari, Defense, Nda, Constable, RS CIT, Computer Quiz for Railway and SSC Exams.
MS excel objective questions and answers, ms excel mcq, how to make excel sheet, formula in excel.
MS Excel is an electronic spreadsheet. This application allows you to perform thousands of calculations at once. Currently this microsoft excel application is used a lot. Opening the Excel file will display a workbook in which three worksheets are displayed by default. You can open new sheets and name them as per your requirement.
|
Q 31.
A worksheet range is a ?
Ans.
A group of cells
|
|
Q 32.
How many characters can be typed in a single cell in Excel ?
Ans.
65535
|
|
Q 33.
Comments can be added to cells using which menu option ?
Ans.
View -> Comments
|
|
Q 34.
In MS Excel, to delete an embedded objects, first ?
Ans.
Press the Shift + Delete keys
|
|
Q 35.
Which elements of excel worksheet can be protected from accidental modification ?
Ans.
Scenarios
|
|
Q 36.
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?
Ans.
Press Alt + Home
|
|
Q 37.
The Paste Special command lets you copy and paste ?
Ans.
Formatting options
|
|
Q 38.
In excel, we can use to create a formula ?
Ans.
Cell references but not values
|
|
Q 39.
Which area in an excel window allows entering values and formulas ?
Ans.
Standard toolbar
|
|
Q 40.
To copy formatting from one area in a worksheet and apply it to another area by ?
Ans.
Format Painter button on the standard toolbar
|
|
Q 41.
In Excel, multiple calculations can be made in a single formula using ?
Ans.
Complex formulas
|
|
Q 42.
Comments put in cells are called ?
Ans.
Cell tip
|
|
Q 43.
When integrating Ms-Word and Excel, Word is usually the ?
Ans.
Client
|
|
Q 44.
How do you delete a entire column ?
Ans.
Right click the column heading you want to delete and select delete from the shortcut menu
|
|
Q 45.
Text formulas in Excel ?
Ans.
Return ASCII values of characters
|
|
Q 46.
What is the default row height value of MS Excel ?
Ans.
15
|
|
Q 47.
Typed text showed in active cell and also shows in ?
Ans.
Formula bar
|
|
Q 48.
In MS Excel formula always begins with an ?
Ans.
Equal sign
|
|
Q 49.
Which area is identifies a cell in Excel?
Ans.
Address
|
|
Q 50.
What is the extension of saved file in MS Excel ?
Ans.
.xls
|
|
Q 51.
In Excel, how to uniquly identify the cellname with in a worksheet ?
Ans.
By Column letters and Row numbers
|
|
Q 52.
What will happen, when right click on something in Excel ?
Ans.
Its open a shortcut menu which listing everything that you can do to the object.
|
|
Q 53.
How do you select the entire column ?
Ans.
By click on the column heading letter
|
|
Q 54.
How you can activate a cell in excel ?
Ans.
- By pressing the tab key
- Clicking on cell - Pressing the arrow key |
|
Q 55.
VLOOKUP function is used for ?
Ans.
To find related records.
|
|
Q 56.
How we can set the page border in MS Excel ?
Ans.
We can not set the page border in Excel.
|
|
Q 57.
What function display row data ina column or Column data in a row ?
Ans.
Transpose
|
|
Q 58.
We can convert existing Excel worksheet data and charts to HTML document by using the ?
Ans.
Internet Assistant Wizard
|
|
Q 59.
If you press _____ the cell accepts your typing information as its content.
Ans.
Enter
|
|
Q 60.
In excel, how we can view a cell comment ?
Ans.
To position the mouse pointer over the cell.
|