/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) What is animation?

3 / 202

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

4 / 202

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

5 / 202

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

6 / 202

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

7 / 202

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

8 / 202

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

9 / 202

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

10 / 202

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

11 / 202

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

12 / 202

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

13 / 202

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

14 / 202

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

15 / 202

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

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) Per the order of operations, which of the following is calculated first?

18 / 202

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

19 / 202

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

20 / 202

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

21 / 202

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

22 / 202

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

23 / 202

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

24 / 202

24) RAM stands for ___________.?

25 / 202

25) VDU stands for _________________.?

26 / 202

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

27 / 202

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

28 / 202

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

29 / 202

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

30 / 202

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

31 / 202

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

32 / 202

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

33 / 202

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

34 / 202

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

35 / 202

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

36 / 202

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

37 / 202

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

38 / 202

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

39 / 202

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

40 / 202

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

41 / 202

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

42 / 202

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

43 / 202

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

44 / 202

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

45 / 202

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

46 / 202

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

47 / 202

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

48 / 202

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

49 / 202

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

50 / 202

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

51 / 202

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

52 / 202

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

53 / 202

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

54 / 202

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

55 / 202

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

56 / 202

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

57 / 202

57) To delete one word to the right?

58 / 202

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

59 / 202

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

60 / 202

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

61 / 202

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

62 / 202

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

63 / 202

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

64 / 202

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

65 / 202

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

66 / 202

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

67 / 202

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

68 / 202

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

69 / 202

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

70 / 202

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

71 / 202

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

72 / 202

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

73 / 202

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

74 / 202

74)

The set of programs which consists of full documentation. ?

75 / 202

75) One nibble is equivalent to _____________ bits.?

76 / 202

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

77 / 202

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

78 / 202

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

79 / 202

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

80 / 202

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

81 / 202

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

82 / 202

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

83 / 202

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

84 / 202

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

85 / 202

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

86 / 202

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

87 / 202

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

88 / 202

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

89 / 202

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

90 / 202

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

91 / 202

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

92 / 202

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

93 / 202

93) WWW means __________.?

94 / 202

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

95 / 202

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

96 / 202

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

97 / 202

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

98 / 202

98) Handout Master is defined by _______________.?

99 / 202

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

100 / 202

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

101 / 202

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

102 / 202

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

103 / 202

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

104 / 202

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

105 / 202

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

106 / 202

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

107 / 202

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

108 / 202

108) END Key used to ___________________.?

109 / 202

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

110 / 202

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

111 / 202

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

112 / 202

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

113 / 202

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

114 / 202

114) What is the file extension of Spreadsheet Application?

115 / 202

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

116 / 202

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

117 / 202

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

118 / 202

118) Formula in Excel start with ___________.?

119 / 202

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

120 / 202

120) The most common input devices include ___________.?

121 / 202

121) Page Up Key uses for ___________________________________.?

122 / 202

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

123 / 202

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

124 / 202

124) What is a backup?

125 / 202

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

126 / 202

126) How do you magnify your document?

127 / 202

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

128 / 202

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

129 / 202

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

130 / 202

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

131 / 202

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

132 / 202

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

133 / 202

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

134 / 202

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

135 / 202

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

136 / 202

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

137 / 202

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

138 / 202

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

139 / 202

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

140 / 202

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

141 / 202

141) What is shortcut key for toggle ribbon?

142 / 202

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

143 / 202

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

144 / 202

144) A device driver is _____________________________. ?

145 / 202

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

146 / 202

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

147 / 202

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

148 / 202

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

149 / 202

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

150 / 202

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

151 / 202

151) BIOS stands for ____________.?

152 / 202

152) CPU is an abbreviation for _________.?

153 / 202

153) What do you call a program in execution?

154 / 202

154) Which is the basic element of Power Point?

155 / 202

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

156 / 202

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

157 / 202

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

158 / 202

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

159 / 202

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

160 / 202

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

161 / 202

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

162 / 202

162) One yottabyte consists of ___________.?

163 / 202

163) What does LAN stand for?

164 / 202

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

165 / 202

165) Number of bits in ALU is ___________.?

166 / 202

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

167 / 202

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

168 / 202

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

169 / 202

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

170 / 202

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

171 / 202

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

172 / 202

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

173 / 202

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

174 / 202

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

175 / 202

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

176 / 202

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

177 / 202

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

178 / 202

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

179 / 202

179) VIRUS stands for ___________________.?

180 / 202

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

181 / 202

181) How can you remove borders applied in cells?

182 / 202

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

183 / 202

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

184 / 202

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

185 / 202

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

186 / 202

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

187 / 202

187) Ordinal level data are characterized by ___________.?

188 / 202

188)

The software designed to perform a specific task.?

189 / 202

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

190 / 202

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

191 / 202

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

192 / 202

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

193 / 202

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

194 / 202

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

195 / 202

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

196 / 202

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

197 / 202

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

198 / 202

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

199 / 202

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

200 / 202

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

201 / 202

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

202 / 202

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

Your score is

The average score is 86%

0%

Any comments?