Sorry for the repost: I need the explaination to be consist and clear. Microsoft Excel Formula assignment: The objective of this assignment is to create 3 unique [5x5] tables and each table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table and again, each table cannot repeat the same number. Please educate me on creating this without having to manually type numbers to later create over 50: 5 by 5 tables. What is the best approach to creating these tables? Here is examples for 2 tables that I manually typed out. TABLE 1: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 TABLE 2: 59 2 3 4 1 33 72 8 9 66 11 22 13 88 15 16 17 18 19 5 29 40 99 30 21 I want to use excel tools like formulas, copy and paste, sorting, and others if needed to mass produce tables with very few manual entry. Example of a table that will not work. 1 2 3 4 5 6 7 8 8 9 10 11 12 13 14  16 17 17 18 19 20 21 22 21 25  Tables can generate random numbers if they want to or not with the forumla =RANDBETWEEN(0,101). (Note: as long as the assignment follows -- No 1:1 charts or the duplicate numbers in a table --) Bonus: Kindly demonistrate how to check for duplicate numbers in a table. Highlight or any tools to double check to make sure that each individual chart is unque.  Here are two more examples that will work. 1 22 33 44 55               22 33 44 55 66 66 77 88 99 100          77  88 99 100 11 11 12 13 14 15            12 13 14 15 16 16 17 18 19 20            17 18 19 20 21 21 22 23 24 25             22 23 24 25 1

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Sorry for the repost: I need the explaination to be consist and clear.

Microsoft Excel Formula assignment: The objective of this assignment is to create 3 unique [5x5] tables and each table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table and again, each table cannot repeat the same number.


Please educate me on creating this without having to manually type numbers to later create over 50: 5 by 5 tables.
What is the best approach to creating these tables? Here is examples for 2 tables that I manually typed out.

TABLE 1:
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25

TABLE 2:
59 2 3 4 1
33 72 8 9 66
11 22 13 88 15
16 17 18 19 5
29 40 99 30 21

I want to use excel tools like formulas, copy and paste, sorting, and others if needed to mass produce tables with very few manual entry.

Example of a table that will not work.
1 2 3 4 5
6 7 8 8 9
10 11 12 13 14 
16 17 17 18 19
20 21 22 21 25 

Tables can generate random numbers if they want to or not with the forumla =RANDBETWEEN(0,101).
(Note: as long as the assignment follows -- No 1:1 charts or the duplicate numbers in a table --)

Bonus: Kindly demonistrate how to check for duplicate numbers in a table. Highlight or any tools to double check to make sure that each individual chart is unque. 

Here are two more examples that will work.

1 22 33 44 55               22 33 44 55 66
66 77 88 99 100          77  88 99 100 11
11 12 13 14 15            12 13 14 15 16
16 17 18 19 20            17 18 19 20 21
21 22 23 24 25             22 23 24 25 1

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education