Information Technology Test

0 votes, 0 avg

You will have 60 minutes to complete all the questions. After the timer reaches 60 minutes, the exam will end and be saved automatically. Good luck! *Fingers crossed*

The timer has been reached. The exam has now been terminated and saved.

1 / 60

A _____________ is a collection of design choices that includes colors, fonts, and special
effects.?

a. Theme

b. Table

c. Slide

d. Data

2 / 60

Which of the following statements accurately describes the default selection for AutoSum?

a. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.

b. You must make the selection before clicking AutoSum.

c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell

d. AutoSum does not have a default selection.

3 / 60

In Excel, which one denoted a range from B1 through F5?

a. B1 to F5

b. B1:F5

c. B1-F5

d. B1$F5

4 / 60

Which key deletes the character to the right of the cursor?

a. Delete

b. Backspace

c. Home

d. End

5 / 60

“CTR+Left Arrow” is used to ______________________________.?

a. Moves to the cursor one word left

b. Moves to the cursor one paragraph

c. Moves to the cursor one paragraph down

d. Moves to the cursor beginning of the line

6 / 60

The set of programs which consists of full documentation. ?

a. System Software

b. Utility Software

c. File package

d. Software Package

7 / 60

The software designed to perform a specific task.?

a. System Software

b. Synchronous Software

c. Application Software

d. Package Software

8 / 60

Linux is a (an) ____________ operating system.?

a. Microsoft

b. Open-source

c. Windows

d. Mac

9 / 60

The physical devices of a computer are called _________.?

a. System Software

b. Package

c. Software

d. Hardware

10 / 60

What is the shortcut key to “Undo” the last action in a document?

a. Ctrl + X

b. Ctrl + Z

c. Ctrl + Y

d. None of above

11 / 60

An experimenter measured 30 children’s IQ. He then rank-ordered the children and assigned
them a score from 30 (most intelligent) to 1 (least intelligent) to create a new variable. Does this new
variable consist of _____________.?

a. Ratio data

b. Interval data

c. Ordinal data

d. Nominal data

12 / 60

When you modify the ribbon, which of the following is created?

a. button

b. tab

c. worksheet

d. command

13 / 60

RAM stands for ___________.?

a. Random only memory

b. Random origin money

c. Random access memory

d. Read only memory

14 / 60

If a user needs information instantly available to the CPU, it should be stored ____________.?

a. in secondary storage

b. on a CD

c. in the CPU

d. in RAM

15 / 60

Word processing, spreadsheet, and photo-editing are examples of _______________.?

a. Operating system software

b. Application software

c. System software

d. Platform software

16 / 60

The process of producing useful information for the user is called ___________.?

a. Inputting

b. Outputting

c. Processing

d. Controlling

17 / 60

To change printer, layout, or margin settings, you click the File tab and use which of the
following options?

a. Print

b. Open

c. Options

d. Info

18 / 60

The most common input devices include ___________.?

a. Monitor and keyboard

b. Monitor and mouse

c. Mouse and keyboard

d. Printer and mouse

19 / 60

You don’t like the cell style you just applied. Which of the following is the least effective way to
remove or replace the style?

a. Apply another style to the cell

b. Use the Undo command

c. Clear the cell’s content

d. Apply the Normal style to the cell

20 / 60

How can you remove borders applied in cells?

a. Choose None on Border tab of Format cells

b. Choose None on Border tab of Format cells and Open the list on Border tool in Formatting toolbar then choose first tool (no border)

c. No answer

d. Open the list on Border tool in Formatting toolbar then choose first tool (no border)

21 / 60

Which type of graph can we use to compare frequency distributions of several groups
simultaneously?

a. A boxplot.

b. A population pyramid

c. A histogram

d. A bar chart

22 / 60

Which is a small green square in the lower-right corner of a selected cell or range that you can
use to copy one cell to adjacent cells or to create a series?

a. Cell pointer

b. Fill handle

c. Formula bar

d. Column marker

23 / 60

What does the operation “Recode Into Different Variables” do to the data?

a. Represents the data in the form of a pie chart.

b. Reverses the position of the independent and dependent variable on a graph.

c. Replaces missing data with some random scores.

d. Redistributes a range of values into a new set of categories and creates a new variable.

24 / 60

The file formats ________________ can add to power point shows.?

a. All are corrects

b. JPG

c. WAV

d. MPEG

25 / 60

Which of the following does NOT affect a computer‟ s performance?

a. The number of keys on the keyboard

b. The speed of the CPU

c. The type and speed of the video or graphics card

d. The amount of memory or RAM

26 / 60

Which of the following can be customized for quicker access to your most commonly used
commands?

a. Print Preview

b. Workbook

c. Quick Access Toolbar

d. Printer setup

27 / 60

Ordinal level data are characterized by ___________.?

a. Equal intervals between each adjacent score.

b. None of the above.

c. Data that can be meaningfully arranged by order of magnitude.

d. A fixed zero

28 / 60

____________ is the functional key to display save as box.?

a. F5

b. F12

c. F6

d. F9

29 / 60

__________ are often delivered to a PC through an e-mail attachment and are often designed to
do harm.?

a. Email messages

b. Spam

c. Viruses

d. Portals

30 / 60

How much information can be stored in a kilobyte?

a. As much as an encyclopedia set

b. As much as a one-page letter

c. As much as a bookstore

d. As much as a novel

31 / 60

Why might you tell SPSS to represent the “slices” of a pie chart in different patterns?

a. Because the program tends to crash if you ask it to use colour

b. Because the patterns form symbolic visual images of different social groups.

c. If you do not have a colour printer, it makes the differences between slices clearer.

d. In order to make full use of the facilities that SPSS can offer.

32 / 60

Which of the following options, which type of bar chart would we produce to look at the mean
ratings of two new varieties of Sauvignon Blanc (wine)?

a. Simple 3-D bar chart

b. Simple bar chart

c. Stacked bar chart

d. Clustered bar chart

33 / 60

___________ is the key we use to run the selected command.?

a. TAB

b. CTRL

c. SHIFT

d. ENTER

34 / 60

How would you use the drop-down menus in SPSS to generate a frequency table?

a. Click on: Graphs; Frequencies; Pearson

b. Open the Variable Viewer and recode the value labels

c. Click on: Analyze; Descriptive Statistics; Frequencies

d. Open the Output Viewer and click: Save As; Pie Chart

35 / 60

Which one is not a Function in MS Excel?

a. SUM

b. AVG

c. MAX

d. MIN

36 / 60

Which unit is responsible for converting the data received from the user into computer
understandable format?

a. Memory Unit

b. Input Unit

c. Arithmetic & Logic Unit

d. Output Unit

37 / 60

Which predesigned file already has a significant amount of formatting, text, and other
features?

a. Preset file

b. Template

c. Blank workbook

d. Text fil e

38 / 60

What is entered by the function =TODAY()?

a. The time value according to system clock

b. The date value for the day according to system clock

c. Today’s date as Text format

d. None of the above

39 / 60

Formatting a cell in Currency, you can specify _______________.?

a. Currency Symbol

b. Decimal Places

c. Percentage symbol

d. None of the above

40 / 60

Which of the following contains the commands you use most often, such as Save, Undo, and
Repeat?

a. Quick Access Screen

b. Quick toolbar

c. Quick Access Toolbar

d. Quick command

41 / 60

To delete one word to the right?

a. CTRL+SHIFT

b. CTRL+TAB

c. CTRL+DEL

42 / 60

Page Up Key uses for ___________________________________.?

a. Moves the cursor one paragraph up

b. Moves the cursor one line up

c. Moves the cursor one screen up

d. Moves the cursor one page up

43 / 60

Which of the following is not a function of the Output Unit?

a. It produces results that can be easily understood by the user

b. It supplies the data and instructions to the computer for further processing

c. It accepts the results produced by the computer

d. It supplies the data and instructions to the outside world

44 / 60

Which is the basic element of Power Point?

a. Slide

b. Sheet

c. Page

d. File

45 / 60

__________ is known as unauthorized access into others system.?

a. None of the above

b. Hacking

c. Decryption

d. Encryption

46 / 60

What is the shortcut key for “Spelling Check” in document?

a. Ctrl + F7

b. F7

c. Shift + F7

d. Alt + F7

47 / 60

The headings that appear on the Ribbon, such as File, Home, and Insert, are called _______.?

a. menus

b. tabs

c. groups

d. shortcuts

48 / 60

___________is designed to solve a specific problem or to do a specific task.?

a. User

b. Application Software

c. System Software

d. Utility Software

49 / 60

Which area in an Excel window allows entering values and formulas?

a. Title Bar

b. None of the above

c. Standard Tool Bar

d. Formula Bar

50 / 60

When a formatted number does not fit within a cell, it displays ___________.?

a. None of these

b. #DIV

c. #####

d. #DIV/0

51 / 60

Apple Macintoshes (Macs) and PCs use different ____________ to process data and different
operating systems.?

a. Languages

b. Methods

c. Storage devices

d. CPUs

52 / 60

Which of the following is where you can save, select a template, change document properties,
and close or exit Excel?

a. Edit

b. Windows

c. Print

d. Backstage

53 / 60

Which of the following is not a transformation that can be used to correct skewed data?

a. Log transformation

b. Square root transformation

c. Tangent transformation

d. Reciprocal transformation

54 / 60

What do you call a a specific instruction designed to do a task?

a. Instruction

b. Command

c. Process

d. Task

55 / 60

Which of the following provides a list of synonyms?

a. Replace Command

b. Find command

c. Spelling and Grammar

d. Thesaurus

56 / 60

Which of the following is an example of an absolute cell reference?

a. A$9

b. A9:E9

c. $A$9

d. A9

57 / 60

What is the advantage of using SPSS over calculating statistics by hand?

a. Many researchers use SPSS as it is a recognised software package

b. It equips you with a useful transferable skill.

c. It reduces the chance of making errors in your calculations.

d. All are corrects.

58 / 60

The ‘heart’ of the processor which performs many different operations___________.?

a. Memory

b. Arithmetic and logic unit

c. Control Unit

d. Motherboard

59 / 60

Where a row and a column meet, what do you call that?

a. A cell

b. A box

c. A block

d. None of the above

60 / 60

Which of the numbers below might IBM SPSS report as 10.574 E−05?

a. 10.569

b. 0.00010574

c. 1057400.0

d. 0.10574

Your score is

The average score is 72%

Any comments?

Information Technology Test

Any problems/errors or mistakes found while testing, please let us know for modification!

និស្សិតអាចប្រាប់មកកាន់ពួកយើងបានដើម្បីកែកំហុស ឬអំពីបញ្ហាដោយអចេតនាណាមួយដែលកើតមានកំឡុងពេលធ្វើតេស្ត