Rows, Column, Name Box and Formula Bar
Total Questions: 33
Link copied to clipboard!
A ) Paper size
B ) Page layout
C ) Stirrups
D ) None of these (Column Width) ✅
A ) Table
B ) Cell ✅
C ) Schema
D ) Data
A ) Edit the contents of a cell
B ) Split a worksheet into two panes
C ) View different rows and columns ✅
D ) View different worksheets
A ) Hyperlink placed in word table
B ) Embedded
C ) Linked ✅
D ) None of these
A ) Accessing
B ) Cell Referencing ✅
C ) Updating
D ) Functioning
A ) !
B ) *
C ) $ ✅
D ) None of these
A ) #NUM!
B ) #REF!
C ) #VALUE! ✅
D ) #DIV/0!
A ) Cell referencing but not values
B ) Values but not cell references
C ) Values or cell references although not both at the same time
D ) Both values and cell references ✅
A ) Function wizard
B ) Formulae icon ✅
C ) Auto sum
D ) Equation editor
A ) Space ✅
B ) $
C ) @
D ) /
A ) &
B ) Space ✅
C ) $
D ) None of these
A ) Conditions
B ) Parameters
C ) Variables
D ) Arguments ✅
A ) Clicking on the formula bar
B ) Pressing on arrow key
C ) Pressing the tab key
D ) Pressing the ESC key ✅
A ) To add up a range of cell
B ) To find the average of range of cell
C ) To perform a vertical lookup and returns a value based on specified criteria
D ) To perform a horizontal lookup and returns a value based on a specific criteria ✅
A ) Cell Row
B ) Cell column
C ) Range of cell ✅
D ) Worksheet number
A ) Mixed reference
B ) Relative reference
C ) Absolute reference ✅
D ) Circular reference
A ) New
B ) Fixed ✅
C ) Update
D ) Duplicate
A ) !A! 1
B ) $A$1 ✅
C ) #a#1
D ) None of these
A ) Relative reference
B ) Absolute reference ✅
C ) Static reference
D ) Dynamic Reference
A ) Cell ✅
B ) Box
C ) Tab
D ) Range
A ) Column number and row letters
B ) Column letters and row number ✅
C ) Cell coordinates
D ) None of these
A ) 86400
B ) 86340
C ) 1048576 ✅
D ) None of these
A ) Record ✅
B ) Field
C ) Table
D ) Cell
A ) 1,2,3, etc. ✅
B ) A1, A2, etc.
C ) C, A, B, C, etc.
D ) D, A, B, etc.
A ) Following Rows move button ✅
B ) Uper row move top
C ) Both A and B
D ) None of these
A ) Name box ✅
B ) Formula bar
C ) Status bar
D ) Tool bar
A ) Row headings
B ) Task pane
C ) Formula Bar ✅
D ) Name Box
A ) Currency
B ) Percent
C ) Comma
D ) Normal ✅
A ) Title bar
B ) Formula bar ✅
C ) Menu bar
D ) None of these
A ) Menu Bar
B ) Formula Bar ✅
C ) Title bar
D ) Standard toolbar
A ) Name box
B ) Title bar
C ) Formula bar ✅
D ) None of these
A ) Function wizard
B ) Formula icon ✅
C ) Autosum
D ) Equation editor
A ) Clicking the formula bar
B ) Pressing the F2 key
C ) Double clicking the cell
D ) Pressing the alt key ✅