Excel Basics
Shortcut to create a table
What is CTRL + T?
To always use the same cell in a function or formula you need to do this to it.
What is make it absolute?
To quickly count all the entries in a table, turn on this table feature.
What is Total Row?
The function that will change cheryl little to Cheryl Little
What is proper?
Use this so users can only enter whole numbers between 1 and 5 in a cell range.
What is data validation?
Shortcut to make a cell reference absolute
What is FUNCTION 4?
Use this function so the current date always appears
What is TODAY or NOW?
Use this feature so your data is no longer in a table.
What is convert to a range?
The function that removes extra spaces between words?
What is TRIM?
Used to apply formatting based on specific criteria.
What is Conditional formatting?
Forces text onto a new line in a cell.
What is ATL + ENTER?
Use this function to count how many customers using the Last Name column
What is Count A?
Used to sort by more than one column
What is +Add Level?
The top of every column of data should contain this.
What is header?
The area at the bottom of a workbook where you can quickly view the sum or average of the selected cells
What is the status bar?
Pressing the CTRL + h key does this.
What is opens FIND & REPLACE?
To always have the current time displayed, use this function.
What NOW?
Sort on this to arrange your data according to the Icon set applied using Conditional formatting
What is Conditional Formatting Icon?
Function to remove nonprintable characters from text.
What is CLEAN?
Feature used to keep a portion of a worksheet on the screen when scrolling down or to the right.
What is Freeze Panes?
Shortcut to sum the cells above the current cell
What is ALT + =?
The first argument of this common function is a LOGICAL TEST that must contain a comparison operator (>, <, =, etc.)
What is the IF function?
Create this to sort seasons column by Fall, Winter, Spring and then Summer
What is Custom List?
This feature allows you to automatically fills your data when it senses a pattern .
What is Flash Fill?