Spreadsheet (Pretest)

1. – A function that adds a range of numbers together.
2. – A collection of worksheets stored in one spreadsheet file.
3. – A function that calculates the mean of a range of values.
5. – A single page or tab within a spreadsheet file.
6. – A function that returns the largest value in a set of numbers.
7. – A pre-defined formula in spreadsheets (e.g., =SUM(A1:A5)).
9. – A function that checks a condition and returns one value if true, another if false.
12. – A vertical line of cells, labeled with letters.
13. – A visual representation of data, such as a bar graph or pie chart.
15. – A tool used to arrange data in a specific order, such as ascending or descending.
16. – The address of a cell (e.g., B3) used in formulas.

1. – A digital document used to organize, calculate, and analyze data in rows and columns.
4. – An expression that performs calculations using values in cells (e.g., =A1+B1).
6. – A function that returns the smallest value in a set of numbers.
8. – The smallest unit in a spreadsheet where you can enter data, identified by its column letter and row number.
10. – A tool that displays only the rows that meet certain criteria.
11. – A tool that automatically copies data or extends patterns in adjacent cells.
13. – A function that counts the number of numeric entries in a range.
14. – A horizontal line of cells, labeled with numbers.
17. – A group of cells selected together (e.g., A1:C5).