MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Smart Formula Array formula Standard Formulas Complex Formulas Smart Formula Array formula Standard Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To select a distribution of figures To add borders To insert a background To add shading or color to a cell range To select a distribution of figures To add borders ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Apostrophe (') Hash (#) Exclamation (!) Tilde (~) Apostrophe (') Hash (#) Exclamation (!) Tilde (~) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Input cells Target cell Constraints Changing cells Input cells Target cell Constraints Changing cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS