Spreadsheet Software Test 03
Total Questions: 30
Link copied to clipboard!
A ) C8
B ) D6 ✅
C ) E4
D ) D9
A ) Formatting
B ) Formulas
C ) Functions
D ) Charts ✅
A ) Workbook ✅
B ) Worksheet
C ) Account book
D ) Area
A ) Work cover ✅
B ) Active cell
C ) Workbook
D ) Menu
A ) Many Rows
B ) Many columns
C ) Worksheet ✅
D ) Cells
A ) A workbook
B ) A Column
C ) A Row
D ) A Cell ✅
A ) A workbook
B ) A Column
C ) A Row
D ) A Cell ✅
A ) Workbook
B ) Function
C ) Column
D ) Range ✅
A ) Cell
B ) Bar
C ) Format
D ) Formula ✅
A ) >
B ) = ✅
C ) ==
D ) <
A ) Reference Cell ✅
B ) Column Reference
C ) Sheet Reference
D ) Row Reference
A ) Mixed referencing
B ) Relative referencing ✅
C ) Advanced referencing
D ) Absolute referencing
A ) Mixed referencing
B ) Relative referencing
C ) Advanced referencing
D ) Absolute referencing ✅
A ) # Sign
B ) $ Sign ✅
C ) % Sign
D ) @ Sign
A ) Function ✅
B ) Calculate
C ) Procedure
D ) Update
A ) 1 ✅
B ) 2
C ) 3
D ) 4
A ) Two
B ) One ✅
C ) Equal to range
D ) Equal to column no
A ) Paste function ✅
B ) Function finder
C ) Built in function
D ) Defined function
A ) $B$1
B ) $C$5
C ) B3 ✅
D ) $D$7
A ) A3-G3
B ) A3:G3
C ) A3. . . G3
D ) A3 to G3
A ) 9 - 2 * 3 + 4 / 2
B ) 1 + 2 * 3 - 8 / 2
C ) 8 - 2 * 3 + 8 / 2 ✅
D ) 2 + 2 * 3 - 4 / 2
A ) 7 ✅
B ) 1.5
C ) 2
D ) 12
A ) A1 becomes the active cell
B ) B5 becomes the active cell ✅
C ) C5 becomes the active cell
D ) B6 becomes the active cell
A ) Result
B ) Function ✅
C ) Math operator
D ) Range
A ) + D3 and D4
B ) = D3 and D4
C ) +D4,D5
D ) =D3+D4 ✅
A ) Calculations
B ) Formulas
C ) Functions ✅
D ) Relative addressing
A ) MAX
B ) MIN ✅
C ) MINIMUM
D ) LOWER
A ) HIGHEST
B ) GREATER
C ) MAX ✅
D ) MAXIMUM
A ) Length
B ) Counter
C ) Counting
D ) Count ✅
A ) Average ✅
B ) Avg
C ) Medium
D ) Avrg