Misy 5325 Ms Excel Midterm Exam Study Guide 2023/2024 Passed

Transparency {Ans: ____ allows you to see through the background, so that nay text on the slide is visible.}False {Ans: As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.}Display cells with two decimals places that align vertically {Ans: What effect does the accounting number format format have on the selected cells?}Range Finder {Ans: Excel's __________ _____________ can be used to check which cells are being referenced in the formula assigned to the active cell.}Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1). {Ans: Home - Insert- Insert Cut Cells}Y axis {Ans: In a column/bar chart the vertical axis is called the ____-_______ or value axis.}Left-aligned {Ans: Excel automatically positions text ____________ in a cell.}equal sign (=) {Ans: To alert Excel that you are entering a formula or function and not text, type a (n) ____________ preceding the formula.}Split {Ans: When working with a large worksheet, you can ________ the Excel window into two or four panes to view different parts of the worksheet at the same time.}Axes, chart tittles, and data tables are examples of chart