Exit this survey
Microsoft Excel 2007
1. Please answer the following questions. Thank You.
*
1
. Name
Name
2
. Department
Department
*
3
. Contact Number
Contact Number
4
. To insert a new column, you use the commands in the Cells group on the Home tab. (Pick one answer.)
To insert a new column, you use the commands in the Cells group on the Home tab. (Pick one answer.)
True
False
5
. Where is the button that you click to find commands to open and close your files? (Pick one answer.)
Where is the button that you click to find commands to open and close your files? (Pick one answer.)
On the first tab.
In the upper-left corner of the window.
Underneath the Ribbon.
6
. If you save a file that was created in a previous version of Excel as an Excel 2007 file, the file can use all the new Excel features. (Pick one answer.)
If you save a file that was created in a previous version of Excel as an Excel 2007 file, the file can use all the new Excel features. (Pick one answer.)
True
False
7
. You need a new workbook. How do you create one? (Pick one answer.)
You need a new workbook. How do you create one? (Pick one answer.)
In the Cells group, click Insert, and then click Insert Sheet.
Click the Microsoft Office Button, and then click New. In the New Workbook window, click Blank workbook.
In the Cells group, click Insert, and then click Workbook.
8
. In a new worksheet, you must start by typing in cell A1. (Pick one answer.)
In a new worksheet, you must start by typing in cell A1. (Pick one answer.)
True
False
9
. Pressing ENTER moves the selection one cell to the right. (Pick one answer.)
Pressing ENTER moves the selection one cell to the right. (Pick one answer.)
True
False
10
. To enter the months of the year without typing each month yourself, you’d use which of the following? (Pick one answer.)
To enter the months of the year without typing each month yourself, you’d use which of the following? (Pick one answer.)
AutoComplete.
AutoFill.
CTRL+ENTER.
11
. To add a new row, click in a cell immediately above where you want the new row. (Pick one answer.)
To add a new row, click in a cell immediately above where you want the new row. (Pick one answer.)
True
False
12
. What do you type into an empty cell to start a formula? (Pick one answer.)
What do you type into an empty cell to start a formula? (Pick one answer.)
*
(
=
13
. How does an absolute cell reference work? (Pick one answer.)
How does an absolute cell reference work? (Pick one answer.)
The cell reference automatically changes when the formula is copied down a column or across a row.
The cell reference is fixed.
The cell reference uses the A1 reference style.
14
. If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5? (Pick one answer.)
If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5? (Pick one answer.)
=C5*$D$9
=C4*$D$9
=C5*$E$10
15
. What does #### mean? (Pick one answer.)
What does #### mean? (Pick one answer.)
The column is not wide enough to display the content of the cell.
The cell reference is not valid.
You have misspelled a function name or used a name that Excel doesn’t recognize.
16
. Which function would you use to find the date that falls after a number of workdays? (Pick one answer.)
Which function would you use to find the date that falls after a number of workdays? (Pick one answer.)
NETWORKDAYS
WORKDAY
TODAY
17
. You’ve created a chart. Now you need to compare data another way. To do this, you must create a second chart. (Pick one answer.)
You’ve created a chart. Now you need to compare data another way. To do this, you must create a second chart. (Pick one answer.)
True
False
18
. You can’t change the chart type after you create a chart. (Pick one answer.)
You can’t change the chart type after you create a chart. (Pick one answer.)
True
False
19
. What are PivotTable fields? (Pick one answer.)
What are PivotTable fields? (Pick one answer.)
Columns from the source data.
The area where you pivot data.
The PivotTable report layout area.
20
. In the PivotTable Field List, you can tell which fields are already displayed on the report. (Pick one answer.)
In the PivotTable Field List, you can tell which fields are already displayed on the report. (Pick one answer.)
True
False
Powered by
SurveyMonkey
Create your own
free online survey
now!
Javascript is required for this site to function, please enable.