Week 5 + Week 6 (Excel)

Question 1

A computer program used to enter, analyze, and present (quantitative) data

Answer 1

Microsoft Office Excel

Question 2

A collection of text and numbers laid out in a rectangular grid.

Answer 2

Spreadsheet

Question 3

A collection of related worksheets within one file

Answer 3

Workbook

Question 4

A rectangular group of cells in a worksheet

Answer 4

Range

Question 5

Functions that help you retrieve, filter, and present data efficiently.
They do not perform calculations.

Answer 5

Data Delivery Functions

Question 6

Methods that are used to speed up the process of finding a good enough solution, where an exhaustive search or advanced problem solving techniques are impractical.

Answer 6

Heuristic Methods

Question 7

Cell addresses that are adjusted as a formula containing these addresses is copied within the spreadsheet

Answer 7

Relative Cell Reference

Question 8

Cell addresses that stay fixed & are not adjusted as a formula is copied

Answer 8

Absolute Cell Reference