|Total of questions: 282|
|Total of questions: 282|
|First steps (21 questions)|
|Basic Settings (12 questions)|
|Cells 1 (24 questions)|
|Cells 2 (24 questions)|
|WorkSheets (10 questions)|
|Formulas and Functions (41 questions)|
|Formatting (28 questions)|
|Charts (24 questions)|
|Output: Setup and Print (21 questions)|
|Functions (14 questions)|
|Images (3 questions)|
|MS Excel 2016, 2013, 2010, 2007, 2003 (BENCHMARK) (30 questions)|
|MS Excel 2016, 2013, 2010, 2007, 2003 (ASSESSMENT) (30 questions)|
Change the type of the chart displayed on the active worksheet into 3D Clustered Column chart.
Create a pie chart (not exploded pie) on the 2ndhour2 worksheet. Accept the default settings. The pieces of the pie will represent the product and quantity data.
Set the text Sales per Product as title of the chart displayed on the 2ndhour2 worksheet.
Insert a 3-D column chart in the Contest2 sheet to display the sales of the four companies for August, as they appear on the SALES worksheet. Change the color of the columns to blue, the shape of the columns to Full Pyramids (2) and the chart depth to 150.
Set the fill color for the active chart to red.
Set the following fill effects in the active chart:
Gradient fill: color 1: red and color 2: White, Background 1
Type: Linear and
Direction: from red (top) to white (bottom).
The chart should not display any borders.
Change the color of the Series1 Data Series to red in the active chart.
Change the color of the active pie chart as follows:
RAM Memory to Black, Text 1
Hard Drive to Red,
Screen to White, Background 1
Copy the active chart and paste it to the SALES worksheet.
Move the active chart to the SALES worksheet.
Delete the active chart.
Increase the width of the chart area and decrease the height of it in dimensions of your choice.
Without changing the size of the active chart, move it so that the top left corner is in cell D15.
Create a chart using data from the cell range A5:E9 in line with markers type. Make sure the new chart is placed in a new worksheet.
Go to the computer worksheet and decrease the height of the chart without moving it, so that the contents of the cell range B15:C15 may appear.
Display the X (Primary horizontal) and Y (Primary vertical) axis of the chart.
Move the legend to the bottom of the chart of the spreadsheet 2ndhour2.
Select the chart of the active worksheet.
Change the fill color of the legend of the chart to red.
Change the font color of the legend to red and the font size to 12.
Display the value data labels of the active chart.
Display the percentage data labels on the active chart.
Match the most suitable chart type for each situation.
Change the color of the Gladbach column to red