Excel 1
Returns the current date formatted as a date
TODAY()
Adds all the number in a range of cells
SUM()
Returns the largest value in a set of values
MAX()
Finds average for the cells specified by a given condition
AVERAGEIF()
How do you start a formula
=
How many tabs is there
8
Information that appears at the top of each page
Header
The small black square in the lower-right corner of the selection
Fill Handle
One or more ranges of cells that you designate to print when you don't want to print the whole worksheet
Print Area
This feature keeps selected rows or columns visible while scrolling through a worksheet.
Freeze Panes
This feature visually represents data using bars, lines, pie slices, and other graphical elements.
Chart
It is a feature used to arrange data in ascending or descending order.
Sort
Conditions you specify to limit which records are included in the result set of a query
Criteria
It is a function used to search for a value in a table and return related information from another column.
VLOOKUP (or XLOOKUP)
Used to analyze, explore and present data
PivotTable
Predefined, coordinated set of colors, fonts, graphical effects, and other formats
Themes
Excel feature that automatically increases or decreases the width of a column so that the widest entry will fit
Best Fit
Page Layout View
This feature displays only the data that meets specific criteria.
Filter
Sequence of values to produce a new value
Formula
Returns the position of a cell in a row or column
MATCH()
To determine if all conditions in a test are TRUE
AND()
Returns the serial number of the current date and time
NOW()
It is used to restrict the type of data that can be entered into a cell.
Data Validation
This feature allows users to apply formatting to cells based on specific conditions.
Conditional Formatting