NC Computer Skills Quiz-Spreedsheets
Lines and pictures
Fonts and borders
Formulas and graphs
Labels and envelopes
Words
Labels
Formulas
Values
Pie chart
Bar chart
Scattergram
Line graph
=B4+D7
2+3+6=11
F3*G7
B9/B6
A-B
=C10-B9
$14.00-$5.00=$9.00
B9/B6
=L3*C7
B2+B3/C4
B4 X B6
46 X 39
Line graph
Scattergram
Bar chart
Pie chart
Create a graph comparing class attendance rate
Create a brochure for the band camp
Track batting averages for the softball team
Keep track of field trip payments for the class trip
There isn’t one
Graphs generate spreadsheets
Graphs generate formulas
Graphs depict the spreadsheet data
Add the numbers in cell A1 and A49 together
Subtract the number in cell A49 from cell A1
Multiply cell A1 by cell A49
Add the range of numbers from A1 through A49
Address label
Title bar
Formula bar
Active cell
Where?
Why?
What if?
When?
Manipulate data with numbers and text
View and manipulate text
Manipulate graphics
Make nice banners and posters
Add cells C2 through C6
Add cells A2 through A6
Add cells D2 through D6
Add cells A6 through D6
A3 and A5
A4 and B4
A3 and D3
B3 and C3
Quantity multiplied by Total Cost
Total cost of today’s menu
Cost of one single item
Quantity multiplied by Item
Fields
Values
Formulas
Cells
Column A
Column B
Column D
Column 6
A6
B6
C6
D6