{"id":154,"date":"2023-12-17T15:25:35","date_gmt":"2023-12-17T15:25:35","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/back-matter\/glossary\/"},"modified":"2024-09-18T00:55:37","modified_gmt":"2024-09-18T00:55:37","slug":"glossary","status":"publish","type":"back-matter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/back-matter\/glossary\/","title":{"raw":"Glossary","rendered":"Glossary"},"content":{"raw":"","rendered":"
\n
absolute cell reference<\/dfn><\/dt>\n
\n

An absolute cell reference provides a permanent reference to a specific cell.<\/p>\n<\/dd>\n

active cell<\/dfn><\/dt>\n
\n

The active cell is the current cell. Excel displays a dark border around the active cell in the worksheet window, and the cell address of the active cell appears in the Name Box.<\/p>\n<\/dd>\n

application software<\/dfn><\/dt>\n
\n

An application software, application, program, or simply app for a small application is a computer program designed to carry out a specific task other than the operation of the computer itself, such as word processors, graphic editors, and web browsers.<\/p>\n<\/dd>\n

AVERAGE<\/dfn><\/dt>\n
\n

The AVERAGE function is used to calculate the arithmetic mean of a given set of arguments. For example, if the range B1:B20 contains numbers, the formula =AVERAGE(B1:B20) returns the average of those numbers.<\/p>\n<\/dd>\n

cell<\/dfn><\/dt>\n
\n

Each cell has a unique cell address, identified by first its column letter and then its row number. For xample, the cell at the intersection of column A and row 9 is cell A9.<\/p>\n<\/dd>\n

chart<\/dfn><\/dt>\n
\n

A chart allows you to illustrate your workbook data graphically, so it is easy to visualize comparisons and trends.<\/p>\n<\/dd>\n

column<\/dfn><\/dt>\n
\n

A column in an Excel worksheet file runs vertically across a worksheet's grid structure. Columns are labeled by capital letters known as column headings. There are 16,384 columns in Excel.<\/p>\n<\/dd>\n

COUNT<\/dfn><\/dt>\n
\n

The COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, to count the numbers in the range of cells from cell B1 until cell B20, the formula is =COUNT(B1:B20).<\/p>\n<\/dd>\n

formula<\/dfn><\/dt>\n
\n

A formula in Excel calculates numbers into meaningful results that can update as values changes.<\/p>\n<\/dd>\n

IF<\/dfn><\/dt>\n
\n

The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.<\/p>\n<\/dd>\n

MAX<\/dfn><\/dt>\n
\n

The MAX function returns the largest value in a set of values.<\/p>\n<\/dd>\n

Microsoft 365<\/dfn><\/dt>\n
\n

Microsoft 365 is suite of productivity software, collaboration and cloud-based services owned by Microsoft. It was formerly called Microsoft Office which include applications such as Word, Excel, PowerPoint, and Outlook.<\/p>\n<\/dd>\n

MIN<\/dfn><\/dt>\n
\n

The MIN function returns the smallest number in a set of values.<\/p>\n<\/dd>\n

PMT<\/dfn><\/dt>\n
\n

The PMT function calculates the payment for a loan based on constant payments and a constant interest rate.<\/p>\n<\/dd>\n

PV<\/dfn><\/dt>\n
\n

The PV function calculates the present value of a loan or an investment, based on a constant interest rate.<\/p>\n<\/dd>\n

relative cell reference<\/dfn><\/dt>\n
\n

A relative cell reference indicates a cell's relative location, such as one row up and one column to the left, from the cell containing the formula.<\/p>\n<\/dd>\n

ribbon<\/dfn><\/dt>\n
\n

The ribbon is a set of toolbars at the top of the window in Office programs such as Word or Excel designed to help you quickly find the commands that you need to complete a task. On Excel, you will find Home, Insert and Formulas ribbons.<\/p>\n<\/dd>\n

row<\/dfn><\/dt>\n
\n

A row in an Excel worksheet file runs horizontally across a worksheet's grid structure. Rows are labeled by numbers known as row headings. There are 1,048,576 rows in Excel.<\/p>\n<\/dd>\n

SUM<\/dfn><\/dt>\n
\n

The SUM function totals the values in two or more cells and then displays the result in the cell containing the function. For example, the formula =SUM(M2:M10) adds the values in cells M2 until M10.<\/p>\n<\/dd>\n

VLOOKUP<\/dfn><\/dt>\n
\n

The VLOOKUP function is used when you need to find things in a table or a range by row.<\/p>\n<\/dd>\n

workbook<\/dfn><\/dt>\n
\n

A workbook is a spreadsheet program file that you create in Excel.<\/p>\n<\/dd>\n

worksheet<\/dfn><\/dt>\n
\n

Excel lets you create spreadsheets with multiple pages. Each page is called a worksheet. A collection of one or more worksheets is called a workbook (which is also sometimes called a spreadsheet file).<\/p>\n<\/dd>\n<\/dl>\n","protected":false},"author":91,"menu_order":2,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":"cc-by"},"back-matter-type":[38],"contributor":[],"license":[53],"class_list":["post-154","back-matter","type-back-matter","status-publish","hentry","back-matter-type-glossary","license-cc-by"],"_links":{"self":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter"}],"about":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/types\/back-matter"}],"author":[{"embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/users\/91"}],"version-history":[{"count":1,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter\/154\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter\/154\/revisions\/155"}],"metadata":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter\/154\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/media?parent=154"}],"wp:term":[{"taxonomy":"back-matter-type","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/back-matter-type?post=154"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/contributor?post=154"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/license?post=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}