Excel Module 1 Test Review PDF

Excel: Module 1 Test Review Test Content: 40 Total Points 15 Multiple Choice Questions (2 pts. each) 5 True/False Questions (2 pts. each ) Multiple Choice: An Excel ____ allows data to be summarized and charted easily. A. Worksheet B. Database C. Document D. Presentation Clicking the __...

Excel: Module 1 Test Review Test Content: 40 Total Points 15 Multiple Choice Questions (2 pts. each) 5 True/False Questions (2 pts. each ) Multiple Choice: An Excel ____ allows data to be summarized and charted easily. A. Worksheet B. Database C. Document D. Presentation Clicking the ____ box completes an entry. A. Cancel B. Formula C. Enter D. Tab The ____ is a blinking vertical line that indicates where the next typed character will appear. A. Scroll box B. Sheet tab C. Insertion point D. Split bar By default, text is ____ in a cell. A. Left-aligned B. Centered C. Justified D. Right-aligned You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. A. Semi-colon (;) B. Colon (:) C. Period (.) D. None of the above The ____ is the small black square located in the lower-right corner of the heavy border around the active cell. A. Selection handle B. Sizing handle C. Fill handle D. Copy handle The ____ preceding a formula alerts Excel that you are entering a formula or function and not text. A. Quotation mark (“) B. Colon (:) C. Plus (+) D. Equal sign (=) You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. A. Save B. Print C. Format D. Clear Combining two or more selected cells into one cell is called ____ cells. A. Merging B. Mixing C. Combining D. Spanning Which of the following is the Ribbon path to the Cell Styles button? A. (HOME tab, STYLES group) B. (STYLES tab, HOME group) C. (HOME tab, FORMAT group) D. FORMAT tab, STYLES group) How many chart types does Excel offer? A. 5 B. 10 C. 29 D. 50 A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. A. Exploded B. Outer C. Offset D. Rasterized Press ____ on the keyboard to select the entire worksheet. A. F1 B. CTRL + A C. ALT + A D. F4 The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. A. AutoFormat B. AutoComplete C. AutoFunction D. AutoCalculate The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A. AutoComplete B. AutoCorrect C. AutoFormat D. AutoTyping True/False: Worksheet titles and subtitles should be as wordy as possible. A thin red border indicates the active cell. Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.