Excel Spreadsheet

Question 1

A Spreadsheet…

Answer 1

displays information in a variety of formats

Question 2

What functions do spreadsheets perform?

Answer 2

Calculate appropriate values
Validation of data
To summarize and organize data
Create information in a range of styles

Question 3

What is relative addressing?

Answer 3

When we copy or adjust data from one cell to another

For example, sum(e1:e2)

Question 4

What is absolute addressing?

Answer 4

Keeping values exactly the same as it was in the previous cell.
For example, =sum($a$1:$a$2)

Question 5

IF statements

Answer 5

They are used to find if a condition is true or false

For example, If(a1>25,”trucks”,”cars”)

Question 6

Purpose of Vlookup

Answer 6

Allows you to find items in a list
Vlookup presents a related value based on a found item
Vlookup works with tables of values with possible multiple columns of related values to present

Question 7

Primary sources

Answer 7

Internal sources (reliable)
Interviews
Surveys
Direct data collection

Question 8

Secondary sources

Answer 8

External data
Electronic
Print
Summary data

Question 9

Purpose of a macro

Answer 9

For various programs

Steps to be easily repeated

Question 10

The problem solving methodology: Analysis

Answer 10

Purpose: Describe the main purpose of the organization
Goal: Describe the possible organizational goal of the organization (something they want to achieve
Identifying problems: for the current manual or partial electronic system

Question 11

The Problem solving methodology: Design

Answer 11

Design tools used include layout designs, formulae sheets, and mockups/annotated designs (planning the solution)