Information Technology Quiz: Spreadsheet Applications.
25 Questions
| Attempts: 435
.
Questions and Answers
- 1.An intersection of a row and column is call a _______________.
- A.
Row
- B.
Column
- C.
Grid
- D.
Cell
- 2.Letters are used to identify __________________.
- A.
Row
- B.
Column
- C.
Grid
- D.
Cell
- 3.Numbers are used to identify ________________.
- A.
Row
- B.
Column
- C.
Grid
- D.
Cell
- 4.Spreadsheet is widely used finance tasks such as _______________ and _____________.
- A.
Budgetting and Payroll
- B.
Science and Energy
- C.
Art and craft
- D.
Social Stuidies and Spanish
- 5.Which one of the following represents a Relative Cell?
- A.
B7
- B.
$B$7
- C.
$7$B
- D.
7B
- 6.Which of the following represents an Absolute Cell?
- A.
B7
- B.
$B$7
- C.
$7$B
- D.
7B
- 7.A ____________________ is an equation that tells the spreadsheet what action to take.
- A.
Range
- B.
Cell
- C.
Grid
- D.
Formula
- 8.Which one of the following is NOT a type of spreadsheet?
- A.
Word Prefect
- B.
Lotus
- C.
Spreadsheet
- D.
Excel
- 9.A ________________________ is an application program that allows text, numbers and formulae to be entered into a grid of rectangle cells.
- 10.To enter a formula in a cell, you must start with an _______________________.
- 11.B6 specifies the cell in ___________________ B.
- 12.B6 specifies the cell in __________________ 6.
- 13.To add together the values in cells A1 and A2, you would type the formula ______________.
- 14.A popular spreadsheet application is _____________________.
- 15.If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to add cell B4 and C4:
- 16.If 25 was entered into cell B4 and 75 was entered into cell C4, write the formulae that would be used to multiply cell B4 by 4:
- 17.If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to divide Cell C4 by 3:
- 18.If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to subtract cell B4 from cell C4:
- 19.Which one of the following is NOT a valid cell addresses?
- A.
G3000
- B.
DH30
- C.
20AD
- D.
550
- 20.A ________________ can be used as a title or heading to describe an aspect of a worksheet.
- 21.A _______________ is a piece of data that can be used in a calculation.
- 22._____________ is automatic left align.
- 23._______________ are automatic right align.
- 24.Which symbol is used for multiplication in a spreadsheet?
- 25.Which symbol is used for division in a spreadsheet?
Related Topics
Recent Quizzes
Software Design Methodologies and Project Management Test
Software Design Methodologies and Project Management Test
A Grade 9 Information and Communications Technology Test
A Grade 9 Information and Communications Technology Test
Grade 9 EBHS Information Technology Diagnostic Test
Grade 9 EBHS Information Technology Diagnostic Test
SOS HGS- KUMASI INFORMATION AND COMMUNICATIONS TECHNOLOGY- TEST GRADE 7
SOS HGS- KUMASI INFORMATION AND COMMUNICATIONS TECHNOLOGY- TEST GRADE 7
Back to top