Spreadsheet
Formulas
Charts
Formatting
100

The cell you are currently using is called?

active cell

100

What must be at the front of a formula?

equal sign =

100

How can I create a chart based on date you have input into your spreadsheet?

select the data needed, select charts, select the type of chart and click ok.

100

To select more than one cell at a time, what must you do?

click the mouse and drag over the cells needed.

200

What cell would be 6 to the right and 5 down?

cell F5

200

How would I write the formula for 6% sales tax of $325.00?

=6%*325.00 or 0.06*325.00

200

Where would you go to change the look of your chart so that the title and labels might be in a different place?

go to chart layout and choose the design that fits your chart's needs.

200

What is the fastest way to make everything center aligned and then bold only items in row 1?

select the corner select all button, go to Home and click the center align. Select row 1 and click B for bold.

300

When writing in a cell, the typed data also appears in the?

formula bar

300

What 2 ways could you use a formula to add cell A2, B2,C2, and D2?

select those cells and plug in the sum formula or sum key or click on cell E2 and write =A2+B2+C2+D2

300

What should be done to change the titles/labels in a chart?

double click on the information you would like to change and then type.

300

What steps would I follow to make my page landscape?

Page layout, Orientation, and the Landscape.

400

If I was in cell R7 and moved 4 to the left, 3 down, and then 6 to the right, what cell would I be in?

T10

400

How would you figure out the average of cell A1 - A5?

select those cells and then click Average or write =AVERAGE(A1:A5)

400

What would you need to do to format the details of your chart and then name at least 4 details that can customize your chart.

double click on the chart or go to formatting. Change, color, size, gradient, texture, pattern, ect.

400

How do I make the formula I used in A5 also apply to B5, C5, and D5?

put your cursor on the corner of A5 until you see a plus sign, hold your mouse down and drag it down through D5. (fill handler)