Sterliate Educations 673-A, Second Floor, Gali No.-7, Govindpuri, Kalkaji,, New Delhi 110019 Bharat Excel
Question : 25	Duration : 25 Minutes

1	All of the following terms are associated with spreadsheet software except
A: Virus detection
B: Formula
C: Cell
D: Virus detection
Answer: A

2	Each box in a spreadsheet is called a
A: Field
B: Record
C: Cell
D: Field
Answer: C

3	Which of the following programs enables you to calculate numbers related to rows and columns?
A: Window program
B: Spreadsheet program
C: Graphics program
D: Window program
Answer: B

4	A typical worksheet has ________ Number of columns in excel 2003
A: 128
B: 256
C: 512
D: 128
Answer: B

5	How many characters can be typed in a single cell in Excel?
A: 256
B: 1024
C: 32000
D: 256
Answer: D

6	What term refers to a specific set of values saved with the workbook?
A: Range
B: Scenario
C: Trend line
D: Range
Answer: B

7	Statistical calculations and preparation of tables and graphs can be done using
A: Adobe Photoshop
B: Excel
C: Notepad
D: Adobe Photoshop
Answer: B

8	What type of chart is useful for comparing values over categories ?
A: Pie Chart
B: Column Chart
C: Line Chart
D: Pie Chart
Answer: B

9	What is the intersection of a column and a row on a worksheet called ?
A: Column
B: Value
C: Address
D: Column
Answer: D

10	A cell may be used in a mathematical formula if it contains
A: A label
B: Numerical data
C: Both (a) and (b)
D: A label
Answer: B

11	Excel is -------------
A: Rows
B: Columns
C: Cells
D: Rows
Answer: D

12	To calculate the effect of interest rates on sums of money over time, we should use a
A: String function
B: Financial function
C: Statistical function
D: String function
Answer: B

13	The bar used to display the current cell and its contents is
A: Menu bar
B: Function bar
C: Formula bar
D: Menu bar
Answer: C

14	Which one of the following is not a Spreadsheet program?
A: Quattro Pro
B: MS-DOS
C: Lotus 1-2-3
D: Quattro Pro
Answer: B

15	What type of chart will you use to compare performance of sales of two products ?
A: Column Chart
B: Line Chart
C: Pie Chart
D: Column Chart
Answer: A

16	An Excel file is generally called a / an :
A: E-Spreadsheet
B: Woorksheet
C: Workbook
D: E-Spreadsheet
Answer: C

17	How many sheets are there, by default, when we create a new Excel file ?
A: 1
B: 3
C: 5
D: 1
Answer: B

18	In Excel, Columns are labelled as ___
A: A, B, C, etc
B: 1,2,3 etc
C: A1, A2, etc.
D: A, B, C, etc
Answer: A

19	It is a collection of data that is stored electronically as a series of records in a table.
A: spreadsheet
B: presentation
C: database
D: spreadsheet
Answer: C

20	Functions in MS Excel must begin with ___
A: An () sign
B: An Equal Sign
C: A Plus Sign
D: An () sign
Answer: B

21	Statistical calculations and preparation of tables and graphs can be done using
A: Adobe Photoshop
B: Excel
C: Notepad
D: Adobe Photoshop
Answer: B

22	In Excel, which one denoted a range from B1 through E5
A: B1 - E5
B: B1:E5
C: B1 to E5
D: B1 - E5
Answer: B

23	A features that displays only the data in column (s) according to specified criteria
A: Formula
B: Sorting
C: Filtering
D: Formula
Answer: C

24	Which functionin Excel tells how many numeric entries are there ?
A: NUM
B: COUNT
C: SUM
D: NUM
Answer: B

25	What type of chart is useful for comparing values over categories ?
A: Pie Chart
B: Column Chart
C: Line Chart
D: Pie Chart
Answer: B