MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Exclamation (!) Apostrophe (') Tilde (~) Hash (#) Exclamation (!) Apostrophe (') Tilde (~) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the column heading you want to delete and select Insert Delete from the menu Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Press the Alt key Click the formula bar Double click the cell Press the F2 key Press the Alt key Click the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear Delete Delete Clear All Clear Contents Clear Delete Delete Clear All Clear Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the status bar Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell ANSWER DOWNLOAD EXAMIANS APP