COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
COUNT
|
|
|
MAX
|
|
|
MIN
|
Detailed explanation-1: -To calculate the total values of sales, multiply the average price per product or service sold by the number of products or services sold.
Detailed explanation-2: -The sales revenue formula calculates revenue by multiplying the number of units sold by the average unit price. Service-based businesses calculate the formula slightly differently: by multiplying the number of customers by the average service price.
Detailed explanation-3: -Enter “=SUM(D1:D#)” in the next empty cell in column D. Replace “#” with the row number of the last entry in column D. In the example, enter “=SUM(D1:D2)” to calculate the total sales revenue for the two items.
Detailed explanation-4: -Total sales or gross sales is the grand total of all sales revenues a business generates from normal activities. This is a vital number for any business because money has to go into the cash register before it can be used to pay bills and provide profit for investors.