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

Microsoft Excel - Quiz(MCQ)

Choose required color on Fill Color tool in Drawing toolbar

Choose required color on Fill Color tool in Formatting toolbar

Choose required color form Patterns tab of Format Cells dialog box

All of the above

Correct Answer : All of the above

Explanation : The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

Recently Updated in Microsoft Excel Questions

What is the keyboard shortcut to switch between open Excel windows?

ALT + TAB

CTRL + TAB

CTRL + ALT + TAB

None of the above

Correct Answer : CTRL + TAB

What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?

ALT + SHIFT + "

CTRL + ALT + "

CTRL + SHIFT + C

CTRL + SHIFT + "

Correct Answer : CTRL + SHIFT + "

Explanation : The keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar is "CTRL + SHIFT + "".

What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

CTRL + 1

ALT + 1

CTRL + F

CTRL + SHIFT + F

Correct Answer : CTRL + 1

Explanation : The keyboard shortcut to display the Format Cells dialog box is "CTRL + 1".

New Technologies MCQ's

Machine Learning

Artificial Intelligence