Q. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

View solution

Q. You can check the conditions against __________ when applying conditional formatting

View solution

Q. Which of the following is not true regarding Conditional Formatting?

View solution

Q. Which of the following is invalid statement?

View solution

Q. You can use the formula pallette to

View solution

Q. When a range is selected, how can you activate the previous cell?

View solution

Q. Which tool you will use to join some cells and place the content at the middle of joined cell?

View solution

Q. The Name box on to the left of formula bar

View solution

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