Whether you have entered a job interview for a role that requires fundamental microsoft excel skills or you are looking to solve a real-world problem, how-how-to-revinner takes out the Excel test to double-check, which you know about the popular spreadsheet software nuts and bolts.
This is the first of the three-part series. The second (intermediate) and third (advanced) will be available soon.
Download a free copy of How-how Geek Initial Excel test Workbook. After clicking on the link, you will get the download button in the top-right corner of your screen. You can download the solution and a sample file through the link below this article.
Connected
Excelled about expertise on his own again? 8 concepts you need to learn now
A whistle-stop tour-nais of Microsoft Excel.
Initial work
The following 15 tasks cover these areas: changing the name of the worksheet, using excel table, using direct functions, using inputing and formatting data, applying conditional formatting, finding and replacing values, and inserting charts.
Open the downloaded workbook, and complete the following tasks:
|
1 |
Change the name of the worksheet “Player_database.” |
Help |
|
2 |
Forms a header row, banded rows, and a Purple Excel table with filters, format from A1 to G21 to G21, and name the table “score”. |
Help |
|
3 |
In cell G2, use a formula to calculate the sum of scores in cells D2, E2, and F2, and ensure that the formula is duplicated to the remaining cells, which is below G21. |
Help |
|
4 |
Sort data by column G in descending order. |
Help |
|
5 |
Add the total row to the row 22, and display the average overall score at a decimal location in cell G22, and remove the text in the cell A22. |
Help |
|
6 |
Make a conditional formatting rules that fill in light green color, which in the column G has a larger value than the average. |
Help |
|
7 |
Change all examples of “Eng” into the column C with “GBR” using the same command. |
Help |
|
8 |
Create a 2D cluster column chart on the same worksheet with total (column A) (column A) (column A) (column A) on the X-Axis and Y-Axis. |
Help |
|
9 |
Change the size of the chart so that it cover the cells from i4 to P19. |
Help |
|
10 |
Change the chart title to “player score” and add the horizontal axis title “total score”. |
Help |
|
11 |
Expand the table down a line, and add the player’s name “Harry” to the cell A22. |
Help |
|
12 |
Type 21 SAIL B22, in the nation Spa In SAIL C22, and 30 D22, E22, and F22 respectively in cells. |
|
|
13 |
Update the descending order in the column G. |
Help |
|
14 |
In SAIL i1, Type Total playerAnd in the cell J1, use a formula that counts the number of players in column A and updates whenever the players are added or removed. |
Help |
|
15 |
In SAIL I2, Type More than 40 oldAnd in SAIL J2, use a formula that counts the number of players in columns A which is 41 or older. |
Help |
Connected
Early guide for Excel formulas and functions
You have to know everything about Excel’s engine room.
