The first step in creating an effective worksheet is to make sure you_______
C) understand what is required
____is/are used to add worksheet, column, and row titles on a worksheet
B) text
To cancel an entire entry before entering it into the cell, press the _____ key.
A) ESC
Clicking the ______ box completes an entry
B) enter
The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
A) autocorrect
Pressing the ____ key to complete an entry activates the adjacent cell to the right
A) right arrow
In excel, a number can contain the characters ____
D) all of above
To enter a number such as 6,000,000,000,000,000, you can type the whole number or
D) 6E15
A____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure
C) range
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____
Colon (:)
To enter a number as text, precede it with a (n) ____.
D) apostrophe
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the___.
A) destination area(or paste area)
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand
C) format
In general, use no more than ___ font types in a worksheet.
A) two
Combining two or more selected cells into one cell is called _____ cells
D) merging
Which of the following is the ribbon path to the cell styles button?
A) home tab| styles groups
How many chart types does Excel offer?
A) 5
B) 11
C) 29
D) 50
In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet
B) legend
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet
D) autoCalculate
The___ button is located on the quick Access Toolbar, as shown un the accompanying figure.
D) Undo
Worksheet titles and subtitles should be as wordy as possible.
False
Both the cancel box and the Enter box appear on the formula bar when you begin typing in a cell.
True
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
True
The text is longer than the wodth of a column, Excel displays the overflow characters in adjacent cells to the right.
True
Excel recognizes the following as text
401AX21,921-281,619 628, 883XTY
True
If each cell in a selected range is next to a row of numbers, excel assigns the SUM function to each cell in the selected range when the SUM button is clicked
True
A single point is about 1/32 of one inch height
False
Excel can display characters in only three font colors: black, red and blue.
False
A character with a point size of 10 is about 10/72 of one inch in height.
True
You can turn off the Bold formatting for selected text by clicking the Bold Off(Home Tab|Font group)
False
You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position
True
To use the AutoCalculate area, select the range of ells containing the numbers flr a calculation you want to verify and then double click the AutoCalculate area to display the Customize Status Bar shortcut menu.
False
With Excel in Edit mode, you can edit cell contents directly in the cell
True
You can press the RIGHT ARROW of LEFT ARROW keys to position the insertion point during in cell editing.
True
To clear the entire worksheet, click the clear All Button on the worksheet
False
You can clear cell contests and formatting by clicking Clear Contents on the Clear button menu.
False
You should press the Spacebar to clear a cell.
False
Careful ________ can reduce your effort significantly and result in a worksheet that is accurate , easy to read, flexible, and useful.
Planning
The easiest way to select a cell is to move the block plus sign ____ to a cell and then click
Mouse pointer
Worksheet ____ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet
Columns
While typing in a cell, you can press the _____ key to delete all the characters back to and including the incorrect character you just typed
Backspace
As you type, Excel displays the entry in the _____ and also displays the Cancel box and the Enter box on the formula bar
Formula bar
If the next entry you want to make is in the adjacent cell, use the ______ keys to complete the entry in the current cell and activate the adjacent cell.
Arrow
Excel's _____, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total
SUM function
The default font for a new workbook is _______ 11-point regular black.
Calibri
_________ cell involves creating a single cell by combining two or more selected cells
Merging
A(n) ______ chart often is used to illustrate changes in data over time
Line
To start a new line in a cell, press the ____ keys.
C) ALT+ENTER
All of the following are valid Excel arithmetic operators exepct_____.
C) >
Which of the following calculations multiplies 23 by 0.01?
B) 23%
When Excel follows the order of operations, the formula 8*3+2 equals_____.
B) 26
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell.
The _____ option button lists formatting options following an insertion of cells, rows, or columns .
C) Insert
A_____ cell in Excel has a numerical value of zero
C) blank
The____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
A) formula
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
A) right parenthesis
Which of the following is the path to the Sum button?
B) (Home tab| Editing group)
You should _____ a function nMe in the Formula AutoComplete list to select the function.
A) double click
Clicking the ____ opens the Insert Function dialog box shown in the figure.
A) Insert function box or formula bar
The _____ function determines the lowest number in range.
C) MIN
A_____ is a predefines set of colors, fonts, chart styles, cell styles and fill effects
C) theme
You can open the Format Cells dialog box by pressing the ___ keys.
C) Ctrl+1
The ______ displays numbers with a fixed dollar sign to the left of the number, a comma every thre positions to the left of the decimal point, and displays numbers to the nearest cent.
A) accounting number format
Te ranges E4:14 and F13:113 are formatted with a ___ dollar sign.
A) fixed
Which if the following is the path to the Comma Style button?
D) (Home Tab |Number group)
Which of the following is the path to the Conditional Formatting burrin?
D) (Home tab| Styles Group)
When you decrease the row height to _____, the row is hidden.
D) 0
An asterisk (*) following a cell reference un a formula is the arithmetic operator that directs Excel to perform the division operation
False
Pressing the F9 Key instructs eExcel to recalculate all formulas
True
The arithmetic operator ^, directs Excel to perform the division operation
False
As in Algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations
False
The insert options button lists formatting options.
True
You can use the arrow keys to complete an entry in Point mode
False
Clicking the Insert Function box opens the Function Arguments dialog box
False
The Sum button menu allows you to enter one of five often-used functions easily into. Cell
True
Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data
True
To use Range Finder to veriffy that the formula contains te intended cell references click cell in the formula you want to check
False
To use of a fill color in a cell or range of cells sets off the cell range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range
True
When you click the Decrease Font Size button, Excel assigns the next highest font size in the font size gallery
False
You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box
True
A floating dollar sign appears immediately to the left of the first digit in a dollar value with in spaces
True
You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear
True
Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting
True
Best fit means that the width of the column will be increased or decreased by a percentage you specify
False
Worksheet______ typically contain items analogous to items in a list
Rows
If you have a long text entry, such as a paragraph, you can instruct Excel to ______ text in the cell.
Wrap
One of the reasons Excel is such a valuable tool is that you can assign a (n) _______ to a cell, and Excel will calculate the result
Formula
The / arithmetic operator_____
Division
In the order of operations, the last operation Excel performs is ________
Subtraction
Addition
You can press the _____ key to quit Range Fknder
ESC
A(n) ______ is a dot on the screen that contains a color
Pixel
To set row height to best fit,______ the bottom boundary of the row heading.
Double click
Excel included a (n) ______ you can use to check a worksheet fir spelling errors
Spell checker
Always take time to check the ______ of a worksheet before submitting it to your supervisor
