/202
0

Information Technology Preparation (Mr. Kong Saroeum)

 

1 / 202

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

2 / 202

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

3 / 202

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

4 / 202

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

5 / 202

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

6 / 202

6) Which of the following best describes the variable β€˜Gender’?

7 / 202

7) β€œCTR+Left Arrow” is used to ______________________________.?

8 / 202

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

9 / 202

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

10 / 202

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

11 / 202

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

12 / 202

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

13 / 202

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

14 / 202

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

15 / 202

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

16 / 202

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

17 / 202

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

18 / 202

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

19 / 202

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

20 / 202

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

21 / 202

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

22 / 202

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

23 / 202

23) Formula in Excel start with ___________.?

24 / 202

24) Which of the following is the least affected by outliers?

25 / 202

25) Page Up Key uses for ___________________________________.?

26 / 202

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

27 / 202

27) The β€˜heart’ of the processor which performs many different operations___________.?

28 / 202

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

29 / 202

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

30 / 202

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

31 / 202

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

32 / 202

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

33 / 202

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

34 / 202

34) What is the shortcut key to β€œUndo” the last action in a document?

35 / 202

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

36 / 202

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

37 / 202

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

38 / 202

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

39 / 202

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

40 / 202

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

41 / 202

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

42 / 202

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

43 / 202

43) How can you remove borders applied in cells?

44 / 202

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

45 / 202

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

46 / 202

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

47 / 202

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

48 / 202

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

49 / 202

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

50 / 202

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

51 / 202

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

52 / 202

52) What is the shortcut key to β€œCenter Align” the selected text?

53 / 202

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

54 / 202

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

55 / 202

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

56 / 202

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

57 / 202

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

58 / 202

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

59 / 202

59) Which of the following does NOT affect a computerβ€Ÿ s performance?

60 / 202

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

61 / 202

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

62 / 202

62) What is a backup?

63 / 202

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

64 / 202

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

65 / 202

65) In SPSS, what is the “Data Viewer”?

66 / 202

66) END Key used to ___________________.?

67 / 202

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

68 / 202

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

69 / 202

69) What is the file extension of Spreadsheet Application?

70 / 202

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

71 / 202

71) The most common input devices include ___________.?

72 / 202

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

73 / 202

73) What does LAN stand for?

74 / 202

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

75 / 202

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

76 / 202

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

77 / 202

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

78 / 202

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

79 / 202

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

80 / 202

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

81 / 202

81) One yottabyte consists of ___________.?

82 / 202

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

83 / 202

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

84 / 202

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

85 / 202

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

86 / 202

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

87 / 202

87)

The set of programs which consists of full documentation. ?

88 / 202

88) VIRUS stands for ___________________.?

89 / 202

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

90 / 202

90) How much information can be stored in a kilobyte?

91 / 202

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

92 / 202

92) What is the shortcut key for β€œSpelling Check” in document?

93 / 202

93) To delete one word to the right?

94 / 202

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

95 / 202

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

96 / 202

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

97 / 202

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

98 / 202

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

99 / 202

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

100 / 202

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

101 / 202

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

102 / 202

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

103 / 202

103) The hardware device commonly referred to as the β€˜brain’ of the computer is the ______.?

104 / 202

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

105 / 202

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

106 / 202

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

107 / 202

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

108 / 202

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

109 / 202

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

110 / 202

110) β€œCTR+PageDown” is used to ______________________________.?

111 / 202

111) Which of the following is used to hold running program instructions?

112 / 202

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

113 / 202

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

114 / 202

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

115 / 202

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

116 / 202

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

117 / 202

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

118 / 202

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

119 / 202

119) Number of bits in ALU is ___________.?

120 / 202

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

121 / 202

121) A device driver is _____________________________. ?

122 / 202

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

123 / 202

123) Handout Master is defined by _______________.?

124 / 202

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

125 / 202

125) For what is the β€˜variable view’ in IBM SPSS’s data editor used?

126 / 202

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

127 / 202

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

128 / 202

128)

The software designed to perform a specific task.?

129 / 202

129) Which of the numbers below might IBM SPSS report as 10.574 Eβˆ’05?

130 / 202

130) VDU stands for _________________.?

131 / 202

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

132 / 202

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

133 / 202

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

134 / 202

134) β€œCTR+Down Arrow” is used to ______________________________.?

135 / 202

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

136 / 202

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

137 / 202

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

138 / 202

138) What is animation?

139 / 202

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

140 / 202

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

141 / 202

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

142 / 202

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

143 / 202

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

144 / 202

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

145 / 202

145) WWW means __________.?

146 / 202

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

147 / 202

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

148 / 202

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

149 / 202

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

150 / 202

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

151 / 202

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

152 / 202

152) A Button you can click to take you to a different slide, a file, a website, sound, etc. is called
____.?

153 / 202

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

154 / 202

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

155 / 202

155) What is shortcut key for toggle ribbon?

156 / 202

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

157 / 202

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

158 / 202

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

159 / 202

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

160 / 202

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

161 / 202

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

162 / 202

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

163 / 202

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

164 / 202

164) When you split a window, the window is divided into how many panes?

165 / 202

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

166 / 202

166) CPU is an abbreviation for _________.?

167 / 202

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

168 / 202

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

169 / 202

169) Which is the basic element of Power Point?

170 / 202

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

171 / 202

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

172 / 202

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

173 / 202

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

174 / 202

174) What do you call a program in execution?

175 / 202

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

176 / 202

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

177 / 202

177) BIOS stands for ____________.?

178 / 202

178) Ordinal level data are characterized by ___________.?

179 / 202

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

180 / 202

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

181 / 202

181) RAM stands for ___________.?

182 / 202

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

183 / 202

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

184 / 202

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

185 / 202

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

186 / 202

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

187 / 202

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

188 / 202

188) What is the β€œbrain” or main chip of a computer called?

189 / 202

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

190 / 202

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

191 / 202

191) Where can you set the shading color for a range of cells in Excel?

192 / 202

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

193 / 202

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

194 / 202

194) How do you magnify your document?

195 / 202

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

196 / 202

196) One nibble is equivalent to _____________ bits.?

197 / 202

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

198 / 202

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

199 / 202

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

200 / 202

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

201 / 202

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

202 / 202

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

Your score is

The average score is 0%

0%

Any comments?