/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? a. COUNTA b. COUNT c. SUM d. COUNTBLANK 2 / 202 2) For what is the âvariable viewâ in IBM SPSSâs data editor used? a. Defining characteristics of variables. b. Writing syntax. c. Entering data. d. Viewing output from data analysis. 3 / 202 3) The collection of links throughout the Internet creates an interconnected network called the ______________.? a. Web b. WWW c. All of the above d. World Wide Web 4 / 202 4) Which of the following provides a list of synonyms? a. Replace Command b. Spelling and Grammar c. Find command d. Thesaurus 5 / 202 5) Which command would you use to save a document for the first time? a. Save b. Either A or B c. Save for the first time d. Save As 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? a. Column marker b. Cell pointer c. Formula bar d. Fill handle 7 / 202 7) An example of an output device is __________.? a. The keyboard b. The mouse c. The power cord d. The monitor 8 / 202 8) Which of the numbers below might IBM SPSS report as 8.96 E+03? a. 8960.0 b. 8.960 c. 0.008960 d. 89.60 9 / 202 9) The smallest unit of data in computer is ____________.? a. Byte b. Nibble c. KB d. Bit 10 / 202 10) BIOS stands for ____________.? a. Basic Input Output System b. All the above c. Basic Input Off system d. Binary Input Output System 11 / 202 11) Shortcut key for the Slide Show view is ___________.? a. F3 b. F1 c. F4 d. F5 12 / 202 12) An Excel file is generally called a/an __________.? a. Worksheet b. Workbook c. E-Spreadsheet d. Sheet 13 / 202 13) Which of the following statements accurately describes the default selection for AutoSum? a. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content. b. You must make the selection before clicking AutoSum. c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell d. AutoSum does not have a default selection. 14 / 202 14) Per the order of operations, which of the following is calculated first? a. Negative number (-) b. Exponentiation (Ë c. Addition (+) and subtraction (-) (left to right) d. Percent (%) 15 / 202 15) Which of the following is not an arithmetic operator? a. ] b. * c. + d. â 16 / 202 16) Smaller and less expensive PC-based servers are replacing ____________ in many businesses.? a. Laptops b. Mainframes c. Supercomputers d. Clients 17 / 202 17) Number of bits in ALU is ___________.? a. 4 b. 8 c. 16 d. 2 18 / 202 18) Which of the following is not a process state? a. Terminated b. Execution c. Blocked d. Running 19 / 202 19) To change printer, layout, or margin settings, you click the File tab and use which of the following options? a. Open b. Options c. Info d. Print 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 __________________.? a. Ecological validity b. Criterion validity c. Factorial validity d. Content validity 21 / 202 21) What is the shortcut key to âUndoâ the last action in a document? a. None of above b. Ctrl + Y c. Ctrl + Z d. Ctrl + X 22 / 202 22) Which of the following is not a function of the Output Unit? a. It supplies the data and instructions to the computer for further processing b. It produces results that can be easily understood by the user c. It accepts the results produced by the computer d. It supplies the data and instructions to the outside world 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? a. The bootstrap distribution of the mean b. The sampling distribution of the mean c. The population distribution of the mean d. The standard error of the mean 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 _____________.? a. Interval data b. Ratio data c. Nominal data d. Ordinal data 25 / 202 25) A device driver is _____________________________. ? a. The person who delivers hardware devices to a computer store b. The power supply for the device c. A computer program that allows the operating system to communicate with the device d. The connector that allows you to attach the device to a computer 26 / 202 26) Which of the following is NOT an operating system? a. Microsoft Word b. Mac OS c. Linux d. Microsoft Windows 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? a. Justify b. Top Align c. Middle Align d. Center 28 / 202 28) How do you magnify your document? a. Tools, Customize b. View, Zoom c. Tools, Options d. Format, Font 29 / 202 29) VDU stands for _________________.? a. Visual Detection Unit b. Visual Display Unit c. Virtual Display Unit d. Virtual Detection Unit 30 / 202 30) What does LAN stand for? a. Local Area Network b. Linked Applications Node c. Linked Area Network d. Lots of Anarchy and Nonsense 31 / 202 31) Which of the following is not a transformation that can be used to correct skewed data? a. Square root transformation b. Log transformation c. Tangent transformation d. Reciprocal transformation 32 / 202 32) Which would you choose to save a document with a new name? a. Click File, Save b. Press Ctrl+S c. Click File, Save As d. Click Tools, Options, Save 33 / 202 33) What is the advantage of using SPSS over calculating statistics by hand? a. It equips you with a useful transferable skill. b. All are corrects. c. It reduces the chance of making errors in your calculations. d. Many researchers use SPSS as it is a recognised software package 34 / 202 34) Which of the numbers below might IBM SPSS report as 10.574 Eâ05? a. 0.10574 b. 1057400.0 c. 0.00010574 d. 10.569 35 / 202 35) RAM stands for ___________.? a. Read only memory b. Random origin money c. Random only memory d. Random access memory 36 / 202 36) One nibble is equivalent to _____________ bits.? a. 8 b. 4 c. 2 d. 1 37 / 202 37) If we calculated an effect size and found it was r = .42 which expression would best describe the size of effect? a. Small b. Large c. Medium to large d. Small to medium 38 / 202 38) When cross-tabulating two variables, it is conventional to: a. assign both the dependent and independent variables to columns. b. represent the dependent variable in rows and the independent variable in columns. c. assign both the dependent and independent variables to rows. d. represent the independent variable in rows and the dependent variable in columns. 39 / 202 39) What do you call a a specific instruction designed to do a task? a. Task b. Command c. Process d. Instruction 40 / 202 40) If a user needs information instantly available to the CPU, it should be stored __________.? a. on a CD b. in the CPU c. in RAM d. in secondary storage 41 / 202 41) WWW means __________.? a. World Wide Wizard b. Wide World Web c. World Wide Wonder d. World Wide Web 42 / 202 42) Which command is used to insert a cut or copied selection to a cell or range of cells? a. Copy b. Range c. Document properties d. Paste 43 / 202 43) Do this to display the contents of a certain drive or folder:? a. Right-click the drive or folder. b. Double-click the drive or folder. c. Click the drive or folder while holding down the key. d. Triple-click the drive or folder. 44 / 202 44) To open Power Point from Run Dialog Box, type _____________________.? a. Powerpint b. PowerPoint c. Pwrpoint d. Powerpnt 45 / 202 45) __________ is known as unauthorized access into others system.? a. Decryption b. Encryption c. None of the above d. Hacking 46 / 202 46) Where a row and a column meet, what do you call that? a. None of the above b. A box c. A block d. A cell 47 / 202 47) Which key deletes text before, or to the left, of the insertion point? a. Page Up b. Backspace c. Page Down d. Delete 48 / 202 48) When a formatted number does not fit within a cell, it displays ___________.? a. #DIV/0 b. None of these c. #DIV d. ##### 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? a. Clear the cellâs content b. Apply another style to the cell c. Apply the Normal style to the cell d. Use the Undo command 50 / 202 50) 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. If you do not have a colour printer, it makes the differences between slices clearer. c. In order to make full use of the facilities that SPSS can offer. d. Because the patterns form symbolic visual images of different social groups. 51 / 202 51) The two basic types of memory in a computer are ___________________.? a. Primary and major b. Main and virtual c. Minor and Major d. Primary and Secondary 52 / 202 52) Which key deletes the character to the left of the cursor? a. Delete b. Backspace c. Home d. End 53 / 202 53) Page Up Key uses for ___________________________________.? a. Moves the cursor one page up b. Moves the cursor one screen up c. Moves the cursor one paragraph up d. Moves the cursor one line up 54 / 202 54) What is shortcut key for toggle ribbon? a. CTRL + F4 b. CTRL + F3 c. CTRL + F1 d. CTRL + F2 55 / 202 55) ____________ is the functional key to display save as box.? a. F9 b. F6 c. F5 d. F12 56 / 202 56) The speed of a CPU is measured in what? a. Horsepower b. Lux c. Megahertz (MHz) and gigahertz (GHz) d. Bits per second (Bps) 57 / 202 57) Components that provide internal storage to the CPU are ____________.? a. Internal chips b. Controllers c. Registers d. Program Counters 58 / 202 58) Saving data and instructions to make them readily available is the job of __________.? a. Input Unit b. Cache Unit c. Storage Unit d. Output Unit 59 / 202 59) The page to create Presentation in Power Point is called _____________.? a. Paper b. Sheet c. Slide d. Document 60 / 202 60) In word processing, an efficient way to move the 3rd paragraph to place it after the 5th paragraph is _________.? a. copy, cut and paste b. cut and paste c. copy and paste d. cut, copy and paste 61 / 202 61) Which of the following component displays the contents of active cell? a. Menu bar b. Status bar c. Name box d. Formula bar 62 / 202 62) A desktop computer is also known as a ___________.? a. Mainframe b. Laptop c. PC d. Palmtop 63 / 202 63) ____________ is not the view of Power Point.? a. Outline view b. Slide Show view c. Slide Show view Slide Sorter view d. Normal view 64 / 202 64) To delete one word to the right? a. CTRL+DEL b. CTRL+TAB c. CTRL+SHIFT 65 / 202 65) The main directory of a disk is called the __________ directory.? a. network b. folder c. sub d. root 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 ___________.? a. Output b. Data c. Process d. Input. 67 / 202 67) Which would you choose to move selected text from one place to another? a. Cut and Paste b. Copy and Paste c. Delete and Paste d. Move and Paste 68 / 202 68) Which of the following can you not copy using Format Painter? a. Bold b. Font size c. Font color d. Cell content 69 / 202 69) Which one is not a Function in MS Excel? a. SUM b. MAX c. MIN d. AVG 70 / 202 70) Which key deletes the character to the right of the cursor? a. Backspace b. End c. Home d. Delete 71 / 202 71) What is the relationship between the sum of squared errors (SS), the sample size (n) and the variance (s2)? a. n = (s2/SS) â 1. b. s2 = SS(n â 1). c. SS = s2/(n â 1). d. s2 = SS/(n â 1). 72 / 202 72) Formatting a cell in Currency, you can specify _______________.? a. Currency Symbol b. None of the above c. Decimal Places d. Percentage symbol 73 / 202 73) Ordinal level data are characterized by ___________.? a. A fixed zero b. Equal intervals between each adjacent score. c. None of the above. d. Data that can be meaningfully arranged by order of magnitude. 74 / 202 74) The only language which the computer understands is _____________.? a. Assembly Language b. BASIC c. C Language d. Binary Language 75 / 202 75) Which type of graph can we use to compare frequency distributions of several groups simultaneously? a. A histogram b. A boxplot. c. A population pyramid d. A bar chart 76 / 202 76) The headings that appear on the Ribbon, such as File, Home, and Insert, are called _______.? a. tabs b. groups c. menus d. shortcuts 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? a. A dialog box or task pane b. A list of worksheets c. An additional workbook d. An additional part of the current range 78 / 202 78) The basic unit of a worksheet into which you enter data in Excel is called a _________.? a. Box b. Table c. Column d. Cell 79 / 202 79) You accidentally erased a record in the sheet. What command can be used to restore it immediately? a. Undo b. Copy c. Insert d. Replace 80 / 202 80) Which of the following helps to reduce spelling error in the document? a. Auto Text b. Auto Format c. Auto Correct d. Smart Tags 81 / 202 81) Which of the following can you drag or double-click to change the width of a column? a. Column marker b. Formula bar c. Cell pointer d. Fill handle 82 / 202 82) System software is the set of programs that enables your computers, hardware devices and ____________ software to work together.? a. Application b. Processing c. Management d. Utility 83 / 202 83) In Excel, Columns are labelled as ___________.? a. A, B, C, etc. b. A1, A2, etc. c. $A$1, $A$2, etc. d. 1, 2, 3, etc. 84 / 202 84) How is a variable name different from a variable label? a. It is shorter and less detailed. b. It is longer and more detailed. c. It is abstract and unspecific. d. It refers to codes rather than variables. 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? a. MAX b. AVERAGE c. COUNT d. MIN 86 / 202 86) When all the numbers between 0 and 100 in a range should be displayed in Red color, apply ___________.? a. Apply Conditional Formatting Command on Format menu b. All of above c. Use=if() function to format the required number d. Select the cells that contain number between 0 and 100 then click red color on text color tool 87 / 202 87) The first screen you see when you open Word 2016 is called the ______________.? a. Word screen b. Screen saver c. Recent screen d. Start screen 88 / 202 88) If a user needs information instantly available to the CPU, it should be stored ____________.? a. in RAM b. in secondary storage c. in the CPU d. on a CD 89 / 202 89) What is the storage area for e-mail messages called? a. A mailbox b. The hard disk c. A directory d. A folder 90 / 202 90) The set of programs which consists of full documentation. ? a. System Software b. Utility Software c. Software Package d. File package 91 / 202 91) The process of producing useful information for the user is called ___________.? a. Outputting b. Processing c. Inputting d. Controlling 92 / 202 92) The metal or plastic case that holds all the physical parts of the computer is the______.? a. System Unit b. CPU c. Platform d. Mainframe 93 / 202 93) What is the shortcut key for âSpelling Checkâ in document? a. F7 b. Shift + F7 c. Alt + F7 d. Ctrl + F7 94 / 202 94) What does the operation “Recode Into Different Variables” do to the data? a. Represents the data in the form of a pie chart. b. Replaces missing data with some random scores. c. Reverses the position of the independent and dependent variable on a graph. d. Redistributes a range of values into a new set of categories and creates a new variable. 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? a. File format b. Worksheet c. File sheet d. File range 96 / 202 96) They normally interact with the system via user interface provided by the application software.? a. Testers b. Programmers c. Developers d. Users 97 / 202 97) ___________ is the key we use to run the selected command.? a. CTRL b. TAB c. ENTER d. SHIFT 98 / 202 98) How would you print a bar chart that you have just produced in SPSS? a. In Chart Editor, click Descriptive Statistics, Print, OK b. In Data Editor, open Graphs dialog box, click Save, OK c. In Output Viewer, click File, Print, select the bar chart and click OK d. In Variable Viewer, open bar chart, click File, Print, OK 99 / 202 99) The degree to which a statistical model represents the data collected is known as the ______.? a. Reliability b. Validity c. Fit d. Homogeneity 100 / 202 100) The âheartâ of the processor which performs many different operations___________.? a. Motherboard b. Arithmetic and logic unit c. Memory d. Control Unit 101 / 202 101) ___________is designed to solve a specific problem or to do a specific task.? a. System Software b. User c. Application Software d. Utility Software 102 / 202 102) Which of the following contains the commands you use most often, such as Save, Undo, and Repeat? a. Quick Access Screen b. Quick Access Toolbar c. Quick toolbar d. Quick command 103 / 202 103) The file formats ________________ can add to power point shows.? a. MPEG b. All are corrects c. WAV d. JPG 104 / 202 104) Which area in an Excel window allows entering values and formulas? a. Standard Tool Bar b. Formula Bar c. Title Bar d. None of the above 105 / 202 105) Shortcut key to open pre-made Presentation is ____________.? a. CTRL + O b. CTRL + A c. CTRL + N d. CTRL + L 106 / 202 106) How would you use the drop-down menus in SPSS to generate a frequency table? a. Click on: Graphs; Frequencies; Pearson b. Click on: Analyze; Descriptive Statistics; Frequencies c. Open the Variable Viewer and recode the value labels d. Open the Output Viewer and click: Save As; Pie Chart 107 / 202 107) Which one is not an examples of input devices? a. Mouse b. Scanner c. Keyboard d. Printer 108 / 202 108) Linux is a (an) ____________ operating system.? a. Mac b. Open-source c. Windows d. Microsoft 109 / 202 109) Which f the following does a boxâwhisker plot not display? a. The median b. Outliers c. The mean d. The lower quartile 110 / 202 110) Which of the following consists of details that describe or identify a file, including the author? a. Range b. Paste c. Copy d. Document properties 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.? a. RAM b. CPU c. ROM d. Hard drive 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? a. AVERAGE b. COUNT c. AutoSum d. MAX 113 / 202 113) The steps and tasks needed to process data, such as responses to questions or clicking an icon, are called ___________.? a. the system unit b. the operating system c. application software d. instructions 114 / 202 114) Handout Master is defined by _______________.? a. Layout of handout b. Layout of slide c. Slide transaction d. Slide formattin 115 / 202 115) END Key used to ___________________.? a. Moves the cursor end of the document b. Moves the cursor end of the paragraph c. Moves the cursor end of the screen d. Moves the cursor end of the line 116 / 202 116) In which sub-dialog box can the Chi Square test be found? a. Crosstabs: Statistics b. Gender: Female c. Frequencies: Percentages d. Bivariate: Pearson 117 / 202 117) What is the file extension of Power Point Application? a. .pptx b. .jpeg c. .docx d. .xlsx 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? a. A worksheet b. The Help windows c. The ribbon d. The Quick Access Toolbar 119 / 202 119) What process should be used to recall a document saved previously? a. Copy b. Retrieve c. Enter d. Save 120 / 202 120) Which of the following format you can decide to apply or not in AutoFormat dialog box? a. Font format b. Number format c. Border format d. All are corrects 121 / 202 121) A string of eight 0’s or 1’s is called a: ? a. Kilobyte b. Megabyte c. Gigabyte d. Byte 122 / 202 122) Which unit is responsible for converting the data received from the user into computer understandable format? a. Output Unit b. Arithmetic & Logic Unit c. Memory Unit d. Input Unit 123 / 202 123) Which of the following best describes the variable âGenderâ? a. All of the possible answers are correct. b. A coding variable. c. A between-group variable. d. A grouping variable. 124 / 202 124) _______controls the way in which the computer system functions and provides a means by which users can interact with the computer. ? a. The Operating System b. Application Software c. The Platform d. The Motherboard 125 / 202 125) Which tool you will use to join some cells and place the content at the middle of joined cell? a. From Format Cells dialog box click on Merge Cells check box b. From Format Cells dialog box select the Center alignment c. Click on Merge and Center tool on formatting toolbar d. From Format Cells dialog box choose Merge and Center check box 126 / 202 126) VIRUS stands for ___________________.? a. Vital Information Recourse Under System b. Vital Information Recourse Under Siege c. Vital Information Reason Under Siege d. Virus Information Recourse Under Siege 127 / 202 127) The Name box on to the left of formula bar.? a. None of above b. Shows the name of workbook currently working on c. Shows the name of worksheet currently working on d. Shows the name of cell or range currently working on 128 / 202 128) Which of the following is not useful for changing the font size? a. Increase Indent button b. Font Size drop-down list c. Decrease Font Size button d. Increase Font Size button 129 / 202 129) What is entered by the function =TODAY()? a. Todayâs date as Text format b. None of the above c. The date value for the day according to system clock d. The time value according to system clock 130 / 202 130) âCTR+Left Arrowâ is used to ______________________________.? a. Moves to the cursor one paragraph b. Moves to the cursor one word left c. Moves to the cursor one paragraph down d. Moves to the cursor beginning of the line 131 / 202 131) How can you remove borders applied in cells? a. Choose None on Border tab of Format cells and Open the list on Border tool in Formatting toolbar then choose first tool (no border) b. Choose None on Border tab of Format cells c. No answer d. Open the list on Border tool in Formatting toolbar then choose first tool (no border) 132 / 202 132) Power Point presentation are commonly used in ___________________.? a. All are corrects b. Project presentations by students c. Communication of planning d. Note outline for teachers 133 / 202 133) Which of the following operations moves text from clipboard? a. Copy b. Drag and Drop c. Paste d. Cut 134 / 202 134) What is a backup? a. An exact copy of a system's information b. The ability to get a system up and running in the event of a system crash or failure c. All are corrects d. Restoring the information backup 135 / 202 135) What is the file extension of Spreadsheet Application? a. .xlsx b. .pptx c. .jpeg d. .docx 136 / 202 136) To generate a Spearman’s rho test, which set of instructions should you give SPSS? a. Analyze; Correlate; Bivariate; [select variables]; Spearman; OK b. Analyze; Compare Means; Anova table; First layer; Spearman; OK c. Analyze; Crosstabs; Descriptive Statistics; Spearman; OK d. Graphs; Frequencies; [select variables]; Spearman; OK 137 / 202 137) ____________ are specially designed computers that perform complex calculations extremely rapidly. ? a. Servers b. Mainframes c. Laptops d. Supercomputers 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? a. It is not possible to calculate this unless the mean and standard deviation are given. b. 98% c. 1% d. 95% 139 / 202 139) The most common input devices include ___________.? a. Monitor and mouse b. Monitor and keyboard c. Mouse and keyboard d. Printer and mouse 140 / 202 140) What is animation? a. To make a picture b. Accelerate static image c. Changing the picture in the graph d. Print out 141 / 202 141) You want to calculate the number of nonblank cells in your worksheet. Which function should be used? a. COUNTA b. MAX c. MIN d. SUM 142 / 202 142) Which of the following is an acceptable name for a named range? a. C7 b. subtotal/west c. subtotal west d. subtotal_west 143 / 202 143) Excel display the current cell address in the _________________.? a. Formula bar b. None of the above c. Name Box d. Status Bar 144 / 202 144) Which enables us to send the same letter to different persons? a. template b. macros c. mail merge d. none 145 / 202 145) Formula in Excel start with ___________.? a. + b. # c. % d. = 146 / 202 146) The physical devices of a computer are called _________.? a. Hardware b. System Software c. Package d. Software 147 / 202 147) Variation due to some genuine effect is known as _____________.? a. Homogeneous variance b. Residual variance c. Unsystematic variation d. Systematic variation 148 / 202 148) Which is the basic element of Power Point? a. Page b. Sheet c. Slide d. File 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? a. Stacked bar chart b. Clustered bar chart c. 3-D bar chart d. All of the options are possible. 150 / 202 150) Which is a grid of columns and rows that is used to organize data? a. Table b. Row c. None of the above d. Column 151 / 202 151) The ALU gives the output of the operations and the output is stored in the ___________.? a. Registers b. Memory Devices c. Output Unit d. Flags 152 / 202 152) In Excel, which one denoted a range from B1 through F5? a. B1:F5 b. B1 to F5 c. B1-F5 d. B1$F5 153 / 202 153) What do you call a program in execution? a. Process b. Command c. Task d. Instruction 154 / 202 154) Which of the following commands is used to insert a cell into a worksheet? a. The Format Painter command in the Clipboard group on the Home tab b. The Format command in the shortcut menu when you right-click a cell c. The Format command in the Cells group on the Home tab d. The Insert command in the Cells group on the Home tab 155 / 202 155) ___________ is the raw material used as input and ___________ is the processed data obtained as output of data processing.? a. Data, Program b. Instructions, Program c. Program, Code d. Data, Instructions 156 / 202 156) What is the file extension of word processing Application? a. .docx b. .jpeg c. .pptx d. .xlsx 157 / 202 157) Which of the following is the intersection of a row and column? a. bar chart b. range c. tab d. cell 158 / 202 158) Which of the following is an example of a mixed cell reference? a. A9 b. A9:E9 c. $A$9 d. A$9 159 / 202 159) The hardware device commonly referred to as the âbrainâ of the computer is the ______.? a. RAM chip b. Secondary storage c. Data input d. CPU 160 / 202 160) __________ key is used for Help in Power Point.? a. F3 b. F2 c. F1 d. F6 161 / 202 161) Which predesigned file already has a significant amount of formatting, text, and other features? a. Text fil e b. Preset file c. Blank workbook d. Template 162 / 202 162) A person who designs the programs in a software package is called _________.? a. User b. Software Manager c. System Developer d. System Programmer 163 / 202 163) Which of the following methods will not enter data in a cell? a. Clicking the enter button the formula bar b. Pressing the tab key c. None of the above d. Pressing the Esc key 164 / 202 164) CPU is an abbreviation for _________.? a. Central Processing Unit b. Central Protocol Unit c. Computer Protocol Unit d. Computer Processing Unit e. Central Programming Unit 165 / 202 165) A _____________ is a collection of design choices that includes colors, fonts, and special effects.? a. Data b. Slide c. Table d. Theme 166 / 202 166) â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 167 / 202 167) Which of the following is not a function of the control unit? a. Execute instructions b. Interpret instructions c. Direct operations d. Read instructions 168 / 202 168) What is the shortcut key to âCenter Alignâ the selected text? a. None of above b. Ctrl + F c. Ctrl + E d. Ctrl + C 169 / 202 169) Which of the following can be customized for quicker access to your most commonly used commands? a. Workbook b. Print Preview c. Printer setup d. Quick Access Toolbar 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)? a. Simple 3-D bar chart b. Stacked bar chart c. Simple bar chart d. Clustered bar chart 171 / 202 171) Word processing, spreadsheet, and photo-editing are examples of _______________.? a. System software b. Operating system software c. Application software d. Platform software 172 / 202 172) One yottabyte consists of ___________.? a. 1024 TB b. 1024 PB c. 1024 ZB d. 1024 EB 173 / 202 173) Which function will you use to enter current time in a worksheet cell? a. = NOW() b. = TIME() c. All of the above d. = CURRENTTIME() 174 / 202 174) The default file extension for a 2016 Power Point presentation is _____________.? a. .pptx b. .ppte c. .ppt d. .pptc 175 / 202 175) Which of the following is where you can save, select a template, change document properties, and close or exit Excel? a. Windows b. Print c. Backstage d. Edit 176 / 202 176) How many sheets are there, by default, when we create a new Excel file? a. 10 b. 1 c. 5 d. 3 177 / 202 177) Which of the following is designed to control the operations of a computer? a. User b. Application Software c. System Software d. Utility Software 178 / 202 178) ____________ has a slide design option in MS Power Point.? a. Standard Toolbar b. Formatting Toolbar c. Drawing Toolbar d. None of these 179 / 202 179) âCTR+PageDownâ is used to ______________________________.? a. Moves to the cursor one Page Down b. Moves to the cursor one Line Down c. Moves to the cursor one Screen Down d. Moves to the cursor one Paragraph Down 180 / 202 180) Which part of the computer is used for calculating and comparing? a. Disk unit b. ALU c. System Unit d. Control unit 181 / 202 181) The process of transferring files from a computer on the Internet to your computer is called _____________.? a. FTP b. Uploading c. Downloading d. JPEG 182 / 202 182) __________ are often delivered to a PC through an e-mail attachment and are often designed to do harm.? a. Viruses b. Email messages c. Portals d. Spam 183 / 202 183) Which of the following are assumptions underlying the use of parametric tests (based on the normal distribution)? a. The data should be at least interval level. b. All of the options are true. c. The samples being tested should have approximately equal variances. d. Some feature of the data should be normally distributed. 184 / 202 184) Which of the following does NOT affect a computerâ s performance? a. The type and speed of the video or graphics card b. The speed of the CPU c. The number of keys on the keyboard d. The amount of memory or RAM