ICT 101 JUNE FINAL 2020

Algorithms are _____________________

All of the above can be true (expressed in pseudocode, used to run programs, expressed in vague notation like plain English)

SRAM (static random access memory) is an example of _____________

volatile memory (SRAM loses its contents when power is removed)

Computer designers choosing between serial and parallel data transfer, prefer _________________

serial because it eliminates skew (parallel signals can arrive at slightly different times, causing skew errors at high speeds)

An uninterruptible power supply (UPS) __________________

Both a. and c. are correct (contains a battery AND allows computers to keep going a limited time when power is off)

Numbers in a computer are expressed in binary because __________________

Both a. and c. are correct (a switch can represent two values corresponding to on and off AND ones and zeroes can be thought of as true and false values)

A file name ending in .jpg can contain __________________

only images

Backwards compatibility means __________________

software that can open recent as well as older types of files

On Windows, a remote device in a path __________________

is represented by two backslashes followed by the name of the location (e.g. the UNC path format)

A typist who is skilled in typing in France who visits South Africa and uses a South African keyboard __________________

Both b. and c. are correct (will have problems because special keys they need are not on the keyboard AND will have problems because the keyboard layout is different)

You want to quote someone's exact words in an essay

this is __________________

None of the above (you must use quotation marks, cite a reference, and it should not make up most of your document)

A secure web page URL __________________

Both b. and c. are correct (always starts with https AND has a picture of a padlock before the URL)

In MS Word if you want to change all the headings in a document, this is easiest if __________________

Both b. and c. are correct (use a heading style AND change the definition of the appropriate heading style so all instances update automatically)

In MS Word if you want to keep track of differences between your version of a document and someone else's changes the easiest way is to ________________

use Track Changes

Which of the following is not true about PowerPoint transitions and animations?

For any slide, you can only have one animation (multiple animations can be applied to a single slide)

Which of the following is not true about PowerPoint triggers?

It is not possible to make the trigger object and the animation object the same (it IS possible to click a shape to trigger an animation on that same shape)

Which of the following is not true about background pictures in PowerPoint?

Once a background picture has been added to a slide, it is impossible to adjust its colour (you can format the background picture's colour, transparency, and other properties after inserting it)

Which of the following is not true about image editing?

No free versions of image-editing software are available (Paint.net is a well-known free image editor)

Which is not true about selecting multiple PowerPoint slides?

To select continuous slides, select the first slide and hold down the Ctrl Key and then select the last slide (Shift is used for continuous selection, not Ctrl)

The colour of an image in Paint.net can be adjusted using all of the following methods, except by using __________________

None of the above (brightness and contrast, curves, hue and saturation, and levels are all valid colour adjustment tools in Paint.net)

The following is not true about PowerPoint themes.

None of the above (all statements about themes are true: additional themes can be downloaded, they are under the Design tab, they vary by colour and font, and a template is a theme plus content)

In Paint.net, the brightness of an image can be increased through the __________________

adjustments menu

Which of the following is a shortcut key used to duplicate a slide?

Ctrl Shift D

Which of the following does not fall under the category of PowerPoint objects?

Colour (ClipArt, Charts, Text, and Graphs are insertable objects

Colour is a property or attribute, not an object)

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

You can create a new presentation by completing all of the following except __________________

clicking File, Open (this opens an existing file rather than creating a new one)

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

Dragging

The spelling dialog box can be invoked by choosing spelling from the ____ menu?

Review

The boxes that are displayed to indicate the text, pictures or objects are placed in it are called __________________

Placeholders

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

Layout

To enable even spacing of objects on a slide across a plane, which of the following align commands would work?

Distribute horizontally

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

Rehearsing time button, Slide Show menu, and Slide Transition Button can all be used to add timing to slides

To display the same action on all slides?

Copy and paste the action button on each and every slide (using the Slide Master is more efficient but is not listed as an option)

To change the order of animations on a slide?

Click and drag effects on the Animation Pane

What is the best way to design the layout for your slides?

Create a layout for your slides, handouts and notes using the Master Layout in the Slide Master View

Quoting Einstein on the importance of bees is an example of

Argument from false authority (Einstein was a physicist, not an expert on bees or biology)

Spin is information that is __________________

Both b. and c. are correct (not necessarily false AND deliberately misleading)

An Internet meme is __________________

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

Russian influence on the election of President Trump __________________

Both b. and c. are correct (could have happened through Facebook advertising AND even if it happened, it was not illegal under certain interpretations)

A bot is an example of a technology to create __________________

Both a. and c. are correct (a false meme AND astroturfing — bots simulate grassroots support)

Widespread unscientific social media claims about Covid-19 are an example of __________________

a false meme (unverified misinformation that spreads virally through social networks)

A substitution cypher __________________

Is not very secure (easily broken by frequency analysis since letter patterns are preserved)

Public key encryption __________________

Both a. and c. are correct (allows you to send someone else your public key AND only allows decryption with the private key)

The invention of the microprocessor made possible __________________

Both b. and c. are correct (computer memories where you could no longer see every bit AND Personal computers)

The PAIA law __________________

allows you to obtain information about anything reasonable to disclose from government

Localizing user interfaces is __________________

Both a. and b. are correct (a matter of translating text to a new language AND correcting cultural references that differ)

Someone once said of a free social media service “you are the product”. This means __________________

Both a. and b. are correct (selling advertising access to you pays for the service AND your personal data is collected and monetized)

A highlighted cell represents ______:

Both a. and c. are correct (the cell cursor AND the current active cell)

Which feature starts with a desired result, then calculates the input value that will give that result?

Goal Seek

_______ 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

Cell E4 contains the formula =D1+D2. What formula will you see when you copy and paste this into cell F5?

=E2+E3 (both column and row reference are relative, so they shift down one row and right one column)

The words "Bears", “Dolphins ” and “Whales” in the image below are called the chart’s ______.

legend

What does the cell reference AX23 represent?

The cell in AX column and row 23

What kind of data can we enter into an Excel cell?

All except d. are correct (an Excel cell can store Text, Numbers, and Formulas, but not embedded pictures directly as data)

The opposite of <= is:

>

As you can see in the following picture, the columns and rows are not sequential. In the picture you can see that column GQ is next to column A and row 235 is next to row 1. What must have happened?

It is an effect of freezing panes

What would be a situation where we need to use the following formula: =IF(E5="Yes",D5 + D5*7.5%,D5)?

Return the value plus 7.5% if the item is taxable

If we want to see the sales performance of only Sales Agent 1, we should use the ______ feature of Excel.

Filter