University of Texas, DallasOPRE 6332quiz1-question1. ( ANSWERS CORRECTLY HIGHLIGHTED IN YELLOW )

Document Content and Description Below

Take Test: OPRE6332-Quiz1 Content Assistive Technology Tips [opens in new window] Test Information Instructions Descriptio n Instructio ns Timed Test This test has a time limit of 1 hour.Th... is test will save and submit automatically when the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Multiple Attempts Not allowed. This test can only be taken once. Force Completio n This test can be saved and resumed at any point until time has expired. The timer will continue to run if you leave the test. Remaining Time: 59 minutes, 21 seconds. Question 1 1. What is the minimum number of worksheets in each workbook? a. Threeb. One c. Five d. There is no minimum 1 points Question 2 1. How many columns are there in one Excel 2013 worksheet? (Choose the closest answer). a. More than 19000 b. More than 18000 c. More than 17000 d. More than 16000 1 points Question 3 1. Which of the following are Excel components that can be customized to make your Excel work more efficient?a. Worksheet b. Ribbon c. Both a and b d. Neither a nor b 1 points Question 4 1. With regards to the QAT, which of the following options is FALSE? a. You can add a command button (to QAT) by right-clicking that command (from the ribbon) b. You can remove a command button (from QAT) by rightclicking that command from the ribbon c. Adding a command to the QAT does not remove the command from its original location d. Both A and B are FALSE e. A, B, and C are FALSE 1 pointsQuestion 5 1. What function does "Reset only selected ribbon tabs" have? a. Removes all customizations in a given ribbon b. Removes all customizations in all ribbons c. Removes all buttons in a ribbon d. None 1 points Question 6 1. Which of the following is FALSE? a. QAT stands for 'Quick Access Toolbar' b. The default buttons on the QAT cannot be removed c. The QAT can be positioned above or below the ribbon d. Adding a command to the QAT does not affect the availability of the command in its original location 1 points Question 71. Merging several cells, each of which contains data, will: a. Combine all data into one cell b. Retain data only in the left (or upper) most cell c. Retain data only in the right (or lower) most cell d. Delete data in all cells 1 points Question 8 1. If an apostrophe precedes a number, then: a. The number is entered as a number b. The number is entered as text c. The number is entered in date format d. None of the above 1 points Question 91. What is the default file extension for a workbook in Excel 2013? a. . xlsx b. . xlm c. .csv d. .xls 1 points Question 10 1. In Excel, the text data type includes: a. Letters b. Numbers c. Symbols d. Letters and Symbols only e. Letters, numbers and symbols1 points Question 11 1. Which of the following is TRUE? a. By default Excel aligns numbers to the right b. By default Excel aligns texts to the left c. Both A and B are true d. Neither A nor B is true 1 points Question 12 1. What technique do you use to keep certain cells visible, even when the user scrolls away from those cells? a. Nailing b. Freezi ng c. Gluing d. Staplin g1 points Question 13 1. Which of the following are external data sources to which Excel can be linked? a. Access b. Web c. Text files d. All of the above 1 points Question 14 1. Copy and Paste a. … will not work for data entry b. … will paste text but not numeric values c. … overwrite current formatting in a cell d. … will not work for formulae1 points Question 15 1. Which of the following pairs is correct? a. A7; R7C7 b. C23; R3C23 c. J22; R22C10 d. F12; R12C1 1 points Question 16 1. R1048569C16374 is equivalent to a. XEV10485 69 b. XEQ10485 72 c. XET10485 69 d. XEZ1048569 1 points 24 5 x x+5*26+24*26*26 Question 17 1. If you copy the formula D$38 from one cell into another cell: a. Both the row and the column will change b. The column will remain the same, the row may or may not change c. The row will remain the same, the column may or may not change d. The column will remain the same, the row will definitely change 1 points Question 18 1. What does RC[-2] indicate? a. The cell which is two columns to the right on the current row b. The cell which is two rows up on the current row c. The cell which is two rows down on thecurrent row d. The cell which is two column to the left on the current row 1 points Question 19 1. What does an absolute reference do? a. The row and/or column reference will not change if the formula containing the reference is copied to another location b. The cell will always contain the absolute value of any number entered into it c. The cell reference changes if the formula containing the reference is copied to another location d. It is the only formula used to refer to a cell on another spreadsheet 1 points Question 20 1. What is the formula reference of R8C1 in R1C1 format if the formula in A1 format is"=H6+K4"? a. "=RC(3)+R(2)C(5)"b. "=R(- 2)C(7)+R(2)C(5)" c. "=R(-2)C(7)+R(- 4)C(10)" d. "=R(-2)C(6)+R(- 4)C(9)" 1 points Question 21 1. If there is a formula”= Sum ($B$3:$B$8)” in cell B9, what is the formula when we copy it into cell B12? a. =Sum ($C$3:$C$9) b. =Sum ($B6:C$12) c. =Sum ($B$3:$B$8) d. =Sum (C3:C12) 1 points Question 22 1. In the R1C1 format, cell address CQ910 is:a. R910C9 5 b. R910C4 32 c. R910C1 04 1 points Question 23 1. You are in cell J10. If you put =R[-5]C[-2]-3+R[6]C[2], this will result in the value: a. -3 b. -2 c. -5 d. 0 1 points Question 24 1. Why we use R1C1 notation?a. It is more understandable b. It is the default reference c. It is easier to find errors in our formula notation d. It is convenient 1 points Question 25 1. Which of the following is possible by using Data Validation? a. Limit the number of text characters in a cell b. Restrict numbers outside a specified range in a cell c. Restrict dates outside a certain period in a cell d. All of the above Number list date time text length 1 points Question 261. Copy pasting a cell with data and validation rules a. Copies the data but not the rules b. Copies the data and the rules c. Copies the rules but not the data d. Returns an error 1 points Question 27 1. When do error alerts appear in Data Validation? a. A user enters invalid data in the cell by copying another cell b. A formula in the cell calculates a result that is not valid c. Doing either A or B gives an error message d. Doing either A or B does not give an error message 1 pointsQuestion 28 1. A range is expressed from starting cell to the ending cell separated by? a. Hash (#) b. Semicolon (‘) c. Colon (:) d. Asterisk (*) 1 points Question 29 1. Range names are useful, hence: a. It is necessary to have a range name for each variable/cell in our model b. It is advisable to have a range name for each variable/cell in our model c. Both A and B are true d. Neither A nor B is true 1 pointsQuestion 30 1. Which of the following is true? a. We need to use the Paste List command before we have created all range names b. Once a list is pasted, it updates to reflect changes c. A good practice when modifying an existing workbook is to clear the old range names d. None of the above 1 points Question 31 1. Range names can be given for which of the following? a. A single cell b. A group of cells as long as the selection is rectangular c. A collection of cells even if they are not rectangular d. All of the above 1 pointsQuestion 32 1. Which of the following is a valid range name? a. JamesBond0 07 b. 007JamesBo nd c. James Bond 007 d. JamesBond 007 1 points 一定要字母開頭，rc 開頭不可以用，除非在限制外，可以＿\ 開頭， 字母，數字，標點，底線可以用在裡面，g5 這種不能用，空格絕對不能用， 1~255 個字 Question 33 1. Which of the following is NOT a valid range name? a. SamCol a b. Sam Cola c. Cola_Sa md. Sam_Co la 1 points Question 34 1. Which of the following is FALSE about a range name created in one worksheet? a. It can be used in the same worksheet in the same workbook b. It can be used in a different worksheet in the same workbook c. It can be used as an absolute value d. It can be used as a relative value 1 points Question 35 1. The scope of range names can be set to: a. A worksheet b. A workbook c. Cannot berestricted d. Both A and B 1 points Question 36 1. What is the fastest way to clear Range Names? a. Delete the names one by one b. Use the Name Manager to delete the Range Names c. Create a new workbook d. Select desired cells->delete key 1 points Question 37 1. We can define a range name from which of the following? a. 'Name box' on the formula bar b. 'Create from selection' c. 'Define Name'd. All of the above 1 points Question 38 1. Which of the following is TRUE of range names? a. A name can be a minimum of 1 character to a maximum of 255 characters b. The scope of a name can be restricted to a worksheet c. Names are absolute cell references d. All of the above 1 points Question 39 1. Which of the following is not a valid rule for naming ranges? a. It can contain a period, numbers, and letters b. It can contain spaces c. It can start with an underscore d. It is case sensitive1 points Question 40 1. Which of the following is a likely benefit from using a range name? a. It can reduce errors in data entry b. It makes entry of formulae easier c. Both A and B are benefits d. Neither A nor B is a benefit 1 points Question 41 1. If a file is ‘read-only’ it means: a. We can make changes to the file and save the file with a different name b. We can make changes to the file but cannot save it with same name in original folder c. Both A and B are trued. Neither A nor B is true 1 points Question 42 1. The option to format cells is in which ribbon? a. Home b. Insert c. Formul as d. Data 1 points Question 43 1. Saving a worksheet automatically creates a backup sheet in the local drive. True False 1 points Question 44 1. In Excel, we cana. lock a cell b. protect a worksheet c. protect the entire workbook d. all above 1 points Question 45 1. Which of the following cannot be hidden: a. An entire row b. An entire column c. Part of a column d. Worksheet 1 points Question 46 1. Converting rows to columns and columns to rows is called:a. Transposing b. Converting c. Row-Column Conversion d. Altpositioning 1 points Question 47 1. Which of the following statements is FALSE with respect to number formats? a. A number format can have up to four sections of code b. All four code sections do not need to be included c. If you specify only one code section, it is used for text d. Text, in a code section, needs to be separated by double quotes 1 points Question 481. Which of the following formats would you use to display '1,000.55' with a dollar sign? a. Curren cy b. Text c. Numbe r d. Date 1 points Question 49 1. The date format to display the day as 'Sun' is: a. d b. ddd d c. ddd d. dd 1 points Question 501. If I want to display 0 (zero) as 0.00, which format should I use? a. #,###. 00_); b. (#,###. 00); c. 0.00; d. #.##; 1 points Click Save and Submit to save and submit. Click Save All Answers to save all answers. [Show More]

Last updated: 2 years ago

Preview 1 out of 27 pages