Question: Format this sheet to look as same as possible as the printed solution, using the instructions below. 1. Large title cell formatting (merged cells); light-gray

Format this sheet to look as same as possible as the printed solution, using the instructions below. 1. Large title cell formatting (merged cells); light-gray fill colour, larger font size (estimate). (2 marks) Borders as shown. (2 marks) Enter a date function in Cell B16 that will display the current date and time. Change the format to display both the date and time; do not use two cells to do this. (2 marks) 2. 3. 4. Cell formatting: 1) Accounting Format (no decimals) where you see the dollar signs, 2) comma formatting (no decimals) on remaining values, and 3) text bolded and centred where needed. (3 marks) Adjust print layout for this sheet so it matches the solution provided: . Set print area for the budget sheet only. (1 mark) Centred horizontally only. (1 mark) Name in header. (1 mark) Current date. (1 mark) Sheet name (1 mark) Page numbers in footer as shown (1 mark) Prints on one page in landscape orientation. (1 mark) Answer the questions 1. Use the correct function to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!