Advanced level 2025 South West mock financial accounting 1
Advanced level 2025 South West mock financial accounting 1
There are two views when working in a table.
One of the views is
A Spread sheet view
B Database view
C Date sheet view
D Datasheet view
45. The function =Average(B2:BlO)is used to.
A Calculate average for cell B2 and Cell ft in
B Calculate average from cell B2 to cel Bio
C Calculate average for cell B.2 to Cel R m
D Calculate averageTor cell B^dciu^o
To view journal entries, we click on
A List of records
Account consultation
C Record consultation
D Enter operations
477 The unique identifier for each record in a table
A Auto number
B Primary Key
C Primary number
D Identifier number
46.
B
is
487 This data type allows alphanumeric characters
and special symbols
A Auto number
B Text
C Alpha
D Memo
49. From the spider menu to the consultation of the
balance of the current year of a new site, the
following steps are needed
A Accounting, balance sheet, current year,
choose your site, validate and yes
B Accounting, Choose your site, balance
sheet, current year, validate and yes
C Accounting, balance sheet, choose your
site, validate and yes
D Accounting, balance sheet, choose your
site, current year, validate and yes
*
50. Given an extract below
B C D E
4
Which of the following is the correct function
to sum the cells
A =Sum (B4:E4)
B =Sum(B4:E4)
C =B4 + C4 + D4 + E4
D –A4 + B4 + C4 + D4 + E4
. The correct effects of the owner of a business
| 36. (liven an ex 4 I i |
__ |
| C D E |
| paying capital 1ijto the bank is A Increase assets ‘“»d decrease cash |
B |
B Increase assets and decnroJT capital
C Increase asset and increase capital
assets and increase capital
Which of the following is the correct formula
to sufii?
A =Sum(A4:E4)
B *sSum(B4:E4)
C =B4 + C4+ D4 + E4
D =A4 + B4 + D4 + E4
Which of the following is a database
A Microsoft Words
B IPLANS ERP
C Microsoft Excel
D Microsoft Access
38. To create a basic file in stock management
using IPLANS ERP we first click on
A CLIENT
B Article
C Exploitation
D Spider menu
39. In order to sort data according to logic, we use
A SUM function
B IF function
C Count function
D Financial functions
D Decrease
30. Opening cash credit balance is 50,000, Cash
sales of goods- 720,000, Credit sales of goods
= 250,000, credit purchases of goods = 180,000,
cash purchases of goods = 360,000, received
from customers by cash = 120,000. Calculate
the cash balance.
A 840,000 Debit
B 430,000 Debit
C 500,000 Debit
D 500,000 Credit
37 .
31. Financial statement that summarises the
financial position of an organisation at a point in
time is
A Balance sheet
B Cash flow statement
C Trial balance
D Profit and loss statement
32. In order to check that there is a matching credit
entry for every debit entry, we prepare
A Balance sheet
B Cash flow statement
C Trial balance
D Profit and loss statement 40. The correct expression to type full name given
first name and last name is Full Name:
A [first name]&” “&[last name]
B [fust name)&” “&(la$t name]
C (fust name]&” “&[last name)
D [fust name]&” &”[last name]
33. Which of the following is a liability
A Equipment
B Suppliers
C Cash at Bank
D Depreciations 41. To create a salary tab using IPLANS ERP we
use the following steps
A HRM-Salary tab-Select site-New
B HRM-Selcct site-New-Salary tab
C HRM-New-Select site-Salary tab
D HRM-Salary tab-New-Sclect site
34. Given that sales of goods * 2,450,000, opening
stocks ** 150,000, depreciations “ 320,000,
purchases of goods =* 1,650,000, closing stocks
«267,000 and telephone expenses * 55,000.
Calculate the gross profit.
42. The correct function to calculate straightli
depreciation annuity inMsExcel is
A =SLN(price,salvage,life)
BCD == =SLN SLN SLN(((salvage price price,,life salvage ,life ,salvage ,price ,life )))
43. Whichof these windowsis used t
payslip?
A Accounting
BC Human PAY resource management
D Company
me
A 542,000
B 800
,000
C 478,000
D 917,000
35. Which of these books of accounts can be
classified as a subsidiary book as well as a
ledger
A The cash book
B The sales day book
C The trial balance
D The general ledger
END.
GO BACK AND CHECK YOUR WORK.
