Excel Interview Questions Part 2

 
 Excel Interview Questions Part 2 [20 Questions]

01.   What is the intersection of a column and a row on a worksheet called? 
Ans. Cell

02.   What type of chart is useful for comparing values over categories?
Ans. Column

03.   Which function in Excel tells how many numeric entries are there.
Ans. COUNT

04.   A feature that displays only the data in column (s) according to specified criteria
Ans. FILTERING

05.   What type of chart will you use to compare performance of two employees in the year 2016?
Ans. LINE

06.   Which Function is used for average in MS Excel?
Ans. Average()

 07.   Functions in MS Excel must begin with ___?
Ans. =

08.   Which function in Excel checks whether a condition is true or not?
Ans. IF().

09.   In Excel, Columns are labelled as ___
Ans. A,B,C

10.   The Greater Than sign (>) is an example of _____ operator.
Ans. LOGICAL

11.   What is the shortcut key for replace?"
Ans. Ctrl + H

12.   The process of arranging the items of a column in some sequence or order is known as?
Ans. SORTING

13.   The ____ feature of MS Excel quickly completes a series of data
Ans. AUTO FILL

14.   What type of chart is useful for comparing parts of a whole?
Ans. Pie

15.   What do you use to create a chart?
Ans.  CHART WIZARD

16.   How will you graphically (CHART) represent expenditure in different departments?
Ans. Pie

17.   What type of chart is good for single series of data? 
Ans. Pie

18.   The basic unit of a worksheet into which you enter data in Excel is called a.
Ans. CELL

19.   In Excel, which one denoted a range from B1 through E5.
Ans. B1:E5

20.   It is a collection of data that is stored electronically as a series of records in a table
Ans. SPREADSHEET