Revision 2 BUS02004: Create and use basic spreadsheets

A ..................is a built-in formula in Excel.

• function

• Ribbon

• Column

• Raw

In Excel, a ................. is used to display data in a graphical format.

• Chart

• Cell

• Table

• Formula

............................ allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction of the text.

• Border tab

• Alignment tab

• Font tab

• Number tab

By choosing ...................................tab you can combine the cells and centers the contents in the new larger cell

• Merge & Center

• Merge Cells

• Unmerge Cells

• Merge Across:

The .......................... feature in Excel allows you to automatically fill cells with data based on a pattern.

• Data Validation

• Flash Fill

• Conditional Formatting

• AutoFill

Excel offers many types of ......................including Column, Line, Pie, Bar, Area, Scatter and more

• Shapes

• Tables

• Charts

• Drawing

By Pressing one of the buttons in Excel we can create

• Form

• Picture

• Chart

• Border

The .......................... function in Excel is used to find the highest value in a range of cells.

• MAX

• AVERAGE

• SUM

• MIN

To set the page margins Click the Margins button on the ........................tab

• Data

• Home

• Formulas

• Page Layout

you can create a header or footer by clicking the Header Footer button on the ........................tab

• Data

• Home

• Insert

• Page layout