Demonstrate the following task: Task 1 Prepare and plan to develop two complex spreadsheets. BENCHMARKS Organise the
Question:
Demonstrate the following task:
Task 1
Prepare and plan to develop two complex spreadsheets.
BENCHMARKS
Organise the work environment, so it meets ergonomic requirements and follows safe work practices, eg:
seat
monitor
keyboard and mouse
Analyse the task and determine the spreadsheet specifications, eg:
formulae
formatting and reformatting
functions
headers and footers
headings
Identify the data entry, storage, output, reporting, and presentation requirements, eg:
input
processing
output
Apply strategies and techniques for energy and resource conservation, eg:
reduce
reuse
recycle
Task 2
Follow procedures and guidelines to develop two linked spreadsheet solutions.
BENCHMARKS
Use the spreadsheet application’s functions and formulae to meet its requirements, eg:
cell references:
absolute
relative
ranges
Use the application’s functionality to link spreadsheets.
Format spreadsheet cells and use data attributes, eg:
borders
shading
number formatting
Test formulae to confirm output meets task requirements.
Task 3
Follow procedures and guidelines to automate and standardise operations on two complex spreadsheets.
BENCHMARKS
Identify tasks from the spreadsheet that can be automated, eg:
editing and formatting
combining multiple commands or actions
automate complex tasks
Create, use, and edit macros to fulfil the requirements of tasks and automate spreadsheet operation.
Develop, edit, and use templates to ensure consistent design and layout.
Task 4
Follow procedures and guidelines to prepare, develop, and use two complex spreadsheets that meet the identified task requirements.
BENCHMARKS
Enter, check, and amend data, eg:
data entry forms
data validation rules
Import and export data between spreadsheets or other documents, eg:
import data
format data
adjust documents
export data in an appropriate format for use by another application
Use help functions to overcome problems with spreadsheet design or production.
Prepare, preview, and adjust the spreadsheets, so they meet task requirements, eg:
content fits page
content is readable
Task 5
Represent numerical data in graphic form in two complex spreadsheets and follow organisational requirements to store the spreadsheets.
BENCHMARKS
Determine the type of chart that meets the specified requirements, eg:bar
pie
line
Manipulate spreadsheet data to produce the desired outcome.
Create a chart with labels and titles from numerical data contained in the spreadsheet.
Follow procedures to name and store the spreadsheet.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill