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.

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.

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 _____.

• 
• 
• 
•