Skip to content

Functions Path Playground Leaderboard Blog

fx

ABCD

1

2

3

4

5

Loading…

Free, hands-on Excel practice in a real spreadsheet. Learn by doing, not by watching.

Practice

All exercises
Start with SUM
Learning path
Playground
Keyboard shortcuts
Skills Passport
Leaderboards
Blog

Functions

SUM
IF
XLOOKUP
COUNTIF
All functions

Account

Sign in
Create free account

SheetSkill

About us
Contact us
Privacy Policy
Terms of Use

© 2026 SheetSkill · Learn. Practice. Master. · Always free.Developed by Jerin George Pallath · Not affiliated with Microsoft

AVERAGEIF/Average Hours for Remote Staff

0 of 1195 complete

AVERAGEIFIntermediate

Average Hours for Remote Staff

Question

In E2, find the average hours per week for employees who work Remote.

Answer in cell E2

How it’s written

=AVERAGEIF(range, criteria, [average_range])

rangeThe cells to check.
criteriaThe condition, such as "Remote".
average_rangeOptional. The cells to average.

10 points for a first try without hints, 5 otherwise.

Practice sheetClick the dashed cell E2, type your formula, press Enter.

Loading the spreadsheet…

Check from anywhere with Ctrl + Enter