Absolute Cell References $, Named Cells, Spreadsheet, Excel, N5 Admin & I.T, Higher Admin & I.T

BYS [SSV1004] – Absolute Cell References & Named Cells

Name: BYS [SSV1004] - Absolute Cell References &amp; Named Cells
SKU: 460
Availability: InStock

£25.00

Using ($) absolute cell references and naming cells to complete worksheets. See below for a full product description.

Category: Microsoft Excel Tags: Absolute cell references $, Excel, Higher Admin & I.T, N5 Admin & I.T, Named Cells, Spreadsheet

Description
Reviews (0)

Description

This unit begins with using information in a specific cell, such as commission rate % and applying an absolute cell reference and formula to complete various calculations. It then progresses to using named cells and following sequential instructions to complete each worksheet. The last 5 tasks also have summary sheets as part of the task where named cells need to be inserted and formulae used to complete the worksheet. ** Solutions are also included**.