Business Solutions Support Technician Diagnostic Exam

1.

What is the difference bewteen a journal and a ledger?
- A.
  
  A journal holds the original entries and accounts for transactions which are then posted to the ledger.
- B.
  
  A ledger holds the original entries and accounts for transactions which are then posted to the journal.
- C.
  
  There is no difference, they are the same thing.
Correct Answer
A. A journal holds the original entries and accounts for transactions which are then posted to the ledger.

Explanation
A journal and a ledger are both important components of the accounting process. However, they serve different purposes. A journal is where the original entries for transactions are recorded. It provides a chronological record of all transactions. On the other hand, a ledger is a collection of accounts that summarize and organize the information from the journal. It contains individual accounts for each asset, liability, equity, revenue, and expense. The information recorded in the journal is then posted or transferred to the appropriate accounts in the ledger. Thus, the correct answer is that a journal holds the original entries and accounts for transactions which are then posted to the ledger.

Rate this question:
2.

In Excel, this is created by the intersection of a row and a column.
- A.
  
  Area
- B.
  
  Pane
- C.
  
  Chart
- D.
  
  Cell
Correct Answer
D. Cell

Explanation
A cell in Excel is created by the intersection of a row and a column. It is the smallest unit in a spreadsheet where data can be entered, calculated, and displayed. Cells can contain various types of data such as numbers, text, formulas, and functions. They are used to organize and manipulate data in a structured manner.

Rate this question:
3.

The helium- filled balloon rose in the air.
- A.
  
  Rose in the air.
- B.
  
  Was rising in the air.
- C.
  
  Was in the air.
- D.
  
  Rose into the air.
- E.
  
  Would rise in the air.
Correct Answer
D. Rose into the air.

Explanation
The correct answer is "rose into the air." This answer accurately describes the movement of the helium-filled balloon as it goes upward. The verb "rose" indicates a vertical movement, while "into the air" specifies the direction in which the balloon is rising.

Rate this question:
4.

What is SQL?
- A.
  
  SQL or Software Queue Load is a object-oriented computer language used to write web-based applications.
- B.
  
  SQL or Structured Query Language is a database computer language designed for managing data in relational database management systems.
- C.
  
  SQL or Supper Quality Level is what you use to evaluate your dinner.
Correct Answer
B. SQL or Structured Query Language is a database computer language designed for managing data in relational database management systems.

Explanation
SQL, or Structured Query Language, is a programming language specifically designed for managing and manipulating data in relational database management systems. It is used to create, retrieve, update, and delete data in databases. SQL allows users to define and manipulate the structure of a database, as well as perform various operations on the data stored within it. It is widely used in the field of database management and is essential for working with relational databases.

Rate this question:
5.

For public companies, what part of the Unadjusted Trial Balance is reported to ouside investors?
- A.
  
  The Income Statement
- B.
  
  The Balance Sheet
- C.
  
  The Statement of Owner's Equity
- D.
  
  None, this is an internal document only.
Correct Answer
A. The Income Statement

Explanation
The income statement is reported to outside investors for public companies. This statement shows the company's revenues, expenses, and net income or loss for a specific period. It provides information on the company's profitability and helps investors assess its financial performance. The balance sheet, on the other hand, provides a snapshot of the company's financial position at a specific point in time, while the statement of owner's equity shows the changes in the owner's equity during a specific period.

Rate this question:
6.

Which of the following bar is not available in MS-Word?
- A.
  
  Toolbar
- B.
  
  Formula Bar
- C.
  
  Status Bar
- D.
  
  Menu Bar
Correct Answer
B. Formula Bar

Explanation
The formula bar is not available in MS-Word. The formula bar is a feature found in spreadsheet programs like Microsoft Excel, where users can enter and edit formulas. In MS-Word, the formula bar is not included as it is not designed for creating or editing formulas. MS-Word is primarily used for word processing tasks such as creating documents, formatting text, and adding images.

Rate this question:
7.

If the books have been cataloged last week, why haven't they been placed on the shelf?
- A.
  
  Have been cataloged
- B.
  
  Would have been cataloged
- C.
  
  Was cataloged
- D.
  
  Were cataloged
- E.
  
  Had been cataloged
Correct Answer
D. Were cataloged

Explanation
The use of "were cataloged" in the answer suggests that the books were cataloged in the past but the action of placing them on the shelf has not been completed yet. This implies that there might be some delay or issue preventing the books from being placed on the shelf after they were cataloged last week.

Rate this question:
8.

What would the following query return?SELECT * FROM Sales_Order WHERE ordernum > 10000 and batchnumber like '%sales%'
- A.
  
  All sales orders whose order number is greater than 10,000 and batch number begins with 'sales'
- B.
  
  All sales orders whose order number is less than 10,000 and batch number contains the word 'sales'
- C.
  
  All sales orders whose order number is greater than 10,000 and batch number contains the word 'sales'
- D.
  
  What's a sales order?
Correct Answer
C. All sales orders whose order number is greater than 10,000 and batch number contains the word 'sales'

Explanation
The query would return all sales orders whose order number is greater than 10,000 and the batch number contains the word 'sales'.

Rate this question:

Business Solutions Support Technician Diagnostic Exam

What is the difference bewteen a journal and a ledger?

In Excel, this is created by the intersection of a row and a column.

The helium- filled balloon rose in the air.

What is SQL?

For public companies, what part of the Unadjusted Trial Balance is reported to ouside investors?

Which of the following bar is not available in MS-Word?

If the books have been cataloged last week, why haven't they been placed on the shelf?

What would the following query return?SELECT * FROM Sales_Order WHERE ordernum > 10000 and batchnumber like '%sales%'