MS Excel Which of following is Not one of Excel's what-if function? Goal seek Scenario manager Solver Auto Outline Goal seek Scenario manager Solver Auto Outline ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Complex Formulas Standard Formulas Smart Formula Array formula Complex Formulas Standard Formulas Smart Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5436.80 6.8 5430 5436.8 5436.80 6.8 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? 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 Select Tools > Finder from the menu Select Insert > Find from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > split Review > window Window > split View > window > split View > split Review > window Window > split View > window > split ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS