Microsoft Excel Advanced Formatting

6 Questions | By Dhardma1 | Last updated: Feb 15, 2013 | Total Attempts: 79

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

Related Topics

More Advanced Excel Quizzes

Advanced Excel Quiz Questions And Answers

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: 2400 | Last updated: May 18, 2021

Sample Question
_______ tab, in the Editing group, click Find & Select, and then click Go To.

Data

Home

Advanced Excel For Actuaries Quiz

See if you got the correct answers to the assignment.

Questions: 5 | Attempts: 229 | Last updated: Aug 25, 2013

Sample Question
On the Summary tab, what formula did you use to get Region 6's Aug value (cell G9)?

=INDIRECT("'"&F$1&"'!"&$L9)

=INDIRECT("'"&G$1&"'!"&$L2)

=INDIRECT("'"&G$1&"'!"&$L9)

=SUM(INDIRECT(H1&"!"&"B2:B13"))

Ms Excel Assessment Test: Questions & Answers

Think you are an expert in MS Excel? How much do you know about spreadsheets, cells, columns, etc.? Can you apply formulas on cells to get desired results? Take the online quiz to test your knowledge and brush up on your basics...

Questions: 25 | Attempts: 2294 | Last updated: May 5, 2021