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 1.
To open the formula window in excel, press ?
Ans.
Shift + F3
|
|
Q 2.
Which creates a chart of the data in the current range ?
Ans.
Alt + F1
|
|
Q 3.
What is the shortcut key to insert a new Worksheet ?
Ans.
Alt + Shift + F1
|
|
Q 4.
Which shortcut key opens the Go To Dialog box ?
Ans.
F5
|
|
Q 5.
Who is the father of MS Excel ?
Ans.
Charles Simonyi
|
|
Q 6.
In excel, which one denoted a range from C1 through E9 ?
Ans.
C1:E9
|
|
Q 7.
The Greator than sign ( > ) is an example of ?
Ans.
Logical operator
|
|
Q 8.
To display the open dialog box, press ?
Ans.
Ctrl + O
|
|
Q 9.
To minimize the currently selected window, press ?
Ans.
Ctrl + F9
|
|
Q 10.
What is the shortcut key to highlight the entire row ?
Ans.
Shift + Spacebar
|
|
Q 11.
What is the shortcut key to highlight the entire column ?
Ans.
Ctrl + Spacebar
|
|
Q 12.
In excel, data can be sorted using ?
Ans.
Filter function
|
|
Q 13.
Open workbooks can easily be switched using shortcut key ?
Ans.
Ctrl + tab
|
|
Q 14.
A workbook can be closed by which command ?
Ans.
Ctrl + W
|
|
Q 15.
In Excel, which shortcut key is used to open the 'Save As Dialog Box' ?
Ans.
F12
|
|
Q 16.
To insert three column between D and E, you would ?
Ans.
Select column E, F and G
|
|
Q 17.
What is the shortcut key to insert a new sheet in a current Workbook ?
Ans.
Shift + F11
|
|
Q 18.
The name box _______.
Ans.
Appears to the left of the formula bar
|
|
Q 19.
Which shortcut key is used to replace a data within worksheet ?
Ans.
Ctrl + H
|
|
Q 20.
In Excel, by default Numeric Values appears in which alignment ?
Ans.
Right aligned
|
|
Q 21.
Ctrl + D shortcut key is Excel used for ?
Ans.
Fill down in the selection
|
|
Q 22.
Which shortcut key is used to hide entire Column ?
Ans.
Ctrl + 0
|
|
Q 23.
Which shortcut key is used to hide entire row in Ms Excel ?
Ans.
Ctrl + 9
|
|
Q 24.
The first cell in excel worksheet is labeled as ?
Ans.
A1
|
|
Q 25.
What is the latest version of Excel ?
Ans.
2019
|
|
Q 26.
Using the F 11 shortcut key to create a chart on chart sheet creates ?
Ans.
A 2-dimensional column chart
|
|
Q 27.
Which type of chart is good for single series of data ?
Ans.
Pie chart
|
|
Q 28.
The ______ feature of MS Excel quickly completes a series of data.
Ans.
Auto fill
|
|
Q 29.
Which one is the oldest spreadsheet package ?
Ans.
VisiCalc
|
|
Q 30.
In excel concatenation of text can be done using ?
Ans.
Ampersand (&)
|