Explore Westonci.ca, the leading Q&A site where experts provide accurate and helpful answers to all your questions. Ask your questions and receive precise answers from experienced professionals across different disciplines. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform.

Lee has finished formatting his table. He wants to import an Excel table to show the density and mean temperature data of the terrestrial planets.

\begin{tabular}{|l|c|c|}
\hline
\multicolumn{1}{|c|}{Planet} & \begin{tabular}{c}
Mass \\
[tex]$\left(10^{24} \text{kg}\right)$[/tex]
\end{tabular} & \begin{tabular}{c}
Diameter \\
[tex]$(\text{km})$[/tex]
\end{tabular} \\
\hline
Mercury & 0.330 & 4,879 \\
\hline
Venus & 4.87 & 12,104 \\
\hline
Earth & 5.97 & 12,756 \\
\hline
Mars & 0.642 & 6,792 \\
\hline
\end{tabular}

1. Which tab should he navigate to? [tex]$\square$[/tex]

2. Which command group should he use? [tex]$\square$[/tex]

3. Which option should he click? [tex]$\square$[/tex]

4. Which button should he click first in the dialog box that opens? [tex]$\square$[/tex]

Sagot :

To import the Excel table with the density and mean temperature data of the terrestrial planets, Lee should follow these steps:

1. Which tab should he navigate to?
- He should navigate to the Data tab.

2. Which command group should he use?
- He should use the Get & Transform Data command group.

3. Which option should he click?
- He should click the From File option.

4. Which button should he click first in the dialog box that opens?
- He should click the From Workbook button.

So, the filled-in answers should be:

[tex]\[ \begin{tabular}{|c|c|} \hline Step & Action \\ \hline 1 & Data \\ \hline 2 & Get & Transform Data \\ \hline 3 & From File \\ \hline 4 & From Workbook \\ \hline \end{tabular} \][/tex]