Introduction

Formatting Data Tables in Spreadsheets

Figure 1

multiple-info example

Figure 2

single-info example

Formatting Problems

Figure 1

multiple tables

Figure 2

filling in zeros

Figure 3

formatting

Figure 4

good formatting

Figure 5

comments in cells

Dates as Data

Figure 1

Many formats, many ambiguities

Figure 2

dates exercise 1

Quality Assurance

Figure 1

Image of data validation tab in Excel

Figure 2

Image of data validation tab in LibreOffice

Figure 3

Image of data validation tab for number rules in Excel

Figure 4

Image of data validation tab in LibreOffice

Figure 5

Image of error message for inputing invalid data in Excel

Figure 6

Image of error message for inputing invalid data in LibreOffice

Figure 7

Image of Input Message tab in Excel

Figure 8

Image of Input Message tab in LibreOffice

Figure 9

Image of Error Alert tab in Excel

Figure 10

Image of Error Alert tab in LibreOffice

Figure 11

Image of data validation tab in Excel

Figure 12

Image of data validation tab in Excel

Figure 13

Image of selecting a range of values to allow in Excel

Figure 14

Image of selecting a range of values to allow in LibreOffice

Figure 15

Image of filled in range of values to allow in LibreOffice

Exporting Data

Figure 1

Saving an Excel file to CSV