Scribd
Upload
6 views2 pages

Excel Basic Calculations Practice Guide

This document provides instructions for a basic Microsoft Excel practice calculating totals and balances. Students are asked to open a new Excel spreadsheet, save it as "IT_M2Tp2TKB_practice01.xls" on their thumbdrive, and enter sample data. They are then instructed to use formulas to find the total expenses in cell D16 and the balanced amount in cell D19. The final question asks students to report the value of the balanced amount calculated.

Uploaded by

api-26062599
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Excel Basic Calculations Practice Guide

This document provides instructions for a basic Microsoft Excel practice calculating totals and balances. Students are asked to open a new Excel spreadsheet, save it as "IT_M2Tp2TKB_practice01.xls" on their thumbdrive, and enter sample data. They are then instructed to use formulas to find the total expenses in cell D16 and the balanced amount in cell D19. The final question asks students to report the value of the balanced amount calculated.

Uploaded by

api-26062599
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Microsoft Excel –Basic Calculation

Name: ___________________________________
Class: _______________ Date: _______________
Module 2:
Spreadsheet – Microsoft Excel
Topic 2: Basic Calculation
Practice 01
 Open a new MS Excel spreadsheet.

 Save the file as “IT_M2Tp2TKB_practice01.xls” in your thumbdrive.

 Type in the following


data:

Cell: D16
Find the total expenses.

Cell: D19
Find the Balanced Amount.

 On the Toolbar, click the icon to save the file.

Page 1 of 2 IT_M2Tp2TkB_practice01.doc
Microsoft Excel –Basic Calculation

 What is the value of the Balanced Amount you had calculated?


$_____________

Page 2 of 2 IT_M2Tp2TkB_practice01.doc

You might also like