0
Login

MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 151 - 160 of 336 Questions

80 Details Computer Science MS Excel Easy

You can set Page Border in Excel from

A From Border tab in Format Cells dialog box
B From Border tool in Formatting toolbar
C From Line Style tool in Drawing toolbar
D You can not set page border in Excel
Correct Answer

Option D: You can not set page border in Excel

Discussion
68 Details Computer Science MS Excel Easy

Where can you set the shedding color for a range of cells in Excel?

A Choose required color form Patterns tab of Format Cells dialog box
B Choose required color on Fill Color tool in Formatting toolbar
C Choose required color on Fill Color tool in Drawing toolbar
D All of above
Correct Answer

Option D: All of above

Discussion
64 Details Computer Science MS Excel Easy

How can you remove borders applied in cells?

A Choose None on Border tab of Format cells
B Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C Both of above
D None of above
Correct Answer

Option C: Both of above

Discussion
71 Details Computer Science MS Excel Easy

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A Number format
B Border format
C Font format
D All of above
Correct Answer

Option D: All of above

Discussion
75 Details Computer Science MS Excel Easy

Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from

A from Fromat >> Cells
B from Format >> Autoformat
C from Table >> Autoformat
D All of above
Correct Answer

Option B: from Format >> Autoformat

Discussion
72 Details Computer Science MS Excel Easy

Merge cells option can be applied from

A Format Cells dialog box Alignment Tab
B Formatting toolbar
C Both of above
D None of above
Correct Answer

Option C: Both of above

Discussion
63 Details Computer Science MS Excel Easy

Special category of Number tab in Format Cells dialog box can be used to apply formats like

A Zip Code
B Phone Number
C Both of above
D None of above
Correct Answer

Option C: Both of above

Discussion
69 Details Computer Science MS Excel Easy

Which function will you use to enter current time in a woksheet cell?

A =today()
B =now()
C =time()
D =currentTime()
Correct Answer

Option B: =now()

Discussion
75 Details Computer Science MS Excel Easy

What is entered by the function =today()

A The date value for the day according to system clock
B The time value according to system clock
C Today’s date as Text format
D All of above
Correct Answer

Option A: The date value for the day according to system clock

Discussion
72 Details Computer Science MS Excel Easy

Formatting a cell in Number format you can’t set

A Decimal Places
B Use 1000 separator
C Negative numbers
D Currency Symbol
Correct Answer

Option D: Currency Symbol

Discussion


Computer Science

WhatsApp Support