# Spreadsheets Level 1: Spreadsheet basics (free quiz and certificate) | Get Certified for Free

Source: https://getcertifiedforfree.com/courses/spreadsheets/level-1/

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.
1. Formulas start with an equals sign, for example =A1+A2.
1. SUM adds a range: =SUM(B2:B10) adds every value from B2 through B10.
1. Keep one type of data per column and one record per row. Put headers in the first row.
1. 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.

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](https://getcertifiedforfree.com/about-our-certificates/).

[← Spreadsheets overview](https://getcertifiedforfree.com/courses/spreadsheets/) [Level 2: Functions and references →](https://getcertifiedforfree.com/courses/spreadsheets/level-2/)