0
0
Google Sheetsspreadsheet~5 mins

Reading and writing cell values in Google Sheets - Cheat Sheet & Quick Revision

Choose your learning style9 modes available
Recall & Review
beginner
What does it mean to read a cell value in Google Sheets?
Reading a cell value means looking at the content inside a cell to see what data or text it holds.
Click to reveal answer
beginner
How do you write a value into a cell in Google Sheets?
You click on the cell and type the value or formula you want, then press Enter to save it.
Click to reveal answer
beginner
What is the difference between a cell's value and a cell's formula?
A cell's value is what you see displayed, while a formula is an instruction that calculates that value.
Click to reveal answer
beginner
How can you reference another cell's value in a formula?
You use the cell address, like A1 or B2, inside the formula to use that cell's value.
Click to reveal answer
beginner
What happens if you write a formula in a cell?
The cell shows the result of the formula, not the formula text itself.
Click to reveal answer
How do you read the value of cell B3 in Google Sheets?
AUse the formula =SUM(B3)
BType =B3 in another cell
CClick on cell B3 and press Delete
DLook at the content displayed in cell B3
What is the first step to write a value into a cell?
ASelect the cell you want to write in
BPress Enter without selecting a cell
CType a formula in the formula bar without selecting a cell
DCopy a cell value
If cell A1 contains 5, what will =A1+3 show in another cell?
AA1+3
B8
C5+3
DError
What does a formula in a cell display?
AThe result of the calculation
BThe formula text itself
CNothing
DThe cell address
How do you reference cell C2 in a formula?
AType $C$2 only
BType =C2 in the cell
CType C2 inside the formula
DType #C2
Explain how to read and write values in Google Sheets cells.
Think about clicking a cell to see or change its content.
You got /4 concepts.
    Describe how formulas use cell references to get values from other cells.
    Formulas use letters and numbers to point to cells.
    You got /4 concepts.