Moduel 2

Unmerge Cells—

reverses a merge, returning the merged cell to a range of individual cells

Page Break Preview shows only

those parts of the active sheet that will print and how the content will be split across pages. A dotted blue border indicates a page break, which separates one page from another.

The Format Cells dialog box has six tabs, each focusing on a different set of formatting options, as described below:

Number— options for formatting the appearance of numbers, including dates and numbers treated as text such as telephone or Social Security numbers Alignment— options for how data is aligned within a cell Font— options for selecting font types, sizes, styles, and other formatting attributes such as underlining and font colors Border— options for adding and removing cell borders as well as selecting a line style and color Fill— options for creating and applying background colors and patterns to cells Protection— options for locking or hiding cells to prevent other users from modifying their contents

where do you find the pint titles option in excel?

On the Page Layout tab, in the Page Setup group, click the Print Titles button. The Page Setup dialog box opens with the Sheet tab displayed.

filling a cell's background with color, also known as

a fill color, can be helpful for highlighting data, differentiating parts of a worksheet, or adding visual interest to a report. Fill colors can also be used with the sheet tabs.

theme is

a predefined coordinated set of colors, fonts, graphical effects, and other formats that can be applied to workbooks to give them a consistent, professional look.

The Paste Special command provides another way to control what you paste from the Clipboard. To use Paste Special, select

and copy a range, select the range where you want to paste the Clipboard contents, click the Paste arrow in the Clipboard group on the Home tab, and then click Paste Special to open the dialog box

Serif fonts, such

as Times New Roman, have extra strokes at the end of each character.

Ten standard colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—are always

available regardless of the workbook's theme.

One way to ensure that similar data is displayed consistently is with

cell styles. A cell style is a collection of formatting options—such as specified font, font size, font styles, font color, fill color, and borders—that you can apply to cells .(home tab, style group)

The Currency format places the

currency symbol directly to the left of the first digit of the monetary value and displays negative numbers with a negative sign.

To ensure that everyone knows why certain cells are highlighted, you should

document the meaning of the format.

The Format Painter provides a

fast and efficient way of copying and pasting formats from several cells at once, ensuring that a workbook has a consistent look and feel. The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data.

The Find and Replace

find each occurrence of the search text one at a time and decide whether to replace it.

When you create a custom cell style, you select the

font, font size, font styles, alignment, number format, borders, and fill you want to include in that cell style

Cells start out formatted with the General format, which,

for the most part, displays numbers exactly as they are typed.

Conditional formatting is used to

format a cell based on its value, which helps draw attention to important or unusual results, such as sales that exceed a specified goal or a large expense on a balance sheet.

how to rotate words in a cell?

home tab, alignment group, orientation button, rotate text...

AVERAGE function calculates the average value from a collection of numbers. It has the syntax:

=AVERAGE(NUMBER1, [NUMBER2], [NUMBER3], ...) =AVERAGE (A1:A4)

Once you've changed a theme's colors or fonts, you can save the custom theme in its own theme file. You do this by

clicking the Themes button in the Themes group on the Page Layout tab, and then clicking Save Current Theme.

A header is 2. a footer is

information that appears at the top of each printed page, 2. the information that appears on the bottom of every page.

Text formatted with a standard font retains

its appearance no matter what theme is used with the workbook.

The Accounting format places the currency symbol at the

left edge of the column and displays negative numbers within parentheses and zero values with a dash.

To split the printout into logical segments, you can insert

manual page breaks. Page Break Preview identifies manual page breaks with a solid blue line and automatic page breaks with a dotted blue line. When you specify a print area for a nonadjacent range, manual page breaks are inserted around the adjacent ranges and appears in the print area you defined.

Merge Across—

merges each row in the selected range across the columns in the range

Merge Cells—

merges the range into a single cell but does not horizontally center the cell content

Merge & Center—

merges the range into one cell and horizontally centers the content

You can modify any conditional formatting rule to change what is being formatted, as well as change what formatting is applied. You do this by

n the Home tab, in the Styles group, click the Conditional Formatting button and then click Manage Rules. The Conditional Formatting Rules Manager dialog box opens. 2. Click the Show formatting rules for arrow, and then click This Worksheet to list all conditional formatting rules in the current worksheet Make sure the Top 10% rule is highlighted, and then click Edit Rule. Change the rules and click oK

f you want to print only part of a worksheet, you can set a confirm what will print.

print area, which is the region of the worksheet that is sent to the printer. Each worksheet has its own print area. Although you can set the print area in any view, Page Break Preview shades the areas of the worksheet that are not included in the print area, making it simple to

Theme colors are a set of

12 coordinated colors that belong to the workbook's theme

To change the theme colors, click the

Colors button in the Themes group on the Page Layout tab, and then select one of the color palettes.

To change the theme fonts, click the

Fonts button in the Themes group on the Page Layout tab, and then select one of the font themes for heading and body text.

Use the following steps to copy custom cell styles from one workbook to another:

Open the workbook containing the custom cell styles (the source workbook). Open the workbook you want to copy the cell styles to (the destination workbook). In the destination workbook, open the Cell Styles gallery, and then click Merge Styles at the bottom of the gallery. Select the source workbook containing the custom cell styles, and then click OK.

To create custom colors, you use the

RGB Color model in which each color is expressed with varying intensities of red, green, and blue.

The abbreviated format, mm/dd/yyyy, entered in the Documentation sheet is referred to as the

Short Date format.

The Mini toolbar is a

small toolbar that appears next to selected content, containing the most frequently used formatting commands for that content.

Sans serif fonts,

such as Calibri, do not include these flourishes

The Long Date format displays

the day of the week and the full month name in addition to the day of the month and the year

You can remove a conditional format at any time without affecting the underlying data. Just select

the range containing the conditional format, click the Conditional Formatting button in the Styles group on the Home tab, and then click the Clear Rules command. A menu opens, providing options to clear the conditional formatting rules from the selected cells or the entire worksheet.

To help you choose the best formatting option, Live Preview shows

the results that would occur in your workbook if you clicked the formatting option you are pointing to.

A margin is

the space between the page content and the edges of the page. By default, Excel sets the page margins to 0.7 inch on the left and right sides, and 0.75 inch on the top and bottom; and it allows for 0.3-inch margins around the header and footer.

The Quick Analysis tool,

which appears whenever you select a range of cells, provides access to the most common tools for data analysis and formatting of the selected range

A theme font is associated

with a particular theme and used for headings and body text in the workbook.