Problem Solving

Question 1

What is a variable

Answer 1

A variable name is a name given to a container that stores data.
A Variable refers to a value (numeric or
non-numeric) that can change throughout the
course of a pseudocode depending on the
person, place, animal or thing under
consideration.

Question 2

What is a constant?

Answer 2

A name given to a container whos value is known beforehand, it is fixed no matter what.

Question 3

Rules for naming variables

Answer 3

No spaces
Should not be pluralized 
Cant start with a symbol
Cant begin with a number
should not be too long
Use underscore the bridge two short words

Question 4

Types of Cell Addressing/References

Answer 4

Relative Addressing
Absolute Addressing
Mixed Addressing

Question 5

What is relative addressing?

Answer 5

Relative addressing refers to when a formula with relative cell references is copied to another cell where the references changes based on a relative position of rows and columns. By default all references in excel or relative

Question 6

What is absolute addressing/references

Answer 6

Absolute References refers to adding the dollar sign that fixes to a given cell so that it remains unchanged no matter where the formula moves. In other words using the dollar sign in cell references allows you to copy the formula in excel without changes references.

Question 7

What is Mixed addressing/references

Answer 7

A mixed cell referencing in excel is a reference where either the column letter or row number is fixed for examples $A1, A$1

Question 8

Examples of constants

Answer 8

Number of days in a week= 7
Number of months in a year= 12
Pi= 3.14

Question 9

What is the decomposition of a problem?

Answer 9

This means to separate the parts of the problem that is classifies as input, output & processing.

Question 10

IPO chart

Answer 10

An IPO chart is used to partition/separate a problem into its components.

Question 11

What does IPO stand for?

Answer 11

Input
Output
Processing

Question 12

What is algorithm

Answer 12

An algorithm is a set of instructions that if followed in sequence will lead to the solution for the problem

Question 13

What is a pseudo code?

Answer 13

A pseudo code algorithm consists of sequence of instructions written in the authors language set out to solve a specific problem.

Question 14

What is the purpose of the COUNTIF function?

Answer 14

The purpose of the of the COUNTIF function is to count the number of cells that meet a criterion

Question 15

What are the two arguments?

Answer 15

Constant and Variable

Question 16

What is the return value/number?

Answer 16

Number represent the cells counted

Question 17

Format of the COUNTIF function

Answer 17

=COUNTIF

Question 18

real format of the countif function

Answer 18

=COUNTIF(C1:C2, “over $100.00”)

=COUNTIFC1:C3,”Jim”)

Question 19

What is the IF function?

Answer 19

A speadsheet program used for making decisions/

Question 20

Data Types

Answer 20

Numeric & Non-numeric

Question 21

Integer

Answer 21

Positive and Negative whole number

Question 22

String

Answer 22

Consists of 2 or more symbols or letters

Question 23

Real number

Answer 23

Negative or positive, fraction or decimal whole numbers

Question 24

At which stage in the problem solving
purpose does decomposing takes
place?

Answer 24

Stage 2.

Question 25

Define Data Type

Answer 25

Data type is a standard classification
of similar data in order to define
which actions can safely be
performed on that data.