Advanced Excel Course Database Function Notes Set 01

Computer Science Study Guide: Advanced Excel Course Database Function Notes Set 01

Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Database Function 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.

The database functions DSUM, DMIN, DAVERAGE, DMAX and DCOUNT are shown on one item, company, quantity and price table, using a small criteria range of an item name and a company name.

DSUM, DMIN, DAVERAGE, DMAX, DCOUNT

A database function works on a table (the database) with column headings, and picks only the rows that match a criteria range. The syntax is function(database, field, criteria), for example =DSUM(A2:F12,D2,A14:B15). The database is A2:F12 (with the headings), the field is the heading cell of the column to be calculated (D2 is QTY) and the criteria range is a heading row with a value row below it.

S.N.ITEMCOMPANYQTYPRICEAMOUNT
1MOUSEABC251200=D3*E3
2KEYBOARDXYZ251500=D4*E4
3MOUSEABC181100=D5*E5
4KEYBOARDXYZ15100=D6*E6
5MOUSEXYZ46400=D7*E7
6KEYBOARDST10800=D8*E8
7CPUABC25200=D9*E9
8MOUSEST70300=D10*E10
9CPUST84350=D11*E11
10CPUABC10150=D12*E12

Each criteria range has the headings ITEM and COMPANY with the values MOUSE and ABC below them, so only the rows 1 and 3 (MOUSE, ABC) are used.

FunctionFormulaResult
DSUM=DSUM(A2:F12,D2,A14:B15)43 (25 + 18)
DMAX=DMAX(A2:F12,D2,F14:G15)25
DMIN=DMIN(A2:F12,E2,A17:B18)1100 (the lowest PRICE of the matching rows)
DCOUNT=DCOUNT(A2:F12,D2,F17:G18)2
DAVERAGE=DAVERAGE(A2:F12,D2,A20:B21)21.5

Computer Science Exam Resources: 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

Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within MS Office and demystifies standard marking schemes for Computer Science evaluations.

Next Steps in Your Exam Preparation

Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

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.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

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.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

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.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

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.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

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.