MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Pmt Max Sum Average Pmt Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Margins Headers and Footers Page Break Preview Page Orientation Margins Headers and Footers Page Break Preview Page Orientation ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Input cells Changing cells Constraints Target cell Input cells Changing cells Constraints Target cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS