MS Excel Text formulas: Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters 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 Clear and then Formats Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Custom List Auto fill options Fill series Fill across worksheet Custom List Auto fill options Fill series Fill across worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you wrap the text in a cell ? Format, cells, number Format, cells, alignment Format, cells, protection Format, cells, font Format, cells, number Format, cells, alignment Format, cells, protection Format, cells, font 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
EXAMIANS