Excel Exercises

Open a new Excel file. Delete the worksheets: Sheet1 and Sheet2.

Create the Worksheet shown above in Sheet1 and Rename it Coral.

Set the columns A,B:9; Columns C&D:11.

Set the height of Row 2 as 40.

Align all columns labels horizontally and vertically center.

After entering data, insert a new row between rows 2&3.

Format column F to include $ sign and 2 decimal places.

Center the worksheet vertically and holizontally on the page.

Save the file with the name EXCEL1 in the KNECEXAM folder.

Open a spreadsheet program and key in the data as it appears. Save the workbook as hospital data in the KNECEXAM folder.