ACC216 PAST QUESTIONS

MCQS

1. What function in Excel calculates the sum of a range of numbers?

A. =TOTAL()

B. =SUM()

C. =ADD()

D. =PLUS()

Answer: B

2. Which of the following is a correct cell reference in Excel?

A. 1A

B. A-1

C. A1

D. RowA1

Answer: C

3. Which chart type is most suitable for showing the trend of sales over several
months?

A. Pie Chart

B. Bar Chart

C. Line Chart

D. Scatter Plot

Answer: C
4. The formula =AVERAGE(B2:B10) is used to:

A. Add B2 and B10

B. Multiply B2 by B10

C. Find the sum of B2 to B10

D. Find the mean of values from B2 to B10

Answer: D

5. What feature in Excel allows you to highlight cells that meet certain criteria?

A. AutoFormat

B. Conditional Formatting

C. Data Validation

D. Sorting

Answer: B

6. In Excel, what does =IF(A1>100,”Yes”,”No”) mean?

A. Checks if A1 equals 100

B. Returns Yes if A1 is greater than 100

C. Adds A1 and 100

D. Changes A1 to Yes if it’s 100

Answer: B
7. What is the shortcut to copy a selected cell in Excel?

A. Ctrl + V

B. Ctrl + C

C. Ctrl + X

D. Ctrl + P

Answer: B

8. The function =MAX(A1:A10) will return:

A. The minimum number in the range

B. The sum of the numbers

C. The average of the range

D. The largest number in the range

Answer: D

9. Which Excel tool is used for summarizing large data sets quickly?

A. Data Validation

B. Chart Tool

C. Pivot Table

D. Goal Seek

Answer: C
10. To count all non-empty cells in Excel, you use:

A. =COUNT()

B. =COUNTA()

C. =COUNTIF()

D. =COUNTBLANK()

Answer: B

11. Which Excel feature helps remove repeated entries in a column?

A. Data Sort

B. AutoSum

C. Remove Duplicates

D. Data Form

Answer: C

12. What is the purpose of the VLOOKUP function in Excel?

A. To find vertical data in a column

B. To sum multiple rows

C. To validate numeric entries

D. To transpose data

Answer: A
13. What will =ROUND(25.678,1) return?

A. 25.7

B. 25.68

C. 25.6

D. 26

Answer: A

14. What does the $ symbol indicate in a cell reference like $B$2?

A. Currency formatting

B. Relative reference

C. Absolute reference

D. Text reference

Answer: C

15. Which of the following is a valid Excel error message?

A. #NOTFOUND

B. #VALUE!

C. #EMPTY

D. #ERROR!

Answer: B
16. What function counts only numeric values in Excel?

A. =COUNT()

B. =COUNTA()

C. =COUNTBLANK()

D. =COUNTNUM()

Answer: A

17. The “Freeze Panes” feature in Excel is used to:

A. Hide rows

B. Protect worksheets

C. Keep headers visible while scrolling

D. Lock formulas

Answer: C

18. Which Excel function returns the smallest value in a range?

A. =MIN()

B. =SMALL()

C. =LOW()

D. =LEAST()

Answer: A
19. What is the shortcut for inserting a new worksheet in Excel?

A. Shift + F11

B. Ctrl + F11

C. Alt + N

D. Ctrl + W

Answer: A

20. What does =TRIM(A1) do in Excel?

A. Cuts the value

B. Removes decimals

C. Removes extra spaces from text

D. Hides the cell

Answer: C

Perfect! Here’s the next set of 20 multiple-choice questions, starting from Question
21 to 40, based on the topic:

“Cloud Accounting Software and ERP Systems” under ACC 216: Accounting
Laboratory I.

21. Which of the following is a cloud-based accounting software?

A. Tally ERP 9

B. Microsoft Excel
C. QuickBooks Online

D. Peachtree Classic

Answer: C

22. What is the main benefit of cloud accounting software over traditional desktop
software?

A. Requires no internet connection

B. Can only be accessed from one location

C. Accessible from anywhere with internet

D. It’s completely offline

Answer: C

23. Which of the following is an example of an ERP software?

A. Canva

B. SAP

C. Zoom

D. Dropbox

Answer: B

24. In QuickBooks, which feature helps to match transactions with your bank
statement?

A. Chart of Accounts
B. Bank Reconciliation

C. Trial Balance

D. Expense Tracker

Answer: B

25. What does ERP stand for?

A. Easy Revenue Processing

B. Electronic Report Program

C. Enterprise Resource Planning

D. External Resource Portal

Answer: C

26. One major advantage of ERP systems is:

A. Increased paper usage

B. Redundant data entry

C. Centralized data management

D. Lack of integration

Answer: C

27. Which accounting function is NOT commonly automated in ERP systems?

A. Ledger posting
B. Bank deposit

C. Journal entry

D. Forecasting

Answer: B

28. The process of giving user-specific access in cloud accounting software is

A. Cloud backup

B. Multi-user permission

C. Journal setup

D. Batch control

Answer: B

29. Which of the following is a Nigerian cloud-based accounting software?

A. Wave

B. QuickBooks

C. SAGE

D. KashFlow

Answer: D (Trick question; in Nigeria, some local solutions include options like
“Kippa” or “Accounteer”)

(You can update this based on your lecturer’s preference)

A. Internet security

B. Electricity supply

C. High printing cost

D. USB drive failure

Answer: A

31. The “Dashboard” in QuickBooks is used to:

A. Record expenses only

B. Display financial summaries

C. Enter journal entries

D. Print payroll slips

Answer: B

32. The “Chart of Accounts” in an accounting system is used to:

A. Plot graphs

B. List all transactions

C. Categorize accounts for reporting

D. Add sales receipts

Answer: C
33. Which ERP module handles product stock tracking?

A. Payroll

B. General Ledger

C. Inventory Management

D. Fixed Asset

Answer: C

34. In cloud accounting, backup of data is typically:

A. Manual

B. Not available

C. Automated and stored online

D. Saved on a CD

Answer: C

35. Which of these can be generated automatically in most cloud accounting tools?

A. Electricity bill

B. Salary scale

C. Trial balance

D. Lecture schedule

Answer: C
36. What is the full meaning of SaaS, often related to cloud tools?

A. Software and Advanced Access System

B. Software as a Solution

C. Software as a Service

D. System as a Software

Answer: C

37. Which of the following is used for audit trails in ERP systems?

A. Chart Wizard

B. AutoSum

C. Transaction Log

D. Pay Schedule

Answer: C

38. What role does a “user role” setting play in ERP systems?

A. Assigns salaries

B. Manages backups

C. Controls access and permissions

D. Changes templates

Answer: C
39. What is the purpose of an “Invoice” in cloud accounting software?

A. To create a tax return

B. To record income received

C. To bill a customer for a service or product

D. To post journal entries

Answer: C

40. Which feature of cloud accounting allows real-time collaboration?

A. Export to PDF

B. Offline mode

C. Multi-user access

D. Password reset

Answer: C

41. Which of the following is an audit software used for computerized auditing?

A. Tally

B. IDEA

C. Zoom

D. Canva

Answer: B

42. What is the primary purpose of using audit software?

B. Editing documents

C. Analyzing financial data for inconsistencies

D. Creating invoices

Answer: C

43. Which audit software helps in detecting fraud and anomalies in accounting
records?

A. Peachtree

B. QuickBooks

C. CaseWare

D. Excel

Answer: C

44. What feature in audit software is used to track the history of every transaction?

A. Time-stamping

B. Audit trail

C. Ledger control

D. Forecast log

Answer: B

45. One benefit of using financial reporting tools is:

B. Instant report generation

C. Handwritten journals

D. Data duplication

Answer: B

46. What software is commonly used for creating financial reports and
dashboards?

A. PowerPoint

B. Excel

C. Paint

D. WordPad

Answer: B

47. Which tool is best for team collaboration in accounting projects?

A. Notepad

B. WhatsApp

C. Microsoft Teams

D. Calculator

Answer: C
48. What is the role of the “Comment” feature in Google Sheets during accounting
reviews?

A. Deletes the row

B. Adds VAT

C. Provides feedback on a specific cell

D. Calculates net profit

Answer: C

49. Which of the following is NOT a productivity tool used in accounting?

A. Slack

B. Zoom

C. Canva

D. Tally ERP

Answer: C

50. The use of Google Drive in accounting labs is mainly for:

A. Playing music

B. Storing financial documents

C. Creating animations

D. Converting files to MP4

Answer: B
51. Which Microsoft Office tool is most useful for writing audit reports?

A. PowerPoint

B. Excel

C. Word

D. Access

Answer: C

52. Which of these is most appropriate for scheduling audit tasks?

A. YouTube

B. Trello

C. Google Maps

D. Paint

Answer: B

53. One key feature of audit software is:

A. Graphic design

B. Voice calling

C. Exception reporting

D. Budget advertising

Answer: C
54. Which shortcut is commonly used to print a report in most software?

A. Ctrl + P

B. Alt + R

C. Ctrl + D

D. Ctrl + B

Answer: A

55. In financial analysis, dashboards are used to:

A. Decorate the screen

B. Show real-time performance indicators

C. Encrypt passwords

D. Store bank details

Answer: B

56. What does “cloud backup” in accounting software protect against?

A. Theft only

B. Internet disconnection

C. Data loss

D. Account balance error

Answer: C
57. Which app allows accountants to conduct virtual meetings and share reports?

A. IDEA

B. Microsoft Teams

C. Peachtree

D. LedgerLink

Answer: B

58. Why is password protection important in accounting tools?

A. To limit internet access

B. To decorate files

C. To secure financial data

D. To increase file size

Answer: C

59. What is one common use of Microsoft Excel in accounting labs?

A. Typing essays

B. Designing logos

C. Recording and analyzing transactions

D. Watching movies

Answer: C
60. In audit software, the term “sampling” means:

A. Choosing random transactions for testing

B. Counting assets

C. Forecasting future income

D. Duplicating data entries

Answer: A

Complied by ; EBONY (F.M.S)