MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 6.8 5436.80 5436.8 5430 6.8 5436.80 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Sheet tabs can be colored Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Sheet tabs can be colored Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formats Formulas Validation All of above Formats Formulas Validation All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments can be added to cells using File > Comments View > Comments Edit > Comments Insert > Comments File > Comments View > Comments Edit > Comments Insert > Comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text ANSWER DOWNLOAD EXAMIANS APP