After studying this chapter you will be able to understand: What is the concept of formula? What is function in spreadsheet? What happens if you don’t use equal sign before formula or function? List few types of charts. | MS Excel- Spreadsheet ADE100- Computer Literacy Lecture 18 Knowledge test What is the concept of formula? What is function in spreadsheet? What happens if you don’t use equal sign before formula or function? List few types of charts. 2 Topics covered Print properties Using spreadsheets to create classroom management documents Seating chart Electronic attendance register Result sheet Student academic performance graph Bio data 3 Printing in Excel Print preview Provides a view about how the page will look like after printing Allows to make changes before printing Method Choose File>>Print>>Print Preview 4 Print preview 5 Print preview toolbar 6 Print Print dialog box will open Zoom Increase or decrease the page view in percentage Show margins Click to view page margins Print dialog box 7 Print preview toolbar Next page Click to view the next page of document Previous page Click to view the previous page of document Close print preview Click to close print preview window 8 Print preview | MS Excel- Spreadsheet ADE100- Computer Literacy Lecture 18 Knowledge test What is the concept of formula? What is function in spreadsheet? What happens if you don’t use equal sign before formula or function? List few types of charts. 2 Topics covered Print properties Using spreadsheets to create classroom management documents Seating chart Electronic attendance register Result sheet Student academic performance graph Bio data 3 Printing in Excel Print preview Provides a view about how the page will look like after printing Allows to make changes before printing Method Choose File>>Print>>Print Preview 4 Print preview 5 Print preview toolbar 6 Print Print dialog box will open Zoom Increase or decrease the page view in percentage Show margins Click to view page margins Print dialog box 7 Print preview toolbar Next page Click to view the next page of document Previous page Click to view the previous page of document Close print preview Click to close print preview window 8 Print preview Page setup Used to set page orientation Scale the print to fit one or more pages Adjust margins Create page headers and footers Print or hide gridlines and screen colors 9 Page orientation, size and scaling Page orientation You can change page orientation between portrait (tall & thin) and landscape (short and wide) Landscape is better for large no. of columns Portrait is better for less columns but more rows Paper size Paper size should match the paper in the printer or the worksheet will not print correctly For example, Letter, A4, Legal, etc. Scaling Used to shrink the print to any required size, a number greater than 100 is used to enlarge the page 10 Page Setup 11 Page margins From page setup dialog box, select the margins tab Enter the new margin dimensions in the boxes From the Center on page panel, click the alignment tick boxes required . horizontally or vertically 12 Page Margins 13 Header and Footer of worksheet Data can be added at the top (header) or at the bottom .
