MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5430 5436.80 5436.8 6.8 5430 5436.80 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7+14 =B7*B1 10+50 =10+50 =B7+14 =B7*B1 10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu 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 To select an entire column in MS - EXCEL, press ? CTRL + C CTRL + S CTRL + Arrow key None of the listed here CTRL + C CTRL + S CTRL + Arrow key None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP