StudyXT

Connecting a laptop to a projector is usually straightforward: 1. Check the projector and laptop ports Common connections are: HDMI — best and most common VGA — older projectors/laptops USB-C — newer laptops; may need a USB-C-to-HDMI adapter 2. Connect the cable Turn on the projector. Connect the HDMI/VGA cable to the laptop. Connect the other end to the projector. On the projector, select the correct Input/Source (e.g., HDMI 1). 3. Select the display mode on Windows Press: Windows + P You'll see four options: PC screen only — projector off Duplicate — laptop and projector show the same screen ⭐ Extend — projector becomes a second monitor Second screen only — display only on projector For teaching/presentations, choose Duplicate . If the projector says "No Signal" Try these in order: Check that the projector's Source/Input matches the connected port. Unplug and reconnect the HDMI/VGA cable. Press Windows + P → Duplicate . Restart the projector. Try another HD...

A dvanced MS Excel   formula logic, lookup functions, conditional calculations, references, errors, arrays, and practical formula-based questions . Advanced MS Excel Formula MCQs 1. What will =IF(A1>=60,"Pass","Fail") return if A1 contains 75? A. 60 B. TRUE C. Pass D. Fail Answer: C. Pass Explanation: Since 75 ≥ 60 is TRUE, the IF() function returns "Pass" . 2. What is the result of =SUM(A1:A5) ? A. Adds only A1 and A5 B. Adds values from A1 through A5 C. Counts cells A1 through A5 D. Finds the average Answer: B. Adds values from A1 through A5 Explanation: The colon : specifies a continuous range from A1 to A5. 3. Which formula correctly calculates the average only for values greater than 50 in A1:A20? A. =AVERAGEIF(A1:A20,">50") B. =AVERAGE(A1:A20,">50") C. =IFAVERAGE(A1:A20,50) D. =AVGIF(A1:A20,50) Answer: A. =AVERAGEIF(A1:A20,">50") Explanation: AVERAGEIF() calculates the average of cells satisfying a spe...

MS Excel MCQs with explanations,  suitable for competitive exams, computer exams, UGC/college exams, SSC, banking, teaching recruitment, and general computer knowledge . MS Excel MCQs 1. Microsoft Excel is primarily used for: A. Word processing B. Spreadsheet and data analysis C. Presentation design D. Web browsing Answer: B. Spreadsheet and data analysis Explanation: Excel is spreadsheet software used for storing, organizing, calculating, analyzing, and visualizing data. 2. The intersection of a row and a column is called: A. Sheet B. Cell C. Workbook D. Range Answer: B. Cell Explanation: A cell is the basic unit of an Excel worksheet, such as A1 or B5 . 3. A collection of worksheets is called: A. Workbook B. Range C. Column D. Cell Answer: A. Workbook Explanation: An Excel file containing one or more worksheets is called a workbook. 4. Which symbol is used to begin a formula in Excel? A. # B. @ C. = D. % Answer: C. = Explanation: Every Excel formula generally starts with the...