MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5436.80 6.8 5430 5436.8 5436.80 6.8 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F9 F8 F11 F10 F9 F8 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 Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar 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 There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is not the function of "Edit, Clear" command? Delete contents Delete notes Delete cells Delete formats Delete contents Delete notes Delete cells Delete formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Position tabs Location tabs Reference tabs Sheet tabs Position tabs Location tabs Reference tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Solver Scenario manager Auto Outline Goal seek Solver Scenario manager Auto Outline Goal seek ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS