IC3 Computing Fundamentals and Key Applications Flashcards

In Excel, cell C3 contains the formula =$A3*C$1. You copy C3 and paste it into cell E7. What formula appears in E7?

Answer: =$A7*E$1

This formula uses mixed references. In $A3 the column is locked by the $, but the row is relative, so moving down 4 rows changes 3 to 7: $A7. In C$1 the row is locked, but the column is relative, so moving right 2 columns changes C to E: E$1. The result is =$A7*E$1.

A user tries to copy a 6 GB video file to a new USB flash drive. The drive has 32 GB free, but Windows says the file is too large for the destination. The drive must also work on macOS computers without extra software. What is the best fix?

Answer: Reformat the drive as exFAT

The drive is almost certainly formatted as FAT32, which cannot store a single file larger than 4 GB, no matter how much free space there is. exFAT removes that limit, and both Windows and macOS can read and write it natively. macOS can only read NTFS by default, not write to it. Zipping a video barely shrinks it, and freeing space doesn't help because space isn't the problem.

A Word document is in portrait orientation. You need only page 5, which holds a wide table, to be landscape, while every other page stays portrait. What is the correct approach?

Answer: Insert 'Next Page' section breaks before and after the table, then set only that section to Landscape

In Word, page orientation is a section-level setting. 'Next Page' section breaks put the table in its own section on its own page, so you can make just that section landscape. Manual page breaks don't create new sections, so changing the orientation would affect the whole section. Tables have no orientation setting. Making the whole document landscape defeats the goal.

A worksheet uses =VLOOKUP(E2,A2:C500,3) to find employee departments by ID. Some IDs that definitely exist in column A return the wrong department, and no error appears. The table is sorted by last name, not by ID. What is the most likely cause?

Answer: The fourth argument was left out, so VLOOKUP defaults to approximate match, which needs data sorted by the lookup column

When the range_lookup argument is left out, VLOOKUP defaults to TRUE, which means approximate match. Approximate match assumes the first column is sorted in ascending order. On unsorted data it can quietly return a value from the wrong row. Adding FALSE as the fourth argument (=VLOOKUP(E2,A2:C500,3,FALSE)) forces an exact match. Column 3 is inside A:C, there is no 256-row limit, and absolute references only matter when you copy the formula.

A computer has 8 GB of RAM installed, but System Information shows only about 3.5 GB usable. The memory modules test fine and are seated correctly. What is the most likely explanation?

Answer: The computer is running a 32-bit version of the operating system

A 32-bit operating system can address at most 4 GB of memory, and part of that space is reserved for hardware such as the graphics card. That usually leaves about 3.2 to 3.5 GB usable. Installing a 64-bit OS, on a 64-bit CPU, makes the full 8 GB available. Page file size, drive space and startup programs affect how much memory is free, not how much installed RAM the system reports as usable.

In PowerPoint, you change the title font in the Slide Master. Every slide updates except slide 8, which keeps its old title font. What is the most efficient way to make slide 8 match the master?

Answer: Select slide 8 and use the Reset command on the Home tab

Slide 8's title was formatted manually at some point. Manual formatting overrides the master, so later master changes don't reach it. The Reset command (Home > Slides > Reset) removes those manual changes and restores the slide's placeholders to its layout and master settings, while keeping the content. The other options are disruptive or indirect, and Format Painter would just add more manual formatting.