How do I include empty value cells in an average function in Google Spreadsheet?

How do I include empty value cells in an average function in Google Spreadsheet?
by

1 Answer

Answer :

I think I figured it out. I’m glad Google spreadsheets obey the laws of math lol.
by

Related questions

The shares received from the new company is recorded at________ (A) Face value (B) Market value (C) Average price (D) None of these

Description : The shares received from the new company is recorded at________ (A) Face value (B) Market value (C) Average price (D) None of these

Last Answer : (B) Market value

Shares received from the new company are recorded at - (A) Face value (B) Average price (C) Market value (D) None of the above

Description : Shares received from the new company are recorded at - (A) Face value (B) Average price (C) Market value (D) None of the above

Last Answer : (C) Market value

Calculate the value of closing stock18th January, 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700 from the following according to Weighted Average method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units @ Rs. 4.50 Issues: 2nd January, 2014: 30 units

Description : Calculate the value of closing stock from the following according to Weighted Average method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units ... 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700

Last Answer : (c) Rs. 786

On October 4, 2008, Terry Corporation had credit sales transactions of $2,800 from merchandise having cost $1,900. The entries to record the day's credit transactions include a a. debit of $2,800 to Merchandise Inventory. b. credit of $2,800 to Sales. c. debit of $1,900 to Merchandise Inventory. d. credit of $1,900 to Cost of Goods Sold.

Description : On October 4, 2008, Terry Corporation had credit sales transactions of $2,800 from merchandise having cost $1,900. The entries to record the day's credit transactions include a a. debit of $2,800 to ... c. debit of $1,900 to Merchandise Inventory. d. credit of $1,900 to Cost of Goods Sold.

Last Answer : b. credit of $2,800 to Sales.

he journal entry to record a return of merchandise purchased on account under a perpetual inventory system would include a. Accounts Payable Sales Returns and Allowances b. Purchase Returns and Allowances Accounts Payable c. Accounts Payable Inventory d. Merchandise Inventory Cost of Goods Sold

Description : he journal entry to record a return of merchandise purchased on account under a perpetual inventory system would include a. Accounts Payable Sales Returns and Allowances b. Purchase Returns and ... Accounts Payable c. Accounts Payable Inventory d. Merchandise Inventory Cost of Goods Sold

Last Answer : d. Merchandise Inventory Cost of Goods Sold

The operating expense section of an income statement for a wholesaler would not include a. freight-out. b. utilities expense. c. cost of goods sold. d. insurance expense

Description : The operating expense section of an income statement for a wholesaler would not include a. freight-out. b. utilities expense. c. cost of goods sold. d. insurance expense

Last Answer : d. insurance expense

The sales revenue section of an income statement for a retailer would not include a. Sales discounts. b. Sales. c. Net sales. d. Cost of goods sold.

Description : The sales revenue section of an income statement for a retailer would not include a. Sales discounts. b. Sales. c. Net sales. d. Cost of goods sold.

Last Answer : c. Net sales.

The entry to record the receipt of payment within the discount period on a sale of $750 with terms of 2/10, n/30 will include a credit to a. Sales Discounts for $15. b. Cash for $735. c. Accounts Receivable for $750. d. Sales for $750.

Description : The entry to record the receipt of payment within the discount period on a sale of $750 with terms of 2/10, n/30 will include a credit to a. Sales Discounts for $15. b. Cash for $735. c. Accounts Receivable for $750. d. Sales for $750.

Last Answer : c. Accounts Receivable for $750.

Current liabilities a. are obligations that the company is to pay within the forthcoming year. b. are listed in the balance sheet in order of their expected maturity. c. are listed in the balance sheet, starting with accounts payable. d. should not include long-term debt that is expected to be paid within the next year.

Description : Current liabilities a. are obligations that the company is to pay within the forthcoming year. b. are listed in the balance sheet in order of their expected maturity. c. are listed in the balance sheet, ... . d. should not include long-term debt that is expected to be paid within the next year.

Last Answer : a. are obligations that the company is to pay within the forthcoming year. b. are listed in the balance sheet in order of their expected maturity.

he steps in the preparation of a worksheet do not include a. analyzing documentary evidence. b. preparing a trial balance on the worksheet. c. entering the adjustments in the adjustment columns. d. entering adjusted balances in the adjusted trial balance columns.

Description : he steps in the preparation of a worksheet do not include a. analyzing documentary evidence. b. preparing a trial balance on the worksheet. c. entering the adjustments in the adjustment columns. d. entering adjusted balances in the adjusted trial balance columns.

Last Answer : a. analyzing documentary evidence.

Which statement about long-term investments is not true? a. They will be held for more than one year. b. They are not currently used in the operation of the business. c. They include investments in stock of other companies and land held for future use. d. They can never include cash accounts.

Description : Which statement about long-term investments is not true? a. They will be held for more than one year. b. They are not currently used in the operation of the business. c. They include investments in stock of other companies and land held for future use. d. They can never include cash accounts.

Last Answer : d. They can never include cash accounts.

The sub-classifications on the company’s classified balance sheet would include all of the following except: a. Current Assets. b. Property, Plant, and Equipment. c. Current liabilities. d. Long-term Assets.

Description : The sub-classifications on the company’s classified balance sheet would include all of the following except: a. Current Assets. b. Property, Plant, and Equipment. c. Current liabilities. d. Long-term Assets.

Last Answer : d. Long-term Assets.

intangible assets include each of the following except a. copyrights. b. goodwill. c. land improvements. d. patents.

Description : intangible assets include each of the following except a. copyrights. b. goodwill. c. land improvements. d. patents.

Last Answer : c. land improvements.

If Income Summary has a credit balance after revenues and expenses have been closed into it, the closing entry for Income Summary will include a a. debit to the retained earnings account. b. debit to the owner’s dividends account. c. credit to the retained earnings account. d. credit to the owner’s dividends account.

Description : If Income Summary has a credit balance after revenues and expenses have been closed into it, the closing entry for Income Summary will include a a. debit to the retained earnings account. b. debit ... . c. credit to the retained earnings account. d. credit to the owner's dividends account.

Last Answer : c. credit to the retained earnings account.

Current assets include A. Stores & Spare parts B. Stock in trade C. Sundry Debtors D. All of the above

Description : Current assets include A. Stores & Spare parts B. Stock in trade C. Sundry Debtors D. All of the above

Last Answer : D. All of the above

Cash flow from financing activities include payment of interest on borrowing and___ to share holders a) Dividend b) Interest c) Bonus d) Bonus shares

Description : Cash flow from financing activities include payment of interest on borrowing and___ to share holders a) Dividend b) Interest c) Bonus d) Bonus shares

Last Answer : a) Dividend

Cash flows include a) Cash payments only b) Cash receipts only c) Cash receipts and payments d) Cash and noncash incomes and expenses.

Description : Cash flows include a) Cash payments only b) Cash receipts only c) Cash receipts and payments d) Cash and noncash incomes and expenses.

Last Answer : c) Cash receipts and payments

The term financial ananlysis include both --------- and interpretation a) Comparison b) Analysis c) Conclusion d) Constructions

Description : The term financial ananlysis include both --------- and interpretation a) Comparison b) Analysis c) Conclusion d) Constructions

Last Answer : b) Analysis

The operating cycle of a company is the average time that is required to go from cash to a. sales in producing revenues. b. cash in producing revenues. c. inventory in producing revenues. d. accounts receivable in producing revenues.

Description : The operating cycle of a company is the average time that is required to go from cash to a. sales in producing revenues. b. cash in producing revenues. c. inventory in producing revenues. d. accounts receivable in producing revenues.

Last Answer : b. cash in producing revenues.

The contingent liability denominated in foreign currency at the balance sheet date is disclosed by using the __________ (a) Average Rate (b) Closing Rate (c) Non-monetary Rate (d) Monetary Rate

Description : The contingent liability denominated in foreign currency at the balance sheet date is disclosed by using the __________ (a) Average Rate (b) Closing Rate (c) Non-monetary Rate (d) Monetary Rate

Last Answer : Closing

The exchange rate at the balance sheet date is known as ________ (a) Average Rate (b) Closing Rate (c) Non-monetary Rate (d) Monetary Rate

Description : The exchange rate at the balance sheet date is known as ________ (a) Average Rate (b) Closing Rate (c) Non-monetary Rate (d) Monetary Rate

Last Answer : (b) Closing Rate

Average Rate is the mean of the exchange rates in force during a period.

Description : Average Rate is the mean of the exchange rates in force during a period.

Last Answer : TRUE

. If credit sales for the year is Rs. 5,40,000 and Debtors at the end of year is Rs. 90,000 the Average Collection Period will be (a) 30 days (b) 61 days (c) 90 days (d) 120 days

Description : . If credit sales for the year is Rs. 5,40,000 and Debtors at the end of year is Rs. 90,000 the Average Collection Period will be (a) 30 days (b) 61 days (c) 90 days (d) 120 days

Last Answer : (b) 61 days

Which one out of the following is not an inventory valuation method? (a) FIFO (b) LIFO (c) Weighted Average (d) EOQ

Description : Which one out of the following is not an inventory valuation method? (a) FIFO (b) LIFO (c) Weighted Average (d) EOQ

Last Answer : (d) EOQ

Flow of fund means change in ------------------- a) Working capital b) Gross capital c) Net capital d) Average capital

Description : Flow of fund means change in ------------------- a) Working capital b) Gross capital c) Net capital d) Average capital

Last Answer : c) Net capital

Excess of current asset over current liability is known as ------------- a) Gross working capital b) Net working capital c) Average working capital d) None of these

Description : Excess of current asset over current liability is known as ------------- a) Gross working capital b) Net working capital c) Average working capital d) None of these

Last Answer : a) Gross working capital

The two concept of working capital are gross working capital and -------------------------- a) Net working capital b) Average working capital c) Opening working capital d) Closing working capital

Description : The two concept of working capital are gross working capital and -------------------------- a) Net working capital b) Average working capital c) Opening working capital d) Closing working capital a

Last Answer : b) Average working capital

A firm’s investment in current asset is known as ---------------- a) Net working capital b) Gross working capital c) Average working capital d) None of these

Description : A firm’s investment in current asset is known as ---------------- a) Net working capital b) Gross working capital c) Average working capital d) None of these

Last Answer : b) Gross working capital

Liquidity ratios measure the --------- solvency of a firm a) Long term b) Short term c) Average d) Others

Description : Liquidity ratios measure the --------- solvency of a firm a) Long term b) Short term c) Average d) Others

Last Answer : b) Short term

You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Description : You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Last Answer : (b) Marks of each student tor Mathematics will be required for calculating average marks of mathematics.

- in pt with RA to preserve joint function and movement: -disease modifying medication is sufficient - fish oil gives subjective improvement - cold (ice) compression and decrease joint movement

Description : - in pt with RA to preserve joint function and movement: -disease modifying medication is sufficient - fish oil gives subjective improvement - cold (ice) compression and decrease joint movement

Last Answer : disease modifying medication is sufficient

What is the name of the individual cells on a spreadsheet worksheet?

Description : What is the name of the individual cells on a spreadsheet worksheet?

Last Answer : What is the answer ?

Why would a transaction marked "credit" with a positive value deduct from my available balance at the bank?

Description : Why would a transaction marked "credit" with a positive value deduct from my available balance at the bank?

Last Answer : If your bank hasn’t verified the funds from the entity giving you the credit yet, they won’t make it available for you to access.

The relationship between current assets and current liabilities is important in evaluating a company's a. profitability. b. liquidity. c. market value. d. accounting cycle.

Description : The relationship between current assets and current liabilities is important in evaluating a company's a. profitability. b. liquidity. c. market value. d. accounting cycle.

Last Answer : b. liquidity.

Surplus , if any , from the creditors having been secured on the assets specially pledged , is added to the estimated realisable value of the assets not specifically pledged.

Description : Surplus , if any , from the creditors having been secured on the assets specially pledged , is added to the estimated realisable value of the assets not specifically pledged.

Last Answer : TRUE

___________ value is the amount for which an asset could be exchanged, or a liability settled, between knowledgeable, willing parties in an arm‟s length transaction.

Description : ___________ value is the amount for which an asset could be exchanged, or a liability settled, between knowledgeable, willing parties in an arm‟s length transaction.

Last Answer : Fair,

Intrinsic value of each equity shares of the vendor company is Rs. 250 and that of the purchasing company is Rs. 400. The exchange ratio of shares on the basis of intrinsic value is - (A) 2:1 (B) 8:8 (C) 8:5 (D) None of the above

Description : Intrinsic value of each equity shares of the vendor company is Rs. 250 and that of the purchasing company is Rs. 400. The exchange ratio of shares on the basis of intrinsic value is - (A) 2:1 (B) 8:8 (C) 8:5 (D) None of the above

Last Answer : (C) 8:5

If the market price of the shares to be given for Purchase Consideration at the time of absorption, ............ of the share is to be determined (A) Fair Value (B) Face Value (C) Intrinsic Value (D) Yield Value

Description : If the market price of the shares to be given for Purchase Consideration at the time of absorption, ............ of the share is to be determined (A) Fair Value (B) Face Value (C) Intrinsic Value (D) Yield Value

Last Answer : (C) Intrinsic Value

Kirti Co’s Balance Sheet shows Fixed Asset Rs. 3,60,000. At the time of absorption calculation of Net Assets is 10% less than the market value, then market value of such fixed assets is ............ (A) Rs. 3,24,000 (B) Rs. 4,00,000 (C) Rs. 4,20,000 (D) None of these

Description : Kirti Co’s Balance Sheet shows Fixed Asset Rs. 3,60,000. At the time of absorption calculation of Net Assets is 10% less than the market value, then market value of such fixed assets is ............ (A) Rs. 3,24,000 (B) Rs. 4,00,000 (C) Rs. 4,20,000 (D) None of these

Last Answer : (B) Rs. 4,00,000

Which of the following statement is correct? (A) The amount of Goodwill or Capital Reserve is recorded in the books of purchasing company only (B) The amount of Goodwill or Capital Reserve is recorded in the books of vendor company only. (C) Goodwill = Net Assets – Purchase price (D) The face value of shares of purchasing company will be taken in to account while calculating purchase consideration.

Description : Which of the following statement is correct? (A) The amount of Goodwill or Capital Reserve is recorded in the books of purchasing company only (B) The amount of Goodwill or Capital ... value of shares of purchasing company will be taken in to account while calculating purchase consideration.

Last Answer : The amount of Goodwill or Capital Reserve is recorded in the books of purchasing company only

While calculating purchase price, the following values of assets are considered (A) Book value (B) Revised Value

Description : While calculating purchase price, the following values of assets are considered (A) Book value (B) Revised Value

Last Answer : (B) Revised Value

Following information is available of PQR for year ended March, 2013: 4,000 units in process, 3,800 units output, 10% of input is normal wastage, Rs. 2.50 per unit is scrap value and Rs. 46,000 incurred towards total process cost then amount on account of abnormal gain to be transferred to Costing P&L will be:- (a) Rs. 2,500 (b) Rs. 2,000 (c) Rs. 4,000 (d) Rs. 3,500

Description : Following information is available of PQR for year ended March, 2013: 4,000 units in process, 3,800 units output, 10% of input is normal wastage, Rs. 2.50 per unit is scrap value and Rs. 46,000 incurred towards total process cost ... be:- (a) Rs. 2,500 (b) Rs. 2,000 (c) Rs. 4,000 (d) Rs. 3,500

Last Answer : (a) Rs. 2,500

In process costing, if an abnormal loss arises, the process account is generally (a) Debited with the scrap value of the abnormal loss units (b) Debited with the full production cost of the abnormal loss units (c) Credited with the scrap value of the abnormal loss units

Description : In process costing, if an abnormal loss arises, the process account is generally (a) Debited with the scrap value of the abnormal loss units (b) Debited with the full production cost of the abnormal loss units (c) Credited with the scrap value of the abnormal loss units

Last Answer : (d) Credited with the full production cost of the abnormal loss units

In process costing, a joint product is (a) a product which is later divided into many parts (b) a product which is produced simultaneously with other products and is of similar value to at least one of the other products. (c) A product which is produced simultaneously with other products but which is of a greater value than any of the other products.

Description : In process costing, a joint product is (a) a product which is later divided into many parts (b) a product which is produced simultaneously with other products and is of similar value to ... simultaneously with other products but which is of a greater value  than any of the other products.

Last Answer : (b) a product which is produced simultaneously with other products and is of similar value to at least  one of the other products.

Most suitable basis for apportioning insurance of machine would be: (a) Floor Area (b) Value of Machines (c) No. of Workers (d) No. of Machines

Description : Most suitable basis for apportioning insurance of machine would be: (a) Floor Area (b) Value of Machines (c) No. of Workers (d) No. of Machines

Last Answer : (b) Value of Machines

Calculate the value of closing stock from the following according to LIFO method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units @ Rs. 4.50 Issues: 2nd January, 2014: 30 units 18th January, 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700

Description : Calculate the value of closing stock from the following according to LIFO method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units @ Rs. 4.50 ... , 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700

Last Answer : (b) Rs. 805

Calculate the value of closing stock from the following according to FIFO method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units @ Rs. 4.50 Issues: 2nd January, 2014: 30 units 18th January, 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700

Description : Calculate the value of closing stock from the following according to FIFO method: 1st January, 2014: Opening balance: 50 units @ Rs. 4 Receipts: 5th January, 2014: 100 units @ Rs. 5 12th January, 2014: 200 units @ Rs. 4.50 ... , 2014: 150 units (a) Rs. 765 (b) Rs. 805 (c) Rs. 786 (d) Rs. 700

Last Answer : (a) Rs. 765

In case of rising prices (inflation), LIFO will: (a) provide lowest value of closing stock and profit (b) provide highest value of closing stock and profit (c) provide highest value of closing stock but lowest value of profit (d) provide highest value of profit but lowest value of closing stock

Description : In case of rising prices (inflation), LIFO will: (a) provide lowest value of closing stock and profit (b) provide highest value of closing stock and profit (c) provide highest value ... but lowest value of profit (d) provide highest value of profit but lowest value of closing stock

Last Answer : (a) provide lowest value of closing stock and profit

In case of rising prices (inflation), FIFO method will: (a) provide lowest value of closing stock and profit (b) provide highest value of closing stock and profit (c) provide highest value of closing stock but lowest value of profit (d) provide highest value of profit but lowest value of closing stock

Description : In case of rising prices (inflation), FIFO method will: (a) provide lowest value of closing stock and profit (b) provide highest value of closing stock and profit (c) provide highest value ... stock but lowest value of profit (d) provide highest value of profit but lowest value of closing stock

Last Answer : (b) provide highest value of closing stock and profit