Breaks
Columns
Headers & Footers
Intro to Excel
100

There are many types of breaks to choose from depending on what you need. What are they?

What is page breaks, section breaks, and column breaks. 

100

How does Word allow you to adjust columns?

What is by adjusting your columns by adding column breaks. 

100

What is the header is a section of the document?

What is appears in the top margin.

100

True or False? Excel is a spreadsheet program that allows you to store, organize, and analyze information. 

True. 

200

True or False? By default, breaks are invisible.  

What is true.

200

Your column choices aren't limited to the drop-down menu that appears. What must you do to get more choices?

What is select More Columns at the bottom of the menu to access the Columns dialog box. Click the arrows next to Number of columns: to adjust the number of columns.

200

What is the footer is a section of the document?

What is appears in the bottom margin.

200

When you open Excel for the first time what do you see?

What is the Excel Start Screen.

300

If you want to see the breaks in your document what must you do?

What is click the Show/Hide command on the Home tab.

300

If you want to adjust the spacing and alignment of columns what must you do?

What is click and drag the indent markers on the Ruler until the columns appear the way you want.

300

True or False. After you close the header or footer, it will still be visible, but it will be locked. 

True.

300

What are the parts of the Excel window?

Some parts of the Excel window (like the Ribbon and scroll bars) are standard in most other Microsoft programs. However, there are other features that are more specific to spreadsheets, such as the formula bar, name box, and worksheet tabs.

400

To insert a page break: what are the steps?

What is:

1- Place the insertion point where you want to create the page break.

2- On the Insert tab, click the Page Break command. You can also press Ctrl+Enter on your keyboard.  

3- The page break will be inserted into the document, and the text will move to the next page.

400

To add columns to a document, what must you do?

1- Select the text you want to format.

2- Select the Layout tab, then click the Columns command. A drop-down menu will appear.

3- Select the number of columns you want to create. 

4- The text will format into columns. 

 

400

How do you unlock a header or footer?

Simply double-click a header or footer to unlock it, which will allow you to edit it.

400

The Ribbon contains what parts?

All of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.

500

Section breaks create a barrier between different parts of a document, allowing you to format each section independently. What are examples of section breaks?

  • Next Page: This option inserts a section break and moves text after the break to the next page of the document.
  • Continuous: This option inserts a section break and allows you to continue working on the same page.
  • Even Page and Odd Page: These options add a section break and move the text after the break to the next even or odd page. These options may be useful when you need to begin a new section on an even or odd page (like with a new chapter of a book).
500

To remove column breaks what must you do?

1- By default, breaks are hidden. If you want to show the breaks in your document, click the Show/Hide command on the Home tab. 

2- Place the insertion point to the left of the break you want to delete. 

3- Press the delete key to remove the break.

500

To create a header or footer you must do what?

What is

1- Double-click anywhere on the top or bottom margin of your document. In our example, we'll double-click the top margin. 

2- The header or footer will open, and a Design tab will appear on the right side of the Ribbon. The insertion point will appear in the header or footer. 

3- Type the desired information into the header or footer. In our example, we'll type the author's name and the date. 

4- When you're finished, click Close Header and Footer. You can also press the Esc key. 

5-The header or footer text will appear. 

500

If you want to locate a cell address what must you display?

What is the Name box which displays the location, or name, of a selected cell.