Excel Chapter 1 Test
Fill in the Blank Excel remembers the last ___ actions you have completed.
100
Fill in the Blank How many chart types does Excel offer.
15
Multiple Choice 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
A
Fill in the Blank You easily can obtain a total, an average, or other information about the numbers in a range by using the _____ area on the status bar.
Auto Calculate
Fill in the Blank _____ corrects two initial capital letters by changing the second letter to lowercase.
Auto Correct
Fill in the Blank The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.
Auto Fill Options
Fill in the Blank The _______ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Fill in the Blank 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.
AutoCalculate
Fill in the Blank The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
Fill in the Blank The _____ feature of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
AutoCorrect
Fill in the Blank The date you change a file is an example of a(n) _____ property.
Automatically updated
Fill in the Blank _____ text has darker appearance than normal text.
Bold
Fill in the Blank Press ______ to select the entire worksheet.
CTRL+A
Fill in the Blank You can apply the Bold font style by pressing the ______ keyboard shortcut keys.
CTRL+B
Fill in the Blank Pressing the _____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
Fill in the Blank The default font for a new workbook is ______ 11-point regular black.
Calibri
Fill in the Blank To enter data in a cell, you must first select the ____.
Cell
Fill in the Blank A(n) ______ conveys a visual representation of data.
Chart
Fill in the Blank A(n) _______ conveys a visual representation of data.
Chart
Fill in the Blank The _____ command on the Clear menu is the only command that clears both the cell entry and the cell formatting.
Clear All
Fill in the Blank You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________.
Colon (:)
Fill in the Blank _______ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.
Columns
Fill in the Blank The range of cells receiving the content of copied cells is called the ______.
Destination area
Multiple Choice What effect does the Accounting Number Format have on the selected cells? a. converts alphabetic characters to numbers b. Displays cell contents with two decimal places that align vertically c. Performs tax calculations d. Copies the numbers of one e cell to another.
Displays cell contents with two decimal places that align vertically
Fill in the Blank Excel helps you organize and identify your files by using _______, which are the details about a file such as the project author, title, and subject.
Document Properties
Fill in the Blank Which of the following keys moves the insertion point to the end of data in a cell?
END
Fill in the Blank To erase an entire entry in a cell and then reenter the data from the beginning, press the _____ key.
ESC
Fill in the Blank Clicking the ________ box completes an entry.
Enter
Fill in the Blank A preceding ______ alerts Excel that you are entering a formula or function and not text.
Equal Sign
Fill in the Blank While typing in a cell, you can press the _____ key to erase all the characters back to and including the incorrect character you just typed.
Escape
Fill in the Blank A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
Exploded
True or False A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.
False
True or False A number can contain only the following characters 0,1,2,3,4,5,6,7,8,9.
False
True or False A single point is about 1/32 of one inch in height.
False
True or False A thin red border indicates the active cell.
False
True or False Common font faces include regular, bold, underline, and italic.
False
True or False Excel can display characters in only three font colors: black, red, and blue.
False
True or False Line charts show the contribution of each piece of data to the whole, or total, of the data.
False
True or False Live preview is available on a touch screen.
False
True or False Splitting cells involves creating a single cell by combining two or more selected cells.
False
True or False To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.
False
True or False 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.
False
True or False Worksheet titles and subtitles should be as wordy as possible.
False
True or False You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font Group).
False
True or False You merge a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
False
True or False You should press the SPACEBAR to clear a cell.
False
Modified True or False In a worksheet, columns typically contain information that is similar to a list.
False, Row Titles
Fill in the Blank The _______ is the small black square located in the lower-right corner of the heavy border around the active cell.
Fill Handle
Fill in the Blank You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Format
Fill in the Blank _______ indicates how characters are emphasized.
Format
Fill in the Blank As you type, Excel displays the entry ( and the Cancel box and Enter box) in the _________
Formula Bar
_____ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.
Green Computing
Fill in the Blank Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
Fill in the Blank Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
Fill in the Blank In ______ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right
Insert
Fill in the Blank Like an area chart, a(n) _____ chart often is used to illustrate changes in data over time.
Line
Fill in the Blank Combining two or more selected cells into one cell is called ____ cells.
Merging
Fill in the Blank ____ cells involve creating a single cell by combining two or more selected cells.
Merging
Fill in the Blank The _____ box displays the active cell reference.
Name
Fill in the Blank The active cell reference appears in the ________ on the left side of the formula bar.
Name Box
Fill in the Blank The range of cells receiving copies content is called the _____ area.
Paste
Fill in the Blank Careful _____ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.
Planning
Fill in the Blank The easiest way to select a cell is to move the block _______ pointer to the cell and then click.
Plus sign
Fill in the Blank Font size is gauged by a measurement system called ________.
Points
Fill in the Blank Pressing the _____ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
Fill in the Blank A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
Range
Fill in the Blank A ______ reference is an adjusted cell reference in a copied and pasted formula.
Relative
Fill in the Blank The automatically adjusted cell reference in a pasted formula is called a(n) ________
Relative Reference
Fill in the Blank A(n) _____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and web support.
Requirements
Fill in the Blank The person or persons requesting the worksheet should supply their requirements in a ______ document.
Requirements
Fill in the Blank When you enter numeric data in a cell, Excel recognizes the values as numbers and _____ the values.
Right-aligns
Fill in the Blank Excel's ______ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
SUM
Fill in the Blank The ________ function adds all the numbers in a range of cells.
SUM
Fill in the Blank You can click the ________ button arrow ( HOME tab | Editing group) to view a list of often-used functions.
SUM
Fill in the Blank _____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
Fill in the Blank A(n) _____ chart compares data from three columns and/or rows in a three-dimensional manner.
Surface
Fill in the Blank _____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
Modified True or False The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range.
True
True or False A character with a point size of 10 is about 10/72 of one inch in height.
True
True or False A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
True
True or False Excel recognizes the following as text:401AX21, 921-231.619 321, 883XTY.
True
True or False Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.
True
True or False Pages printed in portrait orientation have the short (8 1/20 edge at the top of the printout; the printed page is taller than it is wide.
True
True or False The AutoCorrect feature can automatically capitalize the first letter in the names of days.
True
True or False The cell being copied is called the source area or copy area.
True
True or False The easiest way to select a cell (make it active) is to tap it or use the mouse to move the block plus sign pointer to the cell and then click.
True
True or False The sheet tabs at the bottom of the window allow you to view any worksheet in the workbook.
True
True or False To add a pie chart, first select the data to be charted and then tap or click the insert pie or Doughnut Chart button ( INSERT tab } Charts group).
True
True or False To select any cell, tap or click the Name box and enter the cell reference of the cell you want to select.
True
True or False With Excel in Edit mode, you can edit cell contents directly in the cell.
True
True or False You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
True
Fill in the Blank The first step in creating an effective worksheet is to make sure you _____.
Understand what is required
Fill in the Blank The _____ button allows you to erase recent cell entries.
Undo
Fill in the Blank An Excel ____ allows data to be summarized and charted easily.
Worksheet
Fill in the Blank You use _____ to view and XPS file.
XPS Viewer
Fill in the Blank When you begin typing a cell entry, Excel displays two additional boxes in the formula bar: _______.
the Cancel box and the Enter box