Microsoft Excel Advanced Formatting
6 Questions
| Total Attempts: 97
Advanced Unit 2. Formating cells & spreadsheets
Questions and Answers
- 1.Themes include which elements?
- A.
Colors
- B.
Fonts
- C.
Borders
- D.
All of the above
- E.
Color & fonts
- 2.A style is a named collection of formats that are saved and applied as a group
- A.
True
- B.
False
- 3.You can apply an actual watermark in Excel
- A.
True
- B.
False
- 4.Which of the following can be used in styles
- A.
Number
- B.
Alignment
- C.
Font
- D.
All of the above
- 5.When you apply special number formats to data, Excel changes both the cell's apperance and the cell's value
- A.
True
- B.
False
- 6.Special number formats contain, but are not limited to, zip codes and phone numbers
- A.
True
- B.
False
Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your...
Questions: 50 | Attempts: 3534 | Last updated: May 18, 2021
-
Sample Question_______ tab, in the Editing group, click Find & Select, and then click Go To.
Knowledge Excel Level 3 (Advanced)
Questions: 10 | Attempts: 728 | Last updated: Feb 28, 2013
-
Sample QuestionHow many conditions can the sumif check for?
Questions: 22 | Attempts: 6422 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Back to top