Answer:
17%
Explanation:
Given parameters:
Cost price of liquor = $4000
Total sale = $24000
Unknown:
Percentage cost of sale for liquor = ?
Solution:
To find the percentage cost of sale;
%Cost of sale of liquor = 
x 100
Input the variables;
%Cost of sale of liquor = 
x 100 = 16.67% = 17%
Answer:
To select nonsequential cells, click the first cell, hold down the Ctrl key, and click each additional cell (or row or column) you want to select. To selectthe entire worksheet, click the small box located to the left of column A and above row 1. Optionally, you can selectall cells in a worksheet by pressing COMMAND+A......
To select all cells on a worksheet, use one of the following methods:
Click the Select All button.Press COMMAND+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing COMMAND+A selects the current region. Pressing COMMAND+A a second time selects the entire worksheet.
Answer:
The formula and value to this question is "=A1+A3+A4+A5 with value 100"
Explanation:
The explanation of the given question as follows:
- In question, it is defined that four cells that are "A1, A2, A3, and A4" contains value that are "10, 20, 30, and 40".
- To add these values we use addition formula that is "=A1+A2+A3+A4". it will give value 100.
- If the user inserts a new row that is "A2" and assigns a value in the cell that is "50" so, we use the above formula that adds values with these values we also use the value "100".
Answer:
The number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.
Explanation:
This part of the code below
WHERE InvoiceTotal - PaymentTotal - CreditTotal >
(SELECT AVG (InvoiceTotal - PaymentTotal- CreditTotal)
FROM Invoices)
gives the condition to pick the invoices with balance that are greater than the average balance for all invoice.
This part of the code below
GROUP BY VendorName
ORDER BY BalanceDue DESC;
then enables the program to group the result of the above condition by VendorName and sort the resulting rows in the order of BalanceDue. You will therefore, obtain for each row in the NumberOfInvoices column, the number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.
