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 You can check the conditions against ____ when applying conditional formatting Cell value None Both Formula Cell value None Both Formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Solver Auto Outline Scenario manager Goal seek Solver Auto Outline Scenario manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Max Average Pmt Sum Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Enter the formula using any input values and the appropriate mathematical operators that make up your formula Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Clarity Description Aditibility Efficiency Clarity Description Aditibility Efficiency ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS