vladimak97 / galactic_innovations_insert_adhere

Importing and Formatting Excel Data

Exercise 2

Disclaimer: The data presented in this exercise is purely fictive and crafted for educational purposes only.

1. Start by creating two new sheets in your workbook, naming them "Books" and "Company".

2. Then, switch to the "Books" sheet that you created. You need to open another Excel file named "books_dataset.xlsx". With both Excel files open, copy all the data from columns A to I from the dataset and paste it as values into your "Books" sheet.

3. Now, adjust the width of all columns to 15. Also, make sure the first letter of each column header is capitalized, with the remaining letters in lowercase. You can achieve this by using the formula =PROPER(cell).

4. Next, in the "Company" sheet, fill in the following information starting from cell A1. You'll be entering data about three companies across three columns and four rows:

5. What is the number of pages in the book listed in row B20?

Answer: It's 589 pages.