At Westonci.ca, we connect you with experts who provide detailed answers to your most pressing questions. Start exploring now! Get immediate and reliable solutions to your questions from a community of experienced experts on our Q&A platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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]