Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Save the workbook as SC_EX_5_FormatCodes. 2. Select cell B3. Display the Format Cells dialog box, and note that the General format has been applied

image text in transcribed

1. Save the workbook as SC_EX_5_FormatCodes. 2. Select cell B3. Display the Format Cells dialog box, and note that the General format has been applied to this cell. Create a custom format code that will display the 10-digit number entered in cell B 3 in the format shown in Figure 5-76b. 3. Select cell B4. Display the Format Cells dialog box, and note that a Custom Format code has been applied to this cell. Edit this custom format code to display the 6-digit number with text i cell B4 in the format shown in Figure 5-76b. 4. For each of the remaining cells in the range B5:B13, edit or create a custom format code to produce formatted cell contents that match Figure 5-76b. 5. Add a header to the worksheet that contains the file name (center) and page number (right). 6. If requested by your instructor, enter your phone number in cell B3 in place of the existing 10-digit number

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

Beginning VB 2008 Databases

Authors: Vidya Vrat Agarwal, James Huddleston

1st Edition

1590599470, 978-1590599471

More Books

Students also viewed these Databases questions

Question

What were the issues and solutions proposed by each team?

Answered: 1 week ago

Question

3. Who would the members be?

Answered: 1 week ago