12
QuizMultiple Choice

Cumulative Exam — Cumulative exam

Question 12 • LHS Business Management

Which option represents the location of the Data Table function?

Answer
A
Insert Tab and Tables group, select Table
B
Insert Tab and Tables group, select PivotTable
C
Data tab and Forecast group, select Data Table
D
Data tab and Forecast group, select What-If Analysis and Data Table

Explanation

In Excel, a Data Table is a What-If Analysis tool. Find it on the Data tab by opening What-If Analysis and choosing Data Table, so the correct choice is “Data tab and Forecast group, select What-If Analysis and Data Table.”

AI-written and checked against the verified answer.

Previous
Next