Accounting Information Systems Quiz

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary function of the input subsystem in a computerized accounting system?

  • To collect, arrange, and make available various types of data (correct)
  • To ensure compliance with internal laws and rules
  • To process information using application software
  • To produce reports in a user-understandable format

Which component of the accounting information system is responsible for maintaining accounts payable and inventory information?

  • Purchasing and inventory management module (correct)
  • Production module
  • Human resources module
  • Sales module

How does the control component of an Accounting Information System ensure quality of information?

  • By preparing payroll information
  • By directly processing sales orders
  • By automating data collection
  • By comparing actual performance with set standards (correct)

Which of the following components tracks costs throughout the manufacturing process?

<p>Production module (A)</p> Signup and view all the answers

What type of data does the sales module primarily manage?

<p>Accounts receivable information (B)</p> Signup and view all the answers

What role does the output subsystem play in a computerized accounting system?

<p>It generates reports in a format understandable to users (B)</p> Signup and view all the answers

What best describes malware?

<p>Unwanted software installed without consent (C)</p> Signup and view all the answers

What does the control component of an accounting information system NOT ensure?

<p>Processing of sales orders (D)</p> Signup and view all the answers

Which statement accurately characterizes a Trojan horse?

<p>It disguises itself as legitimate software to steal information (D)</p> Signup and view all the answers

What is the primary risk associated with social engineering?

<p>Tricking individuals into giving out sensitive information (D)</p> Signup and view all the answers

Which purpose is NOT typically associated with an Accounting Information System?

<p>Personal finance management (C)</p> Signup and view all the answers

When does a logic bomb typically execute?

<p>Upon reaching a specific time or triggered event (B)</p> Signup and view all the answers

What distinguishes worms from viruses?

<p>Worms can self-replicate without a host file (D)</p> Signup and view all the answers

Which type of malware attaches itself to legitimate programs?

<p>Trojan horse (B)</p> Signup and view all the answers

In what manner do viruses infect files?

<p>Through user interaction with infected programs (A)</p> Signup and view all the answers

What type of malware is known for spamming advertisements?

<p>Adware (A)</p> Signup and view all the answers

What does the NPER function determine?

<p>The number of payments required for an investment to grow (D)</p> Signup and view all the answers

Which statement is true regarding simple interest?

<p>It is calculated on the initial principal only. (B)</p> Signup and view all the answers

What is the main characteristic of a typical loan structured as an annuity?

<p>A fixed amount paid every period (C)</p> Signup and view all the answers

If $2,000 is invested at a 10% interest rate compounded annually for 8 years, what will be the final balance?

<p>$4,287 (C)</p> Signup and view all the answers

How often is interest applied in the case of compound interest?

<p>Periodically, according to the compounding schedule (D)</p> Signup and view all the answers

What is a primary feature of the RATE function?

<p>It determines the effective interest rate per period. (B)</p> Signup and view all the answers

In a scenario where $2,000 is borrowed at a 12% annual interest rate compounded monthly for 6 months, what would be a likely outcome for monthly payments?

<p>Payments would be over $400 (C)</p> Signup and view all the answers

What tool can be used to enter function arguments for financial calculations?

<p>Insert Function dialog box (C)</p> Signup and view all the answers

What does the formula B4/F4 translate to when sitting in cell B5?

<p>Divide the value in the cell above by the value four columns to the right. (C)</p> Signup and view all the answers

What is the purpose of making a reference to cell F4 an absolute reference?

<p>To ensure the formula always refers to the same cell, regardless of where it is copied. (B)</p> Signup and view all the answers

Which key should be pressed to convert a relative reference to an absolute reference in Excel?

<p>F4 (C)</p> Signup and view all the answers

What happens when you press the F4 key multiple times while setting an absolute reference?

<p>It alternates between absolute column, absolute row, and both as absolute references. (C)</p> Signup and view all the answers

What will be the result of copying a formula that references $F$4?

<p>The copied formulas will refer correctly to $F$4. (C)</p> Signup and view all the answers

Why did Excel use the $ symbol to indicate absolute references?

<p>Due to limitations of early keyboard designs. (C)</p> Signup and view all the answers

If you are in B5 and need to copy a formula while maintaining a reference to F4 without changing it, what must you do?

<p>Make the reference to F4 an absolute reference. (B)</p> Signup and view all the answers

What can you expect after correctly using the F4 key to set an absolute reference while building a formula?

<p>All copied versions will accurately refer to the original absolute reference. (B)</p> Signup and view all the answers

What is the total amount of interest paid after the first month of payments?

<p>$20.00 (B)</p> Signup and view all the answers

How much is the new balance after the third payment?

<p>$1,014.92 (B)</p> Signup and view all the answers

What does the PMT function calculate?

<p>The periodic payment for an annuity or loan (D)</p> Signup and view all the answers

What is the present value of receiving $200 per month for 3 years at 12% annual interest compounded monthly?

<p>$6021.50 (A)</p> Signup and view all the answers

What would be the future value if you deposit $1,000 today at an annual interest rate of 10% for 3 years with no additional payments?

<p>$1,331.00 (C)</p> Signup and view all the answers

If Ms. JustRetired is looking to withdraw equally each year from her $200,000 investment to have $100,000 left after 5 years, how much can she withdraw annually?

<p>$36,380 (D)</p> Signup and view all the answers

In the repayment schedule, what is the old balance after the fourth payment?

<p>$1,014.92 (D)</p> Signup and view all the answers

What does the type argument in PMT and PV functions indicate?

<p>The timing of the payment (beginning or end of period) (B)</p> Signup and view all the answers

How much will you have after 3 years if you make monthly payments of $200 into an account with a 12% annual interest rate compounded monthly?

<p>$8,615.38 (A)</p> Signup and view all the answers

What is the purpose of the NPER function in investment calculations?

<p>To return the number of periods for an investment (B)</p> Signup and view all the answers

If you invest $1,000 initially and contribute $100 monthly, what will the effective interest rate be if the final value after 10 years is $17,175.24?

<p>6% (D)</p> Signup and view all the answers

What is the correct formula to calculate the difference in days between two dates in Excel?

<p>=L6 - F5 (B)</p> Signup and view all the answers

What will the TODAY function in Excel display?

<p>The current date only (B)</p> Signup and view all the answers

Using the FV function, how much will you have after making monthly payments of $100 for 10 years into an account with a 5% annual interest rate compounded monthly, starting with an initial deposit of $1,000?

<p>$17,175.24 (C)</p> Signup and view all the answers

Which of the following formulas is used to convert a date into a serial number in Excel?

<p>=DATE(year_number, month_number, day_number) (C)</p> Signup and view all the answers

If you need to find out how many years it will take to save $8,615.38 by saving $200 a month at a 12% annual interest rate compounded monthly, which function should you use?

<p>NPER (D)</p> Signup and view all the answers

Flashcards

Social Engineering

A type of cybercrime where hackers try to trick you into giving them your personal information, like passwords or credit card details.

Malware

Any unwanted software installed on your computer without your permission, often with malicious intent.

Computer Virus

A type of malware that spreads by infecting other files or programs on your computer, replicating itself like a biological virus.

Worm

Malware that doesn't need user interaction to spread, it can travel across networks and infect computers without any help.

Signup and view all the flashcards

Trojan Horse

A program disguised as a legitimate one, but it actually steals your information or harms your computer.

Signup and view all the flashcards

Logic Bomb

A type of malware that waits for specific conditions to be met before executing its harmful actions, like a bomb going off.

Signup and view all the flashcards

Ransomware

A type of malware that encrypts your files and demands a ransom from you to unlock them.

Signup and view all the flashcards

Adware

A type of malware that tracks your online activity and displays advertisements without your permission.

Signup and view all the flashcards

Input Subsystem

Collection, arrangement, and making available of transactional, financial, and accounting data for system use.

Signup and view all the flashcards

Processing

Processing information from the input subsystem using software and possibly the internet.

Signup and view all the flashcards

Output Subsystem

Presenting processed data in a user-friendly format, often reports or charts.

Signup and view all the flashcards

Control

Ensuring the accounting information system (AIS) complies with internal rules, government regulations, and maintains data quality and security.

Signup and view all the flashcards

Sales Module

A module within an accounting information system that processes customer orders, manages accounts receivable, and tracks sales.

Signup and view all the flashcards

Purchasing & Inventory Management

This module manages all aspects of purchasing and inventory, including accounts payable and stock maintenance.

Signup and view all the flashcards

Human Resources Module

This module focuses on human resources data, such as employee details, payroll, and tax information.

Signup and view all the flashcards

Production Module

This module tracks the flow of costs during the manufacturing process, from raw materials to finished goods.

Signup and view all the flashcards

Relative Reference

A formula in Excel that calculates a value based on the cell's current location.

Signup and view all the flashcards

Absolute Reference

A formula in Excel that calculates a value based on a fixed cell location, regardless of where the formula is copied.

Signup and view all the flashcards

Absolute Cell Reference Syntax

A reference to a cell in Excel using the $ symbol before the column and row letters, e.g., $A$1.

Signup and view all the flashcards

Division Formula in Excel

A formula that divides the value in one cell by the value in another cell, defined by a relative or absolute reference.

Signup and view all the flashcards

F4 Key Function in Excel

The F4 key in Excel toggles between different reference types (relative, absolute, mixed).

Signup and view all the flashcards

Copying Formulas in Excel

Copying a formula to other cells in Excel, preserving references.

Signup and view all the flashcards

Formula Copying with References

The process of ensuring that a formula references the correct cells, even after copying it to other locations.

Signup and view all the flashcards

Name Box in Excel

The box in Excel that shows the current cell's address.

Signup and view all the flashcards

NPER Function

A financial function used to calculate the number of payments needed for an investment to grow or pay back a loan.

Signup and view all the flashcards

Annual Percentage Rate (APR)

The interest rate charged on a loan or investment, expressed as a percentage per year.

Signup and view all the flashcards

RATE Function

A financial function that calculates the effective interest rate of an investment or loan.

Signup and view all the flashcards

Principal

The total amount of money borrowed or invested at the start of a loan or investment period.

Signup and view all the flashcards

Number of Periods (nper)

The number of periods, usually months or years, over which a loan or investment is paid back or compounded.

Signup and view all the flashcards

Annuity

A series of equal payments made over a period of time, often used for loans and investments.

Signup and view all the flashcards

Simple Interest

Interest is only calculated on the initial principal amount, not on accumulated interest.

Signup and view all the flashcards

Payment (pmt)

The regular, fixed payment made on a loan or investment each period.

Signup and view all the flashcards

Compound Interest

Interest is calculated on both the principal amount and the accumulated interest, leading to exponential growth.

Signup and view all the flashcards

Balance

The total amount of money you owe on a loan or investment at a given point in time.

Signup and view all the flashcards

Compounding Frequency

The number of times interest is calculated and added to the principal amount within a year.

Signup and view all the flashcards

Interest (int)

The interest earned on a loan or investment over a single period, calculated on the outstanding balance.

Signup and view all the flashcards

Principal

The initial amount of money invested or borrowed.

Signup and view all the flashcards

Future Value (fv)

The total amount of money a loan or investment will be worth at the end of the repayment or compounding period.

Signup and view all the flashcards

Interest Rate

The percentage charged or earned on the principal amount, typically expressed as an annual percentage rate (APR).

Signup and view all the flashcards

Present Value (pv)

The present value of a series of future payments, meaning the amount of money those payments are worth today.

Signup and view all the flashcards

FV Function

A function in Excel that calculates the future value of an investment, based on a constant interest rate, periodic payments, and a starting principal amount.

Signup and view all the flashcards

TODAY Function

The TODAY function returns the current date and time.

Signup and view all the flashcards

Study Notes

Cybercrime Prevention Act of the Philippines

  • The act, also known as computer crime, uses a computer to further illegal activities
  • Examples include: fraud, child pornography, intellectual property theft, identity theft, and violation of privacy.

Difference Between Traditional and Cybercrime

  • The key difference is the use of a computer in committing traditional crimes
  • Cybercrime primarily targets the information of individuals, governments, or corporations.

Republic Act No. 10175 (Cybercrime Prevention Act of 2012)

  • Introduced by the Philippines government to combat cybercrime
  • Signed by President Benigno Aquino on September 12, 2012
  • Aimed to penalize acts like cybersex, child pornography, and identity theft.

Illegal Access

  • Gaining unauthorized access to a computer or application.

Illegal Interception

  • Intercepting non-public computer data transmissions without permission.

Data Interference

  • Unauthorized modification, destruction, or deletion of computer data or electronic messages. This includes spreading viruses.

System Interference

  • Interfering with a computer's or network's operation by introducing or spreading viruses, deleting, modifying, deleting or suppressing data and programs. This can apply even if technically authorized, but the actions exceed the agreed scope.

Misuse of Devices

  • Unauthorized use, possession, production, sale, procurement, or importation of gadgets, computer programs, or materials meant to commit crimes listed in Republic Act 10175.
  • Also includes unauthorized use of passwords, access codes, or similar data for malicious use.

Cybersquatting

  • Acquiring domain names in bad faith to profit, deceive, and harm the reputation of others, especially those with trademarks already registered.
  • Unauthorized input, alteration, or deletion of computer data to make it appear authentic, regardless if the data is immediately readable.
  • Unauthorized access, alteration, or deletion of computer data or programs, or disrupting a computer system with the goal of causing harm.
  • Unauthorized acquisition, use, transfer, possession, change, or deletion of a person's identifying information.

Cybersex

  • Engaging in lascivious presentations or sexual activity via a computer system with compensation or consideration.

Child Pornography

  • Unlawful or restricted actions conducted via a computer system.

Libel

  • Defamation of character. Also, covered by the Revised Penal Code if conducted through computer systems or other similar means.

Aiding or Abetting in Cybercrime

  • Anyone assisting in any listed cybercrime is also held accountable.

Attempting Cybercrime

  • Attempting to commit any listed cybercrime is considered a crime.

Final Examination Dates

  • December 2nd to 7th

Other Important Events

  • December 9th - 10th: BSIT Christmas Party
  • December 11, 2024: 12:00PM Exchange Gift, Raffle, Games
  • December 12th - January 6th: Sem Break

Importance of Cyber Security

  • Attackers can operate from anywhere globally
  • Risks include: identity theft, financial losses, legal ramifications, and job/account termination

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

More Like This

Use Quizgecko on...
Browser
Browser