Whether you've landed a job interview for a role that requires basic Microsoft Excel skills or you're looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to verify that you understand the fundamentals of this popular spreadsheet software.
This is the first in a three-part series. The second (intermediate) and third (advanced) will be coming soon.
Lied On Your Resume About Excel Expertise? 8 Concepts You Need to Learn Right Now A quick overview of Microsoft Excel's essential features.
Beginner Tasks ----------------The following 15 tasks cover these areas: renaming worksheets, working with Excel tables, using simple functions, entering and formatting data, applying conditional formatting, searching and replacing values, and inserting and editing charts.
Open the downloaded workbook and complete the following tasks:
1 | Rename the worksheet "Player\_Database." | Help |
2 | Format cells A1 to G21 as a purple Excel table with a header row, alternating row colors, and filters, and name the table "Scores." | Help |
3 | In cell G2, use a formula to calculate the sum of the scores in cells D2, E2, and F2, and make sure the formula is copied to all remaining cells down to G21. | Help |
4 | Sort the data by column G in descending order. | Help |
5 | Add a total row at row 22, and show the average overall scores to one decimal place in cell G22, and remove the text in cell A22. | Help |
6 | Create a conditional formatting rule that fills light green in all cells in column G that have total values greater than the average. | Help |
7 | Replace every instance of "ENG" in column C with "GBR" using a single command. | Help |
8 | Create a 2D clustered column chart on the same worksheet with Player\_Name (column A) on the x-axis and Total (column G) on the y-axis. | Help |
9 | Resize the chart so it spans from cell I4 to P19. | Help |
10 | Change the chart title to "Player Scores," and add the horizontal axis label "Total Score." | Help |
11 | Extend the table down by one row and enter the player name "Harry" into cell A22. | Help |
12 | Type 21 into cell B22, nation SPA into cell C22, and 30 into cells D22, E22, and F22 respectively. | |
13 | Reapply the descending sort order in column G. | Help |
14 | In cell I1, type Total players, and in cell J1, use a formula that counts the number of players in column A and updates automatically when players are added or removed. | Help |
15 | In cell I2, type Older than 40, and in cell J2, use a formula that counts how many players in column A are aged 41 or older. | Help |
Related ##### The Beginner’s Guide to Excel’s Formulas and Functions
Everything you need to know about Excel's engine room.
1 Download a free copy of the How-To Geek Beginner Excel Test Solutions PDF and a sample Excel file containing all the completed tasks. After opening these links, click the download button located in the top-right corner of the window. The solutions provided may not be the only way to tackle the problems.The above is the detailed content of Microsoft Excel Essential Skills Test. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Quick Links Parentheses: Controlling the Order of Opera

This guide will walk you through how to customize, move, hide, and show the Quick Access Toolbar, helping you shape your Outlook workspace to fit your daily routine and preferences. The Quick Access Toolbar in Microsoft Outlook is a usefu

Want to insert dates quickly in Outlook? Whether you're composing a one-off email, meeting invite, or reusable template, this guide shows you how to add a clickable date picker that saves you time. Adding a calendar popup to Outlook email

Whether you've secured a data-focused job promotion or recently picked up some new Microsoft Excel techniques, challenge yourself with the How-To Geek Intermediate Excel Test to evaluate your proficiency!This is the second in a three-part series. The

Quick LinksWhy Deleting Filtered Rows Crashes ExcelSort the Data First to Prevent Excel From CrashingRemoving rows from a large filtered range in Microsoft Excel can be time-consuming, cause the program to temporarily become unresponsive, or even lea

More and more users are enabling dark mode on their devices, particularly in apps like Excel that feature a lot of white elements. If your eyes are sensitive to bright screens, you spend long hours working in Excel, or you often work after dark, swit

Whether you've landed a job interview for a role that requires basic Microsoft Excel skills or you're looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to verify that you understand the fundamentals of this popular sprea

Ever played the "just one quick copy-paste" game with Google Sheets... and lost an hour of your life? What starts as a simple data transfer quickly snowballs into a nightmare when working with dynamic information. Those "quick fixes&qu
