/202
336

Information Technology Preparation (Mr. Kong Saroeum)

 

1 / 202

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

2 / 202

2) For what is the ‘variable view’ in IBM SPSS’s data editor used?

3 / 202

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

4 / 202

4) Which of the following provides a list of synonyms?

5 / 202

5) Which command would you use to save a document for the first time?

6 / 202

6) 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?

7 / 202

7) An example of an output device is __________.?

8 / 202

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

9 / 202

9) The smallest unit of data in computer is ____________.?

10 / 202

10) BIOS stands for ____________.?

11 / 202

11) Shortcut key for the Slide Show view is ___________.?

12 / 202

12) An Excel file is generally called a/an __________.?

13 / 202

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

14 / 202

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

15 / 202

15) Which of the following is not an arithmetic operator?

16 / 202

16) Smaller and less expensive PC-based servers are replacing ____________ in many businesses.?

17 / 202

17) Number of bits in ALU is ___________.?

18 / 202

18) Which of the following is not a process state?

19 / 202

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

20 / 202

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

21 / 202

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

22 / 202

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

23 / 202

23) 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?

24 / 202

24) 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 _____________.?

25 / 202

25) A device driver is _____________________________. ?

26 / 202

26) Which of the following is NOT an operating system?

27 / 202

27) 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?

28 / 202

28) How do you magnify your document?

29 / 202

29) VDU stands for _________________.?

30 / 202

30) What does LAN stand for?

31 / 202

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

32 / 202

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

33 / 202

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

34 / 202

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

35 / 202

35) RAM stands for ___________.?

36 / 202

36) One nibble is equivalent to _____________ bits.?

37 / 202

37) If we calculated an effect size and found it was r = .42 which expression would best describe
the size of effect?

38 / 202

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

39 / 202

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

40 / 202

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

41 / 202

41) WWW means __________.?

42 / 202

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

43 / 202

43) Do this to display the contents of a certain drive or folder:?

44 / 202

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

45 / 202

45) __________ is known as unauthorized access into others system.?

46 / 202

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

47 / 202

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

48 / 202

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

49 / 202

49) 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?

50 / 202

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

51 / 202

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

52 / 202

52) Which key deletes the character to the left of the cursor?

53 / 202

53) Page Up Key uses for ___________________________________.?

54 / 202

54) What is shortcut key for toggle ribbon?

55 / 202

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

56 / 202

56) The speed of a CPU is measured in what?

57 / 202

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

58 / 202

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

59 / 202

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

60 / 202

60) In word processing, an efficient way to move the 3rd paragraph to place it after the 5th
paragraph is _________.?

61 / 202

61) Which of the following component displays the contents of active cell?

62 / 202

62) A desktop computer is also known as a ___________.?

63 / 202

63) ____________ is not the view of Power Point.?

64 / 202

64) To delete one word to the right?

65 / 202

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

66 / 202

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

67 / 202

67) Which would you choose to move selected text from one place to another?

68 / 202

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

69 / 202

69) Which one is not a Function in MS Excel?

70 / 202

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

71 / 202

71) What is the relationship between the sum of squared errors (SS), the sample size (n) and the
variance (s2)?

72 / 202

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

73 / 202

73) Ordinal level data are characterized by ___________.?

74 / 202

74) The only language which the computer understands is _____________.?

75 / 202

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

76 / 202

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

77 / 202

77) An arrow in the lower-right corner of a group on the ribbon tells you that which of the following
is available?

78 / 202

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

79 / 202

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

80 / 202

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

81 / 202

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

82 / 202

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

83 / 202

83) In Excel, Columns are labelled as ___________.?

84 / 202

84) How is a variable name different from a variable label?

85 / 202

85) 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?

86 / 202

86) When all the numbers between 0 and 100 in a range should be displayed in Red color, apply
___________.?

87 / 202

87) The first screen you see when you open Word 2016 is called the ______________.?

88 / 202

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

89 / 202

89) What is the storage area for e-mail messages called?

90 / 202

90)

The set of programs which consists of full documentation. ?

91 / 202

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

92 / 202

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

93 / 202

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

94 / 202

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

95 / 202

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

96 / 202

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

97 / 202

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

98 / 202

98) How would you print a bar chart that you have just produced in SPSS?

99 / 202

99) The degree to which a statistical model represents the data collected is known as the ______.?

100 / 202

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

101 / 202

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

102 / 202

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

103 / 202

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

104 / 202

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

105 / 202

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

106 / 202

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

107 / 202

107) Which one is not an examples of input devices?

108 / 202

108) Linux is a (an) ____________ operating system.?

109 / 202

109) Which f the following does a box–whisker plot not display?

110 / 202

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

111 / 202

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

112 / 202

112) 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?

113 / 202

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

114 / 202

114) Handout Master is defined by _______________.?

115 / 202

115) END Key used to ___________________.?

116 / 202

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

117 / 202

117) What is the file extension of Power Point Application?

118 / 202

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

119 / 202

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

120 / 202

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

121 / 202

121) A string of eight 0’s or 1’s is called a: ?

122 / 202

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

123 / 202

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

124 / 202

124) _______controls the way in which the computer system functions and provides a means by
which users can interact with the computer. ?

125 / 202

125) Which tool you will use to join some cells and place the content at the middle of joined cell?

126 / 202

126) VIRUS stands for ___________________.?

127 / 202

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

128 / 202

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

129 / 202

129) What is entered by the function =TODAY()?

130 / 202

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

131 / 202

131) How can you remove borders applied in cells?

132 / 202

132) Power Point presentation are commonly used in ___________________.?

133 / 202

133) Which of the following operations moves text from clipboard?

134 / 202

134) What is a backup?

135 / 202

135) What is the file extension of Spreadsheet Application?

136 / 202

136) To generate a Spearman’s rho test, which set of instructions should you give SPSS?

137 / 202

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

138 / 202

138) Approximately what percentage of people would have scores lower than an individual with a
z-score of 1.65 in a normally distributed sample?

139 / 202

139) The most common input devices include ___________.?

140 / 202

140) What is animation?

141 / 202

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

142 / 202

142) Which of the following is an acceptable name for a named range?

143 / 202

143) Excel display the current cell address in the _________________.?

144 / 202

144) Which enables us to send the same letter to different persons?

145 / 202

145) Formula in Excel start with ___________.?

146 / 202

146) The physical devices of a computer are called _________.?

147 / 202

147) Variation due to some genuine effect is known as _____________.?

148 / 202

148) Which is the basic element of Power Point?

149 / 202

149) 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?

150 / 202

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

151 / 202

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

152 / 202

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

153 / 202

153) What do you call a program in execution?

154 / 202

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

155 / 202

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

156 / 202

156) What is the file extension of word processing Application?

157 / 202

157) Which of the following is the intersection of a row and column?

158 / 202

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

159 / 202

159) The hardware device commonly referred to as the ‘brain’ of the computer is the ______.?

160 / 202

160) __________ key is used for Help in Power Point.?

161 / 202

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

162 / 202

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

163 / 202

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

164 / 202

164) CPU is an abbreviation for _________.?

165 / 202

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

166 / 202

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

167 / 202

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

168 / 202

168) What is the shortcut key to “Center Align” the selected text?

169 / 202

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

170 / 202

170) 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)?

171 / 202

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

172 / 202

172) One yottabyte consists of ___________.?

173 / 202

173) Which function will you use to enter current time in a worksheet cell?

174 / 202

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

175 / 202

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

176 / 202

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

177 / 202

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

178 / 202

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

179 / 202

179) “CTR+PageDown” is used to ______________________________.?

180 / 202

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

181 / 202

181) The process of transferring files from a computer on the Internet to your computer is called
_____________.?

182 / 202

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

183 / 202

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

184 / 202

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