Q. 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?

View solution

Q. Where can you change automatic or manual calculation mode in Excel?

View solution

Q. How can you show or hide the gridlines in Excel Worksheet?

View solution

Q. Which of the following Excel screen components can NOT be turned on or off?

View solution

Q. What happens when you press Ctrl + X after selecting some cells in Excel?

View solution

Q. Which of the following option is not available in Paste Special dialog box?

View solution

Q. Which command will you choose to convert a column of data into row?

View solution

Q. It is acceptable to let long text flow into adjacent cells on a worksheet when

View solution

Q. Which of the cell pointer indicates you that you can make selection?

View solution

Q. Which of the cell pointer indicates that you can fill series?

View solution

Q. Which of the cell pointer indicate that you can move the content to other cell?

View solution

Q. You can auto fit the width of column by

View solution

Q. Long text can be broken down into many lines within a cell. You can do this through

View solution

Q. MS Excel provides the default value for step in Fill Series dialog box

View solution

Q. When a row of data is to be converted into columns

View solution

Q. Ctrl + D shortcut key in Excel will

View solution

Q. The short cut key Ctrl + R is used in Excel to

View solution

Q. The command Edit >> Fill Across Worksheet is active only when

View solution

Q. Which of the following series type is not valid for Fill Series dialog box?

View solution

Q. Which of the following you can paste selectively using Paste Special command?

View solution