MS Excel Which of the following is an absolute cell reference? #a#1 A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Manipulate values Use the addition operator Manipulate labels Return a formula result Manipulate values Use the addition operator Manipulate labels Return a formula result ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? ROUND ( ) FACT ( ) Div ( ) MOD ( ) ROUND ( ) FACT ( ) Div ( ) MOD ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Solver Goal seek Auto Outline Scenario manager Solver Goal seek Auto Outline Scenario manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS