MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using All of the listed here Changing fonts Applying styles Auto formatting All of the listed here Changing fonts Applying styles Auto formatting 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 search for bold and replace with italics You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search in formula too You can search for bold and replace with italics You can search by rows or columns or sheets You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Tools > Finder from the menu Select Insert > Find from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Select Insert > Find from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Apply double underline for the active cell Fill down in the selection Open the font dialog box None of the listed here Apply double underline for the active cell Fill down in the selection Open the font dialog box None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS