Computer Science, asked by jay147, 1 year ago

make a time table of any class in excel

Answers

Answered by badalsolanki957
0

Explanation:

create your new gmail account and any attachments introduction activities.

Answered by aditijaink283
0

Answer:

The answer to the given question is explained in the explanation.

Explanation:

Excel class schedule creation 1. Launch Microsoft Excel.

2. Enter the class schedule in cell A1.

3. Select the entire column A by clicking the gray "A" box at the top of the worksheet.

Format, go to the cell.

On the Numbers tab, click Time, and then in the Type section, click 2 PM.

Click OK.

3. Start the spreadsheet by creating a time interval in column A. I usually use 15-minute intervals. Please enter at least 3 different times.

4. After you type it three times, you can let the computer do the rest.

Select it three times and move the arrow to the small box in the lower right corner of the box.

Till the day is over, click and drag.

5. Next, select Monday in cell B2.

Click the bottom right box and drag until all the days of the week appear.

6. Select cells A1-F1 to center the header. Click the "Merge and Center" button.

7. You can now create lines in your schedule. Select all cells to be separated by borders. Click the Borders button and select all borders.

8. Now click and drag the gray box above the chart to select columns B-F.

Go to Format, Columns, Width. Enter

"15" and click OK.

9. You can now enter your class schedule. You must enter the cell where the class begins.

10. Then select the two cells you want to combine into one class.

Merge and click the middle button.

Continue this for all classes.

11. Now select all cells containing the day of the week and the class.

Press the center button.

Now click Format, Cells. Select the Align tab and under Vertical, select Top. Also, don't forget to check the box next to Text Wrap.

#SPJ2

Similar questions