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

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. Column marker

b. Cell pointer

c. Formula bar

d. Fill handle

2 / 60

Which of the numbers below might IBM SPSS report as 8.96 E+03?

a. 8960.0

b. 89.60

c. 0.008960

d. 8.960

3 / 60

You want to calculate the number of blank cells in your worksheet. Which function should be
used?

a. COUNTA

b. COUNTBLANK

c. SUM

d. COUNT

4 / 60

Which of the following is not useful for changing the font size?

a. Decrease Font Size button

b. Font Size drop-down list

c. Increase Indent button

d. Increase Font Size button

5 / 60

Which part of the computer is used for calculating and comparing?

a. Control unit

b. System Unit

c. ALU

d. Disk unit

6 / 60

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

a. 0.10574

b. 0.00010574

c. 1057400.0

d. 10.569

7 / 60

The smallest unit of data in computer is ____________.?

a. Byte

b. Bit

c. KB

d. Nibble

8 / 60

If we use the mean as a model, what does the variance represent?

a. The average error between the model and the observed data.

b. The total error between the model and the observed data.

c. The squared total error between the model and the observed data.

d. The square-rooted average error between the model and the observed data.

9 / 60

Which of the following are assumptions underlying the use of parametric tests (based on the
normal distribution)?

a. The samples being tested should have approximately equal variances.

b. All of the options are true.

c. Some feature of the data should be normally distributed.

d. The data should be at least interval level.

10 / 60

Handout Master is defined by _______________.?

a. Slide transaction

b. Slide formattin

c. Layout of handout

d. Layout of slide

11 / 60

Which of the following is NOT an operating system?

a. Linux

b. Mac OS

c. Microsoft Windows

d. Microsoft Word

12 / 60

Which key deletes text before, or to the left, of the insertion point?

a. Delete

b. Backspace

c. Page Down

d. Page Up

13 / 60

What does LAN stand for?

a. Linked Area Network

b. Lots of Anarchy and Nonsense

c. Linked Applications Node

d. Local Area Network

14 / 60

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

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

b. Click on: Analyze; Descriptive Statistics; Frequencies

c. Open the Variable Viewer and recode the value labels

d. Click on: Graphs; Frequencies; Pearson

15 / 60

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

a. None of these

b. #####

c. #DIV/0

d. #DIV

16 / 60

When cross-tabulating two variables, it is conventional to:

a. represent the independent variable in rows and the dependent variable in columns.

b. assign both the dependent and independent variables to columns.

c. assign both the dependent and independent variables to rows.

d. represent the dependent variable in rows and the independent variable in columns.

17 / 60

Shortcut key for the Slide Show view is ___________.?

a. F4

b. F5

c. F1

d. F3

18 / 60

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

a. on a CD

b. in RAM

c. in the CPU

d. in secondary storage

19 / 60

Excel display the current cell address in the _________________.?

a. Formula bar

b. Name Box

c. Status Bar

d. None of the above

20 / 60

One nibble is equivalent to _____________ bits.?

a. 8

b. 2

c. 1

d. 4

21 / 60

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

a. Motherboard

b. Control Unit

c. Memory

d. Arithmetic and logic unit

22 / 60

____________ are specially designed computers that perform complex calculations extremely
rapidly. ?

a. Laptops

b. Servers

c. Mainframes

d. Supercomputers

23 / 60

Which of the following can you drag or double-click to change the width of a column?

a. Formula bar

b. Column marker

c. Fill handle

d. Cell pointer

24 / 60

A person who designs the programs in a software package is called _____________.?

a. Software Manager

b. System Programmer

c. User

d. System Developer

25 / 60

__________ key is used for Help in Power Point.?

a. F1

b. F2

c. F6

d. F3

26 / 60

Saving data and instructions to make them readily available is the job of __________.?

a. Output Unit

b. Storage Unit

c. Cache Unit

d. Input Unit

27 / 60

The steps and tasks needed to process data, such as responses to questions or clicking an icon,
are called ___________.?

a. the operating system

b. application software

c. instructions

d. the system unit

28 / 60

What is the file extension of word processing Application?

a. .jpeg

b. .pptx

c. .xlsx

d. .docx

29 / 60

Which would you choose to save a document with a new name?

a. Click File, Save As

b. Click File, Save

c. Click Tools, Options, Save

d. Press Ctrl+S

30 / 60

Which of the following is an example of a mixed cell reference?

a. $A$9

b. A9:E9

c. A9

d. A$9

31 / 60

Power Point presentation are commonly used in ___________________.?

a. Communication of planning

b. Note outline for teachers

c. Project presentations by students

d. All are corrects

32 / 60

RAM stands for ___________.?

a. Random only memory

b. Read only memory

c. Random origin money

d. Random access memory

33 / 60

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

a. Alt + F7

b. F7

c. Ctrl + F7

d. Shift + F7

34 / 60

The COUNT and MIN functions are examples of which category of functions?

a. text

b. statistical

c. logical

d. financial

35 / 60

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

a. The speed of the CPU

b. The number of keys on the keyboard

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

d. The amount of memory or RAM

36 / 60

The default file extension for a 2016 Power Point presentation is _____________.?

a. .ppte

b. .ppt

c. .pptc

d. .pptx

37 / 60

Which of the following can you not copy using Format Painter?

a. Font size

b. Font color

c. Cell content

d. Bold

38 / 60

In SPSS, what is the “Data Viewer”?

a. A screen in which variables can be defined and labeled.

b. A spreadsheet into which data can be entered.

c. A dialog box that allows you to choose a statistical test.

d. A table summarizing the frequencies of data for one variable.

39 / 60

Which of the following commands is used to insert a cell into a worksheet?

a. The Format command in the Cells group on the Home tab

b. The Format Painter command in the Clipboard group on the Home tab

c. The Format command in the shortcut menu when you right-click a cell

d. The Insert command in the Cells group on the Home tab

40 / 60

What is a backup?

a. All are corrects

b. An exact copy of a system's information

c. Restoring the information backup

d. The ability to get a system up and running in the event of a system crash or failure

41 / 60

Linux is a (an) ____________ operating system.?

a. Windows

b. Mac

c. Open-source

d. Microsoft

42 / 60

END Key used to ___________________.?

a. Moves the cursor end of the screen

b. Moves the cursor end of the paragraph

c. Moves the cursor end of the line

d. Moves the cursor end of the document

43 / 60

The ALU gives the output of the operations and the output is stored in the ___________.?

a. Output Unit

b. Flags

c. Registers

d. Memory Devices

44 / 60

The collection of links throughout the Internet creates an interconnected network called the
______________.?

a. WWW

b. World Wide Web

c. All of the above

d. Web

45 / 60

The basic unit of a worksheet into which you enter data in Excel is called a _________.?

a. Column

b. Cell

c. Table

d. Box

46 / 60

You want to calculate the number of nonblank cells in your worksheet. Which function should
be used?

a. SUM

b. COUNTA

c. MAX

d. MIN

47 / 60

How is a variable name different from a variable label?

a. It refers to codes rather than variables.

b. It is abstract and unspecific.

c. It is longer and more detailed.

d. It is shorter and less detailed.

48 / 60

You want to add a range of cells and then divide by the number of cell entries, determining the
mean value of all values in the range. Which function should be used?

a. MIN

b. COUNT

c. AVERAGE

d. MAX

49 / 60

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

a. Decimal Places

b. None of the above

c. Percentage symbol

d. Currency Symbol

50 / 60

Which of the following methods will not enter data in a cell?

a. Pressing the Esc key

b. Pressing the tab key

c. Clicking the enter button the formula bar

d. None of the above

51 / 60

Which of the following format you can decide to apply or not in AutoFormat dialog box?

a. Border format

b. Number format

c. Font format

d. All are corrects

52 / 60

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

a. Options

b. Info

c. Print

d. Open

53 / 60

____________ has a slide design option in MS Power Point.?

a. Drawing Toolbar

b. Standard Toolbar

c. Formatting Toolbar

d. None of these

54 / 60

Which one is not an examples of input devices?

a. Scanner

b. Mouse

c. Printer

d. Keyboard

55 / 60

Which of the following is not a function of the control unit?

a. Direct operations

b. Read instructions

c. Interpret instructions

d. Execute instructions

56 / 60

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

a. Moves to the cursor one paragraph

b. Moves to the cursor beginning of the line

c. Moves to the cursor one paragraph down

d. Moves to the cursor one word left

57 / 60

The speed of a CPU is measured in what?

a. Horsepower

b. Bits per second (Bps)

c. Megahertz (MHz) and gigahertz (GHz)

d. Lux

58 / 60

They normally interact with the system via user interface provided by the application software.?

a. Developers

b. Testers

c. Users

d. Programmers

59 / 60

What do you call a program in execution?

a. Command

b. Task

c. Process

d. Instruction

60 / 60

Shortcut key to open pre-made Presentation is ____________.?

a. CTRL + N

b. CTRL + O

c. CTRL + A

d. CTRL + L

Your score is

The average score is 0%

Any comments?

Information Technology Test

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

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