db5 - staying within their average or going below....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel advance tools such as Min and Max can be use by companies to see their min and max sales per month. They can determine where they lose or gain in that month or annually. It can record their sales over a monthly or annually timeframe. Letting them know the areas where they need to focus on to bring that negative up to a gain. Conditional formatting is a great way for companies to identify who owes them money. They can format the cells by adding color this will help to quickly identifies who’s in debt with them. Other function companies may want to use is the Average function to determine if they are
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: staying within their average or going below. Reference cell reference is defined as cells or ranges that are usually based on their position relative to the cell that contains the formula. Absolute cell reference is where the cell reference is to be permanent as the formula is copied, because you have a standard calculation that involves a fixed value. So absolute cell is already done and cannot be change. Whereas if you want to make adjustments to your reference you should use the reference cell reference....
View Full Document

This note was uploaded on 04/07/2011 for the course ECON 101 taught by Professor Sei during the Spring '11 term at American Academy of Art.

Ask a homework question - tutors are online