How can we help?
You can also find more resources in our
Select a category
Something is confusing
Something is broken
I have a suggestion
What is your email?
What is 1 + 3?
Excel 2010 Quiz 2
The process of finding and correcting errors in a worksheet.
Used to import data stored on a Web site.
Used to rename sheets; used by double-clicking the sheet tab in the lower-left corner of the window, type the new sheet name then press this.
Tab Scrolling Button
To move between worksheets. Located to the left of the sheet tabs.
E-mailing a workbook from Excel sends the workbook this way in the email.
Any application on this will automatically start when you turn your computer on.
The copy button copies the contents and formats of the source area to this reserved place in the computer's memory.
Button on the Ribbon or a command on the shortcut menu which removes cells (including the data and format) from the worksheet.
Freeze the Titles
Allowed to be done so that Excel displays the titles on the screen, no matter how far down or to the right you scroll.
A formula using this type of cell reference for B20 instructs Excel to adjust the cell reference as it copies it to the destination area.
Aways begins with the # symbol.
IF function is one in which the action to be taken for the true or false case includes yet another IF function.
Used to format the legend on the chart.
Unless you first select a range of cells or an object before starting the spell checker, Excel checks this selected item.
Used if you know the results you want a formula to produce; also used to determine the value of a cell on which the formula depends.