2nd prep Model Answers

2nd prep model answers

Ch.9 page: 7

Q1.

1- spreadsheet 

2- Del 

3- Function bar

4- charts

Q2. 

1- Worksheets

2- Row, and column

3- 25, Col 16

4- Column alphabet, row number

5- Value

6- Select, F2

7- 18:00 "24-hour clock system"

Q3- steps will be found in the sheet

Q4.

FALSE, FALSE, FALSE, TRUE, FALSE, FALSE{Worksheets}, False

Ch.10 page: 13

Q1. 

sheft cells down option from insert menu to shift other rows to add 3 times

Q2. 

1- rename

2- SHIFT

3- Shift cell down and leave the current cells empty 

4- empty the current row

5- CTRL, click over column or row headers

6- 66536, 265

7-CELL

Q3- 

1- Select the whole worksheet button

2- insert menu

3- the arrow button on worksheet tab

Ch.12 page: 21

Q1- 

X: to cancel the function bar editing

Green Checkmark: to accept the editing[function bar editing too]

Q2.

1- built in , predefined

2- Operators precednce

3- = [equal sign]

4- sum of integers/their number example: 200/6 such that those numbers are: 100, 20, 25, 5, 35, 15

5- updated results

6- calculate or to mentor non-empty cells [all cells that have values]

7- sum function

8- 7.5

9- function bar

10- the changing values will make the formula generate updated results

11- formatting

12- auto fill method

13-max, min, sum, countA and average[AVG]

14- MIN Function

Q3- 

FALSE, FALSE, FALSE, FALSE, TRUE, TRUE

Ch.13 page: 26

Q1.

1- graphical representation of worksheet data

2- 2D, 3D Charts

3- chart, insert menu

4- charts toolbar

5- display an example of chart 

Q2. 

1- TRUE

2- true

3- DELETE

4- in other sheets too not only the current worksheet

5- false 2 types 2d and 3d