Start Learning
Beginner

Excel Basics Quiz

Test your knowledge of the Excel fundamentals.

1. What symbol must every Excel formula begin with?

Every formula starts with an equals sign — without it, Excel treats the entry as plain text.

2. Which function adds a range of numbers?

SUM is the standard function for totaling a range of cells.

3. What is a single box in a spreadsheet called?

Each box in the grid, identified by a column letter and row number, is called a cell.

4. Which key lets you edit a cell in place instead of retyping it?

F2 puts the selected cell into edit mode without clearing its existing contents.

5. In the formula =IF(A1>=60,"Pass","Fail"), what do the quotation marks indicate?

Any text result inside a formula needs quotation marks around it; numbers do not.