MS Excel Which of the following is an absolute cell reference? #a#1 A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics 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 Fill across worksheet Auto fill options Fill series Custom List Fill across worksheet Auto fill options Fill series ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Row chart Column chart Line chart Pie chart Row chart Column chart Line chart Pie chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Copy the worksheet Modifiy the worksheet Save workbook Enter text and data Copy the worksheet Modifiy the worksheet Save workbook Enter text and data ANSWER DOWNLOAD EXAMIANS APP