Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started