MS Excel: Formatting Data & Worksheets [G4]

TRUE or FALSE

A style is a set of formatting attributes such as font name, size, alignment, and text color.

(a)  

Which command allows you to apply styles for your selected cell or cell range?

• 
• 
• 
• 

Which command allows you to apply table styles?

• 
• 
• 
• 

Which CLEAR command allows you to remove table styles?

• 
• 
• 

TRUE or FALSE

A table style is a set of formatting choices such as colors, fonts, and effects that you can apply on your worksheet data or other items.

(a)  

In which tab can you find the Themes group?

• Home

• Insert

• Page Layout

• View

All the given commands are found in the Themes group, EXCEPT _____.

• Colors

• Fonts

• Effects

• Styles

Which command are you going to click to remove all borders in your worksheet?

• 
• 
• 
• 

Which number format is used to display currency sign, set the number of decimal places, and set how negative numbers will be displayed.

• General

• Currency

• Percentage

• Number

When you have a long line of text, part of the text might not be visible.

To fix this without changing the column width, click _____.

• 
• 
• 
•