1. What shows the contents of active cell.
(a) Name box
(b) Row heading
(c) Formula bar
(d) Task pan
(e) None of these
2. In a spreadsheet, a _____________ is a number you will use in a calculation.
(a) label
(b) cell
(c) field
(d) value
(e) None of these
3. Which one of the following is associated with table row in excel programme ?
(a) Words
(b) Numbers
(c) Names
(d) Formulas
(e) None of these
4. In Excel All macro keyboard shortcuts include the _____________ key.
(a) Alt
(b) Ctrl
(c) F11
(d) Shift
(e) None of these
5. Special effect used to introduce slides in a presentation are called ___________.
(a) Effect
(b) Custom animation
(c) Transition
(d) Animation
(e) None of these
6. Each box in a spreadsheet is called a ______________.
(a) cell
(b) empty space
(c) record
(d) field
(e) None of these
7. As text, editor are used at the MS-word and ___________ are used in MS-Excel.
(a) work space
(b) work sheet
(c) work area
(d) All of the above
(e) None of these
8. Which of the following is not a toggle key ?
(a) Num lock key
(b) Caps lock key
(c) Both (A) & (B)
(d) Ctrl key
(e) None of these
9. One important function of MS-excels over MS-word is ________________.
(a) Formating numerals
(b) Decimal alignment
(c) Mathematical calculation
(d) Font Selection
(e) None of these
10. MS-Excel offers ____________ different chart types.
(a) 11
(b) 15
(c) 20
(d) 25
(e) None of these
11. In Excel-accounting style shows negative numbers in __________.
(a) Bold
(b) Brackets
(c) Parentheses
(d) Quotes
(e) None of these
12. Ms-excel record cell addresses in formula in three different ways, they are __________ and mixed.
(a) Column, Row
(b) Module, Relative
(c) Absolute, Module
(d) Absolute, Relative
(e) None of these
13. In Excel which of the following is not an option in the spelling dialog box.
(a) Edit
(b) Ignore
(c) Ignore all
(d) Change
(e) None of these
14. In Excel which of the following is not a worksheet design criterion
(a) Efficiency
(b) Auditability
(c) Description
(d) Clarity
(e) None of these
15. In Excel typical worksheet has _____________ Number of columns
(a) 128
(b) 256
(c) 512
(d) 1024
(e) None of these
(a) Name box
(b) Row heading
(c) Formula bar
(d) Task pan
(e) None of these
2. In a spreadsheet, a _____________ is a number you will use in a calculation.
(a) label
(b) cell
(c) field
(d) value
(e) None of these
3. Which one of the following is associated with table row in excel programme ?
(a) Words
(b) Numbers
(c) Names
(d) Formulas
(e) None of these
4. In Excel All macro keyboard shortcuts include the _____________ key.
(a) Alt
(b) Ctrl
(c) F11
(d) Shift
(e) None of these
5. Special effect used to introduce slides in a presentation are called ___________.
(a) Effect
(b) Custom animation
(c) Transition
(d) Animation
(e) None of these
6. Each box in a spreadsheet is called a ______________.
(a) cell
(b) empty space
(c) record
(d) field
(e) None of these
7. As text, editor are used at the MS-word and ___________ are used in MS-Excel.
(a) work space
(b) work sheet
(c) work area
(d) All of the above
(e) None of these
8. Which of the following is not a toggle key ?
(a) Num lock key
(b) Caps lock key
(c) Both (A) & (B)
(d) Ctrl key
(e) None of these
9. One important function of MS-excels over MS-word is ________________.
(a) Formating numerals
(b) Decimal alignment
(c) Mathematical calculation
(d) Font Selection
(e) None of these
10. MS-Excel offers ____________ different chart types.
(a) 11
(b) 15
(c) 20
(d) 25
(e) None of these
11. In Excel-accounting style shows negative numbers in __________.
(a) Bold
(b) Brackets
(c) Parentheses
(d) Quotes
(e) None of these
12. Ms-excel record cell addresses in formula in three different ways, they are __________ and mixed.
(a) Column, Row
(b) Module, Relative
(c) Absolute, Module
(d) Absolute, Relative
(e) None of these
13. In Excel which of the following is not an option in the spelling dialog box.
(a) Edit
(b) Ignore
(c) Ignore all
(d) Change
(e) None of these
14. In Excel which of the following is not a worksheet design criterion
(a) Efficiency
(b) Auditability
(c) Description
(d) Clarity
(e) None of these
15. In Excel typical worksheet has _____________ Number of columns
(a) 128
(b) 256
(c) 512
(d) 1024
(e) None of these
Answers
1. Formula bar
2. value
3. Numbers
4. Alt
5. Animation
6. cell
7. work sheet
8. Ctrl key
9. Decimal alignment
10. 11
11. Parentheses
12. Absolute, Relative
13. Edit
14. Description
15. 256