Which of the following calculations multiplies 23 by 0.01? |
23% |
The adjusted cell references in a copied and pasted formula are called ____ cell references. |
Relative |
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. |
Operations |
You can open the Format Cells dialog box by pressing the ____ keys |
Ctrl + 1 |
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 |
You can use the arrow keys to complete an entry in Point mode. |
False |
To paste copied cell contents, you can press the ____ keys. |
Ctrl + V |
Clicking the ____ opens the Insert Function dialog box. |
Insert function box in the formula bar |
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key |
Right parenthesis |
The most common error when entering a formula is to reference the wrong cell in the formula. |
True |
When you enter a two-digit year that is less than 30, Excel changes the year to ____. |
20xx |
____ view allows you to create or modify a worksheet while viewing how it will look in printed format. |
Page Layout |
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. |
AVERAGE |
Which of the following is the path to the Conditional Formatting button? |
(HOME tab | Styles group) |
Which of the following Option buttons gives options for filling cells following a fill operation? |
Auto Fill Options |
A ____ is text and graphics that print at the top of each page. |
Header |
Cooler colors tend to pull away from the reader. |
True |
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. |
Indirect |
Which of the following is the path to the Sum arrow? |
(HOME tab | Editing group) |
The ____ function determines the lowest number in a range. |
MIN |
The ____ Option button lists formatting options following an insertion of cells, rows, or columns. |
Insert |
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. |
False |
A ____ is text and graphics that print at the bottom of every page. |
Footer |
Moving from left to right, the first calculation in the order of operations is negation (-). |
True |
Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula. |
True |
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. |
True |
You______a worksheet to emphasize certain entries an make the worksheet easier to read and understand. |
Format |
You can apply the Bold font style by pressing the ____keyboard shortcut keys. |
Cntrl + B |
Which of the following keys over the insertion point to the beginning of data in a cell? |
Home |
The ______ preceding a formula alerts Excel that you are entering a formula or function and not text. |
equal sign (=) |
Which of the following is the Ribbon path to the Cell Styles button? |
(HOME tab I Styles group) |
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 |
Live preview is available on a touch screen |
False |
The range of cells receiving the content of copied cells is called the ____. |
Destination Area |
Pressing the ____ key to complete an entry activates the adjacent cell to the right. |
RIGHT ARROW |
A character with a point size of 10 is about 10/72 of one inch in height. |
True |
With Excel in Edit mode, you can edit cell contents directly in the cell. |
True |
Clicking the ___ box completes an entry. |
Enter |
The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area. |
False |
The first step in creating an effective worksheet is to make sure you ____. |
Understand what is required |
A thin red border indicates the active cell |
False |
When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column. |
False |
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. |
True |
You should press the SPACEBAR to clear a cell. |
False |
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key. |
ESC |
If you accidentally undo an action , you can use the Redo button to redo it.. |
True |
If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ECS key to erase the entire entry, and then reenter the data from the beginning. |
True |
An Excel_____ allows data to be summarized and charted easily. |
Worksheet |
A ______ reference is an adjusted cell reference in a copied and pasted formula. |
Relative |
How many chart types does Excel offer? |
10 |
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. |
Range |
The opposite of merging cells is splitting a merged cell. |
True |
______is /are used to place worksheet , column, and row titles on a worksheet. |
Text |
The ______ button allows yo to erase recent cell entries. |
Undo |
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 I Charts group). |
True |
In a worksheet, columns typically contain information that is similar to a list. |
False |
______properties are associated with all Microsoft Office files and include author, title, and subject. |
Standard |
Worksheet titles and subtitles should be as wordy as possible. |
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 |
A pie chart with one or more slices offset is referred to as a(n) _____ pie chart. |
exploded |
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. |
False |
Excel remembers the last _______ actions you have completed. |
100 |
You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab I Font group). |
False |
Press____ to select the entire worksheet |
Ctrl + A |
You use _____ to view as XPS file. |
XPS Viewer |
The _____ features works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. |
AutoCorrect |
By default, text is ______ in a cell |
left-aligned |
The ____ area on the status bar includes six commands as well as the results of the associated calculation on the right side of the menu. |
AutoCalculate |
You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu |
True |
The data you change a file is an example on a(n)_______ property. |
Automatically updated |
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing. |
True |
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as this adjacent cells contain no data. True |
True |
When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros. |
False |
To clear the entire worksheet, tap or click the Clear All button on the worksheet. |
False |
Excel Ch.1, Ch.2
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price