Microsoft Excel

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/16

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

17 Terms

1
New cards

Microsoft Excel/Ms Excel

  • a spreadsheet program that allows users to organize, format, and calculate data in a spreadsheet.

  • It is a spreadsheet program that allows users to organize, format, and calculate data. It's part of Microsoft's 365 suite of software.

  • It also uses Formulas to calculate values.

2
New cards

  • Data entry and management

  • Creating charts and graphs

  • Creating documents such as balance sheets, budgets, and calendars

  • Calculating sums of money

  • Project management

Excel is used for a variety of purposes, including:

3
New cards

WORKBOOK

file that contains one or more worksheets, or spreadsheets, that help organize data.

4
New cards

WORKSHEET

grid of cells organized into rows and columns that allows users to input and calculate data:

5
New cards

CELL

intersection of a row and a column on a spreadsheet and is the basic unit for storing data in Excel.

6
New cards

ROWS

Horizontal lines of cells that run from left to right. Row headings are numbers that range from 1 to 1,048,576.

7
New cards

COLUMNS

Vertical lines of cells that run from top to bottom. Column headings are letters that range from A to XFD

8
New cards

NAME BOX

name of either the active/current cell, or the name of a defined range of cells or table.

9
New cards

CELL REFERENCE

shows the name of the cell/table being selected, i.e., it shows the name of the active/current cell or table.

10
New cards

FORMULA BAR

Shows the data/formula/phrase in the cell selected.

11
New cards

FORMULA

  • allow you to do automated calculations within worksheets, and even amongst different workbooks.

  • A formula is typed into the formula bar and must begin with an equal (=) sign.

  • You can use formulas to carry out any of the four basic mathematical operators (add, subtract, multiply, and divide), use brackets to dictate the order of solving the formula, or use any of the hundreds of in-built functions in Excel.

12
New cards

FUNCTIONS

formulas that are built into Excel.

13
New cards

=SUM

Calculates the sum values of a range of cell.

14
New cards

=AVERAGE

Calculates the arithmetic mean of a range of cell.

15
New cards

=MAX

Gives the maximum value in a range of cells.

16
New cards

=MIN

Gives the minimum value in a range of cells.

17
New cards

=COUNT

Counts the number of cells in a range of cells.