3 in cell d2 write a formula that will format the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: first name followed by one space followed by the last name with no spaces after it. Instructions: 1) In cell B2 write a formula that will extract only the first name. 2) In cell C2 write a formula that will extract only the last name. 3) In cell D2 write a formula that will format the names to be: “Last name, First name” In the spaces provided, show what formulas you would use for each cell. B2 C2 D2 CS100 Review Package Winter 2011 Page 5 of 21 HTML HTML Tags In the HTML Code column, fill in the HTML tags necessary to produce the desired result as shown in the Webpage column. The first row is completed for you. Tag HTML Code Bold <b>CS 100</b> Body Page Content Page Content Break CS 100 CS 100 Definition List Definition Term Definition Description Definition Term Definition of the term Definition Term Defini...
View Full Document

Ask a homework question - tutors are online