Just the Basics
How do you start a new excel document
What is, File > New
How do you add the values of multiple cells?
Select the "AutoSum" function from the Home tab, then select the cells desired to add, and hit enter.
How do you filter data?
Select the cell or cells to be filtered, go to the "DATA" tab, in the "sort & filter" group select "Filter".
How do you save an excel document?
What is, File > Save
How do you find recently used formulas?
Go to the Formulas tab, select the drop down in the "functions library" group.
How do you Sort data
Select the cells to be sorted, go to the "DATA" tab, under the "sort & filter" group select "SORT" or select the "A>Z" or "Z-A" options. (Sort gives more detailed sorting options, the other two are the basics)
How do you change the font of a cell?
Highlight desired cell, select the "home" tab, select the font desired from the drop down in the font group.
How do you enter a formula to auto-update the date on a document?
Select the "date and time" drop down from the functions library group. Select "DATE", add the information in desired format for the current date, hit enter. Excel will automatically update on different dates.
What is "Flash Fill"
Flash fill automatically fills in values based on examples you entered in the row are column prior.
How do you merge multiple cells to be one?
Select all cells desired to be one, Select "merge and center" in the Alignment group on the Home tab
What are the ways you can edit a formula?
In the formula bar below the ribbon or by selecting the cell the formula is in and double clicking the mouse.
How do you check for duplicates in a spreadsheet?
Highlight the data you want evaluated, select the "DATA" tab, go to the "data tools" group, select "Remove Duplicates"
How do you apply a Title Cell Style?
What is the function titled to return "true" in a "true or false" argument.
"AND" function checks if all arguments are true and returns TRUE if all arguments are true.
How do you import data from an external source?
Under the "DATA" tab select "Get Data" from the "get and transform data" group. Choose which type of file you are importing data from, then follow the prompts to import.