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 Auto fill options Custom List Fill series Fill across worksheet Auto fill options Custom List Fill series ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you print three copies of a workbook? Select File > Print from the menu and type 3 in the Number of copies text box Select File > Properties form the menu and type 3 in the Copies to print text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 Select File > Print from the menu and type 3 in the Number of copies text box Select File > Properties form the menu and type 3 in the Copies to print text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Clicking the cell Pressing an arrow key All of these Pressing the Tab key Clicking the cell Pressing an arrow key All of these Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here ANSWER DOWNLOAD EXAMIANS APP
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