Back to lesson
1. What is the main benefit of using Styles?
It is easy to update all similarly formatted cells at once if it's needed.
It is easy to apply multiple formatting components at once.
The color choices are better with styles than with standard formatting alone.
2. Suppose you want to apply a currency style to a set of numbers as quickly as possible. After having selected the numbers, what do you do next?
Right click the selection and choose Format Cells, and then select Numbers and Currency and click OK.
Go to the Home tab, click Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery) and then choose Currency.
Go to the Home tab and click the $ on the Numbers group.
3. How do you modify a custom style to force the changes through your workbook?
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), and then right click your Style and choose Modify.
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), delete the old style, and then click New Style and name it the same as the old style.
Right click any cell that uses the style, and choose “Modify cell style”.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement