Charts
Inserts
Review
Data
Page Layout
100
I am used to show trends over time (years, months, and days) or categories.
What is a Line or Area Chart?
100
It helps to sort, filter, and format data within a sheet.
What is a table?
100
We count cells, formulas, charts, tables so you don't have to.
What is Workbook Statistics?
100
You use me to predict data trends.
What is a Forecast Sheet?
100
Choose rows and columns to repeat on each printed page, such as labels or headers.
What is Print Titles?
200
I can compare values and show categories across geographical regions.
What is a Map Chart?
200
You can arrange and summarize complex data.
What is a PivotTable?
200
I can give you another language.
What is Translate?
200
Summarize data from separate ranges to one single range.
What is Consolidate?
200
You add me where you want the next page to begin in the printed copy.
What are Breaks?
300
You can use it to visually compare values across a few categories.
What is a Column or Bar Chart?
300
To prevent unwanted changes from others by limiting their ability to edit.
What is Protect Sheet?
300
I can limit the type of data entered in a cell.
What is Data Validation?
400
What kinda of chart am I?
What is a Pie Chart?
400
Keep others from making structural changes like moving, deleting or adding sheets.
What is Protect Workbook?
400
I automatically fill in values.
What is Flash Fill?
500
You can use me to show the relationship between sets of values.
What are Scatter (X,Y) or Bubble Chart?
500
Password protection on ranges and by certain people.
What is Allow Edit Ranges?
500
Convert the selected cells to retrieve information on countries, regions, cities, populations, and more.
What is Convert to Geography?