FELEC (ELECTIVE 2)

0.0(0)
Studied by 7 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/53

encourage image

There's no tags or description

Looks like no tags are added yet.

54 Terms

1
New cards

Formula

A user-created expression used to calculate values, which always begins with an equal sign.

2
New cards

Function

A predefined formula in Excel that performs calculations using specific values called arguments.

3
New cards

Cell Reference

A way to refer to a specific cell in Excel using its column letter and row number.

4
New cards

Cross-sheet Reference

A formula that retrieves information from another worksheet.

5
New cards

Active Cell

The currently selected cell that is ready for data entry.

6
New cards

Relative Cell Reference

A reference that changes automatically when copied to another cell.

7
New cards

Absolute Cell Reference

A reference that remains fixed when copied to another cell.

8
New cards

SUM Function

Adds numbers together in a specified range.

9
New cards

AVERAGE Function

Calculates the mean value of a range of numbers.

10
New cards

COUNTIF Function

Counts the number of cells that meet a specified condition within a range.

11
New cards

Alignment

Formatting option used to control the placement of text within a cell.

12
New cards

Border

A tool that adds lines around selected cells for better organization.

13
New cards

Fill Color

A formatting tool that gives cells a colored background.

14
New cards

Line Chart

Used to show trends over time in data.

15
New cards

Cell Formatting

Changes the appearance of data in a cell without altering its value.

16
New cards

Name Box

Displays the address of the active cell.

17
New cards

Formula Bar

Area where users can view and edit data or formulas in the selected cell.

18
New cards

Ribbon

Organizes commands and tools in tabs for easier access.

19
New cards

Quick Access Toolbar

Contains frequently used commands for easy access.

20
New cards

Row

Horizontal lines in a worksheet identified by numbers.

21
New cards

Column

Vertical lines in a worksheet identified by letters.

22
New cards

Sheet Tabs

Tabs located at the bottom of the Excel window used to switch between worksheets.

23
New cards

Data Tab

Contains tools for sorting and filtering data.

24
New cards

Insert Tab

Used for creating charts, tables, and inserting images.

25
New cards

Page Layout Tab

Contains options for themes, margins, and page orientation.

26
New cards

Process of Data Entry

Steps to input information into a spreadsheet properly.

27
New cards

Use AutoFill

Feature that allows users to quickly copy data patterns in adjacent cells.

28
New cards

Wrap Text

Formatting option that allows long text to fit within a single cell.

29
New cards

Keyboard Shortcuts

Key combinations that perform specific functions quickly.

30
New cards

Chart Title

Text that describes what the chart is about.

31
New cards

Data Labels

Labels that display actual data values or percentages in a chart.

32
New cards

Follow Formatting Steps

Procedure to apply specific formatting to Excel cells.

33
New cards

Use of Cell References

Utilizing cell addresses in formulas to perform calculations.

34
New cards

Math Functions

Functions like SUM and AVERAGE used for calculations in Excel.

35
New cards

Insert New Worksheet

Add a new worksheet to an Excel workbook.

36
New cards

Rename Worksheets

Change the name of a worksheet for better organization.

37
New cards

Move Worksheets

Change the order of worksheets in a workbook.

38
New cards

Copy Worksheets

Create a duplicate of an existing worksheet.

39
New cards

Change Sheet Colors

Modify the color of the worksheet tabs for easy identification.

40
New cards

Integrated Charts

Charts that visually represent data alongside reports in Excel.

41
New cards

Multi-Sheet Workbook

An Excel workbook that contains multiple worksheets for organization.

42
New cards

Three-D Reference

A reference that includes multiple sheets in a single formula.

43
New cards

Spreadsheet Structure

The arrangement of rows, columns, and cells in an Excel workbook.

44
New cards

Formatting Tools

Options in Excel that enhance the appearance of data.

45
New cards

Insert Tab

Contains commands for inserting elements like charts and tables.

46
New cards

Save As

Option to save a file under a different name or location.

47
New cards

Excel Interface Elements

Components like the ribbon, toolbar, and formula bar that help navigate Excel.

48
New cards

Logical Functions

Functions that perform operations based on conditions, for example, IF.

49
New cards

Workbook Name

Title displayed in the title bar at the top of the Excel window.

50
New cards

Date Formatting

Changes how dates are displayed within cells.

51
New cards

Name of Active Cell

The location of the cell currently selected in a worksheet.

52
New cards

Sales Data

Information regarding sales, often organized in Excel for analysis.

53
New cards

Sorting Data

Arranging data in a specified order based on certain criteria.

54
New cards

Filtering Data

Displaying a subset of data based on selected criteria.