Sabtu, 09 April 2016

12 FUNGSI – FUNGSI / FORMULA YANG TERDAPAT PADA MICROSOFT EXCEL

12 FUNGSI – FUNGSI / FORMULA YANG TERDAPAT PADA MICROSOFT EXCEL

Posted on 21.59 by Unknown
12 FUNGSI – FUNGSI / FORMULA YANG TERDAPAT PADA MICROSOFT EXCEL 1. SUMSUM digunakan untuk menjumlahkan sekumpulan data pada suatu range. Bentuk umum penulisan fungsi ini adalah  =SUM(number1, number2) - Enter.number1, number2 dan seterusnya adalah range data yang akan dijumlahkan. Misalnya untuk menjumlahkan range data c2 sampai C7, maka rumusnya adalah =SUM(C2:C7) kemudian tekan tombol Enter.    2. AVERAGEAverage...
Leave a comment
Langganan: Postingan (Atom)

About

a { color: #f7f6f2; transition: all .3s ease-in-out; -webkit-transition: all .3s ease-in-out; -o-transition: all .3s ease-in-out; -moz-transition: all .3s ease-in-out; } .main-navigation ul ul :hover > a { } .main-navigation ul li:hover > ul { opacity: 1; visibility: visible; transition: all .3s ease-in-out; -webkit-transition: all .3s ease-in-out; -o-transition: all .3s ease-in-out; -moz-transition: all .3s ease-in-out; } .main-navigation li.current_page_item a, .main-navigation li.current-menu-item a { color: #f7f6f2; } /* Small menu */ .menu-toggle { cursor: pointer; } .main-small-navigation .menu { border-bottom: 1px dashed rgba(255,255,255,.2); display: none; list-style: none; margin: 0 auto; padding: 0; width: 88%; } .main-small-navigation .menu ul { list-style: none; margin: 0; padding: 0; } .main-small-navigation .menu li { list-style: none; margin: 0; padding: 0; } .main-small-navigation .menu a { color: rgba(255,255,255,.2); border-bottom: 1px solid rgba(255,255,255,.1); display: block; font-family: "Fjalla One", Helvetica, Arial, sans-serif; font-size: 16px; font-size: 1.6rem; padding: .9em 0; text-align: center; text-decoration: none; text-transform: uppercase; } .main-small-navigation .menu a:hover { color: #fff; } .main-small-navigation li.current_page_item a, .main-small-navigation li.current-menu-item a { color: #fff; } /* =Content ----------------------------------------------- */ .sticky { } .hentry { margin: 0 0 1.8em; position: relative; } .hentry:before, .hentry:after { content: ""; display: table; } .hentry:after, .author-archives-header:after { background: url('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3aHO3WlpbmIUaYktf9aEaGj5NBIrAmS1q7QjTptPz5zZeAuJ7SbBTRNa6t4qYRyvfXF_xfOer1Y5kgoFyJjIBecQrzi6YxDa1_16WH6fVke6LKEDKUfkhIW7zay9qRqMqIiqnBmG-cck/s0/divider.png') no-repeat; background-position: 50%; background-size: 120px auto; clear: both; content: ""; margin: 3.6em 0; width: 100%; height: 20px; } .entry-content > p:first-of-type:first-letter { float: left; line-height: 1; margin: 0 5px -5px 0; font-size: 58px; font-size: 5.8rem; } .entry-title, .entry-title a { color: #74452e; display: block; font-family: "Fjalla One", script; font-size: 32px; font-size: 3.2rem; margin: 0; max-width: 94%; text-transform: uppercase; } .entry-meta { clear: both; font-family: "Fjalla One", Helvetica, Arial, sans-serif; font-size: 12px; font-size: 1.2rem; margin: 10px 0 0; text-transform: uppercase; } .byline { display: none; } .single .byline, .group-blog .byline { display: inline; } .entry-content, .entry-summary { margin: 10px 0 0; } .entry-content ul li, .mainblog .widget ul li, .sidebar .widget ul li { list-style: none; margin: 0 0 0 -1.3em; } .entry-content ul ul, .mainblog .widget ul ul, .sidebar .widget ul ul { margin: 0 0 0 3.1em; } .entry-content ul ul ul, .mainblog .widget ul ul ul, .sidebar .widget ul ul ul { margin: 0 0 0 1.8em; } .entry-content ul ul li, .mainblog .widget ul ul li, .sidebar .widget ul ul li { list-style: disc; margin: auto; } .entry-content ul ul ul li, .mainblog .widget ul ul ul li, .sidebar .widget ul ul ul li { list-style: circle; } .entry-content ul ul li:before, .mainblog .widget ul ul li:before, .sidebar .widget ul ul li:before { display: none; } .entry-content ul li:before, .mainblog .widget ul li:before, .sidebar .widget ul li:before { background: url('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3aHO3WlpbmIUaYktf9aEaGj5NBIrAmS1q7QjTptPz5zZeAuJ7SbBTRNa6t4qYRyvfXF_xfOer1Y5kgoFyJjIBecQrzi6YxDa1_16WH6fVke6LKEDKUfkhIW7zay9qRqMqIiqnBmG-cck/s0/divider.png') center no-repeat; background-size: auto 10px; content: ""; display: inline-block; margin: 0 .75em 0 -1.5em; width: 10px; height: 10px; } .page-links { clear: both; margin: 0 0 1.8em; } .page-header { margin: 3.6em 0 0; } .page-title { font-family: "Fjalla One", Helvetica, Arial, sans-serif; font-size: 18px; font-size: 1.8rem; margin: 1.8em 0; text-transform: uppercase; } .sep { background: url('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3aHO3WlpbmIUaYktf9aEaGj5NBIrAmS1q7QjTptPz5zZeAuJ7SbBTRNa6t4qYRyvfXF_xfOer1Y5kgoFyJjIBecQrzi6YxDa1_16WH6fVke6LKEDKUfkhIW7zay9qRqMqIiqnBmG-cck/s0/divider.png') center no-repeat; background-size: auto 10px; display: inline-block; margin: 0 .4em; width: 10px; height: 10px; } /* Make sure embeds and iframes fit their containers */ embed, iframe, object { max-width: 100%; } /* =Widgets ----------------------------------------------- */ .mainblog .widget, .sidebar .widget { font-size: 90%; margin: 0 0 3.6em; } .mainblog .widget-title, .sidebar .widget h2, .mainblog .widget-title a, .sidebar .widget h2 a { color: #f7f6f2; font-family: "Fjalla One", Helvetica, Arial, sans-serif; font-size: 20px; font-size: 2.0rem; font-variant: normal; text-transform: uppercase; } .mainblog .widget ul li:before, .sidebar .widget ul li:before { background-image: url('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRASDm6ipz4qaSLIJtG8wBtbIkJhehL2Z0m3OvoVAfG7GhOGL1_RqeFD_fFG_-qCC9RmZdz23TKx_pgkMsxso3xHj3nytsSjtRJ0X9jWKGmWMKOmY19QmEaze6Qr_rQ1rYTKb9VWVIMys/s0/divider-white.png'); } .mainblog .widget ul, .sidebar .widget ul { margin: 0 0 0 3em; } .mainblog .widget ul ul, .sidebar .widget ul ul { margin: 0 0 0 1em; } /* Search widget */ #searchsubmit { display: none; } /* =Responsive Media Queries ----------------------------------------------- */ @media screen and ( max-width: 1000px ) { #page { width: 800px; } #masthead, #masthead:before { width: 240px; } #masthead:after { width: 290px; } } @media screen and ( max-width: 800px ) { #page { width: 100%; } #content, #secondary, .site-footer { box-shadow: none; clear: both; float: none; margin: 0 auto; padding: 0; position: relative; top: auto; left: auto; width: 88%; height: auto; } #content { margin: 1.8em auto 0; } .site-footer { text-align: center; } #masthead, #masthead:before, #masthead:after { border: 0; width: 100%; height: auto; padding: 0; } #masthead:after { border-bottom: 1px dashed rgba(255,255,255,.2); position: absolute; bottom: 10px; z-index: -1; } #masthead .mastheadsec { margin: 0 auto; width: 88%; } #masthead { background: url('https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilv4Xgq8Jg8k2-9g98SxwGd4W_N_GaPrBH0uNWVugVxZiZ6Z6jOyW5trEidi5lIeDsKCV4OKSLiYsHWeJYtgWVkSunYmS7NQHCvkdU9KeqYBHourjUEFIwC8queshvhQouF9ClJueGRtI/s0/background.jpg'); background-size: 400px auto; } .entry-title { word-wrap: break-word; } } h2.date-header { margin: 1.5em 0 .5em; display: none; } .main .widget { margin: 0 0 5px; padding: 0 0 2px; } .main .Blog { border-bottom-width: 0; } #header .description { color:#ffffff; font-size:14px; text-shadow:0px 1px 0px #000000; } /* Comments----------------------------------------------- */ #comments { padding:10px; color:#666; margin-bottom:20px; } #comments h4 { font-size:22px; margin-bottom:10px; } #comment-name-url { width: 365px; float: left; } #comment-date { width: 365px; float: left; margin-top: 5px; font-size: 10px; } #comment-header { float: left; padding: 5px 0 40px 10px; margin: 5px 0 15px 0; position: relative; background-color: #ffffff; border: 1px dashed #eeeeee; } .avatar-image-container { background: url(http: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIxBaMi06imLUbk3LeDDGCbKcft96CTFE_w61NpcjXLrgGBnlRo4D2RH_PNr8p-f4w_Mt3PPmBhfg9fGIU9ZdESKXqkFOCQPshf4IpusstZp3g6lDkvFlqY5DOYs6Iqrpl5S3ahN4cy3E/s0/comment-avatar.jpg); width: 32px; height: 32px; float: right; margin: 5px 10px 5px 5px; border: 1px solid #dddddd; } .avatar-image-container img { width: 32px; height: 32px; } a.comments-autor-name { color: #000000; font: normal bold 14px Arial, Tahoma, Verdana; } a.says { color: #000000; font: normal 14px Arial, Tahoma, Verdana; } .says a:hover { text-decoration: none; } .deleted-comment { font-style: italic; color: gray; } #blog-pager-newer-link { float: left; } #blog-pager-older-link { float: right; } #blog-pager { text-align: center; padding:5px; } .feed-links { clear: both; } /* Profile ----------------------------------------------- */ .profile-img { float: left; margin-top: 0; margin-right: 5px; margin-bottom: 5px; margin-left: 0; padding: 4px; border: 1px solid #eeeeee; } .profile-data { margin: 0; text-transform: uppercase; letter-spacing: .1em; color: #000000; font-weight: bold; line-height: 1.6em; } .profile-datablock { margin: .5em 0 .5em; } .profile-textblock { margin: 0.5em 0; line-height: 1.6em; } .avatar-image-container { background: url(http:https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIxBaMi06imLUbk3LeDDGCbKcft96CTFE_w61NpcjXLrgGBnlRo4D2RH_PNr8p-f4w_Mt3PPmBhfg9fGIU9ZdESKXqkFOCQPshf4IpusstZp3g6lDkvFlqY5DOYs6Iqrpl5S3ahN4cy3E/s0/comment-avatar.jpg); width: 32px; height: 32px; float: right; margin: 5px 10px 5px 5px; border: 1px solid #dddddd; } .avatar-image-container img { width: 32px; height: 32px; } .profile-link { text-transform: uppercase; letter-spacing: .1em; } .comment-form { max-width: 600px; } #navbar-iframe { height: 0; visibility: hidden; display: none; } .PopularPosts .widget-content ul li { padding:6px 0px; } .reaction-buttons table{ border:none; margin-bottom:5px; } .reaction-buttons table, .reaction-buttons td{ border:none; } ]]>
</div></div> <div class="date-outer">

<div class="date-posts">
</div></div>

 

:

1 : :

           

()
Posted in ,