MS Excel Which of the following is an absolute cell reference? !A!1 A1 $A$1 #a#1 !A!1 A1 $A$1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear All Delete Clear Contents Clear Delete Clear All Delete Clear Contents Clear Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Column numbers and row letters Cell names Column letters and row numbers Cell locator coordinates Column numbers and row letters Cell names Column letters and row numbers 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 Format Painter button on the standard toolbar 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 Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar 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 Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top left corner Towards the top right corner Towards the bottom left corner Towards the bottom right corner Towards the top left corner Towards the top right corner Towards the bottom left corner Towards the bottom right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.8 5430 5436.80 6.8 5436.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP