1/53
Looks like no tags are added yet.
Formula
A user-created expression used to calculate values, which always begins with an equal sign.
Function
A predefined formula in Excel that performs calculations using specific values called arguments.
Cell Reference
A way to refer to a specific cell in Excel using its column letter and row number.
Cross-sheet Reference
A formula that retrieves information from another worksheet.
Active Cell
The currently selected cell that is ready for data entry.
Relative Cell Reference
A reference that changes automatically when copied to another cell.
Absolute Cell Reference
A reference that remains fixed when copied to another cell.
SUM Function
Adds numbers together in a specified range.
AVERAGE Function
Calculates the mean value of a range of numbers.
COUNTIF Function
Counts the number of cells that meet a specified condition within a range.
Alignment
Formatting option used to control the placement of text within a cell.
Border
A tool that adds lines around selected cells for better organization.
Fill Color
A formatting tool that gives cells a colored background.
Line Chart
Used to show trends over time in data.
Cell Formatting
Changes the appearance of data in a cell without altering its value.
Name Box
Displays the address of the active cell.
Formula Bar
Area where users can view and edit data or formulas in the selected cell.
Ribbon
Organizes commands and tools in tabs for easier access.
Quick Access Toolbar
Contains frequently used commands for easy access.
Row
Horizontal lines in a worksheet identified by numbers.
Column
Vertical lines in a worksheet identified by letters.
Sheet Tabs
Tabs located at the bottom of the Excel window used to switch between worksheets.
Data Tab
Contains tools for sorting and filtering data.
Insert Tab
Used for creating charts, tables, and inserting images.
Page Layout Tab
Contains options for themes, margins, and page orientation.
Process of Data Entry
Steps to input information into a spreadsheet properly.
Use AutoFill
Feature that allows users to quickly copy data patterns in adjacent cells.
Wrap Text
Formatting option that allows long text to fit within a single cell.
Keyboard Shortcuts
Key combinations that perform specific functions quickly.
Chart Title
Text that describes what the chart is about.
Data Labels
Labels that display actual data values or percentages in a chart.
Follow Formatting Steps
Procedure to apply specific formatting to Excel cells.
Use of Cell References
Utilizing cell addresses in formulas to perform calculations.
Math Functions
Functions like SUM and AVERAGE used for calculations in Excel.
Insert New Worksheet
Add a new worksheet to an Excel workbook.
Rename Worksheets
Change the name of a worksheet for better organization.
Move Worksheets
Change the order of worksheets in a workbook.
Copy Worksheets
Create a duplicate of an existing worksheet.
Change Sheet Colors
Modify the color of the worksheet tabs for easy identification.
Integrated Charts
Charts that visually represent data alongside reports in Excel.
Multi-Sheet Workbook
An Excel workbook that contains multiple worksheets for organization.
Three-D Reference
A reference that includes multiple sheets in a single formula.
Spreadsheet Structure
The arrangement of rows, columns, and cells in an Excel workbook.
Formatting Tools
Options in Excel that enhance the appearance of data.
Insert Tab
Contains commands for inserting elements like charts and tables.
Save As
Option to save a file under a different name or location.
Excel Interface Elements
Components like the ribbon, toolbar, and formula bar that help navigate Excel.
Logical Functions
Functions that perform operations based on conditions, for example, IF.
Workbook Name
Title displayed in the title bar at the top of the Excel window.
Date Formatting
Changes how dates are displayed within cells.
Name of Active Cell
The location of the cell currently selected in a worksheet.
Sales Data
Information regarding sales, often organized in Excel for analysis.
Sorting Data
Arranging data in a specified order based on certain criteria.
Filtering Data
Displaying a subset of data based on selected criteria.