27. (a) Calendar Use Excel to create a spreadsheet of 365 rows and 2 columns, where the first column of each row contains a date in 2015 and the adjacent second column contains the corresponding day of the week. Figure 5.33 shows the first two rows of the spreadsheet. The remaining entries of the spreadsheet can be obtained by select- ing the cells in Fig. 5.30 and dragging them down until 365 rows have been created. (b) Save the spreadsheet as a CSV file named Calendar2015. csv. Note: Select "CSV (Comma delimited)(*.csv)" in the "Save as type" dropdown box. (c) Change the file's name to Calendar2015.txt. (d) Use the text file in a program that requests a date in 2015 as input and then gives its day of the week. See Fig. 5.31. Enter a date in 2015: 11/3/2015 11/3/2015 falls on a Tuesday A B 1 1/1/2015 Thursday 2 1/2/2015 Friday FIGURE 5.30 Spreadsheet for Exercise 27. FIGURE 5.31 Possible outcome of Exercise 27.

C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter3: Assignment, Formatting, And Interactive Input
Section: Chapter Questions
Problem 6PP: (Heat transfer) The formula developed in Exercise 5 can be used to determine the cooling time, t,...
icon
Related questions
Question

Alert dont submit AI generated answer.

Python please solve all question.

 

27. (a) Calendar Use Excel to create a spreadsheet of 365 rows and 2 columns, where the
first column of each row contains a date in 2015 and the adjacent second column
contains the corresponding day of the week. Figure 5.33 shows the first two rows of
the spreadsheet. The remaining entries of the spreadsheet can be obtained by select-
ing the cells in Fig. 5.30 and dragging them down until 365 rows have been created.
(b) Save the spreadsheet as a CSV file named Calendar2015. csv. Note: Select "CSV
(Comma delimited)(*.csv)" in the "Save as type" dropdown box.
(c) Change the file's name to Calendar2015.txt.
(d) Use the text file in a program that requests a date in 2015 as input and then gives
its day of the week. See Fig. 5.31.
Enter a date in 2015: 11/3/2015
11/3/2015 falls on a Tuesday
A
B
1
1/1/2015 Thursday
2
1/2/2015 Friday
FIGURE 5.30 Spreadsheet for Exercise 27.
FIGURE 5.31
Possible outcome of Exercise 27.
Transcribed Image Text:27. (a) Calendar Use Excel to create a spreadsheet of 365 rows and 2 columns, where the first column of each row contains a date in 2015 and the adjacent second column contains the corresponding day of the week. Figure 5.33 shows the first two rows of the spreadsheet. The remaining entries of the spreadsheet can be obtained by select- ing the cells in Fig. 5.30 and dragging them down until 365 rows have been created. (b) Save the spreadsheet as a CSV file named Calendar2015. csv. Note: Select "CSV (Comma delimited)(*.csv)" in the "Save as type" dropdown box. (c) Change the file's name to Calendar2015.txt. (d) Use the text file in a program that requests a date in 2015 as input and then gives its day of the week. See Fig. 5.31. Enter a date in 2015: 11/3/2015 11/3/2015 falls on a Tuesday A B 1 1/1/2015 Thursday 2 1/2/2015 Friday FIGURE 5.30 Spreadsheet for Exercise 27. FIGURE 5.31 Possible outcome of Exercise 27.
Expert Solution
steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage