COMPUTER I K0V2 Quiz 8 Attempt Score: 90 / 100 - 90 %

Question 1 5 / 5 points Text and numbers can be edited directly in the cell or in the ____________ Bar. Question options: a) Status b) Review c) Formula d) Formula Review Question 2 5 / 5 points You can change ...

Question 1 5 / 5 points Text and numbers can be edited directly in the cell or in the ____________ Bar. Question options: a) Status b) Review c) Formula d) Formula Review Question 2 5 / 5 points You can change the worksheet orientation on the Page Layout tab or: Question options: a) on the Print tab b) in Backstage view. c) in Print Preview. d) in Settings. Question 3 5 / 5 points When you select a row and click the _____________button, the default setting of the button inserts a new sheet row above the selected row. Question options: a) Sheet Rows b) Insert c) Select d) Enter Question 4 5 / 5 points The __________check box centers a worksheet horizontally on a page. Question options: a) Format b) Align c) Center on page d) AutoFit Question 5 5 / 5 points __________are symbols that specify a type of calculation. Question options: a) Cell references b) Calculators c) Arithmetic captions d) Arithmetic operators Question 6 5 / 5 points Which of the following is NOT a symbol for an arithmetic operator? Question options: a) + b) - c) # d) * Question 7 5 / 5 points __________will adjust the width of a column to accommodate the content of the widest cell. Question options: a) Scaling b) AutoFit c) Merge & Fit d) Adjust Question 8 5 / 5 points __________refers to the process of specifying the appearance of cells and the overall layout of your worksheet. Question options: a) Text effects b) Page setup c) Formatting d) Artistic editing Question 9 5 / 5 points The ____________ group can be used to align text vertically and horizontally in a cell. Question options: a) format b) alignment c) text effects d) page setup Question 10 5 / 5 points A relative cell reference automatically adjusts when the formula is copied but for those times when you want the cell reference to remain the same, you must use a(n) ___________ cell reference. Question options: a) absolute b) static c) stationary d) locked Question 11 0 / 5 points On the Format tab, in the Format Auditing group, clicking Show Formulas, will ____________ in the cell. Question options: a) print the formula b) display the formula c) print the result d) display the result Question 12 5 / 5 points Use the _______________command to display the contents of a cell on multiple lines. Question options: a) Text Effects b) Wrap Text c) AutoFit d) Align Question 13 5 / 5 points Using the Backstage View, properties and tags can be added or modified and Excel files can be saved as _____________ files. Question options: a) Quicken b) Word c) PDF d) Access Question 14 5 / 5 points Cells and the overall layout of the worksheet can be formatted, using various commands on all the following EXCEPT: Question options: a) the Ribbon. b) shortcut menus. c) Edit bar. d) keyboard shortcuts. Question 15 5 / 5 points In Excel, you can apply custom margins, center the spreadsheet on the page, and insert a Header or Footer using the same technique as ____________ before printing the spreadsheet. Question options: a) Access b) Word c) Quicken d) PowerPoint Question 16 5 / 5 points When creating a formula, you must use a(n) ___________ so that if the value in the cell changes Excel automatically recalculates the spreadsheet. Question options: a) arithmetic operator b) calculator c) cell reference d) AutoFit command Question 17 5 / 5 points In Excel, the __________command begins its checking process with the currently selected cell and moves to the right and down. Question options: a) Format b) Spelling c) Formula Review d) Review Question 18 5 / 5 points Data can be entered by selecting ___________ and then typing text or a number. Question options: a) a column b) a row c) a range of cells d) the typed data Question 19 0 / 5 points Like the ___________ in Word, the Quick Analysis button displays a set of commands and formatting tools when you select a range of data. Question options: a) status bar b) calculate button c) mini toolbar d) stationary Question 20 5 / 5 points Using___________, you can calculate the percentage by which a part makes up a total-with the percentage formatted as a decimal. Question options: a) AutoCalculate b) %calculate c) the equation segment/total = percentage d) the equation amount/total = percentage Attempt Score: 90 / 100 - 90 % Overall Grade (highest attempt): 90 / 100 - 90 %