Computer Science

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 141 - 150 of 1111 Questions

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

A work sheet
B chart sheet
C module sheet
D data sheet
Correct Answer

Option D: data sheet


Discussion

The Name box on to the left of formula bar

A shows the name of workbook currently working on
B shows the name of worksheet currently working on
C shows the name of cell or range currently working on
D None of above
Correct Answer

Option C: shows the name of cell or range currently working on


Discussion

Tab scroll buttons are place on Excel screen

A towards the bottom right corner
B towards the bottom left corner
C towards the top right corner
D towards the top left corner
Correct Answer

Option B: towards the bottom left corner


Discussion

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

A From Format Cells dialog box click on Merge Cells check box
B From Format Cells dialog box select the Centered alignment
C From Format Cells dialog box choose Merge and Center check box
D Click on Merge and Center tool on formatting toolbar
Correct Answer

Option D: Click on Merge and Center tool on formatting toolbar


Discussion

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

A Press the Alt key
B Press Tab
C Press Enter
D None of above
Correct Answer

Option D: None of above


Discussion

You can use the formula pallette to

A format cells containing numbers
B create and edit formula containing functions
C enter assumptions data
D copy a range of cells
Correct Answer

Option B: create and edit formula containing functions


Discussion

Which of the following is invalid statement?

A Sheet tabs can be colored
B Some picture can be applied as a background of a sheet
C You can set the column width automatically fit the amount of text
D The width of a row and be specified manually or fit automatically
Correct Answer

Option D: The width of a row and be specified manually or fit automatically


Discussion

Which of the following is not true regarding Conditional Formatting?

A You can add more than one condition to check
B You can set condition to look for Bold and apply Italics on them.
C You can apply Font, border and pattern formats that meets the specified conditions
D You can delete any condition from Conditional Formatting dialog box if it is not requried
Correct Answer

Option B: You can set condition to look for Bold and apply Italics on them.


Discussion

You can check the conditions against __________ when applying conditional formatting

A Cell value
B Formula
C Both of above
D None of above
Correct Answer

Option C: Both of above


Discussion

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

A Use =if() function to format the required numbers red
B Apply Conditional Formatting command on Format menu
C Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D All of above
Correct Answer

Option B: Apply Conditional Formatting command on Format menu


Discussion



WhatsApp Support