Introduction

Figure 1

Meme with a photo of Oprah Winfrey saying: 'You get an spreadsheet, and you get a spreadsheet. Everyone gets a spreadsheet!'
Oprah spreadsheet meme

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

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

Dates as Data

Figure 1

Meme with the text: Optimist: The glass is one-half full, Pessimist: The glass is one-half empyt, Excel: The glass is January 2nd.

Figure 2

Many formats, many ambiguities

Figure 3

dates exercise 1

Exporting Data

Figure 1

Saving an Excel file to CSV