Excel on the web - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Excel on the web?

Excel on the web is the online version of Microsoft Excel that runs in a web browser. It lets you create, edit, and share spreadsheets without installing software.

beginner

How do you share an Excel workbook in Excel on the web?

You click the Share button, enter email addresses or get a shareable link, and set permissions like view or edit for others.

beginner

Can you use formulas in Excel on the web?

Yes, Excel on the web supports most common Excel formulas like SUM, AVERAGE, IF, and more, just like the desktop version.

intermediate

What happens when multiple people edit the same Excel file on the web at the same time?

Excel on the web allows real-time collaboration, so you can see others' changes instantly and work together smoothly.

intermediate

Name one limitation of Excel on the web compared to the desktop version.

Excel on the web may have fewer advanced features like some complex macros or add-ins that only work in the desktop app.

Which device can you use to access Excel on the web?

A Only mobile phones

B Only Windows PCs

C Only Mac computers

D Any device with a web browser

Excel on the web works on any device that has a web browser, including PCs, Macs, tablets, and phones.

How do you save your work in Excel on the web?

A It saves automatically

B Manually click Save button

C You must download the file to save

D Save is not available

Excel on the web saves your changes automatically as you work.

What feature allows you to work with others at the same time in Excel on the web?

A Real-time collaboration

B Offline mode

C Version history

D Pivot tables

Real-time collaboration lets multiple people edit the same file simultaneously.

Which of these is NOT a way to share an Excel file on the web?

A Send a shareable link

B Email an invitation

C Print and fax the file

D Set permissions for others

Printing and faxing is not a sharing method within Excel on the web.

Which of these is a limitation of Excel on the web?

A Cannot use any formulas

B Some advanced features like macros may not work

C No support for real-time collaboration

D Cannot open files from OneDrive

Excel on the web supports most formulas but some advanced features like macros may not be available.

Explain how Excel on the web helps you work with others on the same spreadsheet.

Think about how you can invite friends to edit and how you see their work as it happens.

Describe one key difference between Excel on the web and the desktop Excel app.

Consider what you can do without installing software and what features might be missing.

Practice

1. What is a key benefit of using Excel on the web compared to the desktop version?

easy

A. You can access and edit your spreadsheets from any device with internet.

B. It has more advanced formulas than the desktop version.

C. It does not save your work automatically.

D. You cannot share files with others.

Solution

1. Step 1: Understand Excel on the web features

   Excel on the web allows access from any device connected to the internet.

2. Step 2: Compare with other options

   Options A, B, and D are incorrect because Excel on the web supports common formulas, saves automatically, and allows sharing.

3. Final Answer:

   You can access and edit your spreadsheets from any device with internet. -> Option A

4. Quick Check:

   Access from any device = C [OK]

Hint: Remember: Excel on the web works anywhere with internet [OK]

Common Mistakes:

• Thinking Excel on the web has more formulas than desktop
• Believing it does not save automatically
• Assuming sharing is not possible

2. Which of these is the correct way to write a formula in Excel on the web to add cells A1 and B1?

easy

A. A1 plus B1

B. =SUM(A1+B1)

C. SUM(A1,B1)

D. =A1+B1

Solution

1. Step 1: Recall formula syntax for addition

   In Excel, to add two cells, use =A1+B1.

2. Step 2: Check each option

   =SUM(A1+B1) uses SUM incorrectly with plus sign inside. SUM(A1,B1) misses '=' and uses wrong syntax. A1 plus B1 is not a formula.

3. Final Answer:

   =A1+B1 -> Option D

4. Quick Check:

   Correct addition formula = A [OK]

Hint: Use '=' to start formulas, then write the operation [OK]

Common Mistakes:

• Using SUM with plus sign inside parentheses
• Omitting '=' at the start
• Writing formulas as plain text

3. If cell A1 contains 10 and B1 contains 5, what will the formula =IF(A1>B1, "Yes", "No") display in Excel on the web?

medium

A. No

B. Yes

C. 10

D. 5

Solution

1. Step 1: Evaluate the condition A1 > B1

   Since A1 is 10 and B1 is 5, 10 > 5 is TRUE.

2. Step 2: Apply IF formula logic

   IF condition is TRUE, so formula returns "Yes".

3. Final Answer:

   Yes -> Option B

4. Quick Check:

   Condition true = Yes [OK]

Hint: IF returns first value if true, second if false [OK]

Common Mistakes:

• Confusing which value IF returns on true
• Mixing up cell values with formula output
• Ignoring quotation marks around text

4. You entered the formula =AVERAGE(A1:A5 in Excel on the web but it shows an error. What is the problem?

medium

A. AVERAGE function does not work on ranges

B. Formula should start with SUM, not AVERAGE

C. Missing closing parenthesis ")"

D. Cells A1 to A5 must be numbers

Solution

1. Step 1: Check formula syntax

   The formula =AVERAGE(A1:A5 is missing the closing parenthesis ")" at the end.

2. Step 2: Understand function requirements

   AVERAGE works on ranges and cells can be numbers; missing parenthesis causes syntax error.

3. Final Answer:

   Missing closing parenthesis ")" -> Option C

4. Quick Check:

   Syntax error due to missing ")" = B [OK]

Hint: Always close parentheses in formulas [OK]

Common Mistakes:

• Forgetting to close parentheses
• Thinking AVERAGE can't use ranges
• Assuming formula must start with SUM

5. You want to share an Excel on the web file with your team so everyone can edit it at the same time. Which steps should you follow?

hard

A. Upload the file to OneDrive and use the Share button to invite team members

B. Save the file locally and email it to each person

C. Send a screenshot of the file to the team

D. Copy and paste the data into a Word document and share it

Solution

1. Step 1: Understand sharing in Excel on the web

   Excel on the web integrates with OneDrive for cloud storage and sharing.

2. Step 2: Identify correct sharing method

   Uploading to OneDrive and using the Share button allows real-time editing by multiple users.

3. Final Answer:

   Upload the file to OneDrive and use the Share button to invite team members -> Option A

4. Quick Check:

   Use OneDrive Share for collaboration = A [OK]

Hint: Use OneDrive Share button for live collaboration [OK]

Common Mistakes:

• Emailing local files causes version conflicts
• Sharing screenshots or Word docs loses spreadsheet features
• Not using cloud storage for collaboration