MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two View > window > split Window > split Format > window View > split View > window > split Window > split Format > window View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Smart Formula Standard Formulas Complex Formulas Array formula Smart Formula Standard Formulas Complex Formulas Array formula 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? Auto fill options Fill across worksheet Custom List Fill series Auto fill options Fill across worksheet Custom List Fill series ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS