In Excel charts, the vertical axis is called the Y-axis.
The Y-axis typically represents values.
The horizontal axis is referred to as the X-axis.
The X-axis represents categories or time.
The default name of the first sheet in any workbook is Sheet1.
Excel assigns this name automatically.
It can be renamed by the user if desired.
The formula bar is the toolbar at the top of the spreadsheet that lets you enter or view information in a cell.
To sum up a range of cells in Excel, you use the SUM function.
This function adds together all the numbers in the specified range of cells.
MAX function finds the highest value in a range of cells.
AVERAGE function calculates the average of the numbers in a range.
COUNT function counts the number of cells that contain numbers.
In MS Excel, “character” is not a valid data type.
There are Three types of data in cells: labels, values, and formulas.
Formulas are instructions for Excel to perform calculations.
Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
Values (numbers) are generally raw numbers or dates.
Hyperlinks can be used for text, drawing objects, and pictures.
They provide a way to navigate within a document, to a different document, or to a web page.
In a spreadsheet, the data is organised in columns and rows.
Cell entry “July 16, 2016” will be considered a value by Excel sheet.
In Excel, “July 16, 2016” is recognized as a date, which is stored as a serial number.
In Excel, each row of a table corresponds to a record.
It is a complete set of data.
Field corresponds to columns in Excel.
Each column represents a field or a specific type of data within the records.
