MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Aditibility Clarity Description Efficiency Aditibility Clarity Description Efficiency ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Window > split View > window > split View > split Format > window Window > split View > window > split View > split Format > window ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells ANSWER DOWNLOAD EXAMIANS APP