Get Certified for Free Browse courses

Spreadsheets · Level 1 of 5 · Intro

Spreadsheet basics

Cells, rows, columns, entering data, and simple formulas.

Study notes

  1. A spreadsheet is a grid. Columns are letters, rows are numbers, and a cell address combines them, like B3.
  2. Formulas start with an equals sign, for example =A1+A2.
  3. SUM adds a range: =SUM(B2:B10) adds every value from B2 through B10.
  4. Keep one type of data per column and one record per row. Put headers in the first row.
  5. Format numbers as currency, percent, or dates so they display correctly without changing the value.

Quiz: 6 questions

Choose one answer for each question, then check your answers. Score 5 of 6 to pass. Then enter your name and email to download a PDF certificate and have a copy emailed to you. Answers are graded in your browser.

1. What is the address of the cell in column C, row 5?

2. Every formula starts with:

3. =SUM(B2:B4) adds:

4. Best layout for a contact list?

5. Formatting 0.25 as a percent shows:

6. If A1 is 10 and A2 is 5, =A1-A2 returns:

About this certificate: Certificates are issued by Get Certified for Free for passing a free online knowledge quiz. They are not accredited, licensed, government, academic, or professional credentials and do not confer a license. Read the full terms.