An Excel ____ allows data to be summarized and charted easily |
worksheet |
The person or persons requesting the worksheet should supply their requirements in a ____ document. |
Requirements |
The first step in creating an effective worksheet is to make sure you ____. |
understand what is required |
To enter data in a cell, you must first select the ____. |
cell |
____ is/are used to place worksheet, column, and row titles on a worksheet. |
Tabs |
Clicking the ____ box completes an entry. |
Enter |
The ____ is a blinking vertical line that indicates where the next typed character will appear. |
insertion point |
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. |
AutoCorrect |
Pressing the ____ key to complete an entry activates the adjacent cell to the right. |
RIGHT ARROW |
By default, text is ____ in a cell. |
left-aligned |
In Excel, a number can contain the characters ____. |
ALL OF THE ABOVE |
The range of cells receiving copied content is called the ____ area. |
PASTE |
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 |
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. |
… |
The range of cells receiving the content of copied cells is called the ____. |
PASTE |
A ____ reference is an adjusted cell reference in a copied and pasted formula. |
RELATIVE |
The ____ is the small black square located in the lower-right corner of the heavy border around the active cell. |
… |
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 |
The ____ preceding a formula alerts Excel that you are entering a formula or function and not text. |
equal sign (=) |
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. |
FORMAT |
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. |
CTRL+B |
Combining two or more selected cells into one cell is called ____ cells. |
merging |
Which of the following is the Ribbon path to the Cell Styles button? |
(HOME tab | Styles group) |
What effect does the Accounting Number Format have on the selected cells? |
Displays cell contents with two decimal places that align vertically |
What effect does the Comma Style format have on the selected cells? |
Displays cell contents with two decimal places and commas as thousands separators |
Pressing the ____ keyboard shortcut key(s) selects cell A1. |
CTRL+HOME |
How many chart types does Excel offer? |
11 |
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. |
exploded |
The date you change a file is an example of a(n) ____ property. |
automatically updated |
____ properties are associated with all Microsoft Office files and include author, title, and subject. |
Standard |
You use ____ to view an XPS file. |
XPS Viewer |
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 |
Which of the following keys toggles between Insert mode and Overtype mode? |
INSERT |
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key. |
ESC |
Which of the following keys moves the insertion point to the beginning of data in a cell? |
HOME |
Which of the following keys moves the insertion point to the end of data in a cell? |
End |
The ____ button allows you to erase recent cell entries. |
Undo |
Excel remembers the last ____ actions you have completed. |
100 |
Press ____ to select the entire worksheet. |
CRT+A |
If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link. |
FILE |
Excel Quiz 1
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price