CIS final exam practice Questions with Complete Solutions A category of data such as a customer's name, city, state, or phone number - Correct Answers ✅Field To relate two fields in a one-to-many relationship, you connect them using a - Correct Answers ✅Subdatasheet ?Tiana wants a line to appear around a paragraph. What should she do - Correct Answers ✅Add a paragraph border What would you use to create a duplicate of the selected cell when the CTRL key is pressed - Correct Answers ✅Copy pointer What can you drag to reposition on a slide? - Correct Answers ✅Guides ?To move a field in Table Datasheet view, you select the column and then... - Correct Answers ✅Drag it to a new location ?To format a range so that all values greater than $500 appear in red, which of the following can you use? - Correct Answers ✅Conditional formatting What do you do to select text? - Correct Answers ✅Click and drag across the desired text 1 / 3
CIS final exam practice Questions with Complete Solutions Jia needs to change the order in which objects on a slide in her presentation animate. What is the best method to do this? - Correct Answers ✅After selecting an object with an animation applied to it, she can click the Move Earlier or Move Later button on the animations tab What is a simple way to signify that a concern raised in a comment has been addressed? - Correct Answers ✅Resolve the comment To create a new, blank workbook, which of the following can you use? - Correct Answers ✅The New command on the File tab and the New command in Backstage view What will you select as X in the following series of clicks to
apply a shadow effect: (double click) text box > format
options > text options > X > shadow? - Correct Answers ✅Text effects What button do you click to see a transition in Normal view? - Correct Answers ✅Preview If you want to add a note to a slide to remind you to mention a fact that is related to the slide, where do you place the note? - Correct Answers ✅Notes pane 2 / 3
CIS final exam practice Questions with Complete Solutions The ______ property creates an easy-to-use visual guide to help users enter accurate data - Correct Answers ✅Input mask
T or F: to change the color of a shape you change the shape
fill. - Correct Answers ✅True To specify the distance of a paragraph from the left margin, which of the following should be done? - Correct Answers ✅Adjust the left indent marker What is true of the Excel spell checker? - Correct Answers ✅You can change all instances of a flagged word to a selected suggestion What is a grid or column and rows used to present information on a slide? - Correct Answers ✅Table What refers to a printed line that surrounds the outer part of a page? - Correct Answers ✅Page border What process is most like copying and pasting? - Correct Answers ✅Importing What is the correct formula to insert the date January 12, 1998 into a cell? - Correct Answers ✅=Date(1998, 1, 12)
- / 3