Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

Students also viewed these Databases questions