Junior Accountant Position, Am Inc. Part 1
Choose the best answer, this is a pre-qualification examination for the Junior Accountant.
Questions and Answers
- 1.
Basic Accounting Concept: A debit may signify a(n):
- A.
Decrease in asset accounts.
- B.
Decrease in liability accounts.
- C.
Increase in the capital account.
- D.
Decrease in expense accounts.
Correct Answer
B. Decrease in liability accounts.Explanation
A debit in accounting refers to an entry made on the left side of an account, indicating an increase in an asset or an expense, or a decrease in a liability or equity. In this case, the correct answer is a decrease in liability accounts because a debit entry would reduce the amount owed by the company to its creditors or other parties.Rate this question:
-
- 2.
Basic Accounting Concept: Which is an advantage of a sole proprietorship form of business?
- A.
Limited personal risk.
- B.
Can continue indefinitely
- C.
Owner makes all the decisions.
- D.
All of the above.
Correct Answer
C. Owner makes all the decisions.Explanation
The advantage of a sole proprietorship form of business is that the owner has complete control over decision-making. Unlike other forms of business, where decisions may need to be made by a board or multiple owners, a sole proprietor has the freedom to make all the decisions independently. This allows for quick and efficient decision-making, as the owner does not need to consult or seek approval from others.Rate this question:
-
- 3.
Basic Accounting Concept: A corporation is a business which is:
- A.
Easy to form.
- B.
Ends with the death of a stockholder.
- C.
Owned by stockholders.
- D.
None of the above.
Correct Answer
C. Owned by stockholders.Explanation
A corporation is a business entity that is owned by stockholders. This means that the ownership of the corporation is divided into shares of stock, which are owned by individuals or other entities. The stockholders have the right to vote on important decisions, such as the election of the board of directors, and they also have the potential to receive dividends based on the profits of the corporation. Therefore, the correct answer is that a corporation is owned by stockholders.Rate this question:
-
- 4.
Basic Accounting Concept: The difference between the balance of a fixed asset account and the related accumulated depreciation account is termed:
- A.
Liability
- B.
Contra asset
- C.
Book value
- D.
Market value
Correct Answer
C. Book valueExplanation
The correct answer is book value. Book value refers to the net value of a fixed asset after deducting its accumulated depreciation. It represents the cost of the asset that has not yet been depreciated. It is an important concept in accounting as it helps determine the true value of an asset on a company's balance sheet.Rate this question:
-
- 5.
Basic Accounting Concept: Who is the person in charge, most of the time, with the fulfillment with GAAP.
- A.
CFO
- B.
Senior Accountant
- C.
CEO
Correct Answer
B. Senior AccountantExplanation
The senior accountant is the person in charge, most of the time, with the fulfillment of GAAP (Generally Accepted Accounting Principles). They are responsible for ensuring that the financial statements and records of the company are prepared in accordance with GAAP guidelines. The CFO (Chief Financial Officer) and CEO (Chief Executive Officer) may have oversight and decision-making authority, but the day-to-day responsibility lies with the senior accountant.Rate this question:
-
- 6.
Basic Accounting Concept: The amount of net sales minus the amount of cost of goods sold measures:
- A.
Gross profit
- B.
Net profit
- C.
Financial leverage
- D.
Operating leverage
Correct Answer
A. Gross profitExplanation
The amount of net sales minus the amount of cost of goods sold measures gross profit. Gross profit represents the profit a company makes after deducting the direct costs associated with producing or purchasing the goods sold. It reflects the profitability of the company's core operations without considering other expenses such as operating expenses or taxes. By calculating gross profit, a company can assess its ability to generate revenue from its products or services and determine the efficiency of its production or purchasing processes.Rate this question:
-
- 7.
Basic Accounting Concept: On which financial statement would you find Salaries Expense?
- A.
Income Statement
- B.
Balance Sheet
- C.
Statement of owner's equity
- D.
It does not appear on a financial statement
Correct Answer
A. Income StatementExplanation
Salaries Expense would be found on the Income Statement. The Income Statement is a financial statement that shows a company's revenues, expenses, and net income or loss for a specific period of time. Salaries Expense represents the amount of money that a company has paid to its employees for their services during that period. It is considered an expense because it reduces the company's net income.Rate this question:
-
- 8.
Basic Accounting Concepts: Which of the following statements is incorrect?
- A.
Assets - Liabilities = Capital
- B.
Assets - Capital = Liabilities
- C.
Liabilities + Capital = Assets
- D.
Liabilities + Assets = Capital
Correct Answer
D. Liabilities + Assets = CapitalExplanation
The given statement "Liabilities + Assets = Capital" is incorrect. According to basic accounting principles, the equation should be "Assets - Liabilities = Capital." This equation represents the fundamental accounting equation, which states that the total assets of a business are equal to the total liabilities and owner's equity.Rate this question:
-
- 9.
Basic Accounting Concepts: Which of the following best describes a trial balance?
- A.
It is a list of balances on the books
- B.
Shows the financial position of a business
- C.
It is a special account
- D.
Shows all the entries in the books
Correct Answer
A. It is a list of balances on the booksExplanation
A trial balance is a list of balances on the books, which means it includes all the account balances in a company's general ledger. It is used to ensure that the debits and credits in the accounting system are equal and to identify any errors or discrepancies in the recording of financial transactions. By comparing the total debits and credits in the trial balance, accountants can verify the accuracy of the company's financial records and prepare accurate financial statements.Rate this question:
-
- 10.
Basic Accounting Concept: Which type of account would not be reported on the income statement?
- A.
Revenue
- B.
Expenses
- C.
Withdrawals
- D.
None of the above
Correct Answer
C. WithdrawalsExplanation
Withdrawals would not be reported on the income statement because withdrawals represent the owner's personal use of business funds and are not considered business expenses or revenue. The income statement is used to report the revenues, expenses, and net income or loss of a business, but withdrawals are not considered part of the business's financial performance. Instead, withdrawals are reported on the owner's equity statement or statement of changes in equity to reflect the decrease in the owner's investment in the business.Rate this question:
-
- 11.
Basic Accounting Concept: Who is the person in charge to sets the direction and oversees the operations of an organization?
- A.
CFO
- B.
Senior Accountant
- C.
CEO
Correct Answer
C. CEOExplanation
The CEO, or Chief Executive Officer, is the person in charge of setting the direction and overseeing the operations of an organization. They are responsible for making major corporate decisions, managing the overall strategy, and ensuring the organization's success. The CFO, or Chief Financial Officer, is typically responsible for managing the financial aspects of the organization, while a Senior Accountant may have a more specialized role in managing accounting functions. However, the CEO is the ultimate authority and has the highest level of responsibility in an organization.Rate this question:
-
- 12.
Basic Accounting Concept: Who is the person responsible for managing the financial analisys, establishing the financial planning and managing the financial risk of the corporation?
- A.
CFO
- B.
Senior Accountant
- C.
CEO
Correct Answer
A. CFOExplanation
The person responsible for managing the financial analysis, establishing the financial planning, and managing the financial risk of the corporation is the CFO (Chief Financial Officer). The CFO is a senior executive who oversees the financial operations of the company, including budgeting, forecasting, financial reporting, and risk management. They play a crucial role in making strategic financial decisions and ensuring the financial health and stability of the organization.Rate this question:
-
- 13.
Basic Accounting Concept: Which of the following accounts would be considered a temporary account?
- A.
Revenue.
- B.
Assets.
- C.
Liabilities.
- D.
Owner's Equity.
Correct Answer
A. Revenue.Explanation
Revenue is considered a temporary account because it represents income earned by a company during a specific accounting period. At the end of the period, revenue is closed out and transferred to the retained earnings account, which is a permanent account. This process ensures that revenue is properly recorded and accounted for in the financial statements. In contrast, assets, liabilities, and owner's equity are considered permanent accounts as they represent the ongoing financial position of the company.Rate this question:
-
- 14.
Basic Accounting Concept: Is it true that the trial balance totals should agree?
- A.
No, there are sometimes good reasons why they differ
- B.
No, because it is not a balance sheet
- C.
Yes, except where the trial balance is extracted at the year end
- D.
Yes, always
Correct Answer
D. Yes, alwaysExplanation
The trial balance is a statement that lists all the debit and credit balances of accounts in the general ledger. It is prepared to ensure that the total of all debit balances equals the total of all credit balances, thus ensuring that the accounting equation (assets = liabilities + equity) is in balance. If the trial balance totals do not agree, it indicates that there is an error in the recording or balancing of accounts. Therefore, the correct answer is that the trial balance totals should always agree.Rate this question:
-
- 15.
Basic Accounting Concept: The entry to record the payment of office salaries would be:
- A.
Debit to Cash, credit to Accounts Receivable.
- B.
Debit to Cash, credit to Salaries Expense.
- C.
Debit to Salaries Expense, credit to Accounts Payable.
- D.
Debit to Salaries Expense, credit to Cash.
Correct Answer
D. Debit to Salaries Expense, credit to Cash.Explanation
The correct answer is debit to Salaries Expense, credit to Cash. This is because when office salaries are paid, it is an expense for the company, so it should be debited to the Salaries Expense account. The company is using cash to make the payment, so it should be credited to the Cash account. This entry reflects the outflow of cash for the payment of salaries.Rate this question:
-
- 16.
Basic Accounting Concept: Items owned by the business such as land, supplies, and equipment are its
- A.
Assets
- B.
Liabilities
- C.
Owner's equity
- D.
Revenue
Correct Answer
A. AssetsExplanation
Assets are items owned by a business that have monetary value and can be used to generate future economic benefits. These can include tangible assets like land, supplies, and equipment, as well as intangible assets like patents or trademarks. Liabilities, on the other hand, are debts or obligations that the business owes to external parties. Owner's equity represents the owner's investment in the business and the accumulated profits or losses. Revenue refers to the income generated from the business's main activities. Therefore, the correct answer is assets, as it represents the items owned by the business.Rate this question:
-
- 17.
Basic Accounting Concept: Residual value is the:
- A.
Value of the asset when it is purchased
- B.
Value of the asset at the end of its useful life
- C.
Cost of the asset
- D.
Allocation of the cost
Correct Answer
B. Value of the asset at the end of its useful lifeExplanation
The residual value refers to the estimated value of an asset at the end of its useful life. It is the amount that the asset is expected to be worth after it has been fully depreciated. This value is important in determining the depreciation expense of the asset over its useful life.Rate this question:
-
- 18.
Basic Accounting Concept: Which of the following is most likely to result in an adjusting entry at the end of the period?
- A.
Payment of two months' insurance in advance.
- B.
Payment of one month's rent.
- C.
Owner's withdrawals.
- D.
Payment for routine maintenance on the company van.
Correct Answer
A. Payment of two months' insurance in advance.Explanation
Payment of two months' insurance in advance is most likely to result in an adjusting entry at the end of the period because it involves the prepayment of an expense that will be incurred over a period of time. The adjusting entry is necessary to recognize the portion of the prepaid insurance that has expired during the period as an expense. This ensures that the financial statements accurately reflect the expenses incurred during the period.Rate this question:
-
- 19.
Basic Accounting Concepts: Which of the following is correct?
- A.
Capital can only come from profit
- B.
Profit does not alter capital
- C.
Profit increases capital
- D.
Profit reduces capital
Correct Answer
C. Profit increases capitalExplanation
Profit increases capital because profit is the excess of revenue over expenses, and it is considered a source of funds for a business. When a business earns a profit, it adds to its capital or owner's equity. This increase in capital allows the business to have more resources to invest, expand operations, or distribute dividends to shareholders. Therefore, profit is an essential factor in growing and strengthening the capital base of a business.Rate this question:
-
- 20.
Basic Accounting Concept: Who is the person in charge to carry out the strategic plans and policies as established by the board of directors?
- A.
CFO
- B.
Senior Accountant
- C.
CEO
Correct Answer
C. CEOExplanation
The CEO, or Chief Executive Officer, is the person in charge of carrying out the strategic plans and policies established by the board of directors. This role is responsible for the overall management and direction of the company, making important decisions that align with the organization's goals and objectives. The CEO is accountable for the company's performance and is typically the highest-ranking executive in the organization.Rate this question:
-
- 21.
Basic Accounting Copcept: Which of the following would not be reported as a separate component on the income statement?
- A.
Income from continuing operations
- B.
Discontinued operations
- C.
Prior period adjustment
- D.
Extraordinary item
Correct Answer
C. Prior period adjustmentExplanation
A prior period adjustment refers to a correction made to the financial statements of a company for errors or omissions in previous periods. It is not reported as a separate component on the income statement because it is considered an adjustment to the opening balance of retained earnings or other appropriate equity accounts. It does not represent the ongoing operations or activities of the company in the current period. Instead, it is a retrospective adjustment that corrects the errors of previous periods and ensures the accuracy of the financial statements.Rate this question:
-
- 22.
Accounting Application: C. Miller service purchased a microscope for $1,500. It has an expected life of 30 months and no residual value. The adjusting journal entry for the month is:
- A.
Debit Depreciation Expense $50, credit Accumulated Depreciation $50.
- B.
Debit Depreciation Expense $500, credit Accumulated Depreciation $500.
- C.
Debit Accumulated Depreciation $50, credit Depreciation Expense $50.
- D.
Debit Accumulated Depreciation $500, credit Equipment $500.
Correct Answer
A. Debit Depreciation Expense $50, credit Accumulated Depreciation $50.Explanation
The correct answer is debit Depreciation Expense $50, credit Accumulated Depreciation $50 because this journal entry reflects the monthly depreciation expense for the microscope. Depreciation is the process of allocating the cost of an asset over its useful life, and in this case, the microscope has an expected life of 30 months with no residual value. By debiting Depreciation Expense, we record the expense for the month, and by crediting Accumulated Depreciation, we accumulate the total depreciation expense over time. This journal entry follows the matching principle in accounting, which requires expenses to be recognized in the same period as the related revenue or asset usage.Rate this question:
-
- 23.
Accounting Application: Amy flew to Philadelphia on a business trip. The purchase price of the ticket was $400 on account. The entry to record the transaction is:
- A.
Debit Accounts Payable, $400; credit Travel Expense, $400.
- B.
Debit Travel Expense, $400; credit Accounts Payable, $400.
- C.
Debit Capital, $400; credit Accounts Payable, $400.
- D.
Debit Travel Expense, $400; credit Cash, $400.
Correct Answer
B. Debit Travel Expense, $400; credit Accounts Payable, $400.Explanation
The correct answer is debit Travel Expense, $400; credit Accounts Payable, $400. This is because the purchase of the ticket is an expense for the business, which is recorded as a debit to the Travel Expense account. Since the purchase was made on account, it is recorded as a credit to the Accounts Payable account, representing the amount owed to the supplier.Rate this question:
-
- 24.
Accounting Application: Carmen's catered a reception. The total price was $1,200. The customer paid $200 cash and charged the remainder. The journal entry to record this transaction is:
- A.
Debit Cash $200 and Accounts Receivable $1,000; credit Catering Service Fees $1,200.
- B.
Debit Cash $200; credit Accounts Receivable $200.
- C.
Debit Cash $1,000 and Accounts Receivable $200; credit Catering Service Fees $1,200
- D.
Debit Accounts Receivable $1,200; credit Cash $200 and Catering Service Fees $1,000.
Correct Answer
A. Debit Cash $200 and Accounts Receivable $1,000; credit Catering Service Fees $1,200.Explanation
The correct answer is debit Cash $200 and Accounts Receivable $1,000; credit Catering Service Fees $1,200. This is the correct journal entry because $200 was received in cash, reducing the amount owed by the customer, and $1,000 was charged to the customer's Accounts Receivable, representing the amount they still owe. The Catering Service Fees account is credited for the total price of $1,200 to record the revenue earned from the reception.Rate this question:
-
- 25.
Accounting Application: Carr Hardware has total assets of $75,000. What are the total assets if new baking equipment is purchased for $10,000 cash?
- A.
$85,000
- B.
$65,000
- C.
$10,000
- D.
$75,000
Correct Answer
D. $75,000Explanation
The correct answer is $75,000. This is because the question asks for the total assets after the new baking equipment is purchased for $10,000 cash. Since the purchase is made in cash, it does not affect the total assets. Therefore, the total assets remain at $75,000.Rate this question:
-
- 26.
Accounting Application: Ellen's Bakery collects $3,500 of its account receivables. The expanded accounting equation changes include:
- A.
Cash and Ellen, Capital increases, $3,500
- B.
Cash and Revenue increases, $3,500
- C.
Cash increases and Accounts Receivable decreases, $3,500
- D.
Accounts Receivable decreases and Ellen, Capital increases, $3,500
Correct Answer
C. Cash increases and Accounts Receivable decreases, $3,500Explanation
When Ellen's Bakery collects $3,500 of its accounts receivables, it means that the bakery is receiving cash from its customers who owed money. This results in an increase in the cash account because the bakery now has more cash on hand. At the same time, the accounts receivable balance decreases because the bakery has received payment and no longer has outstanding receivables. Therefore, the correct answer is "Cash increases and Accounts Receivable decreases, $3,500".Rate this question:
-
- 27.
Accounting Application: Sun Glow Glass estimated depreciation for office equipment is $100. The adjusting entry would include:
- A.
A credit to Accumulated Depreciation for $100.
- B.
A credit to Depreciation Expense for $100.
- C.
A debit to Accumulated Depreciation for $100
- D.
A credit to Office Equipment for $100.
Correct Answer
A. A credit to Accumulated Depreciation for $100.Explanation
The correct answer is a credit to Accumulated Depreciation for $100. This is because the adjusting entry for depreciation involves increasing the Accumulated Depreciation account, which is a contra-asset account that represents the total depreciation expense incurred over time. By crediting Accumulated Depreciation, the account balance is increased, reflecting the accumulated depreciation for the office equipment.Rate this question:
-
- 28.
Accounting Application: A $600 check written for supplies was journalized as $60. The entry to correct this error is:
- A.
Debit Supplies, $540; credit Cash, $540
- B.
Debit Cash, $540; credit Supplies, $540
- C.
Debit Supplies, $60; credit Cash, $60
- D.
Debit Cash, $60; credit Cash, $60
Correct Answer
A. Debit Supplies, $540; credit Cash, $540Explanation
The correct entry to correct the error is to debit Supplies for the correct amount of $540 and credit Cash for the correct amount of $540. This will adjust the accounts to reflect the correct amount spent on supplies and the correct amount of cash paid.Rate this question:
-
- 29.
PC Operations: All computers must have
- A.
Operating System
- B.
Word processing Software
- C.
Keyboard
- D.
Modem
Correct Answer
A. Operating SystemExplanation
An operating system is essential for a computer to function properly. It manages the computer's hardware and software resources, allowing users to interact with the computer and run applications. Without an operating system, the computer would not be able to perform tasks, manage files, or communicate with other devices. While word processing software, keyboard, and modem are important components, they are not necessary for a computer to have in order to be considered a computer.Rate this question:
-
- 30.
PC Operations: MS Outlook is an email client. It is used for the sole purpose of checking, sending and recievie emails.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
MS Outlook is not just an email client, but also a personal information manager that includes features such as calendar, task manager, contact manager, note-taking, journal, and web browsing. It is used for managing personal information, scheduling appointments, and organizing tasks, in addition to checking, sending, and receiving emails. Therefore, the statement that MS Outlook is used solely for checking, sending, and receiving emails is false.Rate this question:
-
- 31.
PC Operations: The brain of the computer is called
- A.
RAM
- B.
CPU
- C.
Cache
- D.
Windows
Correct Answer
B. CPUExplanation
The correct answer is CPU because it stands for Central Processing Unit, which is the main component of a computer that performs most of the processing inside the computer. It carries out instructions of a computer program by performing basic arithmetic, logical, control, and input/output (I/O) operations. The CPU is often referred to as the brain of the computer because it controls and coordinates all the activities of the computer system. RAM, Cache, and Windows are not the brain of the computer but rather other components or software involved in computer operations.Rate this question:
-
- 32.
PC Operations: You'd like each of the emails you sent to display your name and other details automatically at the end of the message. Which feature helps you to set this up?
- A.
Footers
- B.
Signatures
- C.
Tables
- D.
Frames
Correct Answer
B. SignaturesExplanation
Signatures is the feature that allows you to set up your name and other details to automatically appear at the end of your emails. This feature is commonly used in email clients to add a personalized touch to your messages and save time by not having to manually type the same information every time you send an email.Rate this question:
-
- 33.
PC Operations: Which of the following might be a reason that you fail to send or receive an attachment?
- A.
The attachment is too boring
- B.
The attachment doesn't relate to the subject line
- C.
The attachment was created by someone else
- D.
The attachment is too big
Correct Answer
D. The attachment is too bigExplanation
The reason you might fail to send or receive an attachment is that the attachment is too big. Large attachments can exceed the file size limit set by email providers, causing them to fail to send or be rejected upon receipt.Rate this question:
-
- 34.
Excel Application: Q1: What does this button mean?
- A.
Align the text on the borders of the page.
- B.
Extend the content on the entire length of the cell.
- C.
Group together the selected cells and center the content.
- D.
None of the above
Correct Answer
C. Group together the selected cells and center the content.Explanation
This button in the Excel application is used to group together the selected cells and center the content. It allows the user to combine multiple cells into a single cell and align the text in the center of the merged cell. This can be useful for organizing and formatting data in a spreadsheet.Rate this question:
-
- 35.
Excel Application: In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
X
Correct Answer
C. *Explanation
To multiply items in Excel, the asterisk (*) symbol is used.Rate this question:
-
- 36.
Excel Application: A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ? v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
- D.
Delete all the culumns and cells.
Correct Answer
B. Right click on the spreadsheet tab and select DELETEExplanation
The correct sequence of events to remove a spreadsheet from a workbook is to right click on the spreadsheet tab and select DELETE. This action will delete the specific spreadsheet from the workbook.Rate this question:
-
- 37.
Excel Application: What will be the result according to this formula: =vlookup(B1;A4:B8;2) ?
- A.
A
- B.
B
- C.
C
- D.
D
Correct Answer
C. CExplanation
The formula =vlookup(B1;A4:B8;2) is a VLOOKUP function in Excel. It searches for the value in cell B1 in the range A4:B8 and returns the corresponding value from the second column (column B) of that range. The result will be the value in column B that corresponds to the value in B1.Rate this question:
-
- 38.
Excel Application: Why doesn't the SUM formula in E10 show an answer of $30,000?
- A.
The database has been filtered so there must be hidden rows containing other income figures.
- B.
The correct formula for this situation is SUMPRODUCT rather than SUM.
- C.
Conditional formatting has been applied to rows 3, 4, and 6 so that these rows are excluded from the SUM calculations.
- D.
Incorrect data validation has been used.
Correct Answer
A. The database has been filtered so there must be hidden rows containing other income figures. -
- 39.
Excel Application: What is the most appropriate formula you can put in the C2 cell to calculate a 7% tax?
- A.
=A2*0.07
- B.
=A2*.07%
- C.
=A2*1.07
- D.
=A2+(A2*0.07)
Correct Answer
A. =A2*0.07Explanation
The most appropriate formula to calculate a 7% tax is =A2*0.07. This formula multiplies the value in cell A2 by 0.07, which represents 7% as a decimal. This will give the amount of tax to be added to the original value.Rate this question:
-
- 40.
Excel Application: The cell labeled F5 refers to
- A.
Row F column 5
- B.
Functions available in cells
- C.
Column F row 5
- D.
Function key F4
Correct Answer
C. Column F row 5Explanation
The cell labeled F5 refers to the intersection of column F and row 5 in the Excel application. This means that it is the cell located in the fifth row of column F.Rate this question:
-
- 41.
Excel Application: If you copy the formula =$B38 into another cell, the result will be:
- A.
The column part will remain the same
- B.
The row part will remain the same
- C.
Both the column and row will remain the same
- D.
Both will change
Correct Answer
A. The column part will remain the sameExplanation
When the formula =$B38 is copied into another cell, the column part (B) will remain the same. This is because the dollar sign ($) in front of the column reference locks it in place, preventing it from changing when the formula is copied to a different column. However, the row part (38) is not locked with a dollar sign, so it will change relative to the new cell location.Rate this question:
-
- 42.
Excel Application: The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called
- A.
Freezing
- B.
Locking
- C.
Selecting
- D.
Fixing
Correct Answer
A. FreezingExplanation
Freezing is the process of identifying specific rows and columns in Excel so that they remain visible on the screen even when scrolling through large amounts of data. This allows users to keep important information in view while navigating through the spreadsheet. Freezing is commonly used when working with large datasets or when comparing data in different parts of the spreadsheet.Rate this question:
-
- 43.
Excel Application: If you copy the formula =B38 into another cell, the result will be:
- A.
The column part will remain the same
- B.
The row part will remain the same
- C.
Both the column and row will remain the same
- D.
Both will change
Correct Answer
D. Both will changeExplanation
When you copy a formula in Excel to another cell, the cell references in the formula will adjust accordingly. In this case, since the formula being copied is "=B38", both the column (B) and the row (38) references will change based on the new location of the copied formula. So, if you copy the formula to a different cell, the new formula will reference a different column and row.Rate this question:
-
- 44.
Excel Application: What this symbol means? ######
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- D.
The formula is not posible.
Correct Answer
C. The cell is not wide enough.Explanation
The symbol "######" in Excel indicates that the cell is not wide enough to display the entire contents of the cell. This typically happens when the content of the cell is too long or when the column width is too narrow. To fix this, you can either increase the width of the column or decrease the font size in the cell.Rate this question:
-
- 45.
Excel Application: When you are typing an equation into a cell the first thing that must be entered is
- A.
The first cell referenced
- B.
Parenthesis
- C.
Quotation marks
- D.
An equal sign
Correct Answer
D. An equal signExplanation
In Excel, when typing an equation into a cell, the first thing that must be entered is an equal sign. The equal sign is necessary to indicate that the content in the cell is a formula or equation, and not just a regular text entry. Without the equal sign, Excel will treat the input as a text string rather than a mathematical calculation.Rate this question:
-
- 46.
Excel Application: This button represents:
- A.
The AutoCorrect button
- B.
The AutoFormat button
- C.
The AutoSum button
- D.
The conditional format button
Correct Answer
C. The AutoSum buttonExplanation
This button in the Excel application represents the AutoSum button. The AutoSum button is used to automatically calculate the sum of selected cells in a column or row. It is a convenient tool for quickly adding up numbers without having to manually enter the formula.Rate this question:
-
- 47.
Excel Application: Why does the SUM function in B7 show zero?
- A.
Manual calculation is turned on and the cell has not been re-calculated.
- B.
Someone has keyed the number 0 into B7.
- C.
The function contains a circular reference.
- D.
The function is still being edited so hasn't calculated a result yet.
Correct Answer
C. The function contains a circular reference.Explanation
The SUM function in B7 shows zero because it contains a circular reference. A circular reference occurs when a formula refers back to the cell it is located in, creating an infinite loop. In this case, the SUM function in B7 is referring to itself, causing it to continuously calculate and result in zero.Rate this question:
-
- 48.
Peachtree Terminology: How many period let me modified Peachtree?
- A.
12
- B.
24
- C.
1
- D.
All you need to modified.
Correct Answer
B. 24 -
- 49.
Peachtree Terminology: To record a cash sale in Peachtree, the user selects the following:
- A.
Tasks/Maintain Customers/Prospects/Cash sales.
- B.
Tasks/Sales/Invoicing/Cash.
- C.
Tasks/Receipts/type transaction date in deposit ticket ID box/Apply to revenues/record cash sale.
- D.
None of the above.
Correct Answer
C. Tasks/Receipts/type transaction date in deposit ticket ID box/Apply to revenues/record cash sale.Explanation
The correct answer is "Tasks/Receipts/type transaction date in deposit ticket ID box/Apply to revenues/record cash sale" because in Peachtree, to record a cash sale, the user needs to go to the Tasks menu, then select Receipts. They should then type the transaction date in the deposit ticket ID box and apply it to revenues before recording the cash sale.Rate this question:
-
- 50.
Peachtree Terminology: Which of the following is an example of a non-financial transaction?
- A.
Sending a purchase order to a vendor to purchase items for re-sale.
- B.
Creating a cash receipt to mark receipt of a customer payment.
- C.
Preparing a payroll check to send to an employee in payment of the current month's wages.
- D.
Approving a vendor invoice for payment.
Correct Answer
A. Sending a purchase order to a vendor to purchase items for re-sale.Explanation
Sending a purchase order to a vendor to purchase items for re-sale is an example of a non-financial transaction because it involves the ordering of goods rather than the actual exchange of money. It is a request for the purchase of goods, indicating the quantity, description, and price of the items, but does not involve any financial transaction or payment.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 02, 2012Quiz Created by
Hlorenzo
Are You Really Ready for a Mid Life Career Change?
Are You Really Ready for a Mid Life Career Change?
Test Your Career Skills! Take The Xello Career Quiz Now!
Test Your Career Skills! Take The Xello Career Quiz Now!
- Academic Quizzes
- Adult Learning Quizzes
- Blended Learning Quizzes
- Coaching Quizzes
- College Quizzes
- Communication Quizzes
- Curriculum Quizzes
- Distance Learning Quizzes
- E Learning Quizzes
- Early Childhood Education Quizzes
- GCSE Quizzes
- Grade Quizzes
- Graduation Quizzes
- Kindergarten Quizzes
- Knowledge Quizzes
- Literacy Quizzes
- Online Assessment Quizzes
- Online Exam Quizzes
- Online Test Quizzes
- Physical Education Quizzes
- Qualification Quizzes
- Religious Education Quizzes
- School Quizzes
- Special Education Quizzes
- Student Quizzes
- Study Quizzes
- Subject Quizzes
- Teaching Quizzes
- Theory Quizzes
- Thesis Quizzes
- University Quizzes
Back to top