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 command would you use to save a document for the first time?

a. Save As

b. Save

c. Either A or B

d. Save for the first time

2 / 60

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

a. Click on: Analyze; Descriptive Statistics; Frequencies

b. Open the Variable Viewer and recode the value labels

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

d. Click on: Graphs; Frequencies; Pearson

3 / 60

To open Power Point from Run Dialog Box, type _____________________.?

a. Pwrpoint

b. PowerPoint

c. Powerpnt

d. Powerpint

4 / 60

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

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

b. Percent (%)

c. Negative number (-)

d. Exponentiation (ˆ

5 / 60

The main directory of a disk is called the __________ directory.?

a. folder

b. network

c. root

d. sub

6 / 60

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

a. A9:E9

b. A9

c. $A$9

d. A$9

7 / 60

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

a. Column marker

b. Fill handle

c. Formula bar

d. Cell pointer

8 / 60

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

a. Platform software

b. Operating system software

c. Application software

d. System software

9 / 60

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

a. Border format

b. Number format

c. All are corrects

d. Font format

10 / 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 sampling distribution of the mean

b. The population distribution of the mean

c. The bootstrap distribution of the mean

d. The standard error of the mean

11 / 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. In order to make full use of the facilities that SPSS can offer.

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

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

12 / 60

Which of the following is not a process state?

a. Running

b. Terminated

c. Blocked

d. Execution

13 / 60

The speed of a CPU is measured in what?

a. Megahertz (MHz) and gigahertz (GHz)

b. Horsepower

c. Lux

d. Bits per second (Bps)

14 / 60

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

a. Replace

b. Copy

c. Undo

d. Insert

15 / 60

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

a. Font size

b. Cell content

c. Font color

d. Bold

16 / 60

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

a. B1$F5

b. B1 to F5

c. B1:F5

d. B1-F5

17 / 60

The Name box on to the left of formula bar.?

a. Shows the name of workbook currently working on

b. None of above

c. Shows the name of cell or range currently working on

d. Shows the name of worksheet currently working on

18 / 60

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

a. .pptc

b. .ppte

c. .pptx

d. .ppt

19 / 60

Which of the following operations moves text from clipboard?

a. Paste

b. Drag and Drop

c. Cut

d. Copy

20 / 60

Components that provide internal storage to the CPU are ____________.?

a. Registers

b. Controllers

c. Internal chips

d. Program Counters

21 / 60

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

a. Software Manager

b. User

c. System Developer

d. System Programmer

22 / 60

Which feature enables you to preview headers and footers, page breaks, and other features that
will print?

a. ScreenTips

b. Print Layout

c. Synchronous Scrolling

d. Page Layout

23 / 60

Which of the following is designed to control the operations of a computer?

a. System Software

b. Application Software

c. User

d. Utility Software

24 / 60

The page to create Presentation in Power Point is called _____________.?

a. Document

b. Sheet

c. Slide

d. Paper

25 / 60

What is the “brain” or main chip of a computer called?

a. RAM

b. ROM-BIOS

c. CPU

d. Motherboard

26 / 60

The only language which the computer understands is _____________.?

a. Assembly Language

b. BASIC

c. C Language

d. Binary Language

27 / 60

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

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

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

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

d. It accepts the results produced by the computer

28 / 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. COUNT

b. AVERAGE

c. MIN

d. MAX

29 / 60

What is animation?

a. Accelerate static image

b. To make a picture

c. Print out

d. Changing the picture in the graph

30 / 60

The two basic types of memory in a computer are ___________________.?

a. Main and virtual

b. Primary and Secondary

c. Minor and Major

d. Primary and major

31 / 60

What is entered by the function =TODAY()?

a. None of the above

b. Today’s date as Text format

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

d. The time value according to system clock

32 / 60

“CTR+PageDown” is used to ______________________________.?

a. Moves to the cursor one Line Down

b. Moves to the cursor one Screen Down

c. Moves to the cursor one Page Down

d. Moves to the cursor one Paragraph Down

33 / 60

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

a. Memory Unit

b. Arithmetic & Logic Unit

c. Input Unit

d. Output Unit

34 / 60

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

a. Cache Unit

b. Storage Unit

c. Input Unit

d. Output Unit

35 / 60

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

a. Memory Devices

b. Output Unit

c. Flags

d. Registers

36 / 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

37 / 60

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

a. Title Bar

b. Standard Tool Bar

c. None of the above

d. Formula Bar

38 / 60

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

a. Servers

b. Supercomputers

c. Mainframes

d. Laptops

39 / 60

The metal or plastic case that holds all the physical parts of the computer is the______.?

a. Platform

b. CPU

c. Mainframe

d. System Unit

40 / 60

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

a. Decimal Places

b. Percentage symbol

c. None of the above

d. Currency Symbol

41 / 60

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

a. Moves to the cursor beginning of the line

b. Moves to the cursor one word left

c. Moves to the cursor one paragraph down

d. Moves to the cursor one paragraph

42 / 60

Excel display the current cell address in the _________________.?

a. Formula bar

b. None of the above

c. Name Box

d. Status Bar

43 / 60

__________ key is used for Help in Power Point.?

a. F6

b. F2

c. F1

d. F3

44 / 60

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

a. Moves to the cursor one Screen Down

b. Moves to the cursor one Paragraph Down

c. Moves to the cursor one Line Down

d. Moves to the cursor one Page Down

45 / 60

END Key used to ___________________.?

a. Moves the cursor end of the screen

b. Moves the cursor end of the document

c. Moves the cursor end of the line

d. Moves the cursor end of the paragraph

46 / 60

The devices that used to give single or multiple colored images and drawings are _____.?

a. Plotters

b. Monitors

c. VDUs

d. Printers

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. Middle Align

b. Top Align

c. Center

d. Justify

48 / 60

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

a. The amount of memory or RAM

b. The number of keys on the keyboard

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

d. The speed of the CPU

49 / 60

Which of the following helps to reduce spelling error in the document?

a. Auto Text

b. Smart Tags

c. Auto Format

d. Auto Correct

50 / 60

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

a. Workbook

b. Quick Access Toolbar

c. Printer setup

d. Print Preview

51 / 60

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

a. Page Up

b. Delete

c. Page Down

d. Backspace

52 / 60

____________ is not the view of Power Point.?

a. Outline view

b. Normal view

c. Slide Show view Slide Sorter view

d. Slide Show view

53 / 60

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

a. in secondary storage

b. in the CPU

c. in RAM

d. on a CD

54 / 60

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

a. Square root transformation

b. Reciprocal transformation

c. Tangent transformation

d. Log transformation

55 / 60

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

a. IF

b. AVERAGE

c. COUNT

d. SUM

56 / 60

One nibble is equivalent to _____________ bits.?

a. 8

b. 2

c. 1

d. 4

57 / 60

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

a. #DIV

b. #####

c. None of these

d. #DIV/0

58 / 60

Which of the following is the least affected by outliers?

a. The median

b. The mean

c. The standard deviation

d. The range

59 / 60

How can you remove borders applied in cells?

a. No answer

b. Choose None on Border tab of Format cells

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

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

60 / 60

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

a. Preset file

b. Text fil e

c. Blank workbook

d. Template

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!

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