ASSESSMENTS

Question 1

Choose the least effective step in ensuring the accuracy and completeness of data captured by the system:

a. The use of point-of-sale (POS) scanners

b. implementing a system that uses prenumbered source documents

c. manually encoding original and authentic source documents

d. use of machine-readable forms to processing input records

Answer 1

c. manually encoding original and authentic source documents

Question 2

The following are examples of source documents in a disbursement cycle, except:

a. purchase requisition
b. delivery ticket
c. check
d. ADA/Electronic Fund Transfer

Answer 2

b. delivery ticket

Question 3

The following are examples of source documents in a revenue cycle, except:

a. bill of lading
b. receiving report
c. remittance advice
d. credit memo

Answer 3

b. receiving report

Question 4

All of the following are characteristics of data processing cycle, except:

a. cyclical in nature
b. data storage quality
c. sequential flow
d. speed and efficiency

Answer 4

b. data storage quality

Question 5

All of the following are examples of source documents except:

a. bank statement
b. payroll time sheet
c. payment confirmation
d. invoice

Answer 5

idk

Question 6

A manager wants to classify each transaction according to a certain criterion, the correct excel function to use would be

a. IF
b. SUM
c. COUNTIF
d. SUMIF

Answer 6

a. IF

Question 7

A manager wants to determine the total number of sales for the month of August 2023, the correct excel function to use would be

a. IF
b. SUM
c. COUNTIF
d. SUMIF

Answer 7

b. SUM

Question 8

A manager wants to determine the number of total purchase amount for the month of August 2023 from Supplier A, the correct excel function to use would be

a. IF
b. SUM
c. COUNTIF
d. SUMIF

Answer 8

d. SUMIF

Question 9

A manager wants to determine the number of occurrences of sale transaction with Customer A for a certain period, the correct excel function to use would be

a. IF
b. SUM
c. COUNTIF
d. SUMIF

Answer 9

c. COUNTIF

Question 10

Which of the following contains the correct code for countif

a. COUNTIF(range, criteria, sum_range)
b. COUNTIF(sum_range, criteria, range)
c. COUNTIF(range, criteria)
d. COUNTIF(criteria, range)

Answer 10

c. COUNTIF(range, criteria)

Question 11

=COUNTIF

a. (value1, [value2], …)
b. (range, criteria)
c. (logical_test, [value_if_tru], [value_if_false])
d. (range, criteria, [sum_range])

Answer 11

b. (range, criteria)

Question 12

=SUMIF

a. (value1, [value2], …)
b. (range, criteria)
c. (logical_test, [value_if_tru], [value_if_false])
d. (range, criteria, [sum_range])

Answer 12

d. (range, criteria, [sum_range])

Question 13

=IF

a. (value1, [value2], …)
b. (range, criteria)
c. (logical_test, [value_if_tru], [value_if_false])
d. (range, criteria, [sum_range])

Answer 13

c. (logical_test, [value_if_tru], [value_if_false])

Question 14

=SUM

a. (number1, [number2], …)
b. (criteria_range1, criteria1, …)
c. (sum_range, criteria_range1, criteria1, …)
d. (value1, [value2], …)

Answer 14

a. (number1, [number2], …)

Question 15

=SUMIFS

a. (number1, [number2], …)
b. (criteria_range1, criteria1, …)
c. (sum_range, criteria_range1, criteria1, …)
d. (value1, [value2], …)

Answer 15

c. (sum_range, criteria_range1, criteria1, …)

Question 16

=COUNTIFS

a. (number1, [number2], …)
b. (criteria_range1, criteria1, …)
c. (sum_range, criteria_range1, criteria1, …)
d. (value1, [value2], …)

Answer 16

b. (criteria_range1, criteria1, …)