Question - 1
____ appear at the bottom of the Excel window.
- Title bar
- Formula bar
- Work sheet tabs
- Name Tabs
Solutions
Answer- C
Question - 2
What is the intersection of a column and a row on a worksheet called ?
Answer- B
Question - 3
Which one is not a Function in MS Excel ?
Answer- A
Question - 4
Which of the following is not a term pertaining to spreadsheets?
- Cell
- Character
- Browser
- Formula
Solutions
Answer- C
Question - 5
Which functionin Excel tells how many numeric entries are there ?
Answer- C
Question - 6
Which of the following key is Used for help In Ms Excel?
Answer- A
Question - 7
Functions in MS Excel must begin with ___
- An () sign
- An Equal Sign
- A Plus Sign
- A > Sign
Solutions
Answer- B
Question - 8
Which of the following key is used to "Goto" tab In Ms Excel?
Answer- C
Question - 9
Another name for a pre-programmed formula in Excel is
- Cell
- graph
- function
- Range
Solutions
Answer- C
Question - 10
The ____ feature of MS Excel quickly completes a series of data
- Auto Complete
- Auto Fill
- Auto Type
- All the above
Solutions
Answer- B
Question - 11
In which tab wrap text feature is present in MS Excel 2007
- Formulas
- View
- Insert
- Home
Solutions
Answer- D
Question - 12
VLOOKUP Function Used To ?
- Finds Related Records
- Looks Up Text That Contain V
- Check If Two Cells Are Identical
- None Of Above
Solutions
Answer- A
Question - 13
What do you use to create a chart?
- Pie Wizard
- Excel Wizard
- Data Wizard
- Chart Wizard
Solutions
Answer- D
Question - 14
How many sheets are there, by default, when we create a new Excel file ?
Answer- B
Question - 15
In Excel, which one denoted a range from B1 through E5
- B1 - E5
- B1:E5
- B1 to E5
- B1$E5
Solutions
Answer- B
Question - 16
Merge Cells Option Can Be Applied From ?
- Formatting Toolbar
- Format Cells Dialog Box Alignment Tab
- Both Of Above
- None of the above
Solutions
Answer- B
Question - 17
To Minimize Workbook In Ms Excel:
- Ctrl+ F6
- Ctrl+ F7
- Ctrl+ F9
- Ctrl+ F11
Solutions
Answer- C
Question - 18
It is a collection of data that is stored electronically as a series of records in a table.
- spreadsheet
- presentation
- database
- MS Word
Solutions
Answer- C
Question - 19
Which command is used to close the window of Excel?
- Alt+ F4
- Alt+ W
- Alt+ F3
- Alt+ C
Solutions
Answer- A
Question - 20
How many columns are there in of MS Excel?
Answer- D
Practice more set questions
