/202
89

Information Technology Preparation (Mr. Kong Saroeum)

 

1 / 202

1) Ordinal level data are characterized by ___________.?

2 / 202

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

3 / 202

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

4 / 202

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

5 / 202

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

6 / 202

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

7 / 202

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

8 / 202

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

9 / 202

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

10 / 202

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

11 / 202

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

12 / 202

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

13 / 202

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

14 / 202

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

15 / 202

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

16 / 202

16) Formula in Excel start with ___________.?

17 / 202

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

18 / 202

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

19 / 202

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

20 / 202

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

21 / 202

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

22 / 202

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

23 / 202

23) CPU is an abbreviation for _________.?

24 / 202

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

25 / 202

25) What is a backup?

26 / 202

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

27 / 202

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

28 / 202

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

29 / 202

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

30 / 202

30) A device driver is _____________________________. ?

31 / 202

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

32 / 202

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

33 / 202

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

34 / 202

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

35 / 202

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

36 / 202

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

37 / 202

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

38 / 202

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

39 / 202

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

40 / 202

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

41 / 202

41) What is animation?

42 / 202

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

43 / 202

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

44 / 202

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

45 / 202

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

46 / 202

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

47 / 202

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

48 / 202

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

49 / 202

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

50 / 202

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

51 / 202

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

52 / 202

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

53 / 202

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

54 / 202

54) To delete one word to the right?

55 / 202

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

56 / 202

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

57 / 202

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

58 / 202

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

59 / 202

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

60 / 202

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

61 / 202

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

62 / 202

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

63 / 202

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

64 / 202

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

65 / 202

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

66 / 202

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

67 / 202

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

68 / 202

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

69 / 202

69) BIOS stands for ____________.?

70 / 202

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

71 / 202

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

72 / 202

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

73 / 202

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

74 / 202

74) Handout Master is defined by _______________.?

75 / 202

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

76 / 202

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

77 / 202

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

78 / 202

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

79 / 202

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

80 / 202

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

81 / 202

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

82 / 202

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

83 / 202

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

84 / 202

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

85 / 202

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

86 / 202

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

87 / 202

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

88 / 202

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

89 / 202

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

90 / 202

90) What do you call a program in execution?

91 / 202

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

92 / 202

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

93 / 202

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

94 / 202

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

95 / 202

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

96 / 202

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

97 / 202

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

98 / 202

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

99 / 202

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

100 / 202

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

101 / 202

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

102 / 202

102) The most common input devices include ___________.?

103 / 202

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

104 / 202

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

105 / 202

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

106 / 202

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

107 / 202

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

108 / 202

108)

The software designed to perform a specific task.?

109 / 202

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

110 / 202

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

111 / 202

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

112 / 202

112) How can you remove borders applied in cells?

113 / 202

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

114 / 202

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

115 / 202

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

116 / 202

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

117 / 202

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

118 / 202

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

119 / 202

119) RAM stands for ___________.?

120 / 202

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

121 / 202

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

122 / 202

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

123 / 202

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

124 / 202

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

125 / 202

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

126 / 202

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

127 / 202

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

128 / 202

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

129 / 202

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

130 / 202

130) VIRUS stands for ___________________.?

131 / 202

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

132 / 202

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

133 / 202

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

134 / 202

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

135 / 202

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

136 / 202

136) END Key used to ___________________.?

137 / 202

137) One yottabyte consists of ___________.?

138 / 202

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

139 / 202

139) Which is the basic element of Power Point?

140 / 202

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

141 / 202

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

142 / 202

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

143 / 202

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

144 / 202

144) Number of bits in ALU is ___________.?

145 / 202

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

146 / 202

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

147 / 202

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

148 / 202

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

149 / 202

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

150 / 202

150) VDU stands for _________________.?

151 / 202

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

152 / 202

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

153 / 202

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

154 / 202

154) Page Up Key uses for ___________________________________.?

155 / 202

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

156 / 202

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

157 / 202

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

158 / 202

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

159 / 202

159) What does LAN stand for?

160 / 202

160) One nibble is equivalent to _____________ bits.?

161 / 202

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

162 / 202

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

163 / 202

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

164 / 202

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

165 / 202

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

166 / 202

166) What is shortcut key for toggle ribbon?

167 / 202

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

168 / 202

168) WWW means __________.?

169 / 202

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

170 / 202

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

171 / 202

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

172 / 202

172) What is the file extension of Spreadsheet Application?

173 / 202

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

174 / 202

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

175 / 202

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

176 / 202

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

177 / 202

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

178 / 202

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

179 / 202

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

180 / 202

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

181 / 202

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

182 / 202

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

183 / 202

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

184 / 202

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

185 / 202

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

186 / 202

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

187 / 202

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

188 / 202

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

189 / 202

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

190 / 202

190)

The set of programs which consists of full documentation. ?

191 / 202

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

192 / 202

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

193 / 202

193) How do you magnify your document?

194 / 202

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

195 / 202

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

196 / 202

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

197 / 202

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

198 / 202

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

199 / 202

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

200 / 202

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

201 / 202

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

202 / 202

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

Your score is

The average score is 86%

0%

Any comments?