MS Excel Which of following is Not one of Excel's what-if function? Auto Outline Scenario manager Goal seek Solver Auto Outline Scenario manager Goal seek Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? All of above Font format Number format Border format All of above Font format Number format Border format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Standard Formulas Complex Formulas Smart Formula Array formula Standard Formulas Complex Formulas Smart Formula 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 A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS