Reply
Sun 29 Jun, 2008 12:42 am
good evening everybody, I am going to be tested on Monday for a new job as an Account Clerk II and this involves using formulas on excel. You must think I am very dumb, but I have not used formulas in years and forgot how they work. On the test, I have to enter currency on cells on Row A and put the formula on Row B to add the cells on Row A. PLEASE HELP ME!!!
1. select the answer cell enter the following
= sum (A1:A5) where A1:A5 are the cells required to be added
format the answer cell to currency (right click> format cell)
2. use the sigma function.