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 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

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