Introduction

Formatting data tables in Spreadsheets

Formatting problems

Figure 1

multiple tabs

Figure 2

formatting

Figure 3

good formatting

Dates as data

Figure 1

{alt=‘dates, exersize 1’ .output}

Quality control

Figure 1

Image of Data Validation button on Data tab

Figure 2

Image of Data Validation window

Figure 3

Image of Data Validation window for validating plot values

Figure 4

Image of error when trying to enter invalid data

Figure 5

Image of Input Message tab

Figure 6

Image of drop-down menu

Exporting data

Figure 1

Saving an Excel file to CSV