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
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
To add the numbers contained a selected rangeYou would use
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
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
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
4 - Worksheet: Formatting & Copying HM 271 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
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 .
You've reached the end of your free preview.
Want to read all 35 pages?
- Spring '16