Quiz Summary
0 of 34 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 34 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 34
1. Question
On the Qtr 1 worksheet, how do you use the data contained only in the Entries and Total columns to create a 2D Pie chart. Position the new chart below the table?
-
Click and drag the new chart and position it to be below the table
-
Click the Insert tab
-
In the Charts group, click the Insert Pie or Doughnut Chart icon and select 2D Pie
-
While holding down the Control key, select cell range E2:E10
-
On the Qtr 1 worksheet, select cell range A2:A10
View Answers:
CorrectIncorrect -
-
Question 2 of 34
2. Question
On the Qtr 2 worksheet, convert cell range A2:E10 to a table with headers. Apply Red, Table Style Light 14.
-
On the Qtr 2 worksheet, select cell range A2:E10
-
Under the Light section, click Red, Table Style Light 14
-
In the Format As Table pop-up window, do the following: – Confirm the data field contains =$A$2:$E$10. – Confirm the My table has headers box is enabled. – Click OK.
-
On the Home tab, in the Styles group, click Format as Table to open the gallery
View Answers:
CorrectIncorrect -
-
Question 3 of 34
3. Question
Apply Layout 2 to the bar chart on the Qtr 1 worksheet.
-
On the Chart Tools Design tab, in the Chart Layouts group
-
Click Quick Layout and select Layout 2
-
On the Qtr 1 worksheet, click anywhere on the bar chart to select it
View Answers:
CorrectIncorrect -
-
Question 4 of 34
4. Question
On the Employee Bonuses worksheet, insert a mixed reference in cell F4 so that the formula will correctly calculate the commission when copied from F4 through F11. Copy the reference down the column to verify it calculates correctly.
-
Click and drag the fill handle in the lower-right corner of cell F4 down the Commission column, beginning with cell F4 and ending with cell F11
-
On the Employee Bonuses worksheet, select cell F4
-
Insert the mixed reference =B$15*E4 in cell F4
View Answers:
CorrectIncorrect -
-
Question 5 of 34
5. Question
On the Employee Bonuses worksheet, use Autofill to copy the formula in cell G4 to calculate the Total Compensation for each employee.
-
In the lower-right corner of cell G4
-
On the Employee Bonuses worksheet, select cell G4
-
Click-drag the fill handle down the Total Compensation column, beginning with cell G4 and ending with G11
View Answers:
CorrectIncorrect -
-
Question 6 of 34
6. Question
On the Parts worksheet, remove the row containing the salesperson named Allen.
-
Click Open
-
Above the ribbon, click the Customize Quick Access Toolbar down arrow
View Answers:
CorrectIncorrect -
-
Question 7 of 34
7. Question
Add Open to the Quick Access Toolbar.
-
Click Open
-
Above the ribbon, click the Customize Quick Access Toolbar down arrow
View Answers:
CorrectIncorrect -
-
Question 8 of 34
8. Question
Add the value New Rates to the Title property of the document.
-
Click the return arrow in the upper-left corner of the Info window to return to the worksheet
-
Click the File tab
-
Locate the list of Properties on the right side of the Info page
-
In the Title property field, type New Rates
View Answers:
CorrectIncorrect -
-
Question 9 of 34
9. Question
Set cells A1:F10 so that they will be the only cells that print.
-
Select cell range A1:F10
-
Click Print Area and select Set Print Area
-
On the Page Layout tab, in the Page Setup group
View Answers:
CorrectIncorrect -
-
Question 10 of 34
10. Question
In the Qtr 1 worksheet, change the configuration of the Qtr 1 Location Revenue chart so that it displays the months on the x-axis and the revenue on the y-axis
-
Click the chart to reveal the Chart Tools tabs
-
On the Chart Tools Design tab, in the Data group, click Switch Row/Column
-
Click the Qtr 1 worksheet tab to select it
View Answers:
CorrectIncorrect -
-
Question 11 of 34
11. Question
Save the Rooms worksheet as a webpage named Rent_Prices.htm to the Gmetrix Templates folder.
-
In the left pane, select Save As, and browse to the GMetrixTemplates folder
-
In the Save As pop-up window, configure the following: File name: Rent_Prices Save as type: Web Page (*.htm, *.html)
-
Click Publish
-
Select the File tab
-
In the Publish as Web Page dialog box, select All Contents of Rooms
-
Under Save: select Publish
View Answers:
CorrectIncorrect -
-
Question 12 of 34
12. Question
On the Rooms worksheet, configure the heading row in the table (row 2) so that entries wider than the column wrap to multiple lines.
-
On the Rooms worksheet, select row 2
-
Click Wrap Text
-
-
On the Home tab, in the Alignment group
View Answers:
CorrectIncorrect -
-
Question 13 of 34
13. Question
On the Sold worksheet, insert a new column before column A.
-
Right-click on the column and select Insert
-
Click on the Sold worksheet
-
Select column A by clicking the A at the top of the column
View Answers:
CorrectIncorrect -
-
Question 14 of 34
14. Question
Split the view of the Sold worksheet so only rows 1 through 6 appear in the top pane and the remaining rows appear in the bottom pane
-
On the View tab, in the Window group
-
On the Sold worksheet, select row 7
-
Click Split
View Answers:
CorrectIncorrect -
-
Question 15 of 34
15. Question
Configure the Vehicles worksheet so rows 1 through 3 remain visible as you scroll vertically.
-
Click the Freeze Panes down arrow and select Freeze Panes
-
On the View tab, in the Window group
-
On the Vehicles worksheet
-
Select row four
View Answers:
CorrectIncorrect -
-
Question 16 of 34
16. Question
On the Sold worksheet, format the table so that every other row is shaded similar to the table on the Vehicles worksheet. Use a technique that automatically updates the formatting if you insert a new row.
-
On the Table Tools Design contextual tab, in the Table Styles Options group
-
Click the Banded Rows box
-
On the Sold worksheet, click anywhere within the table to select it
View Answers:
CorrectIncorrect -
-
Question 17 of 34
17. Question
On the Vehicles worksheet, insert a function into cell B4 of the Code column that extracts the two leftmost letters of the vehicle style displayed in cell D4.
-
Click OK
-
In the Formula Bar, type =LEFT, then press the tab key on your keyboard
-
To the left of the Formula Bar, click fx to open the Function Arguments wizard
-
On the Vehicles worksheet, select cell B4
-
In the Function Arguments wizard, configure the following: Text: D4 Num_chars: 2
View Answers:
CorrectIncorrect -
-
Question 18 of 34
18. Question
On the Qtr 2 worksheet, in cell F10, insert a column sparkline showing the sales trend from Apr through Jun. Apply Gold, Sparkline Style Accent 2, Darker 25% to the sparkline. Copy the sparkline to the remaining cells in the column (F11:F14)
-
Select the Insert tab
-
Click OK
-
In the lower-right corner of the cell, click-drag the Fill Handle from cell F11 through cell F14 to create a sparkline for each location
-
Select cell F10 on the Qtr 2 worksheet
-
In the Sparklines group, click Column
-
On the Sparkline Tools Design tab, in the Style group, click the More down arrow to open the Style gallery. Select Gold, Sparkline Style Accent 2, Darker 25%
-
In the Create Sparklines pop-up window, configure the fields as follows: Data range: B10:E10 Location range: $F$10
View Answers:
CorrectIncorrect -
-
Question 19 of 34
19. Question
Using the Move Chart feature, move the pie chart on the Qtr 2 worksheet to its own chart sheet named Qtr 2 Chart.
-
On the Chart Tools Design contextual tab, in the Location group, click Move Chart
-
In the Move Chart pop-up window, select New sheet: and type the name Qtr 2 Chart
-
Click OK
-
On the Qtr 2 worksheet, click anywhere on the pie chart to select it
View Answers:
CorrectIncorrect -
-
Question 20 of 34
20. Question
On the Qtr 1 worksheet, apply a number format to display the numbers in columns B through E to two decimal places with the US Dollar symbol ($) left-aligned and the decimal points aligned.
-
On the Home tab, in the Number group, click the $ symbol (this will align the symbols).
-
On the Home tab, in the Number group, click the $ symbol (this will align the symbols).
View Answers:
CorrectIncorrect -
-
Question 21 of 34
21. Question
Display all of the formulas on the Qtr 2 worksheet
-
Click Show Formulas
-
On the Formulas tab, in the Formula Auditing group
-
On the Qtr 2 worksheet, select the Formulas tab
View Answers:
CorrectIncorrect -
-
Question 22 of 34
22. Question
On the Average Call Time worksheet, use an Excel feature to copy the sparkline into all the vacant cells of the Trend column.
-
Select cell G4
-
On the Average Call Time worksheet
-
In the lower-right corner of cell G4, click-drag the fill handle down the Trend column beginning with cell G4 and ending with cell G16
View Answers:
CorrectIncorrect -
-
Question 23 of 34
23. Question
On the Employee Hours worksheet, add a row to the table that automatically calculates the total hours worked by all employees
-
Click the Total Row
-
On the Table Tools Design tab, in the Table Style Options group
-
On the Employee Hours worksheet, click on any cell in the table to select the table
View Answers:
CorrectIncorrect -
-
Question 24 of 34
24. Question
Add a function to the Overtime column in cell H4 on the Employee Hours worksheet that will display the word Yes if the value in cell J4 is higher than 40. Otherwise, display the word No.
-
On the Employee Hours worksheet, click cell H4
-
In the Formula Bar, type =IF, then press the tab key on your keyboard
-
In the Function Arguments wizard, configure the following: Logical_test: J4>40 Value_if_true: Yes Value_if_false: No
-
To the left of the Formula Bar, click fx to open the Function Arguments wizard
-
Click OK
View Answers:
CorrectIncorrect -
-
Question 25 of 34
25. Question
In cell I4 of the Employee Hours sheet, use a function to copy the name from cell A4, and format the name so that all letters are uppercase.
-
To the left of the Formula Bar, click fx to open the Function Arguments wizard
-
In the Function Arguments wizard, configure the following: Text: A4
-
On the Employee Hours worksheet, select cell I4
-
Click OK
-
In the Formula Bar, type =UPPER, then press the tab key on your keyboard
View Answers:
CorrectIncorrect -
-
Question 26 of 34
26. Question
On the Average Call Time worksheet, create a 3-D Clustered Column chart that shows only the Call Time for Friday by each Salesperson. Position the new chart to the right of the table, and change the colors of the chart to Colorful Palette 4.
-
On the Chart Tools Design tab, in the Chart Styles group, click Change Colors and select Colorful Palette 4
-
On the Average Call Time worksheet, click the Insert tab
-
Under Horizontal (Category) Axis Labels, click Edit. Then select cells A4 through A16 and click OK twice
-
Move the chart to the right side of the table
-
In the Charts group, click the Insert Column Chart icon and select 3-D Clustered Column
-
In the Chart Tools Design tab, in the Data group, click Select Data
-
Enter the Chart Data Range: =Parts[Fri] and click the arrow at end of field twice
View Answers:
CorrectIncorrect -
-
Question 27 of 34
27. Question
In the Annual Sales worksheet, use the Find & Select tool to find the cell in the open spreadsheet that contains Conditional Formatingand apply a Thick Outside Border.
-
In the Home tab, go to the Editing group
-
With cell F16 selected in the Home tab, go to the Font group and click on the Borders drop down menu and select Thick Outside Borders
-
Click Find & Select drop down menu select Conditional Formatting
View Answers:
CorrectIncorrect -
-
Question 28 of 34
28. Question
Use the AutoSum tool to get the SUM of the values for each cell (B through F) in the Total row.
-
In the Home tab
-
Highlight cells B16:F16
-
Go to the Editing group and click AutoSum
View Answers:
CorrectIncorrect -
-
Question 29 of 34
29. Question
In the Review worksheet, use the CONCATENATE function to display the contents of cell B4 and A4 separated by a space in cell J4.
-
Highlight Cell J4, in the Formulas tab, go to the Function Library and click Insert Function
-
In the Text1 field enter: B4 in the Text2 field enter a Space. In the Text3 field enter: A4
-
In the dialog box inside the Search for a function box enter Concatenate. Click Go, and select from the list below
-
Click Ok
View Answers:
CorrectIncorrect -
-
Question 30 of 34
30. Question
In the June worksheet, apply Table Style Light 4 to the cells A3through D34.
-
Select cells A3:D34 in the June worksheet
-
In the drop down menu under the Light heading select Table Style Light 4
-
Click OK
-
In the Home tab, go to the Styles group and click the Format as Table drop down menu
View Answers:
CorrectIncorrect -
-
Question 31 of 34
31. Question
In the Annual Sales worksheet, apply a Linksto the title FusionTomo Inc. that links to the website www.fusiontomo.com.
-
Click OK
-
In the dialog box, in the Address text field enter: www.fusiontomo.com
-
In the Annual Sales worksheet, highlight the cell A1
-
In the Insert tab, locate the Links group and click link
View Answers:
CorrectIncorrect -
-
Question 32 of 34
32. Question
In cell range B16:F16 set the style of the cell with the following characteristics: Number Format = Currency, Font = Courier New, Fill Color= Yellow
-
Select the cell range B16:F16
-
In the Home tab, locate the Font group, click the Font drop down, and select Courier New
-
In the Home tab, locate the Font group, click the Fill Color drop down, and select Yellow
-
In the Home tab, locate the Number group, click the Number Format drop down, and select Currency
View Answers:
CorrectIncorrect -
-
Question 33 of 34
33. Question
In the Product worksheet, change the format of the numbers in cells B8:E33so that no decimal places are showing.
-
Click Decrease Decimal until there are no decimals on the numbers
-
In the Home tab, locate the Number group
-
Highlight the cells B8:E33
View Answers:
CorrectIncorrect -
-
Question 34 of 34
34. Question
Change the view to the split screen view.
-
Click Split
-
In the View tab
-
Locate the Window group
View Answers:
CorrectIncorrect -