MS Excel All worksheet formula Use the addition operator Manipulate labels Return a formula result Manipulate values Use the addition operator Manipulate labels Return a formula result Manipulate values ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Standard Formulas Smart Formula Complex Formulas Array formula Standard Formulas Smart Formula Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Max Average Pmt Sum Max Average Pmt Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which would you choose to create a bar diagram? Tools, Chart Edit, Chart Format, Chart Insert, Chart Tools, Chart Edit, Chart Format, Chart Insert, Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP