Quiz Summary
0 of 35 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 35 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
- 35
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 35
1. Question
Merge & Align Right the content in cells A2 through D2 in the June worksheet.
-
Select the merge cells in A2:D2
-
In the June worksheet, select cells A2:D2
-
In the Home tab, locate the Alignment group, and click Align Text Right
-
In the Home tab, locate the Alignment group
-
Click Merge & Center
View Answers:
CorrectIncorrect -
-
Question 2 of 35
2. Question
Apply the style Heading 3to the title Blackbread Books.
-
Select the title Blackbread Books
-
Click the Cell Styles/More drop down button
-
In the Home tab, locate the Styles group
-
In the drop down, under the Titles and Headings section, select Heading 3
View Answers:
CorrectIncorrect -
-
Question 3 of 35
3. Question
Create a new worksheet based on the Expense Report sample template.
-
Click the File tab, select New
-
Clck Create
-
Select Expense Report, from the list of templates
View Answers:
CorrectIncorrect -
-
Question 4 of 35
4. Question
Change the theme of the current worksheet to Ion.
-
Locate the Themes group
-
Click Themes
-
Select Ion from the dropdown
-
In the Page Layout tab
View Answers:
CorrectIncorrect -
-
Question 5 of 35
5. Question
Add the title Average to column H.
-
Type Average.
-
Select the cell H3
View Answers:
CorrectIncorrect -
-
Question 6 of 35
6. Question
Without using the averagefunction, create a formula in the cell H4 that gets the SUM of the values in the cell E4 through G4and divides the sum by three.
-
Type =SUM(E4:G4)/3
-
Select the cell H4
View Answers:
CorrectIncorrect -
-
Question 7 of 35
7. Question
Copy the formula in cell H4 to cells H5:H33.
-
Select Down
-
Select cells H4:H33
-
In the Home tab, locate the Editing group
-
Click Fill
View Answers:
CorrectIncorrect -
-
Question 8 of 35
8. Question
In the June worksheet, in cells E4:E33 use the IF formula to display a 1 if the values of the cells D4:D33 are greater than 2500, and a 0 if it is less than or equal to 2500.
-
In the dialog box select the IF function and click Ok
-
In the Formulas tab, go to the Function Library and click Insert Function
-
Go to the Editing group and click Fill and select Down
-
Highlight the cells E4: E33 and in the Home tab
-
In the new window for: Logical_test enter: D4>2500 and for Value_if_true: 1, and Value_if_false: 0 and click Ok
-
In the June worksheet, highlight the cell E4
View Answers:
CorrectIncorrect -
-
Question 9 of 35
9. Question
Hide column A.
-
Select Hide from the menu
-
Right click on Column A
View Answers:
CorrectIncorrect -
-
Question 10 of 35
10. Question
Freeze the first column in the current spreadsheet.
-
Click the Freeze Panes drop down menu
-
In the View tab, locate the Window group
-
Click Freeze First Column
View Answers:
CorrectIncorrect -
-
Question 11 of 35
11. Question
Change the format of the cell containing the company name FusionTomo Inc. to the cell style Title.
-
Click Title under the Titles and Headings section
-
In the Home tab, locate the Styles group
-
Click Cell Styles
-
Select the title cell
View Answers:
CorrectIncorrect -
-
Question 12 of 35
12. Question
Apply the Built-in theme Ion to the current worksheet.
CorrectIncorrect -
Question 13 of 35
13. Question
Save this spreadsheet as a PDF file named EXCEL05 in the GmetrixTemplates folder. Do not open the file after publishing.
-
Click Create PDF/XPS
-
Navigate to the GMetrixTemplates folder, and enter EXCEL05 in the File name: box.
-
Make sure PDF is selected for the Save as type
-
Click Publish
-
In the File tab, select Export
-
Uncheck the Open File After Publishing option if needed
View Answers:
CorrectIncorrect -
-
Question 14 of 35
14. Question
In the Annual Sales worksheet, Sort the data in the cell range A5:F15 by the Total column and order the values by largest to smallest.
-
In the Home tab, locate the Editing group, click Sort & Filter and in the drop down menu click Custom Sort
-
In the Annual Sales worksheet, select the cell range A5:F15
-
In the Sort by row, select the Total column, sort on Values, order Largest to Smallest, and click Ok
View Answers:
CorrectIncorrect -
-
Question 15 of 35
15. Question
In cell B18, enter a cell reference to cell A7.
-
Click in cell A7, and hit Enter
-
Click cell B18
-
Type a function by typing =
View Answers:
CorrectIncorrect -
-
Question 16 of 35
16. Question
Apply a conditional formatting to the values in columns E, F, and G. Apply ayellow fill to any cells with a value equal to 5.
-
In the dialog box, enter 5, in the first section and in the drop down menu next to it select Custom Format.
-
Highlight the columns E, F and G.
-
In the dialog box, click the Fill tab, select Yellow and click Ok twice.
-
In the Home tab locate the Styles group, click Conditional Formatting and in the drop down menu click Highlight Cell Rules and click Equal To…
View Answers:
CorrectIncorrect -
-
Question 17 of 35
17. Question
Filter the data so that only the people with a position of Developer are displayed.
-
Select the cell range A3:G33.
-
In C3 click the drop down next to Position. In the drop down, unselect all the check boxes except Developer, and click Ok.
-
In the Data tab, locate the Sort & Filter group and click Filter
View Answers:
CorrectIncorrect -
-
Question 18 of 35
18. Question
In Annual Salesworksheet, insert a columnSparkline in the cell G6that references the data in the cells B6 through E6.
-
Locate the Sparkline group, and click Column.
-
Highlight cell G6. in the Insert tab
-
In the dialog box for the Data Range field enter: B6:E6 and click Ok.
View Answers:
CorrectIncorrect -
-
Question 19 of 35
19. Question
In the June worksheet, enter a formula in cell B34 that will get the SUM of the cell range B4:B33. Copy the formula to columns C and D.
-
Select cell B34. In the Formulas tab
-
In the dialog box click SUM and click Ok
-
Select cells B34:D34. In the Home tab, locate the Editing group, select Fill, and click Right
-
Locate the Function Library group, and click Insert Function
-
Enter B4:B33 in the Number1 area and click Ok
View Answers:
CorrectIncorrect -
-
Question 20 of 35
20. Question
In the Totals worksheet in column B, enter a cell reference to the matching Totals values from the June worksheet.
-
In the Totals worksheet, select cell B4 and type = to begin a formula
-
In the June worksheet, select cell C34, and hit enter. The contents of Cell B3 in the Totals worksheet should read, =June!C34
-
In the Totals worksheet, select cell B2 and type = to begin a formula
-
In the June worksheet, select cell B34, and hit enter. The contents of Cell B2 in the Totals worksheet should read, =June!B34.
-
In the June worksheet, select cell D34, and hit enter. The contents of Cell B4 in the Totals worksheet should read, =June!D34
-
In the Totals worksheet, select cell B3 and type = to begin a formula
View Answers:
CorrectIncorrect -
-
Question 21 of 35
21. Question
Change the chart in the Totals worksheet to the 3-D Pie type.
-
Click Ok
-
In the Chart Design contextual tab, locate the Type group, and click Change Chart Type
-
In the dialog box, click on Pie, and select 3-D Pie
-
In the Totals worksheet, select the chart.
View Answers:
CorrectIncorrect -
-
Question 22 of 35
22. Question
In the Time Cardworksheet, insert the image ftlogo.gif, from the GmetrixTemplates folder, at the top of this worksheet.
-
Click Pictures
-
Click Insert
-
Click at the top of the worksheet. In Insert tab, locate the Illustrations group
-
Locate your folder inside your documents folder, select ftlogo.gif
View Answers:
CorrectIncorrect -
-
Question 23 of 35
23. Question
Add a Dark Blue border to the image.
-
Locate the Picture Styles group
-
Click Picture Border, and in the drop down select Dark Blue
-
Select the image. in the Picture Format contextual tab
View Answers:
CorrectIncorrect -
-
Question 24 of 35
24. Question
Change the Theme to Office.
-
Go to the Themes group
-
In the Page Layout tab
-
Click Themes and in the drop down click Office.
View Answers:
CorrectIncorrect -
-
Question 25 of 35
25. Question
In the Source Data worksheet use find & select to find the cell that contains Data Validation, and clear the validation.
-
With cell B2 selected, click the Data tab, locate the Data Tools group, select Data Validation and click Data Validation…
-
In the dialog box, click Clear All, then click OK.
-
Click the Find & Select dropdown, and click Data Validation
-
In the Source Data worksheet, in the Home tab, locate the Editing group
View Answers:
CorrectIncorrect -
-
Question 26 of 35
26. Question
In the Source Data worksheet Unhide any hidden rows.
-
With all the cells of the table selected, in the Home tab, locate the Cells group
-
click Format, and under Visibility in the Hide & Unhide menu select Unhide Rows
-
Select all the cells by using Ctrl+A, or the Select All Button at the top left of the excel sheet.
View Answers:
CorrectIncorrect -
-
Question 27 of 35
27. Question
Change the options on this worksheet so that Gridlinesare visible.
-
Check the Gridlines box
-
Locate the Show group
-
In the View tab
View Answers:
CorrectIncorrect -
-
Question 28 of 35
28. Question
Change the margins to the Narrow setting.
-
Select Narrow
-
Locate the Page Setup group
-
Click the Margins dropdown
-
In the Page Layout tab
View Answers:
CorrectIncorrect -
-
Question 29 of 35
29. Question
In the Annual Sales worksheet, in cell B17 use the COUNTIF function to count the number of times that the values in cell range B6:B15 exceed 5000.
-
Click Insert Function.
-
Select cell B17. In the Formulas tab, locate the Function Library group
-
Type COUNTIF in the Search for a Function field
-
In the Range field, type B6:B15, and in the Criteria field, type >5000
-
Select COUNTIF from the results and click OK
-
Click OK
View Answers:
CorrectIncorrect -
-
Question 30 of 35
30. Question
Insert the Basic Process SmartArtgraphic below the data in this worksheet.
-
Click SmartArt
-
Select Basic Process from the Process section.
-
Click OK
-
Select any cell below the data
-
In the Insert tab, locate the Illustrations group
View Answers:
CorrectIncorrect -
-
Question 31 of 35
31. Question
In the Product worksheet insert a Line Sparkline into cell F33 that references the data in cells B33 through E33.
-
Select cell F33
View Answers:
CorrectIncorrect -
-
Question 32 of 35
32. Question
Use Fill to copy the Sparklinefrom cell F33 to F8:F32.
-
Select the range F8:F33
-
Select the Fill dropdown, and select Up
-
In the Home tab, locate the Editing group
View Answers:
CorrectIncorrect -
-
Question 33 of 35
33. Question
Apply Gradient Fill-Green Data Barconditional formatting to the values in column E.
-
In the Home tab, locate the Style group
-
Click Data Bars, select Gradient Fill and click Green Data Bar.
-
Select Conditional Formatting
-
Select column E. by clicking the E above Cell E1.
View Answers:
CorrectIncorrect -
-
Question 34 of 35
34. Question
Unmerge any merged cells in row 2 of the Review worksheet.
-
In the Home tab, locate the Alignment group
-
Select row 2 by clicking on the 2 to the left of Cell A2
-
Click Merge and Center to remove the merges already in place.
View Answers:
CorrectIncorrect -
-
Question 35 of 35
35. Question
Format cells A3:G33 as a table using Table Style Light 2.
-
Select the range A3:G33
-
Click OK to create the table
-
Click Format As Table, and select Table Style Light 2
-
In the Home tab, locate the Styles group
View Answers:
CorrectIncorrect -