1/30
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No study sessions yet.
Microsoft Excel
a popular spreadsheet system which organized data and column in rows that can be manipulated through formulas that allow the software to perform a mathematical function on the data.
quick access toolbar
It's allowed to access commonly used commands such as save, undo, and redo
title bar
It displays the name of the active work book and excel program name.
Ribbon
it contain tabs that link the various feature of the program
column heading
it contain the letter that appear along the top row of the worksheet window
row heading
it contain the number that appeared along the left column of the worksheet window
worksheet window
a window that displays an excel workbook (spreadsheet)
vertical scroll bar
it is used to control vertically through the workbook window
horizontal scroll bar
it is used to scroll down horizontally through the workbook window
zoom slider/ control
if magnifies and shrinks the content display and the active workbook
View Shortcuts
it contains bottles that are used to change how the worksheet content is displayed - normal page layout or page break preview view
sheet tub
it displayed the name of the worksheets
Sheet tab Scrolling button
these are buttons to scroll the list of sheet tabs and the workbook
select all button
is it used to select all the cells in the active workbook
active cell
the south currently selected in the active workbook
formula bar
a bar that display the value of formula entered in the active cell
status bar
it displayed information about the current state of the worksheet
functions
these are predefined formula that perform calculation using specific values
part of a function
argument, function name, equal sign
=
equal to
>
greater than
<
less than
>=
greater than or equal to
<=
less than or equal to
<>
not equal to
common function name : Sum
to get the total
common function name: IF
used to perform logical test and return one value for a TRUE result and another for a FALSE result
common function name: COUNTIF
used to count the cells with a pacific content within a range
common function name: SUMIF
use to compute for the summation of a range if a certain condition is met
common function names: AVERAGEIF
use the compute for the average of a range if a certain condition is met