BUS 375 Exam 1 More practice questions with Complete Solutions

Document Content and Description Below

BUS 375 Exam 1 More practice questions with Complete Solutions which of the following keyboard shortcuts cuts cells or a cell range? a. ctrl+c b.ctrl+x c.ctrl+s d.ctrl+v ✔✔b.ctrl+x to selec... t adjacent data click one, hold ____, and click again to highlight between the clicks a.ctrl b.alt c.shift d.this is not possible ✔✔c.shift which of the following displays when your pointer is on the bottom right corner of a cell? a.selection pointer b.move pointer c.fill pointer d.resize pointer ✔✔c. fill pointer which of the following keyboard shortcuts opens the format cells dialog box? a.alt+tab b.F2 c.Shift_F1 d.Ctrl+1 ✔✔d. Ctrl+1 which of the following appears when you move your pointer over the center of a cell? a.selection pointer b.move pointer c.fill pointer d.resize pointer ✔✔a.selection pointer which of the following displays the result of a formula? a. cell b.formula bar c.cell trange d.fill handle ✔✔a.cell which of the following page setup options lets your change between portrait and landscape? a.page layout b.header/footer c.margins d.sheet properties ✔✔a. page layout what resizes column width or ow height to accommodate the largest entry? a.AutoFormat b.Fill Handle c.AutoFit d.AutoFart ✔✔c.AutoFit which of the following keys opens the save as dialog box? a. F2 b.F10 c.F8 d.F12 ✔✔d. F12 Before using the center across selection command, what cell should contain the data? a. upper-left cell b. bottom-left cell c. upper-right cell d. bottom-right cell ✔✔a. upper-left cell by default what file extension is given to excel 2016? a. .xlsm b. .xlsx c. .xls d. .xltm ✔✔b. .xlsx if you want excel to store a number as a label rather than a number, what must you type first? a. a space b. an apostrophe c. an open parenthesis d. a hashtag ✔✔b. an apostrophe the image provided shows which pointer shape? (white thick cross) a. selection pointer b. move pointer c. fill pointer d.resize pointer ✔✔a. selection pointer which key lets you insert dollar signs quickly to create an absolute reference? a.F2 b.F6 c.F4 d.F8 ✔✔c. F4 which of the following is a mixed cell address? a. B2 b. B$2 c. $B$2 d.Sheet2!B2 ✔✔b. B$2 which of the following characters must always start a function a.= b. $ c. ( d. none of these ✔✔a. = which of the following functions tallies the number of cells in a range that contain numbers? a.COUNTA b.COUNTNUM c.COUNT d.COUNTDRACULA ✔✔C. COUNT identify the second argument in an IF statement a. logic test b. value if true c. > or < d. value if false ✔✔b. value if true which of the following functions uses a lookup table that is organized in columns a. LOOKUP b. VLOOKUP c. HLOOKUP d. VHLOOKUP ✔✔B. VLOOKUP which auditing took is used to show the formula inputs when the result is the active cells? a. trace precedents b. error checking c. trace dependents d. evaluate formula ✔✔a. trace precedents which of the following formulas includes an absolute reference and a constant? a. =D21+E21 b. =$D$21+E21 c. =D21+21 d. =$D$21+21 ✔✔=$D$21+21 which of the following functions finds the largest value in a range of cells? a. average b. median c. max d. count ✔✔c. max which of the following shows the correct order of operations? a. (), ^, * or /, + or - b. ^, (), * or /, + or - c.(), * or /, + or - d. (), ^, * or +, / or - ✔✔a. (), ^, * or /, + or - which of the following references cells located in another worksheet in the same workbook? a.absoute reference b.3D cell reference c. mixed reference d. relativ reference ✔✔b. 3D cell reference in the function = SUMB(B2:B6), which part of the function is the argument? a. =SUM b. B6 c. B2 d. B2:B6 ✔✔d. B2:B6 [Show More]

Last updated: 10 months ago

Preview 1 out of 9 pages