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

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

a. Moves to the cursor one Page Down

b. Moves to the cursor one Screen Down

c. Moves to the cursor one Paragraph Down

d. Moves to the cursor one Line Down

2 / 60

How many sheets are there, by default, when we create a new Excel file?

a. 1

b. 3

c. 10

d. 5

3 / 60

Which one is not a Function in MS Excel?

a. SUM

b. MAX

c. MIN

d. AVG

4 / 60

When items on a questionnaire appear to correspond to the construct that the questionnaire
claims to measure it is said to have __________________.?

a. Criterion validity

b. Ecological validity

c. Factorial validity

d. Content validity

5 / 60

What is the file extension of word processing Application?

a. .docx

b. .pptx

c. .jpeg

d. .xlsx

6 / 60

How can you remove borders applied in cells?

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

b. Choose None on Border tab of Format cells

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

d. No answer

7 / 60

In which sub-dialog box can the Chi Square test be found?

a. Frequencies: Percentages

b. Bivariate: Pearson

c. Gender: Female

d. Crosstabs: Statistics

8 / 60

You accidentally erased a record in the sheet. What command can be used to restore it
immediately?

a. Undo

b. Insert

c. Replace

d. Copy

9 / 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. the system unit

c. application software

d. instructions

10 / 60

In SPSS, what is the “Data Viewer”?

a. A spreadsheet into which data can be entered.

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

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

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

11 / 60

Which command is used to insert a cut or copied selection to a cell or range of cells?

a. Copy

b. Range

c. Document properties

d. Paste

12 / 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. Fill handle

b. Column marker

c. Formula bar

d. Cell pointer

13 / 60

Which of the following best describes the variable ‘Gender’?

a. All of the possible answers are correct.

b. A between-group variable.

c. A grouping variable.

d. A coding variable.

14 / 60

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

a. Utility Software

b. User

c. System Software

d. Application Software

15 / 60

Which function in Excel checks whether a condition is true or not?

a. COUNT

b. IF

c. AVERAGE

d. SUM

16 / 60

VIRUS stands for ___________________.?

a. Vital Information Reason Under Siege

b. Vital Information Recourse Under Siege

c. Vital Information Recourse Under System

d. Virus Information Recourse Under Siege

17 / 60

Out of the following options, which type of bar chart would we produce to look at the mean
ratings of ‘taste’ and ‘value for money’ for two new varieties of Sauvignon Blanc wine?

a. Clustered bar chart

b. All of the options are possible.

c. Stacked bar chart

d. 3-D bar chart

18 / 60

If you want to use a workbook in another kind of document, you have the option to save using
which of the following?

a. File sheet

b. File range

c. File format

d. Worksheet

19 / 60

How is a variable name different from a variable label?

a. It is longer and more detailed.

b. It is abstract and unspecific.

c. It is shorter and less detailed.

d. It refers to codes rather than variables.

20 / 60

When you type a document on a computer, every letter you type is saved to the computer’s
___________ or temporary storage area.?

a. Hard drive

b. RAM

c. CPU

d. ROM

21 / 60

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

a. Output Unit

b. Flags

c. Memory Devices

d. Registers

22 / 60

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

a. Programmers

b. Testers

c. Users

d. Developers

23 / 60

RAM stands for ___________.?

a. Random access memory

b. Read only memory

c. Random only memory

d. Random origin money

24 / 60

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

a. Template

b. Preset file

c. Blank workbook

d. Text fil e

25 / 60

Which is a grid of columns and rows that is used to organize data?

a. Column

b. Table

c. Row

d. None of the above

26 / 60

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

a. Column

b. Cell

c. Box

d. Table

27 / 60

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

a. Pressing the Esc key

b. Clicking the enter button the formula bar

c. None of the above

d. Pressing the tab key

28 / 60

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

a. MAX

b. MIN

c. SUM

d. COUNTA

29 / 60

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

a. command

b. button

c. worksheet

d. tab

30 / 60

___________ is the raw material used as input and ___________ is the processed data obtained as
output of data processing.?

a. Instructions, Program

b. Program, Code

c. Data, Instructions

d. Data, Program

31 / 60

Per the order of operations, which of the following is calculated first?

a. Exponentiation (ˆ

b. Negative number (-)

c. Percent (%)

d. Addition (+) and subtraction (-) (left to right)

32 / 60

Which of the following is not an arithmetic operator?

a. –

b. ]

c. *

d. +

33 / 60

Which is the basic element of Power Point?

a. Sheet

b. Page

c. File

d. Slide

34 / 60

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

a. 89.60

b. 8960.0

c. 0.008960

d. 8.960

35 / 60

In Excel, Columns are labelled as ___________.?

a. 1, 2, 3, etc.

b. A, B, C, etc.

c. $A$1, $A$2, etc.

d. A1, A2, etc.

36 / 60

The software designed to perform a specific task.?

a. System Software

b. Package Software

c. Application Software

d. Synchronous Software

37 / 60

Which of the following calculates the total from the adjacent cell through the first nonnumeric
cell by default, using the SUM function in its formula?

a. AVERAGE

b. MAX

c. COUNT

d. AutoSum

38 / 60

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

a. in secondary storage

b. in the CPU

c. on a CD

d. in RAM

39 / 60

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

a. A9

b. A9:E9

c. $A$9

d. A$9

40 / 60

Number of bits in ALU is ___________.?

a. 4

b. 16

c. 2

d. 8

41 / 60

Which of the following starts off with Save, Undo, and Redo and can be customized to contain
the commands you use most frequently?

a. A worksheet

b. The Help windows

c. The ribbon

d. The Quick Access Toolbar

42 / 60

One yottabyte consists of ___________.?

a. 1024 PB

b. 1024 ZB

c. 1024 TB

d. 1024 EB

43 / 60

System software is the set of programs that enables your computers, hardware devices and
____________ software to work together.?

a. Utility

b. Application

c. Management

d. Processing

44 / 60

If we were to pull all possible samples from a population, calculate the mean for every sample,
and construct a graph of the shape of the distribution based on all of the means, what would we
have?

a. The population distribution of the mean

b. The standard error of the mean

c. The bootstrap distribution of the mean

d. The sampling distribution of the mean

45 / 60

A device driver is _____________________________. ?

a. A computer program that allows the operating system to communicate with the device

b. The power supply for the device

c. The connector that allows you to attach the device to a computer

d. The person who delivers hardware devices to a computer store

46 / 60

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

a. Execute instructions

b. Direct operations

c. Read instructions

d. Interpret instructions

47 / 60

You want to format a cell so the text is spread evenly throughout the cell, wrapping
automatically and adjusting the row height, if necessary. Which of the following alignment
options should be used?

a. Center

b. Middle Align

c. Justify

d. Top Align

48 / 60

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

a. Quick Access Screen

b. Quick Access Toolbar

c. Quick command

d. Quick toolbar

49 / 60

After a picture has been taken with a digital camera and processed appropriately, the actual
print of the picture is considered as ___________.?

a. Process

b. Data

c. Output

d. Input.

50 / 60

To delete one word to the right?

a. CTRL+DEL

b. CTRL+SHIFT

c. CTRL+TAB

51 / 60

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

a. Control unit

b. Disk unit

c. ALU

d. System Unit

52 / 60

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

a. in the CPU

b. in RAM

c. on a CD

d. in secondary storage

53 / 60

What process should be used to recall a document saved previously?

a. Save

b. Copy

c. Enter

d. Retrieve

54 / 60

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

a. Table

b. Data

c. Theme

d. Slide

55 / 60

Which of the following consists of details that describe or identify a file, including the author?

a. Copy

b. Document properties

c. Paste

d. Range

56 / 60

Power Point presentation are commonly used in ___________________.?

a. Project presentations by students

b. Note outline for teachers

c. All are corrects

d. Communication of planning

57 / 60

Which of the following operations moves text from clipboard?

a. Copy

b. Cut

c. Drag and Drop

d. Paste

58 / 60

What is the file extension of Power Point Application?

a. .xlsx

b. .jpeg

c. .pptx

d. .docx

59 / 60

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

a. All are corrects

b. Font format

c. Number format

d. Border format

60 / 60

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

a. Shift + F7

b. Ctrl + F7

c. Alt + F7

d. F7

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!

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