Excel 2-8 to 2-11

Relational Operator

Formatting will be applied if...

How to change margins

Go to ribbon then go to page layout tab then go to margins

How can I format an entire column at once?

Instead of selecting ranges you can click the column heading then clicked the Center button (Home tab | Alignment group).

Other ways to check spelling is ..

Press F7

Which Colors Work Best When Formatting Your Worksheet?

Warmer colors (red and orange) tend to reach toward the reader. Cooler colors (blue, green, and violet) tend to pull away from the reader.

Margins

are those portions of a printed page outside the main body of the printed document and always are blank when printed.

A background color and border can

draw attention to the title of a worksheet.

What is the result of clicking the Percent Style button?

instructs Excel to display a value as a percentage, which is determined by multiplying the cell entry by 100, rounding the result to the nearest percentage, and adding a percent sign.

What happens when I click the 'Decrease Font Size' button?

Excel assigns the next smaller font size in the Font Size gallery to the selected range.

The following steps print the worksheet.

1 Click File on the ribbon to open the Backstage view. 2 Click the Print tab in the Backstage view to display the Print gallery. 3 If necessary, click the Printer Status button in the Print gallery to display a list of available Printer options and then click the desired printer to change the currently selected printer. 4 Click the No Scaling button and then select 'Fit Sheet on One Page' to select it. 5 Click the Print button in the Print gallery to print the worksheet in landscape orientation on the currently selected printer. 6 When the printer stops, retrieve the hard copy

Steps To Change Column Width

1 Drag through column headings A, B, and C above row 1 to select the columns. Point to the boundary on the right side of column heading C to cause the pointer to become a split double arrow 2 Double-click the right boundary of column heading C to change the width of the selected columns to best fit. Point to the right boundary of the column H heading above row 1. When the pointer changes to a split double arrow, drag until the ScreenTip indicates Width: 10.25 (87 pixels). Do not release the mouse button. 3 Release the mouse button to change the column width. Click the column D heading above row 1 to select the column. While holding down the ctrl key, click the column E heading and then the column I heading above row 1 so that nonadjacent columns are selected. Point to the boundary on the right side of the column I heading above row 1. Drag until the ScreenTip indicates Width: 7.50 (65 pixels). Do not release the mouse button 4 Release the mouse button to change the column widths. Click the column F heading and drag to select the column G heading. While holding down the ctrl key, click the column J heading and drag to select the column K heading above row 1 so that nonadjacent columns are selected. Drag the right boundary of column G until the ScreenTip indicates Width: 11.00 (93 pixels). Release the mouse button to change the column widths. Click anywhere in the worksheet, such as cell A18, to deselect the columns (Figure 2-53).

The following steps assign formats using the 'Accounting Number Format' button and the Comma Style button.

1.Select the range to contain the accounting number format 2.While holding down the ctrl key, select the cell, the range , and cell to select the nonadjacent ranges and cells. 3.Click the 'Accounting Number Format' button (Home tab | Number group) to apply the accounting number format with fixed dollar signs to the selected nonadjacent ranges.

Click the_________ to display the Borders gallery

the Borders arrow

Click the Format Cells: Number Format Dialog Box Launcher to display

the Format Cells dialog box.

"Format only the cells that contain,"

the second text box in the Edit the Rule Description area allows you to select a relational operator, such as greater than, to use in the condition.

Best fit

the width of the column will be increased or decreased so that the widest entry will fit in the column.

Layout to display the Page Layout tab. Click the Themes button to display?

themes gallary

Can I hide a row?

Yes. As with column widths, when you decrease the row height to 0, the row is hidden. To instruct Excel to display a hidden row, position the pointer just below the row heading boundary where the row is hidden and then drag downward. To set a row height to best fit, double-click the bottom boundary of the row heading. You also can hide and unhide rows by right-clicking the row or column heading and selecting the option to hide or unhide the cells.

What else can I place in a header?

You can add additional text, page number information, date and time information, the file path of the workbook, the file name of the workbook, the sheet name of the workbook, and pictures to a header.

What can I print?

Excel includes three options for selecting what to print . As shown in the previous steps, the Print Selection option instructs Excel to print the selected range. The 'Print Active Sheets' option instructs Excel to print the active worksheet (the worksheet currently on the screen) or selected worksheets. Finally, the 'Print Entire Workbook' option instructs Excel to print all of the worksheets in the workbook.

What should I do if I make a mistake setting up a rule?

If after you have applied the conditional formatting you realize you made a mistake when creating a rule, select the cell(s) with the rule you want to edit, click the Conditional Formatting button (Home tab | Styles group), select the rule you want to edit, and then click either the Edit Rule button (to edit the selected rule) or the Delete Rule button (to delete the selected rule).

What other actions can I take in the Spelling dialog box?

If one of the words in the Suggestions list is correct, select it and then click the Change button. If none of the suggested words are correct, type the correct word in the 'Not in Dictionary' text box and then click the Change button. To change the word throughout the worksheet, click the Change All button instead of the Change button. To skip correcting the word, click the Ignore Once button. To have Excel ignore the word for the remainder of the worksheet, click the Ignore All button.

What happens if I change the column width to zero (0)?

If you decrease the column width to 0, the column is hidden. Hiding cells is a technique you can use to hide data that might not be relevant to a particular report. To instruct Excel to display a hidden column, position the mouse pointer to the right of the column heading boundary where the hidden column is located and then drag to the right.

What if I want to make a large change to the column width?

If you want to increase or decrease column width significantly, you can right-click a column heading and then use the Column Width command on the shortcut menu to change the column's width. To use this command, however, you must select one or more entire columns.

You may want to change the format of the dates to better suit your needs. ..

In addition, numbers that are not used in calculations often are centered instead of right-aligned.

Do I need to change the orientation every time I want to print the worksheet?

No. Once you change the orientation and save the workbook, Excel will save the orientation setting for that workbook until you change it. When you open a new workbook, Excel sets the orientation to portrait.

How do I decide which number format to use?

Once you select a number category, you can select the number of decimal places, whether to include a dollar sign (or a symbol of another currency), and how negative numbers should appear. Selecting the appropriate negative numbers format is important, because some formats add a space to the right of the number in order to align numbers in the worksheet on the decimal points and some do not.

How to check speller on worksheet

Select cell A2 so that the spelling checker begins checking at the selected cell. Click Review on the ribbon to display the Review tab. Click the Spelling button (Review tab | Proofing group) to use the spelling checker to display the misspelled word in the Spelling dialog box. Verify that the word highlighted in the Suggestion area is correct. Click the Change button (Spelling dialog box) to change the misspelled word to the correct word Click the Close button to close the Spelling dialog box. If a Microsoft Excel dialog box is displayed, click the OK button. Click anywhere in the worksheet, such as cell A18, to deselect the current cell. Display the Home tab. Save the workbook again on the same storage location with the same file name.

the Fill Color gallery

Select the range and then click the Fill Color arrow (Home tab | Font group) to display

What is the effect of applying the a'Accounting Number Format'?

The ______________ button assigns a fixed dollar sign to the numbers in the ranges and rounds the figure to the nearest 100th. A fixed dollar sign is one that appears to the far left of the cell, with multiple spaces between it and the first digit in the cell.

What happens when the spelling checker finds a misspelled word?

When the spelling checker identifies that a cell contains a word not in its standard or custom dictionary, it selects that cell as the active cell and displays the Spelling dialog box. The Spelling dialog box displays the word that was not found in the dictionary and offers a list of suggested corrections

What is the difference between using the accounting number style and currency style?

When using the currency style, recall that a floating dollar sign always appears immediately to the left of the first digit. With the accounting number style, the fixed dollar sign always appears on the left side of the cell.

between

cell value is between two numbers

equal to

cell value is equal to a number

greater than

cell value is greater than a number

greater than or equal to

cell value is greater than or equal to a number

less than

cell value is less than a number

less than or equal to

cell value is less than or equal to a number

not between

cell value is not between two numbers

not equal to

cell value is not equal to a number

character

defined as a letter, number, symbol, or punctuation mark.

A theme

formats a worksheet by applying a collection of fonts, font styles, colors, and effects to give it a consistent appearance.

footer

is text and graphics that print at the bottom of each page.

A header

is text and graphics that print at the top of each page.

Conditional formatting

offers you the ability to automatically change how a cell appears — the font, font color, background fill, and other options — based on the value in the cell.