You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that
contains various tables, headings, charts, and SmartArt objects. In order to give it a professional
look, you choose Office theme as shown below:

You like the appearance of the sheet in this theme; however, you want to use the Lucida Calligraphy
font for heading and Arial font for the body text. You often use this font combination for formatting
office sheets. You are required to accomplish the following tasks:
Use the font combination in your current document.
Enable Excel to provide this combination in other office documents too.
Choose the required steps to accomplish the tasks.

Answer:

Explanation:
In order to accomplish the tasks, you will have to take the following steps:
Choose the Fonts option in the Themes group on the Page Layout tab.

Open the Create New Theme Fonts dialog box by clicking the Create New Theme Fonts option from
the Theme Fonts list.

In the dialog box, provide the required font names for header and body texts, provide name for the new theme.

These steps will create a custom theme, which will be available for other office documents too.

Document themes work on the overall design of the entire document. It enables users to specify
colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the
document. Microsoft Excel comes with a large collection of pre-built themes. Users can create their
own themes for a document. Themes can be specified through Page Layout > Themes.