system which organize data and call him in, can be money for manipulate

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/30

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai

No study sessions yet.

31 Terms

1
New cards

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.

2
New cards

quick access toolbar

It's allowed to access commonly used commands such as save, undo, and redo

3
New cards

title bar

It displays the name of the active work book and excel program name.

4
New cards

Ribbon

it contain tabs that link the various feature of the program

5
New cards

column heading

it contain the letter that appear along the top row of the worksheet window

6
New cards

row heading

it contain the number that appeared along the left column of the worksheet window

7
New cards

worksheet window

a window that displays an excel workbook (spreadsheet)

8
New cards

vertical scroll bar

it is used to control vertically through the workbook window

9
New cards

horizontal scroll bar

it is used to scroll down horizontally through the workbook window

10
New cards

zoom slider/ control

if magnifies and shrinks the content display and the active workbook

11
New cards

View Shortcuts

it contains bottles that are used to change how the worksheet content is displayed - normal page layout or page break preview view

12
New cards

sheet tub

it displayed the name of the worksheets

13
New cards

Sheet tab Scrolling button

these are buttons to scroll the list of sheet tabs and the workbook

14
New cards

select all button

is it used to select all the cells in the active workbook

15
New cards

active cell

the south currently selected in the active workbook

16
New cards

formula bar

a bar that display the value of formula entered in the active cell

17
New cards

status bar

it displayed information about the current state of the worksheet

18
New cards

functions

these are predefined formula that perform calculation using specific values

19
New cards

part of a function

argument, function name, equal sign

20
New cards

=

equal to

21
New cards

>

greater than

22
New cards

<

less than

23
New cards

>=

greater than or equal to

24
New cards

<=

less than or equal to

25
New cards

<>

not equal to

26
New cards

common function name : Sum

to get the total

27
New cards

common function name: IF

used to perform logical test and return one value for a TRUE result and another for a FALSE result

28
New cards

common function name: COUNTIF

used to count the cells with a pacific content within a range

29
New cards

common function name: SUMIF

use to compute for the summation of a range if a certain condition is met

30
New cards

common function names: AVERAGEIF

use the compute for the average of a range if a certain condition is met

31
New cards