Excel Interview Questions Part 3
1.
The Software which contains rows and columns is
called ______?
Ans. SPREADSHEET
2.
A function inside another function is called
_______?
Ans. NESTED
3.
Formatting a cell in Currency, you can specify?
Ans. CURRENCY
SYMBOL
4.
Which function will you use to enter current
time in a worksheet cell ?
Ans. =NOW()
5.
What type of chart will you use to compare
performance of two employees in the year 2016 ?
Ans. LINE
6.
Which one is not a Function in MS Excel ?
Ans. AVG
7.
Functions in MS Excel must begin with ___?
Ans. =
8.
Which of the following format you can decide to
apply or not in AutoFormat dialog box ?
Ans. FONT,
NUMBER, BORDER
9.
What is entered by the function =today() ?
Ans. CURRENT
DATE
10.
You can check the conditions against __________
when applying conditional formatting
Ans. FORMULA,
CELL VALUE
11.
Which of the following you can paste selectively
using Paste Special command ?
Ans. FORMATS,
VALIDATION, FORMULAS
12.
Long text can be broken down into many lines
within a cell. You can do this through?
Ans. WRAP TEXT
13.
Getting data from a cell located in a different
sheet is called....
Ans. REFERENING
14.
Comments put in cells are called .....?
Ans. CELL TIP
15.
Which of the following is not a valid data type
in Excel ??
Ans. CHARACTER
16.
Which area in an Excel window allows entering values
and formulas ?
Ans. FORMULA
BAR
17.
Multiple calculations can be made in a single
formula using.
Ans. ARRAY
18.
To return the remainder after a number is
divided by a divisor in EXCEL we use the function ?
Ans. MOD()
19.
How do you rearrange the data in ascending or
descending order ?
Ans. DATA,SORT
20.
Excel displays the current cell address in the
....
Ans. NAME BOX
