Q. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

View solution

Q. Which of the following is not the correct method of editing the cell content?

View solution

Q. You can merge the main document with data source in Excel. In mail merge operation, Word is usually

View solution

Q. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

View solution

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