Q1 Election Commission of Malaysia (SPR) wants to develop a registration of voter’s program. To register as an elector, one must be a Malaysian citizen and be 21 years old and above. Firstly, the user need to key in IC number. If the IC number is not valid, the system will print “IC number is not valid" and quit from the system. If the IC number is valid, the system will then check the age of voters based on the year of birth from the IC number. If the age is 21 and above, the program will print a status as "Qualified". If not, the program will print "Disqualified".

Q1 Election Commission of Malaysia (SPR) wants to develop a registration of voter’s program. To register as an elector, one must be a Malaysian citizen and be 21 years old and above. Firstly, the user need to key in IC number. If the IC number is not valid, the system will print “IC number is not valid" and quit from the system. If the IC number is valid, the system will then check the age of voters based on the year of birth from the IC number. If the age is 21 and above, the program will print a status as "Qualified". If not, the program will print "Disqualified".

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 2.3CP

See similar textbooks

Similar questions

A customer calls a clerk at the insurance company and gives his policy number, and the system displays the basic insurance policy. The clerk then checks the information to make sure the premiums are current and the policy is in force. The customer gives the make, model, year, and vehicle identification number (VIN) of the car to be added. The clerk enters this information, and the system ensures that the given data is valid. Next, the customer selects the type of coverage desired and the amount of each. The clerk enters the information, and the system records it and validates the requested amount against the policy limits. After all the coverages have been entered, the system ensures the total coverage against all other ranges, including other cars on the policy. Finally the customer must identify all the drivers and the percentage of time they drive the car. If a new driver is to be added, then another use case – Add new driver – is invoked. At the end of the process, the system…
Write a script that declares a variable and sets it to the count of all products in the Products table. If the count is greater than or equal to 7, the script should display a message that says, “The number of products is greater than or equal to 7”. Otherwise, it should say, “The number of products is less than 7”.
Which scenarios would cause an error ?
An ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10- digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not. Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176 Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN. Note: When the check digit turns out…
From an ATM, a user may withdraw up to $500 every day. The service fee is 4% if a consumer withdraws more than $300. It alerts the customer of insufficient cash and offers to withdraw the funds for a $25 charge. If your account has a negative balance or is empty, you won't be able to withdraw money from the ATM. The ATM notifies the user of the maximum withdrawal amount and refuses the transaction if it exceeds $500. Create a withdrawal amount entry algorithm that clients may use. After checking the account balance, the algorithm debits the customer's account for the amount withdrawn plus any applicable service charges.
why below code is not working?
On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching dollar amount for each faculty member participating in the retirement plan. If the participating member is a Full Professor, the matching amount is 4% of the salary. Otherwise, the matching amount is 3% of the salary. If the member is not participating, show a blank.
Coronavirus disease (COVID-19) is an infectious disease caused by a newly discovered coronavirus. Most people who fall sick with COVID-19 will experience mild to moderate symptoms and recover without special treatment. Create a new program which will analyse Covid-19 case in Malaysia based on a state daily. The user must enter the state (such as Sabah) and number of districts of covid-19 reading. Every day, each district will only update the total of new cases two times. Daily cases are the total of report update daily. To record the data, the system is developing according to specification below: Read number of district, representing the size of array, Read the name of district. i. i. ii. Read total new cases in each update The report must include the following process: i. Calculate and view total cases daily for each district Find the average of new cases in that state. Calculate the frequency of new cases. iv. i. ii. Determine total new cluster based on this criterion below. green…
PS: Please answer number 3 to 5 altogether as they are both associated.
Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
Oracle language Display the employee’s name whose salary is within a range that is specified by theuser input as follows: