1.
If B1 has a tax rate of 5%, how do you calculate tax for values in A1:A5 using an absolute reference?
2.
What does the formula “=A$1+$B2” do when copied from C1 to D2?
3.
How do you add a trendline to a line chart for data in A1:B10?
4.
How do you create a column chart comparing sales in A1:A5 and costs in B1:B5?
5.
How can you make a chart update automatically when new data is added to A1:A10?
1.
Answer: Select A1:A10, go to “Conditional Formatting,” choose “Less Than,” enter 10, and set a red fill.
Description: Conditional formatting highlights data based on rules, improving visual analysis beyond basic formatting.
2.
Answer: In C1, type “=A1*$B$1” and drag down to C5.
Description: The $B$1 locks the tax rate cell, ensuring consistent application across rows when copied.
3.
Answer: In C1, it adds A1+B2. In D2, it adds B1+B3 (A$1 stays row 1, $B2 shifts columns).
Description: Mixed references combine relative and absolute behavior, useful for row- or column-specific calculations.
4.
Answer: Create a line chart, right-click a data series, select “Add Trendline,” and choose a type (e.g., Linear).
Description: Trendlines predict data patterns, enhancing chart analysis beyond basic visualization.
5.
Answer: Convert A1:B10 to a Table (Insert > Table), then create a chart from the table.
Description: Tables dynamically adjust ranges, ensuring charts reflect new data without manual updates.