Computational Thinking and Spreadsheets Quiz

What does decomposition in computational thinking involve?

• Combining complex problems

• Breaking down a complex problem into smaller parts

• Copying the methods of a previously solved problem

• Predicting future outcomes

In a spreadsheet, what is a cell?

• A page in a workbook

• The intersection of a row and a column

• A header of a column

• A type of chart

What is an algorithm in computational thinking?

• A complex equation

• A type of programming language

• A step-by-step solution to a problem

• A data storage method

Which function would you use to find the highest number in cells A1 through A5?

• SUM(A1:A5)

• AVERAGE(A1:A5)

• MAX(A1:A5)

• MIN(A1:A5)

What is abstraction in computational thinking?

• Drawing detailed diagrams

• Removing unnecessary details

• Adding more features to the program

• Using the brightest colors in design

What is the purpose of an email attachment?

• To enhance the visual appeal of an email

• To provide additional information or documents

• To increase the email's size

• To encrypt the email content

Which of the following is an example of a cell reference in a spreadsheet?

• Spreadsheet1

• Column A

• A1

• Cell-1-1

Why is pattern recognition important in computational thinking?

• It helps in identifying the largest data set

• It assists in recognizing and exploiting similarities

• It is only used in advanced algorithm creation

• It is the final step in problem-solving

How would you create a formula to add cells A1 and B1 in a spreadsheet?

• A1 + B1

• = A1 + B1

• SUM(A1, B1)

• A1 & B1