IDB-BISEW Mid Test Computer Fundamentals (CF)

BASICS

Freezing row and column titles Row and Column Transpose

FORMULAS

Creating formulas How to create a formula Copying formulas Operators Formula error messages Common functions Sum function Average function Max function Min function Count function The COUNTA function The COUNTBLANK function What are 'IF functions'? Using the IF function

CHARTS

Creating a column chart Creating a line chart Creating a bar chart Creating a pie chart Changing the chart type EDITING CHARTS Resizing a chart Deleting a chart Chart title or labels Changing the chart background colour Changing the column, bar, line or pie slice colours in a chart Modifying the legend fill colour Modifying charts using the Layout tab Copying and moving charts within a worksheet Copying and moving charts between worksheets Copying and moving charts between workbooks

PREPARING OUTPUTS

Worksheet margins Worksheet orientation Worksheet page size Headers and footers Header and footer fields Scaling your worksheet to fit a page PREPARING TO PRINT A WORKSHEET Visually check your calculations Spell checking Displaying gridlines when printing Printing titles on every page when printing Printing the Excel row and column headings Previewing a worksheet Comparing workbooks side by side Printing options