Subtotal, Mathematical functions, Statistical functions
by The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and …
Year: 2019
Date and Time Functions
To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a …
Text functions
Excel has many functions to offer when it comes to manipulating text strings. Join Strings To join strings, use the & operator. Note: to insert …
Financial Functions
Financial functions calculate financial information, such as net present value and payments. For example, you can calculate the monthly payments required to buy a car …
Analyze data with Pivot Tables
A PivotTable is an Excel tool for summarizing a list into a simple format. You create PivotTables from lists, as you define which fields should …
Create and Manage scenarios and summaries
Use Excel Scenarios to store several versions of the data in a worksheet. For example, when preparing an annual budget, the Marketing and Finance departments …
Cannons of Taxation Person
By canons of taxation we simply mean the characteristics or qualities which a good tax system should possess. In fact, canons of taxation are related …
Income Tax Return forms and their due dates
Income Tax Return forms and their due dates
Types of Software
Software is a set of programs, which is designed to perform a well-defined function. A program is a sequence of instructions written to solve a …
Introduction to Operating System
An operating system acts as an intermediary between the user of a computer and computer hardware. The purpose of an operating system is to provide …
You must be logged in to post a comment.