![]() ![]() =(C11+D11)-B7ġ4 Minimum JOINERY PAY ITEM WAGE FOR 6 DAYS Adam 660 Patrick 450 Caleb 520 Ian 420 Minimum wage =minimum(B3:B6) Maximum wage Average wage Insert the formula manually for minimum - this will work out the minimum price in the column.ġ5 Maximum JOINERY PAY ITEM WAGE FOR 6 DAYS Adam 660 Patrick 450 Caleb 520 Ian 420 Minimum wage Maximum wage = maximum(B3:B6) Average wage Insert the formula manually for maximum - this will work out the maximum price in the column.ġ6 Average JOINERY PAY ITEM WAGE FOR 6 DAYS Adam 660 Patrick 450 Caleb 520 Ian 420 Minimum wage Maximum wage Average wage =AVERAGE(B3:B6) Insert the formula manually for average - this will work out the average price in the column. This is significantly more than the other options provided, which are 65,536, 64,000, and 256. With Excel, you can use built-in functions to quickly and easily perform common tasks. The correct answer is 'Over 1 million' because Excel 2007 supports a maximum of 1,048,576 rows on a single worksheet. ![]() It can be programmed to access external databases and is an excellent tool for data modeling, statistics, and financial calculations. ![]() Merge and centre L2 - Wrap (Alt + Enter) Currency Decimal Places Autosum Orientation (portrait and landscape) Alignment – left, centre and rightġ3 L2 Rule Any formula with brackets – the formula within the brackets are calculated first. Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more. Hammer £32.50 £6.50 Screwdriver £12.25 £2.45 Tool Bag £35.99 £7.20ġ0 Minus JOINERY EQUIPMENT ITEM PRICE DISCOUNT PRICE LESS DISCOUNT Boots It can handle all the financial applications for a large business or sort out your weekly budget It is really a glorified calculator – but a pretty amazing one at that!ģ Open Microsoft Excel Start All Programs Microsoft Office 2013Ĥ Cell references 1 = B3 C5 = active cellĥ + - * / Formula Symbols =B3+C4 All formulas begin with = (Add) (Minus)Ħ Parts of a spreadsheet Many cells are called a RANGE of cellsĨ Multiply JOINERY PAY NAME Per Hour Pay for 8 hours Adam £7.25 Patrickĩ Add JOINERY EQUIPMENT ITEM PRICE VAT TOTAL PLUS VAT Boots £26.99 £5.40 2 What is a Spreadsheet? A spreadsheet is a piece of software which is used to work out calculations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |