Scribd
Upload
4 views6 pages

Excel Budgeting and Formulas Guide

The document discusses Excel features including the file extension for Excel documents, the maximum number of worksheets, customizing the quick access toolbar, cell references, basic formulas, order of operations, and taxes. It provides examples of Excel concepts like the cell reference example, purpose of absolute references, and character used for absolute references.

Uploaded by

Ayan Dey
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views6 pages

Excel Budgeting and Formulas Guide

The document discusses Excel features including the file extension for Excel documents, the maximum number of worksheets, customizing the quick access toolbar, cell references, basic formulas, order of operations, and taxes. It provides examples of Excel concepts like the cell reference example, purpose of absolute references, and character used for absolute references.

Uploaded by

Ayan Dey
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1 File Extensionof Excel Docs .

xlsx
2 Max Worksheets in Excel 255
3 Purpose of Quick Access Toolbar
4 Can we customize Quick Access Toolbar Yes
Monthly Budget

January/2022 February/2022 March/2022 Apr/2022


Groceries 2500
Education 5000
Mobile Recharge 200
Entertainment 2000
Expenses
TV 250 4
Electricity 800
Travel 800
Misc 2000
Total 13550 5+6
11

13550
8 7 3

11
Monthly Budget Text and Numeric
Date Day,Month,Year
Dates are Numeric
Date Format
Custom

Cell References Continuous and Non Continuous

Basic Formulas =
Total in Budget
Formula Benefit
Color Coding
Relative
Absolute Percent

Order of Operation Bill


Evaluate Formula
PEMDAS
A
B
C
Total- Before Tax
Tax
Total
1 What Char do all Calculation starts with
2 Cell Reference Example
3 Purpose of Absolute Reference
4 Character to use for Absolute Reference

You might also like