Page Layout
Home
Insert
Formula
Data
100
This uses a set of fonts, colors, and effects to create a consistent look and feel.
What is Theme.
100
This keyboard shortcut allows you to paste text and images.
What is ctrl+v ?
100
This is how you add an image.
What is insert picture from an online source?
100
Use this function to add the values in cells.
What is SUM functions?
100
Get the latest data by doing this to all the sources in the workbook.
What is Refresh All?
200
This allows you to change the page from portrait to landscape.
What is Orientation.
200
Calibri, Arial, Comic Sans are just some of these.
What are Fonts?
200
Use this to quickly access web pages and files or to take you to places in your document.
What is Hyperlink?
200
Press this key and this key on your keyboard for insert function.
What is Shift + F3?
200
Find values quickly, A to Z or Z to A by doing this?
What is Sort?
300
Change your Gridlines and Headings here.
What are Sheet Options?
300
You can't split an individual cell, but you can make it appear as if a cell has been split by doing this.
What merging the cells above it?
300
Click this button after selecting data on your worksheet to get a customized set of this that will best fit your data.
What is Recommended Charts?
300
Choose this to create, edit, delete and find all the names used in a workbook.
What is the Name Manager?
300
Choose this to separate a column full of names into separate last names and first names columns.
What is Text to Columns?
400
Add this where you want the next page to begin in the printed copy.
What is Page Break?
400
Format your dollars, Euros or other currency here.
What is Accounting Number Format?
400
Easily arrange and summarize complex data in this.
What is a Pivot Table?
400
Use this to check for common errors that occur when using formulas
What is Error Checking?
400
This allows you to temporarily hide some of the data in a table, so you can focus on the data you want to see.
What is Filter?
500
When your worksheet is more than one printed page, you can label data by adding row and column headings that will appear on each print page.
What is Print Titles?
500
Found in Editing, this removes everything in the cell or just removes formatting, contents, comments, or hyperlinks.
What is Clear?
500
Place these minicharts in a single cell to represent a section of your data.
What is a Sparkline?
500
Add cells to this list when you want to keep an eye on their values as you update other parts of the sheet.
What is the Watch Window?
500
Do this to restrict the type of data or the values that a user enters into a cell.
What is Data Validation?