Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) Click the tab of the first worksheet.
(ii) Hold down the Ctrl key as you click tabs of other worksheets you want to have the same orientation as the first worksheet. Each worksheet tab should appear "highlighted," indicating you are constructing a set of selected worksheets.
(iii) Choose the Page Setup option from the File menu. Excel displays the Page Setup dialog box. To display the dialog box in Excel 2007, click the Page Layout tab of the ribbon and then click the small icon at the bottom-right of the Page Setup group.
(iv) Specify the orientation you want to use from the selected worksheets.
(v) Click OK.
(vi) Click on a worksheet tab different than the one that is currently selected. The tabs should go back to normal, indicating that you are no longer working with a selection set.
(vii) Collating Copies: When you print multiple copies of worksheets that require more than one page each, you will probably want those copies printed as sets. By turning on collation, you can direct Excel to print the sets that you need.
maurice.mutuku answered the question on April 11, 2018 at 05:26
- What is "collating copy printing" and how can you control it?(Solved)
Define "collating copy printing" and show how to control it.
Date posted: April 10, 2018. Answers (1)
- What are the types of page orientation?(Solved)
Give the main types of page orientation.
Date posted: April 10, 2018. Answers (1)
- What is "Page orientation?"(Solved)
Define "Page orientation"
Date posted: April 10, 2018. Answers (1)
- What is computer printout, and why is it important for any organization?(Solved)
Define a computer printout and why it is important for any organization.
Date posted: April 10, 2018. Answers (1)
- What is the difference between a legend and a label in charting?(Solved)
Distinguish between a legend and label in charting.
Date posted: April 10, 2018. Answers (1)
- What are the steps required in creating a bar graph in Excel?(Solved)
List the steps required in creating a bar graph in Excel.
Date posted: April 10, 2018. Answers (1)
- It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet. What precaution would...(Solved)
It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet.
Highlight the precautions you would take before you produce a chart.
Date posted: April 10, 2018. Answers (1)
- How would you place a chart on your worksheet?(Solved)
List ways of placing a chart on your worksheet.
Date posted: April 10, 2018. Answers (1)
- Define the term DSS(Solved)
Define the term DSS.
Date posted: April 10, 2018. Answers (1)
- What are the types of charts in a spreadsheet?(Solved)
Discuss the types of charts in a spreadsheet.
Date posted: April 10, 2018. Answers (1)
- Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were...(Solved)
Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were some ties on similar names that appeared in a disorganized manner.
Advise him on how to break the tie.
Date posted: April 10, 2018. Answers (1)
- Why would you prefer to use forms for data entry in a worksheet than entering data directly onto the cells?(Solved)
Give the reason why you would prefer to use forms for data entry in a worksheet than entering data directly onto the cells.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "Autofilter" and "Advanced Filter?"(Solved)
Differentiate between "Autofilter" and "Advanced Filter"
Date posted: April 10, 2018. Answers (1)
- What is the difference between Sorting and filtering?(Solved)
Differentiate between Sorting and filtering.
Date posted: April 10, 2018. Answers (1)
- What types of format are you likely to carry out on data in a worksheet?(Solved)
Give the types of format you are likely to carry out on data in a worksheet.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "justify" with "Center across selection?"(Solved)
Distinguish between "justify" with "Center across selection"
Date posted: April 10, 2018. Answers (1)
- How would you adjust the column width entries to best fit in your spreadsheet?(Solved)
Explain how you would adjust the column width entries to best fit in your spreadsheet.
Date posted: April 10, 2018. Answers (1)
- What are the golden rules of formatting?(Solved)
List the golden rules of formatting.
Date posted: April 10, 2018. Answers (1)
- What is 'Worksheet formatting?'(Solved)
Define 'Worksheet formatting'
Date posted: April 10, 2018. Answers (1)
- What are the possible causes of the #VALUE! error?(Solved)
Explain the possible cause of the #VALUE! error.
Date posted: April 10, 2018. Answers (1)