4.0 - Worksheet formatting-1.pptx - Last week Name ranges Name box(tables Define name Create from selection(name of the range in an adjacent cell Insert

4.0 - Worksheet formatting-1.pptx - Last week Name ranges...

This preview shows page 1 - 11 out of 35 pages.

Last week Name ranges Name box (tables) Define name Create from selection (name of the range in an adjacent cell) Insert Name Ranges in formulas and functions COUNTA() Function COUNTBLANK() Function ROUND() Function Slide 1 of 22
Image of page 1
To count the number of cells containing Text in a selected rangeYou would use A. The COUNT() FunctionB. The SUM() FunctionC. The COUNTA() FunctionD. A & C would both work
Image of page 2
To add the numbers contained a selected rangeYou would use
Image of page 3
PRINTING 4
Image of page 4
Printing Setting the print area 1. Select the range to be printed 2. Under the “Page Layout” tab, click on the “Print Area” drop- down menu 3. Click on “Set Print Area” Slide 5 of 22
Image of page 5
Printing Setting the print area You can define multiple and separate print areas They will print on different documents Mouse 1. Select a range with the mouse 2. Hold the Ctrl key 3. Select another range 4. Set the “Print area” Keyboard 5. Select a range 6. Press Shift F8 to anchor the first area 7. Select a second range 8. Press Shift F8 9. Repeat as needed 10. Set the “Print area” You can verify your print areas by pressing the F5 key (GoTo) and selecting Print_Area Slide 6 of 22
Image of page 6
Printing Pre-viewing and adjusting the document The Print menu is activated by clicking on the File tab Or Ctrl F2 on the keyboard The Print page displays a preview of the printed document page formatting commands (size, scaling, orientation, margins…) A drop-down menu listing available printer the Print button to launch the actual printing Slide 7 of 22
Image of page 7
4 - Worksheet: Formatting & Copying HM 271 8
Image of page 8
Objectives Format text, numbers, and dates Change font colors and fill colors Use the format painter Merge a range into a single cell Apply a built-in cell style Select a different theme Format multiple worksheets a time Apply a built-in table style Add conditional formats to tables with highlight rules and data bars Hide worksheet rows & columns Slide 9 of 22
Image of page 9
Formatting Formatting is the process of changing a workbook’s appearance by defining the fonts, styles, colors, and appearance features A theme is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook The quality of your work is evaluated based on both substance and appearance .
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 35 pages?

  • Spring '16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture