zen707
Answered

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]



Answer :

GinnyAnswer
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]

Other Questions