Microsoft Excel is a spreadsheet program used to enter, organize, calculate, analyze, and present data.
2. What is an Excel workbook?
A workbook is an Excel file that can contain one or more worksheets.
3. What is a worksheet?
A worksheet is a spreadsheet page made up of rows and columns where data is entered.
4. What is a cell?
A cell is the box created where a row and a column intersect. For example, A1 is a cell.
5. What is a cell address?
A cell address identifies the location of a cell using its column letter and row number, such as B5.
6. What is a row in Excel?
A row is a horizontal group of cells identified by numbers such as 1, 2, 3, and so on.
7. What is a column in Excel?
A column is a vertical group of cells identified by letters such as A, B, C, and so on.
8. How do you enter data into a cell?
Select a cell, type the data, and press Enter.
9. What is a formula in Excel?
A formula is an expression used to perform calculations. Excel formulas normally begin with an equal sign (=).
10. How do you add two numbers in Excel?
You can use a formula such as =A1+B1.
11. What is the SUM function?
The SUM function adds numbers together. For example, =SUM(A1:A10) adds the values from A1 to A10.
12.What is the AVERAGE function?
The AVERAGE function calculates the average of selected numbers. For example, =AVERAGE(B1:B10).
13. What is the difference between a formula and a function?
A formula is a calculation created by the user, while a function is a predefined Excel calculation, such as SUM, AVERAGE, MAX, or MIN.
14. What is formatting in Excel?
Formatting changes the appearance of data, such as font, size, color, borders, alignment, and number format.
15. How can you make text bold in Excel?
Select the cell or text and click the Bold (B) button on the Home tab, or press Ctrl + B.
16. What is sorting in Excel?
Sorting arranges data in a particular order, such as A to Z, Z to A, smallest to largest, or largest to smallest.
17. What is filtering in Excel?
Filtering displays only the rows that meet specific conditions while temporarily hiding the other rows.
18. What is an Excel chart?
A chart is a graphical representation of data that makes information easier to understand and compare.
19. How do you save an Excel workbook?
Click File → Save or press Ctrl + S. You can then choose the location and file name.
20. Why is Excel useful for beginners?
Excel helps beginners organize information, perform calculations, create tables and charts, analyze data, and automate repetitive tasks.
About the author
Vinay Bhatt
Vinay Bhatt is the Founder of LearnInCreation, an education and technology platform focused on making computer science and digital learning simple, practical, and accessible. He holds a B.Sc. degree from Kumaun University and has professional certifications in Full Stack Web Development, Digital Marketing, and Ethical Hacking. Passionate about education and technology, he creates beginner-friendly courses, practical learning resources, and projects that help students develop real-world skills and prepare for their careers.
Join LearnInCreation Study Center to learn practical computer and technology skills through simple lessons and hands-on training. Choose from Computer Basics, MS Office, Programming, Web Designing, Digital Marketing, and more. Get guidance, practice your skills, and prepare for your future. Visit our study center and enroll today!
