Which of the following format you can decide to apply or not in AutoFormat dialog box?
Select an option to see the answer and solution.
Computer Fundamentals · all questionsMicrosoft Excel
Microsoft Excel
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
198
Questions
1/10
Page
Pick an option on a question to see the right answer and solution.
How can you remove borders applied in cells?
Select an option to see the answer and solution.
Where can you set the shading color for a range of cells in Excel?
Select an option to see the answer and solution.
You can set Page Border in Excel from
Select an option to see the answer and solution.
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Select an option to see the answer and solution.
You can check the conditions against __________ when applying conditional formatting
Select an option to see the answer and solution.
Which of the following is not true regarding Conditional Formatting?
Select an option to see the answer and solution.
Which of the following is invalid statement?
Select an option to see the answer and solution.
You can use the formula palette to
Select an option to see the answer and solution.
When a range is selected, how can you activate the previous cell?
Select an option to see the answer and solution.
Which tool you will use to join some cells and place the content at the middle of joined cell?
Select an option to see the answer and solution.
Tab scroll buttons are place on Excel screen
Select an option to see the answer and solution.
The Name box on to the left of formula bar
Select an option to see the answer and solution.
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Select an option to see the answer and solution.
Which of the following is not the correct method of editing the cell content?
Select an option to see the answer and solution.
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Select an option to see the answer and solution.
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Select an option to see the answer and solution.
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?
Select an option to see the answer and solution.
Where can you change automatic or manual calculation mode in Excel?
Select an option to see the answer and solution.
How can you show or hide the gridlines in Excel Worksheet?
Select an option to see the answer and solution.