MS Excel
Computers · MS Excel · 18 facts
MS Excel is spreadsheet software by Microsoft
Excel file extension is .xlsx
Cell is intersection of row and column in Excel
SUM function adds values: =SUM(A1:A10)
AVERAGE function calculates mean of values
COUNT function counts number of cells with data
IF function performs conditional logic: =IF(condition, true, false)
VLOOKUP searches for value in a table column
Excel has 1,048,576 rows and 16,384 columns
Pivot Table summarizes large data sets
Ctrl+; inserts current date in Excel
MAX and MIN functions find highest and lowest values
Charts in Excel visualize data (bar, pie, line)
Freeze Panes keeps rows/columns visible while scrolling
Conditional Formatting highlights cells based on rules
Excel macros automate repetitive tasks using VBA
CONCATENATE or & joins text from multiple cells
Data Validation restricts type of data entered in cells