MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Border format Font format All of above Number format Border format Font format All of above Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press Esc Press the Edit Formula button Press the Enter button Press the Erase key Press Esc Press the Edit Formula button Press the Enter button Press the Erase key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Date () Now () Today () Time () Date () Now () Today () Time () ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP