Formatting: Test your skills >> Excel Skills For Business: Essential
1. Sean wants to make a change in cell B2, but every time he clicks on the cell, A1 becomes the active cell instead.
What is most likely happening here?
- A1:B2 have been set to Wrap Text.
- A1:B2 are a range and cannot be selected separately.
- A1:B2 are linked through an absolute reference.
- A1:B2 have been merged.
2. Open the attached workbook and observe how the heading in row 1 has been formatted. What is the name of the font used in the heading?
W03-Assessment.xlsx
36
3. Which alignment option has been applied to the heading in row 1?
- Middle Align
- Wrap Text
- Merge and Center
- Increase Indent
4. Which alignment options have been applied to cell A3?
(One or more answers are possible — partial credit will be awarded)
- Middle Align
- Center
- Italics
- Bold
5. The date in B3 has lost its formatting. Apply a Long Date format. What day of the week was this data last modified?
- Monday
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
- Sunday
6. The percentages in T9 and T10 also have the wrong number format. Change them to the correct number format (to match the rest of the data in the column). What value now shows in T9?
93%
7. Which Cell Style has been added to cells C38:U38? (Hint: Look in the Cell Styles gallery, when you hover over a style it tells you the name.)
Total
8. Which of the following formats has been added to B3?
- Underline
- Outside Borders
- Thick Bottom Border
- Double Underline
9. Which alignment option has been applied to the headings in D6:T6?
- Merge and Center
- Rotate Text Up
- Vertical Text
- Wrap Text
10. Which alignment option has been applied to cell U31?
- Merge and Center
- Middle Align
- Center
- Wrap Text
11. Click on cell S38 and increase the number of decimal places to 3. What is the value in the cell now? (Enter using the number format ##.###).
30.867