Microsoft Excel 1 Midterm Study Guide

New workbooks typically contain how many worksheets?

1

What is the small green square in the bottom right of a cell called?

Fill handle

What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 in A30 without having to type in the entire sequence?

Auto Fill

What do you adjust if you see ###### displayed in a cell?

column width

Which of the following is not true about a Fill color?

It cannot be applied to an entire row or column.

Which of the following would not be considered text?

=2*2

What does pressing the Enter key while in a cell, do?

The value is set, and the cell below becomes the active cell

Which keyboard shortcut puts the user in cell edit mode?

F2

Which of the following is not true of the Formula bar?

It allows you to pick from an assortment of formulas.

How is text aligned by default?

Left

Which of the following is not a valid formula?

=#12/31/2018#-#12/31/2019#

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Order of operations

In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?

(2-3)

In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?

6^2

What is the true about an input area?

It is used when certain values are used repeatedly throughout the worksheet.

What should you do if there are columns you need, but do not want to display?

Hide the columns you do not want to display, then unhide them when finished.

What does it mean when you see ####### in a cell?

Your column is not wide enough.

One point is how big?

1/72 of an inch

Which of the following is not a way to widen a column?

Click on the Column label and drag it to the right.

A range is specified by its ________.

top left and bottom right cells

What is the best practice to switch the columns and rows in a range?

Cut the range, then use the Paste Special option called Transpose

Which is not a valid range?

A1:A3, B1:B3

Which Paste option would you choose if you wanted to flip the rows and columns?

Transpose

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?

Values & Source Formatting

What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents?

Formatting

Where can you find more alignment options?

Format Cells dialog box

Which of the following is not included when you use a cell style?

Cell protection

What is the best practice for centering a title over multiple columns?

Use the Merge and Center alignment

If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the ________ feature in Excel.

wrap text

The default number format is ________.

General

Which of the following is not a valid number format?

$ -1,000.00

What can you not do within the worksheet tabs shortcut menu?

Format the worksheet

Which of the following names of worksheet tabs would be best?

January Payroll Information

The best way to apply Page Setup options to multiple worksheets is to ________.

group the worksheets

What is the best way to make sure your worksheet prints on only one page?

Use the Fit to option

What would not be a typical item to have in a header or footer?

The file size

What can you not do from the Page Setup, Sheet tab?

Set margins

What can you not do directly from the Backstage, Print screen view?

Switch to formula view and print formulas

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

Absolute

If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?

E$14

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell?

$A7

What is the default method of referencing cells in formulas?

Relative

Which of the following is not a valid logical test?

=>

Which keyboard shortcut toggles through the types of reference options?

F4

What type of cell reference should be used when a value remains constant?

Absolute

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

=$B$14

Which Excel function changes the value to a desired number of decimal places?

Round

What describes a function's purpose?

Name

Which of the following is not a category of functions?

Graphing

What punctuation is used to separate the two cell references in a range?

Colon (:)

Functions can be selected by using the ________.

Insert Function dialog box

What do you use to separate arguments in a function?

Comma (,)

What error will you get if you type a function name incorrectly?

#NAME?

What term refers to the necessity of following the rules when it comes to using functions?

syntax

What does Excel use to indicate optional arguments in a function?

Square brackets []

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

COUNT

What two functions compute the central tendency of values?

AVERAGE and MEDIAN

Where does Excel automatically display statistics like count, average, and sum when a range of values is selected?

Status bar

The ROUND function requires how many arguments?

2

What is the term for the inputs required in a function?

arguments

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use?

COUNT

Which status bar statistic can you not enable?

Range Name

What action changes the actual number of decimal places Excel stores instead of just changing what is displayed?

ROUND function

What does the AVERAGE function not ignore?

Dates

What function computes the value in which one-half of the data is above and one-half is below.

MEDIAN

Which of the following does not comply with the preferred way of using the SUM function?

=SUM(A4/A11)

What will you see if you enter the TODAY function without the parenthesis?

#NAME?

Which function would you use to find the oldest date in a range?

MIN

Which of the following will not return the system clock's date?

DATE()

What keyboard shortcut will automatically update any formulas using =TODAY() or =NOW()?

F9

Which of the following is not a valid test in an =IF statement?

A4-B4

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

=IF(A7

Which of the following is not an argument associated with the IF function?

Value if neither true nor false

Which of the following is not a valid =IF statement?

=IF(A5>19,Greater,Not Greater)

Which of the following is not a valid lookup function?

LLOOKUP

To look up an exact match, what should you enter in the range_lookup argument?

FALSE

Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%?

=PMT(6%,60,-13000)

What should you not select when selecting data for a chart?

Worksheet titles

Which axis in a chart displays the descriptive labels for the data points?

Category

Which of the following is not a chart element?

Data area

What is not true about an effective chart?

It always contains more than one series.

What is not a purpose of using an effective chart?

Reveals even subtle errors in formulas

Which of the following, when included, distorts the effectiveness of charting data points?

Aggregates

Which axis in a chart displays incremental numbers for the data points?

Value

Which of the following is not a chart type?

Circle

A 100% stacked column chart is similar to which other chart in that it converts values to percentages?

Pie

Which of the following is not true about trendlines?

They can be added to all chart types.

Which of the following is not true about sizing handles?

They always maintain the proper aspect ratio for the object.

They always maintain the proper aspect ratio for the object.

Segments do not start at the same point.

Which chart type is not listed in the All Charts window?

Waterfall

Correct! Sparkline

Which axis displays descriptive labels for the data points in a chart?

category axis

Which axis displays incremental numbers to identify the approximate values of data points?

value axis

Which chart type is best when you want to chart two unrelated data types?

Combo chart

What chart type represents data as spokes going from the center to the outer edge of the chart?

Radar

As a general rule, Pie charts should be limited to how many slices?

7

Where does the primary axis display on a Combo chart?

Left side

What chart type can display two different chart types at the same time?

Combo

In a bar chart, which axis displays the categories?

Vertical

Which chart type displays the data vertically?

Column