Online Marketer's Excel Skills Test
Name: _____________________________ Date: ________________ Time for Test: 5 minutes (20 questions)
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.