Excel Level 2
Excel 2007 level 2 after 2-day class
- 1.
When you try to move this graphic further to the right you find that the 3 parts don’t stay together. What must you do if you want to move them as a single unit?
- A.
A. layer them
- B.
B. ungroup them
- C.
C. rotate and layer them
- D.
D. group them
Correct Answer
D. D. group them -
- 2.
Clicking and dragging the small black square located in the lower right corner of the cell.
- A.
A. moves the data
- B.
B. copies/fills a series of information
- C.
C. selects the cells
- D.
D. adds a border to the cell(s)
Correct Answer
B. B. copies/fills a series of information -
- 3.
You enter “Quarter 1” in cell B1, as shown in the graph below. Then you need to create headings for subsequent quarters in C1, D1, and E1. Which one action should you take?
- A.
A. Choose Fill and then Right
- B.
B. Drag the fill handle to cell E1
- C.
C. Copy B1, and then paste the copied content into C1:E1.
- D.
D. Copy B1, and then use the Paste Special command to paste the copied formulas and number formats into C1:E1
Correct Answer
B. B. Drag the fill handle to cell E1 -
- 4.
If you create a workbook from an Excel template called “Embassy Guests,” the default file name of the workbook will be
- A.
A. Embassy Guests.xltx
- B.
B. Book 1.xlsx
- C.
C. Embassy Guests 1.xlsx
- D.
D. None of the above
Correct Answer
C. C. Embassy Guests 1.xlsx -
- 5.
Which of the following is an acceptable name for a range of cells?
- A.
A. Q1
- B.
B. Quarter 1
- C.
C. Qtr 1
- D.
D. Quarter_1
Correct Answer
D. D. Quarter_1 -
- 6.
Which function displays the current date?
- A.
A. =current_date
- B.
B. Now=today
- C.
C. =now()
- D.
D. =now!
Correct Answer
C. C. =now() -
- 7.
Which type of chart shows the relation of the parts to the whole?
- A.
A. Line
- B.
B. Pie
- C.
C. Bar
- D.
D. Column
Correct Answer
B. B. Pie -
- 8.
Which feature would not be represented well by a pie chart?
- A.
A. Negative values
- B.
B. Two categories
- C.
C. One series of data
- D.
D. Four categories
Correct Answer
A. A. Negative values -
- 9.
What does the PROPER function do?
- A.
A. Converts a text string to uppercase
- B.
B. Converts text to block capital letters
- C.
C. converts the first letter of each word to uppercase and all other letters to lowercase
- D.
D. Converts a text string to sentence case
Correct Answer
C. C. converts the first letter of each word to uppercase and all other letters to lowercase -
- 10.
Which of the following functions would you use to convert text from uppercase to title case?
- A.
A. Upper
- B.
B. Proper
- C.
c. Lower
- D.
D. Substitute
Correct Answer
B. B. Proper -
- 11.
What function looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify?
- A.
A. Lookup
- B.
B. Hlookup
- C.
C. Proper
- D.
D. Vlookup
Correct Answer
D. D. Vlookup -
- 12.
To autofit a selection for a column you should
- A.
A. Right-click the column letter
- B.
B. Triple-click between the column headings
- C.
C. Double-click between the column headings
- D.
D. Click and drag to widen the column
Correct Answer
C. C. Double-click between the column headings -
- 13.
An Excel table currently spans the range A3:E9, as shown in this graphic below. What feature is not being used in this table?
- A.
A. Header row
- B.
B. Banded columns
- C.
C. Total row
- D.
D. Banded rows
Correct Answer
B. B. Banded columns -
- 14.
An Excel workbook contains many occurrences of the word July. You need to replace each occurrence of the word July with the word August. In the Editing group on the Home tab, what should you do?
- A.
A. Use the Find command. Set the Find What criteria to July. In the Within list, click Workbook. Click Find.
- B.
B. Use the Replace command. Set the Find What criteria to July and the Replace With criteria to August. Click Replace All.
- C.
C. Use the Replace command. Set the Find What criteria to July and the Replace With criteria to August. In the Within list, click Workbook. Click Find All.
- D.
D. Use the Replace command. Set the Find What criteria to July and the the Replace With criteria to August. In the Within list, click Workbook. Click Replace All.
Correct Answer
D. D. Use the Replace command. Set the Find What criteria to July and the the Replace With criteria to August. In the Within list, click Workbook. Click Replace All. -
- 15.
You need to create a formula that, for each project, will calculate the number of days the project lasted. You will create the formula in cell E2 and fill it from E2 to E5. Which formula should you use?
- A.
A. =D2-C2
- B.
B. =C2-D2
- C.
C. =$D$2-$C$2
- D.
D. =length(C2-D2)
Correct Answer
A. A. =D2-C2 -
- 16.
What are ALL of the differences between the two charts shown below?
- A.
A. Chart A has a Legend but Chart B does not.
- B.
B. Data Labels, a Title, and a Legend have been added to Chart B.
- C.
C. The Expenses Title appears on Chart B.
- D.
D. Data Labels and a Title have been added to Chart B.
Correct Answer
D. D. Data Labels and a Title have been added to Chart B. -
- 17.
What is a Pivot Table?
- A.
A. A table that displays all data for successive items as a running total
- B.
B. A table that extracts data from a fill series
- C.
C. An interactive worksheet table that you create from a 3D chart or an Area chart
- D.
D. An interactive worksheet table that you use to summarize and analyze large amounts of data quickly
Correct Answer
D. D. An interactive worksheet table that you use to summarize and analyze large amounts of data quickly -
- 18.
Choose one set of items that can all be placed in a cell:
- A.
A. chart, hyperlink, pivot table
- B.
B. hyperlink, data, chart
- C.
C. data, formula, hyperlink
- D.
D. formula, chart, range
Correct Answer
C. C. data, formula, hyperlink -
- 19.
What function looks for a value in the top row of a table, and then returns a value in the same column from a row you specify?
- A.
A. Hlookup
- B.
B. Lookup
- C.
C. Proper
- D.
D. Vlookup
Correct Answer
A. A. Hlookup -
- 20.
Which part of a chart indicates what color or pattern is being used to represent a particular data series?
- A.
A. format
- B.
B. X axis and Y axis
- C.
C. area
- D.
D. legend
Correct Answer
D. D. legend -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 22, 2013Quiz Edited by
ProProfs Editorial Team -
Jan 12, 2011Quiz Created by
Tanoueas
Back to top