ICT 101 FINAL repeating questions

What is the logical complement or exact structural opposite of the strictly greater than (>) operator?

What is the logical complement or exact structural opposite of the less than or equal to (<=) operator?

(strictly greater than)

What structural Excel feature produces non-sequential column or row viewing layouts on screen (e.g. column GQ next to column A)?

Freezing Panes

What type of logical fallacy is committed by quoting a renowned historical physicist like Albert Einstein to support a biological claim about bees?

Argument from false authority

What are the colored identifier markers or name tags that map series coordinates on an Excel visual graphic plot called?

Legend

What exact data parameter variables can be stored within a standard Microsoft Excel spreadsheet cell grid?

Text strings, numeric integers, and operational mathematical formulas

What happens visually to an Excel cell display workspace if a formatted numeric or date structure exceeds the column width properties?

It displays a string of hash symbols (#########)

What type of data storage memory architecture classification maintains its structural byte configuration when completely disconnected from an electrical source?

Persistent or non-volatile memory (such as solid state disks or flash storage drives)

What type of malicious application file payload tracks local session configuration scripts by hiding inside an apparently safe software package?

A Trojan horse virus

What type of security encryption tool lets anyone seal data using an open key, but strictly enforces that only one matching key can unlock it?

Public Key Encryption (Asymmetric Cryptography)

What South African statutory legislation controls how personal data profiles can be utilized, and allows citizens to verify records collected about them?

The POPI Act (Protection of Personal Information Act)

What standard website indicator parameters verify that a live URL endpoint connection path is encrypted via secure sockets?

The address string begins with an https:// configuration prefix and displays a padlock icon in the browser layout bar

What is the fundamental functional difference between the operations of the logical AND vs the logical OR functions inside conditional expressions?

AND demands that all expressions evaluate as true, whereas OR evaluates as true if any single expression is true

What specific location attribute coordinates are defined by an alphanumeric tag such as AX23?

Column AX and Row 23

How does an absolute cell reference marker protect cell references when dragging formulas down or across?

Dollar symbols lock the values securely like $A$14

What character properties are mandated globally by network administrators to define a secure account authorization password string?

All of the above (mixed-case alphabet characters, structural numbers, and custom special punctuation variables)

What type of program acts as an intermediary between application software and computer hardware, like a hard disk?

Operating system

How can we create a uniform appearance by adding a background image to all PowerPoint slides?

By editing the Slide Master

How can you view all your slides at once in PowerPoint?

Through Slide Sorter View

What is the best way to create another copy of a PowerPoint slide?

From Insert Menu, choose Duplicate Slide

What are the steps to insert slide numbers in PowerPoint?

Choose Insert, then Slide number

To preview a motion path effect using the custom animation task pane in PowerPoint, you should __________________

click the Play Button

Which is the way to name a slide?

Click View, Outline View, click to the right of a slide thumb, type the name

What is the term used when you press and hold the left mouse key and move the mouse around the slide?

Dragging

Which of the following can you use to add times to slides in a presentation?

All of the above (Rehearse timing button, Slide show menu, and Slide transition button can all add timing to slides)

In PowerPoint the arrangement of elements such as Title and subtitle text, pictures, tables, etc, is known as:

Layout

An Internet meme is __________________

Both b. and c. are correct (largely spread by social connections AND not always true)

Information on the web __________________

Both b. and c. are correct (needs to be verified AND is only always correct if from a trusted source)

The anti-vax (anti-vaccination) movement is an example of __________________

a false meme (it is misinformation that spreads virally despite being contradicted by scientific evidence)

In order to copy a formula to adjacent cells you must ________________

left click on the lower right corner and drag it to the desired cells (this uses the fill handle)

MS Excel uniquely identifies cells within a worksheet with ________________

column letters and row numbers (e.g. cell B5 = column B, row 5)

Which statement is the most correct regarding Excel column identification?

A column in a worksheet is identified by a letter (columns use letters A, B, C… AA, AB… etc.)

What feature can be used to quickly highlight information in a spreadsheet by applying formatting options, such as data bars, color scales, or icon sets that match your criteria?

Conditional formatting

What formula would you use to evaluate a logical test branch where a specific cell input returns conditional calculations depending on a true or false match evaluation?

The IF function

What does a single quote symbol (') do when typed at the very beginning of a cell numeric entry in Excel?

It forces Excel to treat the numeric entry as a literal unformatted text string

In Paint.net, what tool should you use first if your workflow task requires you to crop an image to a targeted canvas grid frame?

Rectangle Select

What menu tab allows you to adjust properties like contrast, brightness, hue, and color saturation variables inside Paint.net?

Adjustments menu

What does the Magic Wand selection tool do in graphic layout platforms like Paint.net?

It selects adjacent pixels of highly matching or similar colors based on a specific tolerance threshold

What metadata attribute fields get dynamically synchronized and overwritten by the filesystem when an existing document file is updated?

Last Accessed and Last Modified dates