Most Important MS Excel Questions And Answers.
A quick MS Excel Questions & Answer revision. Top-level selected questions for your interview and all competitive exam like Bank PO, Civil Services, Railway, etc.
Q – When we save MS Excel file, what is the default
extension?
Ans : .xml
Q – In MS
Excel, VBA stands for ?
Ans : Visual Basic For Applications.
Q – Which version used First time VBA option?
Ans: Excel 5 Version
Q – How many
character a cell can contain.
Ans – 32,767
Q – What IS a
short cut key to creating a bar graph within a second?
Ans : Function Key F11
Q – By which
sign, we can fix a table array?
Ans : By putting $ sign (Table A1:E10) We can fix
the table (Table $A$1:$E$10)
Q – Short cut
key to open a new workbook?
Ans : Ctrl + N
Q – In which
year Microsoft company launched the first version of MS Excel?
Ans: 1987
Q – X, Y
Chart called in MS Excel?
Ans: Scatter Chart
Q – How to
print anything in excel
Ans: By pressing Ctrl + P Button
Q – What is
filter in MS Excel?
Ans: A filter is use to sort the data, we can get information
easily by applying filters in a huge database.
Q – What is
the shortcut to apply filter in Excel sheets?
Ans : Select the column, press Ctrl + Shift + L
Q – How to
lock your Computer by short cut key?
Ans : Window + L
Q – If there
are two functions, and inside one function there is one more function, what
does it call?
Ans : Nested Function
Q – Which function
can show current data and time.
Ans : Now Function
Q – How many
sheets available by default in Excel Workbook
Ans : 3
Q – Is it
true, each cell in MS Excel has a unique address
Ans : Yes. Each cell has its own unique address like
. A1, A2.. B1, B2..
Q – Why we
use the comment option in MS Excel?
Ans : With The help of comments, we can write any information
related to the cell or what we like to remember. it is a small note over the
cell. It can clarify the purpose of the cell. We can also mention the formula
or any location in the comment box.
Q – What is
the shot cut of Comment.
Ans : Shift + F2
Q – Why we
use freeze Row or Column.
Ans : Freeze is use to fix upper heading or side row
data. Freeze is use to freeze the upper column or starting left-hand side rows.
After freezing any row or cell, the portion fixes, and we can move all over the
workbook but the frozen cell or row doesn’t move.
Q – What is
the Difference Count, Countblank, CountA, Countif, Countifs
Ans :
Count: is
use to count only numeric values or data.
CountA: means Count All, it is used to count any
value in the cell except blank
CountBlank: is use to count the blank values only.
Countif: is use for logical values, text logical
function. It means count the value if the criteria match.
Countries: is use to check multiple logical
conditions.
Q - What is the short cut key to get the sum value
Ans: Alt + (Alt and press plus button)
If you have any queries, kindly put your comments below for more clarification. You can also give your precious advice in the comment section below.
Comments
Post a Comment