1 Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing. a) Point b) Sort c) ScreenTip d) Cut 2 If you want to paste a formula result â€” but not the underlying formula â€” to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to and then: a) Click the Paste button on the Standard toolbar. b) Click the arrow on the Paste button on the Standard toolbar, then click Formulas. c) Click the arrow on the Paste button on the Standard toolbar, then click Formatting. d) Click the arrow on the Paste button on the Standard toolbar, then click Paste Special and select Values. 3 A color option that uses the Windows default text and background color values. a) Automatic color b) Total row c) Mini toolbar d) Standard color 4 A fast way to add up this column of numbers is to click in the cell below the numbers and then: a) Click Subtotals on the Data menu. b) View the sum in the formula bar. c) Click the AutoSum button on the Standard toolbar, then press ENTER. d) Click the Toolbox and then press SUMIF+D29 5 Which of the following is an absolute cell reference? a) G5 b) $A$8 c) B:2 d) #J#9 6 To remove data from a cell and place it on the Office Clipboard. a) Chart b) Cut c) Link d) Cell 7 On an Excel sheet the active cell is indicated by _____________. a) A dark wide border b) A dotted border c) A blinking border d) None of the above 8 How do you change column width to fit the contents? a) Single-click the boundary to the left of the column heading. b) Double-click the boundary to the right of the column heading. c) Press ALT and single-click anywhere in the column. d) Press SHIFT W 9 ###### means: a) You’ve entered a number wrong. b) You’ve misspelled something. c) The cell is not wide enough. d) You entered an incorrect formula. 10 Which key do you press to group two or more adjacent rows, columns, or cells? a) CTRL. b) SHIFT c) ALT d) F5 11 In order to multiply items in Excel you would use which symbol: a) ^ b) @ c) * d) # 12 A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ? a) Go to FILE – SAVE AS – SAVE AS TYPE – Excel 4.0 Work Sheet b) Right click on the spreadsheet tab and select DELETE c) Right click on the spreadsheet and select INSERT – ENTIRE COLUMN d) Right click on the spreadsheet tab and press the X key. 13 Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ? a) Count b) Average c) Sum d) MAX 14 __________ orientation is a worksheet whereby the page is wider than it is tall. Answer: Landscape orientation a) Diagonal b) Portrait c) Landscape d) Vertical 15 The _______
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique.
FALL 2018 HOMEWORK HELP| ASSIGNMENT HELP,…