A company wants a formula that checks two conditions in sequence — first whether a processor’s price is over $500, and if not, whether it’s over $250 — to assign a ‘Premium,’ ‘Mid-range,’ or ‘Budget’ label. What is this technique of putting one IF function inside another called?

Which of the following was one of the case studies students examined in the Technology and the Law project?

What defines open source software?

In the data-information-knowledge hierarchy, what is ‘knowledge’ best described as?

A restaurant chain keeps a separate worksheet for each of its 12 locations within one workbook, and wants a formula on a summary sheet to pull the January sales figure from the ‘Downtown’ worksheet. What Excel concept lets a formula reference a cell on a different worksheet in the same workbook?

According to lecture, what is artificial general intelligence (AGI)?

A Q&A platform built a strong network effect over a decade, becoming the default place programmers went for help. Yet a generative AI tool displaced much of its usage within about two years. Which analysis best explains why a strong network effect did not fully protect the platform?

A spreadsheet uses VLOOKUP to find a student’s name in a grade table, but the table is not sorted alphabetically. What is the most likely result?

What term does the lecture use for when a generative AI presents an incorrect answer as if it were correct?

A finance team wants to know how much a $15,000 loan would cost per month, given an interest rate and a loan term in years. Which Excel function’s core purpose is to compute a periodic loan payment amount?