Question

microsoft excel quiz: rows, columns, cells, and ranges
date: ______ class period: ______
instructions: answer the following 20 questions. read carefully — scenarios are different in various quizzes.
reference chart

	a	b	c	d	e
2	laptops	120	135	150	160
3	tablets	90	100	110	105
4	smartphones	200	220	210	230
5	headphones	75	85	95	100
6	monitors	60	70	80	90

1. what is the cell reference for the q2 sales of laptops?
2. which cell contains the number 230?
3. write the range that covers all q1 sales.
4. what is the value in cell d3?
5. which range includes all sales data for tablets?
6. write the range that contains all product names.
7. what is the cell reference for monitors’ q4 sales?
8. which range covers smartphones’ q2 through q4 sales?
9. what number is in cell c5?
10. write the range for all sales in q3.
11. which cell contains the lowest sales figure in q1?
12. what is the value in cell b6?
13. write the range that includes all q2 and q3 sales for all products.
14. which cell contains headphones’ q4 sales?
15. write the range covering all sales for laptops and tablets.

Explanation:

Step1: Identify cell - reference rules

In Excel, columns are labeled with letters and rows with numbers. A cell reference is a combination of column letter and row number.

Step2: Answer question 13

For Q2 and Q3 sales of all products, the columns are C (Q2) and D (Q3), and the rows range from 2 to 6 for the products. So the range is C2:D6.

Step3: Answer question 14

Headphones' Q4 sales are in the cell where the row for Headphones (row 5) and the column for Q4 (column E) intersect, which is E5.

Step4: Answer question 15

For all sales of Laptops (row 2) and Tablets (row 3), the columns range from B to E. So the range is B2:E3.

Answer:

1. C2:D6
2. E5
3. B2:E3