Spreadsheet Software Test 02

Total Questions: 29

1 - Which of the following is a spreadsheet?

A ) MS Word
B ) MS Excel ✅
C ) MS PowerPoint
D ) None

2 - The actual working area in Microsoft Excel is:

A ) Workbook
B ) Worksheet ✅
C ) Spreadsheet
D ) Notesheet

3 - Which of the following is an absolute address?

A ) A1
B ) A1$
C ) $A$1 ✅
D ) $A1

4 - Formula can only be applied on:

A ) Values ✅
B ) Labels
C ) Ummerged cells
D ) None

5 - Which of the following function is used to get the current data?

A ) Exact()
B ) Today () ✅
C ) Month ()
D ) Year ()

6 - Which of the following is spreadsheet software?

A ) LOTOUS 123
B ) MS Excel
C ) A and B
D ) Word

7 - Another name for an electronic spreadsheet is:

A ) Workbook
B ) Worksheet ✅
C ) Document
D ) Database

9 - The extension of MS- Excel file is:

A ) wrd
B ) xls ✅
C ) jpg
D ) doc

10 - The default name of the first worksheet in a workbook is:

A ) First sheet
B ) Sheet 1 ✅
C ) Sheet one
D ) One

11 - The title bar in MS Excel displays the name of the:

A ) Worksheet
B ) Workbook ✅
C ) Formula
D ) Location

12 - A spreadsheet is a grid of:

A ) Rows
B ) Columns
C ) Rows and columns ✅
D ) Lines

13 - The horizontal dimension of a spreadsheet is called:

A ) Dimension
B ) Cell
C ) Row ✅
D ) Column

14 - The vertical dimension of a spreadsheet is called:

A ) Field
B ) Record
C ) Row
D ) Column ✅

15 - The intersection of a row and column is called:

A ) Intersection
B ) Cell ✅
C ) Field
D ) Address

16 - Each cell in a spreadsheet has a unique:

A ) Row
B ) Column
C ) Address ✅
D ) A and B

17 - The columns in a spreadsheet are labeled by:

A ) Letters ✅
B ) Numbers
C ) Cell references
D ) Digits

18 - The rows in a spreadsheet are labeled by:

A ) Letters
B ) Numbers ✅
C ) Cell references
D ) Digits

19 - The combination of letters and numbers such as A5, B9, D15 refers to:

A ) Row identifier
B ) Cell address ✅
C ) Function
D ) Formula

20 - A spreadsheet cell highlighted with a heavy border is the:

A ) Active cell ✅
B ) Absolute Cell
C ) Locked cell
D ) Passive cell

24 - Each cell can contain a:

A ) Label
B ) Value
C ) Formula
D ) All

25 - The row number used in spreadsheet are called:

A ) Labels ✅
B ) Reference
C ) Formulas
D ) Values

28 - The cell that contains a formula or function will show:

A ) Formula or function
B ) Cell's address
C ) The result value ✅
D ) Range address

29 - B2: E3 is an example of a cell:

A ) Range ✅
B ) Location
C ) Command
D ) Style