TUGAS TIP MS EXCEL
0 likes136 views
This document contains rental fee calculations for items using cell references and formulas in Excel. It lists the rent fee formula of cell I8 multiplied by H8, the discount formula of 10% of J8 if item is national and rental time is less than or equal to 1, and the penalty fee formula of I8 if rental time is greater than 1. It concludes with the total payment formula of J8 minus discount plus penalty fee.
1 of 2
Download to read offline
Recommended
Certificate[4]![Certificate[4]](https://cdn.slidesharecdn.com/ss_thumbnails/e1ce90a2-3522-4789-8488-99dd73291ace-150812060528-lva1-app6891-thumbnail.jpg?width=560&fit=bounds)
Certificate[4]Shailendra Rawat
油
Shailendra Singh completed a web-based training course on February 10, 2014 called "Zero Harm Culture @ Energy for Employees" according to a Certificate of Participation. The training covered the importance of a zero harm culture at Energy, the principles of a zero harm culture, and how to personally contribute to working safely and creating a safer work environment. The certificate was confirmed by Siemens' Global Learning Campus and Energy EHS Officer.Construction firm sentenced over 'life changing' fall
Construction firm sentenced over 'life changing' fallnwroffingcompany
油
A Construction company has been sentenced after pleading guilty to safety failings after a 55 year o...manufacturer&lab
manufacturer&labTom Feng
油
Jiangsu Inter-China Group Corporation is located at Room 704-723, 2nd Building, Nanshanhuating Business Center, No.1 Zhuangquan Road, Zhenjiang, Jiangsu, China. Their phone number is 86-511-84416352 and their fax number is 86-511-84441036.Remote comparison rfc
Remote comparison rfcKhairul Zainal
油
The document discusses remote function call (RFC) specifications between different systems for various analysis processes in a project called Landscape. It states that the same RFC name should be used when transmitting data from the Analysis system to either the Statistics or Reference system as is specified in the Control system. It provides examples of RFC names for Clearing Analysis, Upgrade Change Impact Analysis, and Change and Transport System Analysis. It also notes that the target and statistics systems are typically the same for CTS analysis.Frank Mechanic Resume
Frank Mechanic ResumeFrancis Ferguson
油
Francis L. Ferguson is an ASE certified medium/heavy truck master technician with over 10 years of experience in the automotive industry. He currently works as a shop foreman and senior mechanic for the U.S. Army, where he supervises maintenance of over 200 vehicles and manages a budget of over $2 million. Ferguson has extensive education and training in automotive skills, hazardous materials handling, and leadership.
TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
This document contains rental fee calculations for items using cell references and formulas in Excel. It describes using the formula =I8*H8 to calculate rental fees in cell J8, a 10% discount if rentals are national and less than 1 day in cell K8, penalties if rentals are longer than 1 day in cell L8, and a total to pay formula of J8-K8+L8 in the next cell.
TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
Dokumen tersebut merupakan laporan sewa VCD di toko film "My Movie" yang mencakup daftar film yang disewa beserta detailnya seperti kode, jenis, produksi, tanggal pinjam dan kembali, jumlah keping yang dipinjam, lama pinjam, tarif, discount, dan total bayar. Terdapat 10 transaksi sewa VCD dengan rincian jenis film, produksi, dan tarif berbeda-beda.
TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
This document contains rental fee calculations for items using cell references and formulas in Excel. It lists the rent fee formula of cell I8 multiplied by H8, the discount formula of 10% of J8 if item is national and rental time is less than or equal to 1, and the penalty fee formula of I8 if rental time is greater than 1. It concludes with the total payment formula of J8 minus discount plus penalty fees.
Langkah-langkah pekerjaan Ms.Excel
Langkah-langkah pekerjaan Ms.ExcelYulia Nur Rahmadhani Puspaningrum
油
Tabel ini merupakan daftar 10 transaksi sewa VCD di toko film "My Movie" yang mencakup informasi kode kaset, jenis film, produksi, tanggal sewa, jumlah hari sewa, tarif sewa, discount, dan total bayar. Terdapat 4 jenis film yaitu action, drama, horror dan komedi dengan tarif berbeda untuk film dalam negeri dan luar negeri. Total keseluruhan pembayaran adalah Rp. 43.000 dengan pembayaran tertinggi Rp.
Cara penggajian 2
Cara penggajian 2Yulia Nur Rahmadhani Puspaningrum
油
The document contains a payroll report for employees of CV. Radja including name, position, marital status, number of children, basic salary, allowances, child allowances, and total salary received. It lists 7 employees - 3 managers, 2 in marketing, 1 staff member, and 1 general employee. The basic salaries and allowances are based on the employee's position. Child allowances are a maximum of 2 million per child and health, pension, and income tax deductions are calculated based on basic salary.Cara penggajian
Cara penggajianYulia Nur Rahmadhani Puspaningrum
油
This document contains a payroll list for CV. Makmur employees. It includes each employee's name, salary grade, basic salary, marital status, area bonus, number of children, tax deductions, transportation allowance and total salary. Transportation allowance amounts vary depending on marital status and area. Bonuses are given as 15.7% of basic salary for each child. The basic salaries are Rp. 980,000 for grade 1 and Rp. 1,250,000 for grade 2.Cara membuat grafik di Ms Excel
Cara membuat grafik di Ms ExcelYulia Nur Rahmadhani Puspaningrum
油
Dokumen tersebut memberikan instruksi cara membuat grafik di Ms. Excel dengan 3 langkah yaitu memasukkan data penjualan sepatu per bulan dan tahun 2015, memilih data lalu klik insert untuk memilih jenis grafik, dan mengedit grafik di menu chart tools.
History of the Economy of Pakistan (1947-2024)
History of the Economy of Pakistan (1947-2024)Vaqar Ahmed
油
This presentation unlocks the key insights into Pakistans economic evolution with this in-depth PowerPoint presentation, perfect for anyone invested in understanding the country's economic trajectory and future prospects. Whether you're an economist, civil servant, investor, development agency professional, or business leader, this presentation offers valuable historical context and critical analyses of Pakistans economic journey from its inception in 1947 to the present day (end-2024). #PakistanEconomy
#EconomicHistory
#EconomicGrowth
#PakistanDevelopment
#InvestmentOpportunities
#EconomicInsights
#SouthAsiaEconomy
#EconomicPolicy
#PakistanInvestment
#CivilServants
#BusinessStrategy
#EconomicAnalysis
#DevelopmentAgencies
#PakistanBusiness
#EconomicForecast
#Economists
#FutureOfPakistan
#EconomicTrajectories
#PolicyMakers
#InvestInPakistan #PakistanEconomicHistory
#PakistanEconomy2024
#EconomicHistoryOfPakistan
#HistoryOfPakistanEconomy
#PakistanEconomicDevelopment
#PakistanEconomicGrowth
#PakistanEconomics
#PakistanTrade
#PakistaniEconomyInsights
#PakistanEconomicPolicy
#SouthAsiaEconomicHistory
#EconomicsOfPakistan
#EconomicReformsInPakistan
#PakistanInvestmentClimate
#EconomicDevelopmentPakistan
#PakistanEconomicChallenges
#EconomicTransformationPakistan
#PakistanIndustryHistory
#CPECandPakistanEconomy
#PakistanMacroEconomy #India #China #SAARC #WorldBank #ADBMore Related Content
More from Yulia Nur Rahmadhani Puspaningrum (20)
TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
This document contains rental fee calculations for items using cell references and formulas in Excel. It describes using the formula =I8*H8 to calculate rental fees in cell J8, a 10% discount if rentals are national and less than 1 day in cell K8, penalties if rentals are longer than 1 day in cell L8, and a total to pay formula of J8-K8+L8 in the next cell.TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
Dokumen tersebut merupakan laporan sewa VCD di toko film "My Movie" yang mencakup daftar film yang disewa beserta detailnya seperti kode, jenis, produksi, tanggal pinjam dan kembali, jumlah keping yang dipinjam, lama pinjam, tarif, discount, dan total bayar. Terdapat 10 transaksi sewa VCD dengan rincian jenis film, produksi, dan tarif berbeda-beda.TUGAS TIP MS EXCEL
TUGAS TIP MS EXCELYulia Nur Rahmadhani Puspaningrum
油
This document contains rental fee calculations for items using cell references and formulas in Excel. It lists the rent fee formula of cell I8 multiplied by H8, the discount formula of 10% of J8 if item is national and rental time is less than or equal to 1, and the penalty fee formula of I8 if rental time is greater than 1. It concludes with the total payment formula of J8 minus discount plus penalty fees.Langkah-langkah pekerjaan Ms.Excel
Langkah-langkah pekerjaan Ms.ExcelYulia Nur Rahmadhani Puspaningrum
油
Tabel ini merupakan daftar 10 transaksi sewa VCD di toko film "My Movie" yang mencakup informasi kode kaset, jenis film, produksi, tanggal sewa, jumlah hari sewa, tarif sewa, discount, dan total bayar. Terdapat 4 jenis film yaitu action, drama, horror dan komedi dengan tarif berbeda untuk film dalam negeri dan luar negeri. Total keseluruhan pembayaran adalah Rp. 43.000 dengan pembayaran tertinggi Rp.Cara penggajian 2
Cara penggajian 2Yulia Nur Rahmadhani Puspaningrum
油
The document contains a payroll report for employees of CV. Radja including name, position, marital status, number of children, basic salary, allowances, child allowances, and total salary received. It lists 7 employees - 3 managers, 2 in marketing, 1 staff member, and 1 general employee. The basic salaries and allowances are based on the employee's position. Child allowances are a maximum of 2 million per child and health, pension, and income tax deductions are calculated based on basic salary.Cara penggajian
Cara penggajianYulia Nur Rahmadhani Puspaningrum
油
This document contains a payroll list for CV. Makmur employees. It includes each employee's name, salary grade, basic salary, marital status, area bonus, number of children, tax deductions, transportation allowance and total salary. Transportation allowance amounts vary depending on marital status and area. Bonuses are given as 15.7% of basic salary for each child. The basic salaries are Rp. 980,000 for grade 1 and Rp. 1,250,000 for grade 2.Cara membuat grafik di Ms Excel
Cara membuat grafik di Ms ExcelYulia Nur Rahmadhani Puspaningrum
油
Dokumen tersebut memberikan instruksi cara membuat grafik di Ms. Excel dengan 3 langkah yaitu memasukkan data penjualan sepatu per bulan dan tahun 2015, memilih data lalu klik insert untuk memilih jenis grafik, dan mengedit grafik di menu chart tools.Recently uploaded (20)
History of the Economy of Pakistan (1947-2024)
History of the Economy of Pakistan (1947-2024)Vaqar Ahmed
油
This presentation unlocks the key insights into Pakistans economic evolution with this in-depth PowerPoint presentation, perfect for anyone invested in understanding the country's economic trajectory and future prospects. Whether you're an economist, civil servant, investor, development agency professional, or business leader, this presentation offers valuable historical context and critical analyses of Pakistans economic journey from its inception in 1947 to the present day (end-2024). #PakistanEconomy
#EconomicHistory
#EconomicGrowth
#PakistanDevelopment
#InvestmentOpportunities
#EconomicInsights
#SouthAsiaEconomy
#EconomicPolicy
#PakistanInvestment
#CivilServants
#BusinessStrategy
#EconomicAnalysis
#DevelopmentAgencies
#PakistanBusiness
#EconomicForecast
#Economists
#FutureOfPakistan
#EconomicTrajectories
#PolicyMakers
#InvestInPakistan #PakistanEconomicHistory
#PakistanEconomy2024
#EconomicHistoryOfPakistan
#HistoryOfPakistanEconomy
#PakistanEconomicDevelopment
#PakistanEconomicGrowth
#PakistanEconomics
#PakistanTrade
#PakistaniEconomyInsights
#PakistanEconomicPolicy
#SouthAsiaEconomicHistory
#EconomicsOfPakistan
#EconomicReformsInPakistan
#PakistanInvestmentClimate
#EconomicDevelopmentPakistan
#PakistanEconomicChallenges
#EconomicTransformationPakistan
#PakistanIndustryHistory
#CPECandPakistanEconomy
#PakistanMacroEconomy #India #China #SAARC #WorldBank #ADBLundin Gold - April 2025 Corporate Presentation
Lundin Gold - April 2025 Corporate PresentationAdnet Communications
油
Lundin Gold - April 2025 Corporate PresentationGeniZeniths Red Flags Flashed Hours Before the Melania Meme Rug Pull
GeniZeniths Red Flags Flashed Hours Before the Melania Meme Rug PullGeniZenith
油
The Melania Meme (MELANIA) token promised a glamorous revolution, skyrocketing 900% with viral NFTs and a buzzing community of 23,000. Behind the sheen, red flags waved: a wallet siphoned 120,000 SOL, and 43% of the supply sat in just five wallets. GeniZeniths API glitches masked inflated volumes, while a deepfake Melania X post lured retirees like Clara, who lost her $28K pension. The rug pull hit hardan 82% crash in 90 minutesexposing a crypto honeypot dressed in gold.Reporte del Forno econ坦mico mundial: WEF_Global_Risks_Report_2025.pdf
Reporte del Forno econ坦mico mundial: WEF_Global_Risks_Report_2025.pdfEdgarCruzCruz2
油
Reporte de los principales riesgos 2025 segun el foro econ坦mico mundial, en donde se aprecia los 10 riesgos m叩s cr鱈ticos que enfrenta el mundoFeeling secure: balancing information, wellness and collaboration
Feeling secure: balancing information, wellness and collaborationAndrea Mennillo
油
"I am a businessman, who belongs to a generation that went to school and studied hard to land jobs that would guarantee money, security, and status. [] But I am here to tell you that our generations definition of success was wrong." I spoke these words in 2012, at the graduation ceremony of my son, Francesco. Thinking back on those words 13 years later, they are by no means irrelevant today.
New generations are clearly questioning the role of money and status in the search for happiness, connecting success more with wellness and personal balance. But at the same time, we all feel a greater need for security, for protection: in our health, our affective ties, and our personal and career decisions.
Top Executives in India with Highest Salaries in 2024
Top Executives in India with Highest Salaries in 2024Roshan Rai
油
Discover the top five highest-paid executives in India for FY24, featuring Abhay Bhutada of the Poonawalla Group who received a record-breaking salary. This presentation covers executive compensation details, leadership impact, and contributions across major industries.Group 3 Initiatives taken by Bangladesh Government to promote export111.pptx
Group 3 Initiatives taken by Bangladesh Government to promote export111.pptxNursadia2
油
Initiatives taken by Bangladesh Government to promote exportDiversified Financial Strategies Key to Attracting HNW Clients
Diversified Financial Strategies Key to Attracting HNW ClientsFrank Cardia
油
High-net-worth (HNW) clients are a small but growing segment of the population. Financial advisors who want to cater to this market should be willing to adapt their services to clients needs.
TriStar Gold April 2025 Corporate Presentation
TriStar Gold April 2025 Corporate PresentationAdnet Communications
油
TriStar Gold April 2025 Corporate Presentation
Seeman_Fiintouch_LLP_Newsletter_April_2025.pdf
Seeman_Fiintouch_LLP_Newsletter_April_2025.pdfAshis Kumar Dey
油
Stay Calm, Stay Invested !
SIPs win in the Long Run
Volatility Isnt the Enemy Its the Opportunity
The Power of Cost Averaging
Investment Tip
Market Updates
Inspiring Investment StoryFrom Greenwashing to Green Proofing Strengthening ESG Investment Integrity.pdf
From Greenwashing to Green Proofing Strengthening ESG Investment Integrity.pdfJasper Colin
油
ESG integrity is at stake as greenwashing runs rampant. Our latest case study explores how AI-driven validation, standardized reporting, and transparency can help asset managers build trust. Learn more.
Abhay Bhutada From Entrepreneurial Spirit to Social Change
Abhay Bhutada From Entrepreneurial Spirit to Social ChangeHarsh Mishra
油
Learn about Abhay Bhutadas rise from a Chartered Accountant to a top executive with a net worth exceeding Rs 1000 crore. This presentation also highlights the impactful initiatives of the Abhay Bhutada Foundation across education, healthcare, and sports.Managerial Accounting - Profitability Ratio Analysis of HUL.pptx
Managerial Accounting - Profitability Ratio Analysis of HUL.pptxJeya Sree
油
Gathering key financial metrics from financial statements to calculate the profitability of Hindustan Unilever Limited.
Net profit margin
Earnings per share
Return on equity
Return on capital employed
Operating profit margin
Top Five Business Leaders with Highest Earnings in 2024
Top Five Business Leaders with Highest Earnings in 2024Harsh Mishra
油
Explore the top-earning business leaders in India for FY24, including Abhay Bhutada whose salary reached 241.21 crore. The presentation highlights their roles, achievements, and how their leadership influenced company growth and success.
TUGAS TIP MS EXCEL
- 1. 4. TARIF SEWA KITA GUNAKAN RUMUS =I8*H8 LALU DI TARIK KEBAWAH : 5. DISC KITA GUNAKAN RUMUS =IF(AND(E8="Nasional",H8<=1),10%*J8,0) LALU DI TARIK KEBAWAH : 6. DENDA KITA GUNAKAN RUMUS =IF(H8>1,I8,0) LALU DI TARIK KEBAWAH :
- 2. 7. TOTAL BAYAR KITA GUNAKAN RUMUS =J8-K8+L8 LALU DI TARIK KEBAWAH :