Which group of the page layout tab has feature to get a worksheet ready for printing explain any three options that is offers
Answers
Answer:
In Page Layout option, we have various commands which we use to prepare the workbook for printing and exporting to PDF format. Through this command, we can adjust the page in the way we want to see after printing.
Explanation:
a) Themes: - This option is used to change the theme color of workbook by just click of a button. Each theme has 12 colors, two fonts (heading and body), SmartArt and the effects for shape. Also, we have color option whereby we can create new color’s theme, by using the Font option, we can create new font theme as well. So, if we want to create our own theme we can create it by using Themes option in Excel.
b) Page Setup: -We use this option to set up the page for printing. So, we have Margins, Orientation, Size, Print Area, Breaks, Background and Print titles, in this group, which we use to prepare the page for printout.
c) Scale to Fit: -This option helps to fit the page for printing by shrinking or enlarging its size to better fit the pages. We can use Scale to fit to adjust the width and height by describing the scale %age.
d) Sheet Options: -It is also a printing option that can show or hide the gridlines, while printing and heading options are used to give headings to the rows and columns.