BSBITU402 - Complex Spreadsheets: Developing & Using Techniques

This project assignment focuses on developing and using complex spreadsheets to minimize resource and energy costs in the workplace. It covers strategies such as using natural light, selecting energy-efficient devices, and utilizing computer power-saving features. The assignment also differentiates between macros and templates, explains how to review and edit macros, and demonstrates the use of the Microsoft Excel help function. Furthermore, it explains the functionality of the COUNTIF function in Excel. This document is available on Desklib, a platform offering a wide array of study tools and solved assignments for students.

Running head: DEVELOPING AND USING COMPLEX SPREADSHEETS
Developing and using complex spreadsheets
Name of the Student
Name of the University
Author Note

DEVELOPING AND USING COMPLEX SPREADSHEETS
Answer to question 4:
Requirement a)
This section requires addressing the efforts taken by employees in minimizing the
coat of resources and energy at workplace.
1. Using natural lights and switching off artificial lights
Employees should be educated about the importance of using natural lights along with
the benefits it provide. The workplace should be adequate provision of natural light which
will results in reducing use of electricity considerably. This in turn would help in saving the
cost of energy.
2. Selecting light bulbs that are energy efficient
Using energy efficient bulbs would help in lowering down the expenditure on the
electricity bills. Choosing energy efficient bulbs is itself a way of conserving energy.
3. Choosing laptops over desktop
Using of desktop results in higher consumption of energy compared to laptop due to
uninterruptible supply of power. However, the consumption of energy by laptops can be
reduced by putting the laptops in power saving mode. This will help in using the energy more
efficiently and thereby recuing the energy cost.
4. Using hibernation features on all computers
The consumption of energy by personal computers can increase the total cost of
energy. Running the computer on hibernation mode would help in saving the power
consumed as it is one of the power management features in built in computers. In addition to

DEVELOPING AND USING COMPLEX SPREADSHEETS
reduction of power consumer by computer, this feature also helps in monitoring the total time
in running the device while producing less heat.
5. Buying devices that are energy efficient
Energy efficient devices intend to reduce the consumption of energy and ultimately
the cost of resources and energy. Such devices help in saving the energy that is wasted when
the device is not in use. Therefore, employees should purchase and efficiently operating the
energy efficient devices.
Requirement b)
Differences between macro and template are presented below in the table format.
Macro Template
Macros do not follow the syntactical rules of C +
+ and are considerably less powerful than
template.
Template are considerably powerful and they
follow the syntactical rules of C ++. A set of
certain rules is followed by macro that causes
code substitution.
Macros are limited to single expansion and
contrary to template, macros cannot call
themselves. Therefore, for compilation, macros
take lesser time. The expansion of macro is done
by using pre processor.
Template on other hand takes longer time for
compilation. The time taken by template is longer
and the reason is attributable to one of the
features that are recursive which are required to
be generated. This recursive is the foundation
upon which construction of looping in template
metaprogramming is done.

DEVELOPING AND USING COMPLEX SPREADSHEETS
Requirement c)
Macros are the pre processor that is available in C that helps in identifying then
program by communicating the block of code to the complier before the actual coding is
entered. It is a sequence that is automated that imitates actions of mouse and key strokes.
Some of the common applications of macro are in the word processing and spread sheet.
The manner in which macro reviewing and editing is done can be explained in the
flowing steps and they are as follows:
 On the macro command options, it is required to click on the option of view macro.
Alternatively, this can be done by pressing Alt+F8 button and Alt+WMV.
 The name to be edited in the list of macro is clicked followed by clicking on the edit
button.
 As required, the statement in the code window of the basic visual editor should be
edited.
 At the initiation of the standard toolbar, the excel button of view Microsoft is clicked.
Alternatively, the minimized button on the taskbar of window’s workbook should be
clicked.
 In order to save the changes made to the modified macro, the save button on the quick
access toolbar should be clicked. This is done if the changes are stored as a part of the
present workbook.
Requirement d)
The manner in which the Microsoft help button can be used is explained in the
following steps.
 In the first step, user is required to either press F1 or to click on the help button of
Excel.

DEVELOPING AND USING COMPLEX SPREADSHEETS
 Until the topic to be accessed is found, user should click on the help links available on
the window.
 The show table displayed in the content button is clicked thereafter.
 This step requires the user to click on the search button after typing the keywords in
the search box.
 The last step requires the user to right click on the window taskbar. After clicking, the
user performs the side by side selection of show windows.
Countif is a function in excel that helps in counting the cells by meeting the single
criteria. Such function can be used to count cells with number, dates and texts complying
particular criteria. The wildcards and logical operators for partial matching are supported by
countif function. This particular function in Excel is inbuilt and can be used as a function of
worksheet. In a worksheet cell, the function can be entered as a part of formula.
This particular function helps in setting the criteria and range that helps in creating
flexibility. It is done by drilling into the sets of data that returns with the numerical value.

DEVELOPING AND USING COMPLEX SPREADSHEETS
Moreover, a name range can be used with the help of this function and for viewing name
ranged; name is selected under the insert menu. After selecting the name, the define option is
clicked.