Computer Science Study Guide: Advanced Excel Course Transpose Factorial and Decimal to Binary Convert Notes Set 01
Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Transpose Factorial and Decimal to Binary Convert Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.
Download MS Office Study Material PDF
Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.
This page covers three short topics: the TRANSPOSE array function that turns a table on its side, the FACT function for factorials, and the DEC2BIN and BIN2DEC functions that convert numbers between decimal and binary.
Transpose
{=TRANSPOSE(A1:E10)}TRANSPOSE changes rows into columns. The table A1:E10 has the headings Student name, Hindi, Art, Science and Computer for nine students. The function is entered in an empty area (A12:J16) as an array formula, and it is confirmed with Ctrl + Shift + Enter, so that curly brackets appear around the formula.
| Student name | Hindi | Art | Science | Computer |
|---|---|---|---|---|
| Meena | 25 | 85 | 12 | 20 |
| Teena | 24 | 25 | 25 | 52 |
| Riya | 15 | 14 | 25 | 41 |
| Suraj | 36 | 25 | 35 | 69 |
| Rahul | 87 | 63 | 25 | 58 |
| Pinki | 25 | 54 | 85 | 36 |
| Manoj | 63 | 58 | 45 | 25 |
| Suhail | 95 | 36 | 63 | 54 |
| Sumit | 45 | 14 | 59 | 21 |
After transposing, the names run across the first row and the subjects run down the first column.
| Student name | Meena | Teena | Riya | Suraj | Rahul | Pinki | Manoj | Suhail | Sumit |
|---|---|---|---|---|---|---|---|---|---|
| Hindi | 25 | 24 | 15 | 36 | 87 | 25 | 63 | 95 | 45 |
| Art | 85 | 25 | 14 | 25 | 63 | 54 | 58 | 36 | 14 |
| Science | 12 | 25 | 25 | 35 | 25 | 85 | 45 | 63 | 59 |
| Computer | 20 | 52 | 41 | 69 | 58 | 36 | 25 | 54 | 21 |
Factorial
=FACT(A2)
FACT returns the factorial of a number (1 x 2 x 3 x ... x n).
| Number | Factorial |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 6 |
| 4 | 24 |
| 5 | 120 |
| 6 | 720 |
| 7 | 5040 |
| 8 | 40320 |
| 9 | 362880 |
Decimal to Binary Convert
=DEC2BIN(A2)
DEC2BIN converts a decimal number into a binary number.
| Number | Binary |
|---|---|
| 25 | 11001 |
| 5 | 101 |
| 36 | 100100 |
| 50 | 110010 |
| 10 | 1010 |
| 16 | 10000 |
| 20 | 10100 |
| 22 | 10110 |
| 28 | 11100 |
| 30 | 11110 |
Binary to Decimal Convert
=BIN2DEC(A2)
BIN2DEC converts a binary number into a decimal number.
| Binary | Decimal |
|---|---|
| 11001 | 25 |
| 101 | 5 |
| 100100 | 36 |
| 110010 | 50 |
| 1010 | 10 |
| 10000 | 16 |
| 10100 | 20 |
| 10110 | 22 |
| 11100 | 28 |
| 11110 | 30 |
Free study material for Computer Science
Free CBSE Study Guides: Computer Science MS Office
Core Study Kit: Computer Science MS Office
Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.
NCERT-Aligned Solutions for MS Office
Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.
Next Steps in Your Exam Preparation
Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.