MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not 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? Fill across worksheet Fill series Auto fill options Custom List Fill across worksheet Fill series Auto fill options Custom List 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Location tabs Sheet tabs Reference tabs Position tabs Location tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? All of above Goal seek Solver Scenario Manager All of above Goal seek Solver Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? All of these Answer Wizard tab Index tab Contents tab All of these Answer Wizard tab Index tab Contents tab ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS