3. 5.428571429 [=average(c4:I4)] 4. 14 hours [ ($16000/52)/$22 ] 5. $836.00 [ =((J4*K4)*c10 ] 6. $13,247.97 [=IF(N5>16000,N5*64%*98%,N5)]
Archive for the ‘Spreadsheet’ Category
spreadsheet [answers]
October 28, 2007Spreadsheet
October 28, 2007Spreadsheets are used in business manipulate data such as numbers to produce information NB: in the HSC you need to talk about Software application using Spreadsheets Database Desktop Publishing Word processing Other software is generally called either operating system or utility software These application are characterised by the use of columns and rows to hold [...]
Spreadsheet application in business
October 28, 2007Spreadsheet application in business Common uses for spreadsheets Payslips Invoices Operator There are three types of operators in most spreadsheets 1. Arithmetic operators – mathematical operations on numbers – add, minus, multiply etc. 2. Comparisons – compare TWO things BINARY VALUE (RESULT) – 0 or 1 – yes or no eg. A1>B1 3. Text operator – [...]
