Formula in Excel
Total Questions: 26
Link copied to clipboard!
A ) Numeric value
B ) Label
C ) Both A and B ✅
D ) None of these
A ) Equal sign
B ) Apostrophe ✅
C ) Tide
D ) Hash
A ) GMT
B ) PST
C ) PMT ✅
D ) None of these
A ) Function within a function ✅
B ) Function nearest a function
C ) Function outside a function
D ) None of these
A ) Edit existing formulas
B ) Format cells
C ) Create and edit formulas containing functions ✅
D ) Perform complex calculations
A ) Criteria row
B ) Aggregate function ✅
C ) Format row
D ) Format layout
A ) 6.25
B ) 34.655 ✅
C ) 232
D ) 320
A ) Change ✅
B ) Repeat
C ) Replace
D ) Recoverable
A ) Add
B ) Count ✅
C ) Sum
D ) Total
A ) Cell
B ) Locked cell
C ) Active Cell ✅
D ) Cell containing a formula
A ) Pressing an arrow key
B ) Clicking the cell
C ) Pressing the tab key
D ) All of these ✅
A ) =SUM(A1:A5)*.5
B ) SUM(Sales)-A3 ✅
C ) =SUM(A1:A5)/(1+0+10)
D ) =SUM(A1:A5)-10
A ) Choose the new command from the file menu
B ) Select the cell you want to place the formula into ✅
C ) Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D ) Type the equals sign(=) to tell Excel that you're about to enter a formula
A ) The word document contains a reference to the original source application ✅
B ) The word document must contain a hyperlink
C ) The word document cannot be edited
D ) The word document contains a copy of the actual dara
A ) Edit the hyperlink
B ) Use the Excel menu bar and toolbars inside the word application ✅
C ) Use the word menu bar and toolbar
D ) Edit the data in an Excel source application
A ) Pressing the Alt key ✅
B ) click the formula bar
C ) Double press the cell
D ) F2
A ) Formula
B ) Value ✅
C ) Label
D ) Number
A ) Software
B ) Program
C ) Predefined formula ✅
D ) None of these
A ) Filters
B ) Formatting
C ) Formulas ✅
D ) Insertions
A ) = ✅
B ) +
C ) /
D ) &
A ) Calculation error
B ) Data corruption
C ) Low memory
D ) Invalid input ✅
A ) Subtraction sign
B ) Equal sign ✅
C ) Addition sign
D ) Parenthesis sign
A ) Composite
B ) Nested
C ) Multiple
D ) All of these ✅
A ) #NAME?
B ) =A1+A2 ✅
C ) =SUM(A1, A2)
D ) SUM(A1, A2)
A ) (A1+A2)
B ) SUM(A1, A2)
C ) =A1+A2 ✅
D ) #REF!
A ) 3
B ) 5
C ) 7 ✅
D ) 8