Company A tracks processor builds in a spreadsheet with build number, price, regional availability, and units sold by year. A manager wants to see total units sold broken out by both region and year at the same time, without writing any formulas. What should they insert?

Why does the PMT function in Excel often display its result as a negative number?

Problem 1 (10 pts) A three-phase uncontrolled bridge rectifier supplies an RL load with continuous current. The average output voltage is 540 V, and the load resistance is 30 ohms. Assume ideal diodes and negligible source inductance. (a) Determine the average load current, I0. (1 pt) (b) Based on the Fourier-series representation of the AC source current, determine the following: (5 pts) The peak amplitude of the fundamental current component. The orders and peak amplitudes of the first two nonzero harmonic current components. The total harmonic distortion (THD) of the AC source current. Now replace the uncontrolled bridge rectifier with a three-phase fully controlled bridge rectifier. The source line-to-line RMS voltage is 480 V, and the load resistance remains 30 ohms. Assume ideal SCRs, continuous current, and negligible source inductance. (c) Determine the firing angle

How does reinforcement learning from human feedback (RLHF) differ from an expert system?

A messaging app has a small but loyal user base, and no competitor has managed to displace it despite offering similar features. Which Five Forces element does a strong network effect most directly weaken for potential competitors?

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?