MCIS: Excel Study Guide

Created by ea4031 

Upgrade to
remove ads

100 terms

An Excel ____ allows data easily to be summarized and charted.

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 or activate the ____.

cell

____ is/are used to add worksheet, column, and row titles on a worksheet.

Text

To cancel an entire entry before entering it into the cell, press the ____ key.

ESC

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

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 ____.

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.

range

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon (:)

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.

relative

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.

format

In general, use no more than ____ font types in a worksheet.

two

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

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?

11

A(n) ____ chart is drawn on the same worksheet as the data.

embedded

In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.

legend

____ properties are associated with all Microsoft Office documents and include author, title, and subject.

Standard

The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.

AutoCalculate

Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE?

END

The ____ button is located on the Quick Access Toolbar, as shown in the accompanying figure.

Undo

Excel remembers the last ____ actions you have completed.

100

To remove an embedded chart, you should ____ it and press the DELETE key.

click

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 ____.

20xx

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

=23%

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

operations

When Excel follows the order of operations, the formula, 8 * 3 + @, equals ____.

26

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.

relative

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.

AutoCorrect Options

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.

Trace Error

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

A ____ cell in Excel has a numerical value of zero.

blank

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

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

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.

double-click

The ____ function displays the highest value in a range.

MAX

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.

MIN

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.

Range Finder

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

theme

You can open the Format Cells dialog box by pressing the ____ keys.

CTRL + 1

The most popular background color is _____.

blue

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.

fixed

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.

8.43

When you decrease the row height to ____, the row is hidden.

0

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.

Page Layout

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.

Print Selection

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

You can ensure correctness in your formulas by carefully checking them using ____.

Range Finder

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.

Rotated

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?

625, 600

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.

three

The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory.

Clipboard

An alternative to clicking the Paste button is to press the ____ key.

ENTER

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 (,).

semi-colon (;)

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.

#REF!

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

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.

nested

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Sparkline

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.

Double-click

You should use a ____ chart to show the relationship or proportion of parts to a whole.

Pie

A(n) ____ is a separate sheet in a workbook that contains only a chart.

chart sheet

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.

Goal

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set