Scribd
Upload
7 views1 page

Excel Basics: Functions, Formulas, and Data Management

The document outlines key concepts and functionalities of Microsoft Excel, including definitions of worksheets, workbooks, cell references, and the importance of pivot tables. It also provides practical tasks such as creating tables, using functions, applying conditional formatting, and linking worksheets. Additionally, it discusses common errors in Excel formulas and the role of data validation and charts in enhancing data interpretation.

Uploaded by

saitoti ombok
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views1 page

Excel Basics: Functions, Formulas, and Data Management

The document outlines key concepts and functionalities of Microsoft Excel, including definitions of worksheets, workbooks, cell references, and the importance of pivot tables. It also provides practical tasks such as creating tables, using functions, applying conditional formatting, and linking worksheets. Additionally, it discusses common errors in Excel formulas and the role of data validation and charts in enhancing data interpretation.

Uploaded by

saitoti ombok
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. What is Microsoft Excel and what are its main uses?

2. Explain the difference between a worksheet and a workbook.


3. What are cell references in Excel and what is the difference between relative, absolute,
and mixed references?
4. What is the purpose of Excel functions? Give two examples.
5. Define the term “Pivot Table” and explain its importance.
6. What are formulas in Excel? How do they differ from functions?
7. Explain the role of data validation in Excel.
8. What are charts in Excel and how do they enhance data interpretation?
9. What is conditional formatting and how is it useful?
10. Describe three types of errors you may encounter in Excel formulas and what they mean
(e.g., #DIV/0!, #VALUE!, #REF!).

1. Enter data in Excel to create a table of five students with their marks in three subjects.
Calculate total and average marks.
2. Use the IF function to display “Pass” if a student’s average mark is 50 or above,
otherwise “Fail”.
3. Apply conditional formatting to highlight marks less than 40 in red.
4. Create a bar chart to display the total marks of each student.
5. Sort the student data in descending order based on average marks.
6. Use Data Validation to restrict entries in a column to numbers between 0 and 100.
7. Create a dropdown list using Data Validation for selecting a department name (e.g., HR,
IT, Sales).
8. Link two worksheets: In Sheet2, reference a total score from Sheet1.

You might also like