Online Marketer's Excel Skills Test

Note - there are many ways to perform the same task in Excel. Please list the quickest, most efficient method.

• What is the keyboard shortcut for Paste?

• In what mode of Excel allows you to look at how a document is going to look when printed before actually printing.

• Which tool allows you to copy the formatting of one cell to another?

• Which formula is being described in the following Excel definition? "The _________ function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items."

• What are two ways in which you can select all of the cells in a spreadsheet?"

• True or False? You can set Excel to print the gridlines of the cells without having to create borders around each cell.

• How do you copy and paste just the value of one cell which is a formula into another cell?

• To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by using which Excel feature?

• Which formula is being described in the following Excel definition: "You can use the ________ function to search the first column of a range of cells, and then return a value from any cell on the same row of the range.

• Right click any cell and choose which feature to change the cell's shading, borders, font, etc?

• True or False? It is possible to insert an image into a spreadsheet?

• What is the shortcut for entering the current date into a cell?

• How do you quickly change a column width to fit the contents?

• True or False? By default, when the source data table of a pivot table is altered, those changes automatically are updated in the pivot table.

• In the formula, =SUM(F5+G8), what do you need to do to the formula so when you drag it down, the first value to be summed is still F5?

• What feature in Excel allows helps you autoformat cells based on rules? For example, "change the shading of all cells to red with values greater than 50".

• True or False? A macro allows you to look very close into a cell.

• Which feature in Excel allows you to displays only the rows that meet criteria that you specify and hides rows that you do not want displayed?

• Which feature allows you to reset the chosen range in alphabetical order?

• True or False? If you use a password to protect a worksheet, you have to enter it and then re-enter it for verification.