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 for number rules in Excel

Figure 3

Image of data validation tab in LibreOffice

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 Error Alert tab in Excel

Figure 8

Image of Error Alert tab in LibreOffice

Figure 9

Image of Input Message tab in Excel

Figure 10

Image of Input Message tab in LibreOffice

Figure 11

Image of selecting a range of values to allow in Excel

Figure 12

Image of selecting a range of values to allow in LibreOffice

Figure 13

Image of filled in range of values to allow in LibreOffice

Exporting Data

Figure 1

Saving an Excel file to CSV