Excel Module 1 Test Review

Excel Module 1 Test Review

• Test Content: 40 total points
• Multiple Choice Questions: 15 questions, 2 points each
• True/False Questions: 5 questions, 2 points each

Multiple Choice Questions

• Worksheet: An Excel worksheet allows data to be summarized and charted easily.

• Completing an entry: Clicking the "Enter" box completes an entry.

• Insertion point: The insertion point is a blinking vertical line that shows where the next typed character will appear.

• Default text alignment: By default, text is left-aligned in a cell.

• Entering cell range: To enter a correct range in a function, separate the beginning and ending cell references with a colon (:).

• Sizing handle: The sizing handle is the small black square in the lower-right corner of the active cell's border.

• Formula Indicator: The equal sign (=) preceding a formula alerts Excel you are entering a formula or function, not text.

• Formatting Worksheet: Formatting a worksheet emphasizes certain entries and improves readability.

• Merging Cells: Combining two or more selected cells into one cell is called merging.

• Cell Styles: The Ribbon path to the Cell Styles button is (HOME tab, STYLES group).

• Chart Types: Excel offers 29 chart types.

• Exploded Pie Chart: A pie chart with one or more slices offset is called an exploded pie chart.

• Selecting Entire Worksheet: Press CTRL + A on the keyboard to select the entire worksheet.

• Status Bar Function: The AutoCalculate area on the status bar shows associated calculation results.

• AutoCorrect Feature: The AutoCorrect feature fixes common typing or spelling errors when completing text entry.

• Worksheet Titles: Worksheet titles and subtitles shouldn't be overly wordy.

• Active Cell Indication: A thin red border indicates the active cell.

• Formula Bar Boxes: Both the Cancel box and the Enter box display on the formula bar when typing in a cell.

• Overflow Text: When text exceeds column width, Excel displays the overflow in adjacent right cells if those cells are empty.

• Entering Dollar Values: When entering dollar values in cells, include the dollar sign ($), commas, and trailing zeros.

Prepare for your Excel Module 1 test with this comprehensive review. This quiz includes multiple choice and true/false questions covering essential features and functions of Excel worksheets. Test your knowledge and get ready for success!