Objective Type Question & Answer

Q. What is the intersection of a column and a row on a worksheet called ?
Answer : Cell
Q. Which functionin Excel tells how many numeric entries are there ?
Answer : COUNT
Q. A features that displays only the data in column (s) according to specified criteria
Answer : Filtering
Q. Which one is not a Function in MS Excel ?
Answer : AVG
Q. Functions in MS Excel must begin with ___
Answer : An Equal Sign
Q. Which functionin Excel checks whether a condition is true or not ?
Answer : IF
Q. The Greater Than sign (>) is an example of _____ operator.
Answer : Logical

Q. What type of chart is useful for showing trends or changes over time ?
Answer : Line Chart
Q. The process of arrenging the items of a column in some sequence or order is known as :
Answer : Sorting
Q. The ____ feature of MS Excel quickly completes a series of data.
Answer : Auto Fill
Q. The basic unit of a worksheet into which you enter data in Excel is called a
Answer : cell
Q. Ms excel is used for creating?
Answer : Spreadsheets
Q. The combination of row and column is called ______________
Answer : Cell
Q. In a Table how many number of Cells can be merged ?
Answer : Any Number

Q. In MS Excel, in which bar have the currency option
Answer : Formatting Toolbar
Q. Which menu contains macro options in MS Excel
Answer : Tools
Q. In MS Excel, which menu does have Sort option
Answer : Data
Q. MS EXCEL Based on _______ Software.
Answer : WINDOWS.
Q. A spreadsheet is a collection of pages is called a _______
Answer : Workbook
Q. What is the Extension of Excel Workbook in MS Excel 2007?
Answer : .xlsx
Q. How many sheets are there, by default, when we create a new Excel file ?
Answer : 3