Chapter 10: Excel

Question 1

Data types

Answer 1

General
Number
Currency
Date 
Text
Time
Percentage 
Logical value

Question 2

Data life cycle

Answer 2

1. Data collection
2. Data processing
3. Data analysis
4. Data distribution

Question 3

Logical functions

Answer 3

IF()
AND()
OR()
NOT()

Question 4

Text functions

Answer 4

LEN()
MID()
LEFT()
RIGHT()

Question 5

Date function

Answer 5

TODAY()

Question 6

Math functions

Answer 6

CEILING.MATH()
FLOOR.MATH()
POWER()
SQRT()
ROUND()
RANDBETWEEN()
RAND()
SUM()
SUMIF()
QUOTIENT()
MOD()

Question 7

Lookup functions

Answer 7

VLOOKUP()

HLOOKUP()

Question 8

Stats functions

Answer 8

MAX()
MIN()
COUNT()
COUNTA()
COUNTIF()
COUNTBLANK()
MODE.SNGL()
MEDIAN()
AVERAGE()
LARGE()
SMALL()

Question 9

Conditional formatting

Answer 9

Spreadsheet feature which automatically formats a cell based on given criteria

Select cells _ to _. Click “conditional formatting” at the Home Tab. Select cell rules that change to _ when value in cell is equal to _

Question 10

Why have ####

Answer 10

Column _ is not wide enough to show all the contents in _

Question 11

Goal seek

Answer 11

Used to adjust the value in one cell so that another cell can reach a particular value through a trial-and-error approach