| | All of the following terms are associated with spreadsheet software except
A. Virus detection
B. Formula
C. Cell
D. Worksheet
Ans. A | Excel |
| | Each box in a spreadsheet is called a
A. Field
B. Record
C. Cell
D. Empty space
Ans. C | Excel |
| | 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. Word program
Ans. B | Excel |
| | A typical worksheet has ________ Number of columns in excel 2003
A. 128
B. 256
C. 512
D. 16384
Ans. B | Excel |
| | How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Ans. D | Excel |
| | What term refers to a specific set of values saved with the workbook?
A. Range
B. Scenario
C. Trend line
D. What-if analysis
Ans. B | Excel |
| | Statistical calculations and preparation of tables and graphs can be done using
A. Adobe Photoshop
B. Excel
C. Notepad
D. Power Point
Ans. B | Excel |
| | What type of chart is useful for comparing values over categories ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
Ans. B | Excel |
| | What is the intersection of a column and a row on a worksheet called ?
A. Column
B. Value
C. Address
D. Cell
Ans. D | Excel |
| | A cell may be used in a mathematical formula if it contains
A. A label
B. Numerical data
C. Both (a) and (b)
D. None of these
Ans. B | Excel |
| | Excel is -------------
A. Rows
B. Columns
C. Cells
D. All of these
Ans. D | Excel |
| | 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. Mathematical function
Ans. B | Excel |
| | The bar used to display the current cell and its contents is
A. Menu bar
B. Function bar
C. Formula bar
D. Object bar
Ans. C | Excel |
| | Which one of the following is not a Spreadsheet program?
A. Quattro Pro
B. MS-DOS
C. Lotus 1-2-3
D. VisiCalc
Ans. B | Excel |
| | 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. Both A and B
Ans. A | Excel |
| | An Excel file is generally called a / an :
A. E-Spreadsheet
B. Woorksheet
C. Workbook
D. Sheet
Ans. C | Excel |
| | How many sheets are there, by default, when we create a new Excel file ?
A. 1
B. 3
C. 5
D. 10
Ans. B | Excel |
| | In Excel, Columns are labelled as ___
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. $A$1, $A$2, etc.
Ans. A | Excel |
| | 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. MS Word
Ans. C | Excel |
| | Functions in MS Excel must begin with ___
A. An () sign
B. An Equal Sign
C. A Plus Sign
D. A > Sign
Ans. B | Excel |
| | Statistical calculations and preparation of tables and graphs can be done using
A. Adobe Photoshop
B. Excel
C. Notepad
D. Power Point
Ans. B | Excel |
| | In Excel, which one denoted a range from B1 through E5
A. B1 - E5
B. B1:E5
C. B1 to E5
D. B1$E5
Ans. B | Excel |
| | A features that displays only the data in column (s) according to specified criteria
A. Formula
B. Sorting
C. Filtering
D. Pivot
Ans. C | Excel |
| | Which functionin Excel tells how many numeric entries are there ?
A. NUM
B. COUNT
C. SUM
D. CHKNUM
Ans. B | Excel |
| | What type of chart is useful for comparing values over categories ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Dot Graph
Ans. B | Excel |
| | What is the intersection of a column and a row on a worksheet called ?
A. Column
B. Value
C. Address
D. Cell
Ans. D | Excel |
