MS Excel Which function is not available in the Consolidate dialog box ? Average Max Sum Pmt Average Max Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The cancel button The edit formula button All of these The enter button The cancel button The edit formula button All of these The enter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Percentage Divide Square Goal seek Percentage Divide Square Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS