Name and Auditing
Display the formulas in the worksheet
Go to the formulas tab in the formula auditing group select the show formulas button
Apply currency format to selected cells
Home tab, number group drop down and select currency
How do you Autofit a column?
Double click the right column boundary
Enter a formula to show the value of cell G7 in cell B4
Select cell B4 type =G7
Use a formula to show todays date in cell A23
Select cell A23 type =TODAY (either tab or double click) enter, or formulas tab function library group Date & Time then Today and ok
Show the tracer arrows to show what cells precede (are used in) the formula in cell C6
Select cell C6 on the formulas tab in the formula auditing group select the Trace Precedents button
Use the format painter to copy formatting from cell A1 to B1
Select cell A1, home tab, clipboard group, format painter then select cell B1
How would you insert a column to the left of column B?
Insert button on home tab in cells group then insert sheet column, or right click column B and select insert
How could we easily calculate the total of cells C5:E9?
=SUM(C5:E9)
How would a formula look that is showing the value of a cell in another worksheet look? Say we are using Cell C7 from the Rates sheet.
=Rates!C7
There is an error in cell A7. Accept Excel's suggestion to fix the error.
Click into cell A7, select the trace error button (exclamation point) select the first clickable option
Change the Rates sheet tab color to standard color orange
Right click worksheet tab hover on tab color, select orange
Change the width of column A&B to 32
Select the columns then right click and select column width, or select format on home tab in cells group and select column width, then type 32 and click ok.
What formula would you use to count a group of numbers in a range? What would you use to count a group of words in a range?
Numbers COUNT, Words COUNTA
If you were manually typing in a function how would you separate each argument, or nonadjacent cells?
Use a comma
Create named ranges for the data table B9:D13 using the text in row 8 for the names.
Select B8:D13 on the formulas tab in the defined names group use the create from selection. Select top row and click okay.
Add the File Name Element to the right section of the header
Page layout view from status bar (or insert tab, text group, header footer) click into right hand section from header and footer elements click file name
Hide Column H
Right click E and select hide. Select column E then drop down format button on home tab in cells group hover over hide and unhide click hide columns.
What formula would you use if in cell D5 you want it to show VIP if the value in cell C5 is greater than or equal to 5 and Not Yet if it is not. And what would be the logical test?
You would us IF. C5>=5
What are the two formulas that will allow you to string text together? What is the difference between the two?
TEXTJOIN and CONCAT. Text join has a delimiter that will be put between each line of text. CONCAT you are able to add something different between each line of text.