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
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
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
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
.PNG)
