Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel problem N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer

Excel problemimage text in transcribed

N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer first then by Name then by Time. 2 All the records should be grouped by layer. Within each layer the records should be in name order. Within each well name, the records should be in time order. 4 5 Name 6 W2 7 W2 8 W2 9 W2 10 W2 11 W2 12 W2 13 W2 14 W2 15 W2 16 W2 17 W2 18 W2 19 W2 20 W2 21 W2 22 W2 23 W2 24 W2 25 W2 26 W2 27 W2 28 W2 29 W2 30 W2 31 W2 Time X Y 7:18:24 AM 796072.9 980540.7 7:30:48 AM 796072.9 980540.7 7:42:00 AM 796072.9 980540.7 7:54:24 AM 796072.9 980540.7 8:06:24 AM 796072.9 980540.7 8:18:48 AM 796072.9 980540.7 8:30:48 AM 796072.9 980540.7 8:43:12 AM 796072.9 980540.7 8:55:36 AM 796072.9 980540.7 9:07:36 AM 796072.9 980540.7 9:20:00 AM 796072.9 980540.7 9:32:00 AM 796072.9 980540.7 9:44:24 AM 796072.9 980540.7 9:56:48 AM 796072.9 980540.7 10:08:24 AM 796072.9 980540.7 10:20:48 AM 796072.9 980540.7 10:32:48 AM 796072.9 980540.7 10:45:12 AM 796072.9 980540.7 10:57:12 AM 796072.9 980540.7 11:09:36 AM 796072.9 980540.7 11:22:00 AM 796072.9 980540.7 11:34:00 AM 796072.9 980540.7 11:46:24 AM 796072.9 980540.7 11:58:24 AM 796072.9 980540.7 12:10:48 PM 796072.9 980540.7 12:23:12 PM 796072.9 980540.7 Layer Observed 68.36 67.65 67.99 68.39 67.66 68.13 67.29 67.84 67.97 67.48 67.61 67.61 67.88 67.7 67.51 67.62 68.04 67.6 67.27 67.6 67.37 68.01 67.51 1 67.53 68.13 67.6 N. A B C D E F G H I 1 Sort the following table so that the fields are grouped by Layer first then by Name then by Time. 2 All the records should be grouped by layer. Within each layer the records should be in name order. Within each well name, the records should be in time order. 4 5 Name 6 W2 7 W2 8 W2 9 W2 10 W2 11 W2 12 W2 13 W2 14 W2 15 W2 16 W2 17 W2 18 W2 19 W2 20 W2 21 W2 22 W2 23 W2 24 W2 25 W2 26 W2 27 W2 28 W2 29 W2 30 W2 31 W2 Time X Y 7:18:24 AM 796072.9 980540.7 7:30:48 AM 796072.9 980540.7 7:42:00 AM 796072.9 980540.7 7:54:24 AM 796072.9 980540.7 8:06:24 AM 796072.9 980540.7 8:18:48 AM 796072.9 980540.7 8:30:48 AM 796072.9 980540.7 8:43:12 AM 796072.9 980540.7 8:55:36 AM 796072.9 980540.7 9:07:36 AM 796072.9 980540.7 9:20:00 AM 796072.9 980540.7 9:32:00 AM 796072.9 980540.7 9:44:24 AM 796072.9 980540.7 9:56:48 AM 796072.9 980540.7 10:08:24 AM 796072.9 980540.7 10:20:48 AM 796072.9 980540.7 10:32:48 AM 796072.9 980540.7 10:45:12 AM 796072.9 980540.7 10:57:12 AM 796072.9 980540.7 11:09:36 AM 796072.9 980540.7 11:22:00 AM 796072.9 980540.7 11:34:00 AM 796072.9 980540.7 11:46:24 AM 796072.9 980540.7 11:58:24 AM 796072.9 980540.7 12:10:48 PM 796072.9 980540.7 12:23:12 PM 796072.9 980540.7 Layer Observed 68.36 67.65 67.99 68.39 67.66 68.13 67.29 67.84 67.97 67.48 67.61 67.61 67.88 67.7 67.51 67.62 68.04 67.6 67.27 67.6 67.37 68.01 67.51 1 67.53 68.13 67.6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Aided Database Design

Authors: Antonio Albano, Valeria De Antonellis, A. Di Leva

1st Edition

0444877355, 978-0444877352

More Books

Students also viewed these Databases questions