Get premium membership and access questions with answers, video lessons as well as revision papers.
Collating is a printing option that allows one to print all pages of a worksheet before printing the next copy of the worksheet.
To control collating, the following steps are made:
(i) Display the Print dialog box from File menu or Click office button and Choose Print in Excel 2007 or press Ctrl+P.
(ii) Specify the number of copies you wish to print.
(iii) Check Collate Copies check box. A check mark in the box indicates the copies will be collated.
(iv) Click on OK. Your worksheet will be printed.
maurice.mutuku answered the question on April 10, 2018 at 13:19
- 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)
- How can you clear as well as edit a cell's content in Excel?(Solved)
Explain how you can clear as well as edit a cell's content in Excel.
Date posted: April 10, 2018. Answers (1)