MCIS: Excel Study Guide
An Excel ____ allows data easily to be summarized and charted.
The person or persons requesting the worksheet should supply their requirements in a ____ document.
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 or activate the ____.
____ is/are used to add worksheet, column, and row titles on a worksheet.
To cancel an entire entry before entering it into the cell, press the ____ key.
Clicking the ____ box completes an entry.
The ____ is a blinking vertical line that indicates where the next typed character will appear.
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
In Excel, a number can contain the characters ____.
0 1 2 3 4 5 6 7 8 9
+ - ( ) , /
. $ % E e
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____.
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.
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ____.
destination area (or paste area)
A ____ reference is an adjusted cell reference in a copied and pasted formula.
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
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
In general, use no more than ____ font types in a worksheet.
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.
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
How many chart types does Excel offer?
A(n) ____ chart is drawn on the same worksheet as the data.
In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE?
The ____ button is located on the Quick Access Toolbar, as shown in the accompanying figure.
Excel remembers the last ____ actions you have completed.
To remove an embedded chart, you should ____ it and press the DELETE key.
To start a new line in a cell, press the ____ keys.
ALT + ENTER
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
All of the following are valid Excel arithmetic operators except: ^ * % >
Which of the following calculations multiplies 23 by 0.01: =23%, =23, =23 + .01, =24 - .01
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
When Excel follows the order of operations, the formula, 8 * 3 + @, equals ____.
Point mode allows you to ____, as shown in the accompanying figure below.
select cells for use in a formula using the mouse pointer
The adjusted cell references in a copied and pasted formula are called ____ references.
Which of the following is the path to the Copy and Paste buttons?
(Home tab | Clipboard group)
You can click the ____ button to undo an automatic correction.
Which of the following Option buttons gives options for filling cells following a fill operation: Auto Fill Options, AutoCorrect Options, Insert Options, Paste Options.
Auto Fill Options
The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
A ____ cell in Excel has a numerical value of zero.
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.
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
Which of the following is the path to the Sum button?
(Home tab | Editing group)
You should ____ a function name in the Formula AutoComplete list to select the function.
The ____ function displays the highest value in a range.
Clicking the ____ opens the Insert Function dialog box shown in the accompanying figure.
Insert Function box on the formula bar
The ____ function determines the lowest number in a range.
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL + C
To paste copied cell contents, you can press the ____ keys.
CTRL + V
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL + 1
The most popular background color is _____.
The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Accounting number format
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ____ dollar sign.
Which of the following is the path to the Comma Style button?
(Home tab | Number group)
Which of the following is the path to the Conditional Formatting button?
(Home tab | Styles group)
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
When you decrease the row height to ____, the row is hidden.
Which of the following is the path to the Spelling button?
(Review tab | Proofing group)
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
You can ensure correctness in your formulas by carefully checking them using ____.
Which of the following is a suggested decision to make when you plan a workbook?
determine the necessary functions and formulas needed
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____.
use Excel to create the worksheet
____ text often provides a strong visual appeal.
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____.
Dialog Box Launcher
The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
Which of the following patterns extends the fill series to 575, 550, 525?
In the accompanying figure, the split double arrow mouse pointer ____.
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
Which of the following is the path to the Increase or Decrease Indent button?
(Home tab | Alignment group)
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory.
An alternative to clicking the Paste button is to press the ____ key.
Using the mouse to move or copy cells is called ____.
drag and drop
Which of the following is the path to the Insert button?
(Home tab | Cells group)
Which of the following is not a valid format symbol: semi colon (;), percent sign (%), dollar sign ($), comma (,).
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
The ____ function is useful when you want to assign a value to a cell based on a logical test.
Which comparison operator means "not equal to"?
____ refers to cells not wide enough to display the entire entry.
# # # # #
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
You can press the ____ keys to open the Format Cells dialog box.
CTRL + 1
The path to the Format Painter button is ____.
(Home tab | Clipboard group)
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
You should use a ____ chart to show the relationship or proportion of parts to a whole.
A(n) ____ is a separate sheet in a workbook that contains only a chart.
A Pie chart with one or more slices offset is called a(n) ____.
exploded Pie chart
Which of the following is the path to the Zoom button?
(View tab | Zoom group)
When working with a large worksheet, you can split the window into ____ panes.
two or four
Which of the following is the path to the Goal Seek button?
(Data tab | Data Tools group)
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.