Scribd
Upload
9 views1 page

Excel Functions and Data Management Guide

The document covers key concepts from Chapters 2 and 3 of a computer homework assignment. Chapter 2 discusses formulas, functions, and features like Autofill and AutoSum for efficient calculations. Chapter 3 focuses on data organization through sorting and filtering, along with conditional formatting for visual data analysis.

Uploaded by

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

Excel Functions and Data Management Guide

The document covers key concepts from Chapters 2 and 3 of a computer homework assignment. Chapter 2 discusses formulas, functions, and features like Autofill and AutoSum for efficient calculations. Chapter 3 focuses on data organization through sorting and filtering, along with conditional formatting for visual data analysis.

Uploaded by

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

Computer Homework

Chapter 2

1. =SUM(C2:C9)

2. Autofill copies formulas or patterns automatically, saving time and reducing errors.

3. Relative references change when copied; e.g., =A1+B1 becomes =A2+B2 when dragged
down.

4. A function is a built-in formula for calculations; examples: =SUM(A1:A5),


=AVERAGE(B1:B5).

5. AutoSum quickly adds a range by selecting cells and inserting the SUM formula.

Chapter 3

1. Sorting arranges data alphabetically or numerically for easier analysis.

2. Two types of sorting: ascending (A-Z, 1-9) and descending (Z-A, 9-1).

3. Filtering shows only data meeting set criteria, hiding the rest temporarily.

4. Sorting rearranges all data; filtering hides unmatched rows but keeps order.

5. Conditional formatting changes cell color based on rules; e.g., scores above 90 green,
below 35 red.

You might also like