2. Excel

In the magical land of spreadsheets, where do a column and a row meet? Help Holly and Joshua solve this mystery!

• cell

• worksheet

• chart

• sum

Answer explanation

In spreadsheets, a column and a row intersect at a 'cell'. This is where data is entered, making 'cell' the correct answer. Other options like 'worksheet', 'chart', and 'sum' do not represent this intersection.

Hey there! Imagine you're helping Fran and Ewan with their Excel project. When you open an Excel file, it opens a workbook. Can you guess what those tabs at the bottom help you switch between?

• worksheets

• formulas

• permissions

• number formats

Answer explanation

The tabs at the bottom of an Excel workbook allow you to switch between different worksheets. Each worksheet can contain its own data, making it easy to organize and manage information within the same file.

Hey there, Excel wizards! Can you help Freya spot what's missing in this magical formula?

SUM(C12:C15)

• It should have an equals sign (=) at the beginning

• There is nothing wrong with the formula

• It should use quotation marks instead of brackets

• It should use the COUNT function

Answer explanation

The formula is missing an equals sign (=) at the beginning, which is necessary for Excel to recognize it as a formula. Without it, Excel treats the text as a string rather than executing the SUM function.

Fran and Lucy are having a friendly debate: Can you really see the magic behind a formula by simply double-clicking the cell that holds it? True or False?

• True

• False

Answer explanation

True. Double-clicking a cell in a spreadsheet reveals the formula used in that cell, allowing you to see how the result is calculated, thus showcasing the 'magic' behind it.

Rhys and Emily are having a friendly math challenge! Can you help them solve this formula to find the correct value? =(82-32)/5+8*2

• 26

• 7.69

• 91.6

• 36

Answer explanation

To solve =(82-32)/5+8*2, first calculate 82-32=50. Then, 50/5=10. Next, calculate 8*2=16. Finally, add 10+16=26. Thus, the correct answer is 26.

During a fun tech quiz, Jacob asked Sydney, "What is the Google equivalent of Excel?"

• Sheets

• Sheet

• OpenOffice

• FusionGrid

• ClickUp

Answer explanation

The Google equivalent of Excel is Google Sheets, which is a spreadsheet program that allows users to create and edit spreadsheets online. Other options like OpenOffice and ClickUp are not Google's products.

Sydney and Grace are having a friendly competition in Excel wizardry! Can you help them decide which function to use to find the average of a range of cells?

• AVERAGE

• SUM

• COUNT

• MIN

Answer explanation

To find the average of a range of cells in Excel, the correct function to use is AVERAGE. The SUM function adds values, COUNT counts them, and MIN finds the smallest value, but AVERAGE calculates the mean.

Jacob and Fran are having a friendly debate: Can you merge cells in Excel to create a single larger cell? Who's right?

• True

• False

Answer explanation

True. In Excel, you can merge cells to create a single larger cell, allowing for better formatting and organization of data. Therefore, Harry is correct.

Fran and Grace are racing against time to finish their Excel project. Can you help them by telling which shortcut key they should use to save their workbook quickly?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

Answer explanation

The correct shortcut to save a workbook quickly in Excel is Ctrl + S. This command is universally used to save files across many applications, making it the best choice for Oscar and Sebastian.