Sample Video Drill from Spreadsheets I, Lesson 4

1. How do we change the width of columns?

Point the mouse between the columns anywhere and hold the mouse down and move the mouse.
Point the mouse at the column line at the very top between the column letters and hold the mouse down and move the mouse.
Right-click the column letter.
Click any cell in the column and point to its side.
2. How do we change the way the spreadsheet will print from Portrait to Landscape?

Click Edit, then click Page, then click the Page tab, then click the circle next to Landscape, then click OK.
Click File, then click Page, then click the Page tab, then click the circle next to Landscape, then click OK.
Click Format, then click Page, then click the Page tab, then click the circle next to Landscape, then click OK.
Click Tools, then click Page, then click the Page tab, then click the circle next to Landscape, then click OK.
3. How do we add lines or borders around only some cells?

Highlight the area that we want borders (using shift and arrow keys) and click the Border button on the menu bar.
Click the Border button on the menu bar.
Highlight the area that we want borders (using shift and arrow keys) and click Edit then click Borders.
Highlight the area that we want borders (using shift and arrow keys) and click File then click Printer Properties.
4. How do we see what our spreadsheet will look like before we print?

Click File then Printer Properties.
Click the Printer picture on the tool bar.
Click View then Zoom.
Click the Page Preview button.
5. When we are through looking at the Page Preview, what must we do?

Click the X or close button to return to the spreadsheet.
Click the Close Preview button to return to our spreadsheet.
Click Format Page.
Click the Return to Spreadsheet button.
6. How do we save our spreadsheet?

Click File then Save.
Click the little picture of a floppy disk.
Click File then Save As and enter a name without punctuation.
Click Edit then Save As and enter a name without punctuation.
7. Where should we save our files?

Desktop
Drive D
Drive C
My Documents
8. What will happen if we click the corner button between the "1" and the "A"? The button directly above the number 1?

It will save our file.
It will highlight the entire spreadsheet.
It will highlight the area we have been working in.
It will let us see a page preview.
9. After we type something in a cell, what must we do before we can use the cell or change the way it looks?

Save our file.
Preview the page.
Leave the cell and then return to it.
Hold the shift key down and arrow over it.
10. What command do we use to put days or months across a number of highlighted cells?

Edit, Fill, Right.
Edit, Fill, Down.
Edit, Paste
Edit, Fill, Series.
11. What must be in the first cell we highlight when using the Fill command?

The day or month we want to begin with.
The number 1.
The word "series"
The word "fill".
12. What will happen if we highlight more than 7 cells for days of the week OR more than 12 cells for months of the year when using the Fill command?

It repeats the last day or month.
It repeats the series starting with the first day or month you used.
It will give you an error.
It leaves those cells empty.
13. When adding titles at the top of a spreadsheet, which column do we usually start with?

A
B
C
D
14. What does pressing the Home key on the keyboard do in a spreadsheet?

It lets you start a new spreadsheet.
It moves you one column to the left.
It moves you to the far left or Column A quickly.
It moves you to the far right of a spreadsheet.
15. When using titles or categories down Column A, what row do we usuually start with?

Row 1
Row 2
Row 3
Row 4
16. Where do we put a formula in a spreadsheet?

Where we want the answer to show.
At the very bottom of the screen.
At the top of the column.
In Column A.
17. Which is the right way to make an addition formula?

=sum(b2:b6
=sum(b2;b6)
=sum(b2:b6)
=sum b2:b6
18. When using Fill with formulas, which Fill option do we normally use?

Series
Right or Down
Paste
Sheets
19. What do we usually put in the column to the right of December in a budget file?

Leave empty.
Formulas to repeat the year.
Formulas to add each row to see total spending for each item.
We retype the bill titles.
20. What do we do to make it so we can see titles even if we move around in the spreadsheet?

Click Window, then Freeze.
Click Edit, then Freeze.
Click Format, then Freeze.
Click Data, then Freeze.
21. Which cell should we be in when we Freeze?

A1
A2
B1
B2
Back to Top