Misy 5325 Ms Excel Midterm Exam Study Guide Questions And Answers Latest Updated

Lookup {Ans: To change the list of choices in a single or multivalued lookup field, open the in Design view, select the field to be modified, and tap or click the _______ tab in Field Properties pane.}Point Mode {Ans: __________ _________ allows cells to be selected for use in a formula by using the mouse.}Because the Sum function is a rarely used function it has no button on the Ribbon. {Ans: False}Insert Function box in the formal box {Ans: Clicking the ____ opens the insert function dialog box.}Options {Ans: The difference between the effects and the styles is that each effect has several ____ providing you with more control over the exact look of the image.}T {Ans: You can accomplish almost any formatting task by selecting a cell or range of cells, right-clicking on that cell or range of cells, and then selecting Format Cells from the shortcut menu.}