Description

Course 1 Final Assessment LATEST SUBMISSION GRADE 100% 1 / 1 point 1 / 1 point Keep Learning Download the workbook and save it on your computer. Open the workbook and then come back here to start answering the questions. C1 Assessment Workbook.xlsx TIP: Make sure that you save your progress on the workbook in Excel frequently as you progress through the exam. Here is the first question: The workbook contains data downloaded from a government database. It is not very easy to read, so your first job is to address some of the formatting. The heading in cell A1 cannot be seen properly. Change the alignment so that you can see what it says. In which year was this data collected? Enter your answer in four digits #### 2015 Correct Yes, that's correct. The title of this spreadsheet is the 2015 Household Expenditure Report, so the data was collected in 2015. 1. Somehow the date in cell B2 has lost its formatting. Change the format to a date. What date is now shown in B2? Enter your answer in Year-Month-Day format (e.g., 2016-12-31