Deck 4: Excel

Question 1

The active cell is always highlighted in yellow.

Answer 1

False

Question 2

Blank workbook is a type of Excel template you can choose.

Answer 2

True

Question 3

E44 is an example of a cell pointer, also called a cell address.  _________________________

Answer 3

False

Question 4

When you type something in a cell and then press Enter, the cell pointer moves to the first cell of the next row. _________________________

Question 5

A(n) value is text that describes data in a worksheet. _________________________

Question 6

Double-clicking a column boundary automatically widens the column to fit the longest entry in the column using a feature called AutoComplete. _________________________

Question 7

You can add more worksheets to a workbook if you need more than the default number.

Question 8

The AVERAGE function is so common it has its own button on the Home tab. _________________________

Question 9

When Excel guesses which word you want to type after you enter the first letter, you are experiencing a feature known as AutoComplete.  _________________________

Question 10

The name box shows the address of the selected cell.

Question 11

The formula bar shows the address of the selected cell.

Question 12

A worksheet is an electronic grid in which you can perform numeric calculations.

Question 13

Sometimes a worksheet or workbook is referred to as a spreadsheet.

Question 14

When you resize a row by dragging, the pointer becomes a two-headed arrow. _________________________

Question 15

You can edit cell contents by double-clicking a cell. _________________________

Question 16

A1-C5 is an example of a cell range reference.

Question 17

The active sheet in a workbook is in bold on the sheet tab.

Question 18

Every cell in a worksheet has it own unique cell pointer.

Question 19

Labels are numeric data that can be used in calculations. _________________________

Question 20

A group of selected cells that share boundaries is called a cell range. _________________________

Question 21

When you copy a formula to a new cell, the original cell references are replaced with cell references that are in the same ____ position as those in the original formula.

A) relative
B) adjacent
C) absolute
D) exact

Question 22

A(n) ____ can consist of values, cell references, and cell ranges.

A) action
B) cell pointer
C) cell style
D) argument

Question 23

The ____ bar, located just above the column headings, shows the contents of the selected cell.

A) formula
B) data
C) name
D) address

Question 24

According to the order of precedence, which operation below should be performed first?

A) *
B) +
C) ( )
D) /

Question 25

References to cell addresses, such as A1 and E42 are known as ____.

A) cell ids
B) cell references
C) referent addresses
D) referent ids

Question 26

Excel uses the order of precedence which is the standard order used in  ____.

A) math
B) Word
C) statistics
D) English

Question 27

When you click the ____ button, a dotted border appears around the range of cells that Excel assumes you want to add together.

A) AutoSum
B) ADD
C) AUTO
D) Addition

Question 28

To preview a worksheet, click the ______ button in Backstage view.

Question 29

The Enter button, which is a check mark icon, is on the ____.

A) toolbar
B) formula bar
C) address bar
D) function bar

Question 30

All formulas must begin with a(n) ____.

A) equal sign (=)
B) plus sign (+)
C) minus sign (-)
D) forward slash

Question 31

In Excel, the asterisk is the symbol for ____.

A) division
B) multiplication
C) addition
D) the square root

Question 32

The ____ box shows the address of the selected cell.

A) formula
B) data
C) name
D) address

Question 33

If a page is taller than it is wide and some columns are cut off from view, you need to adjust the _________________ in the Settings area of the Print Preview area.

Question 34

In Excel, pressing ____ has the same effect as pressing the right arrow key.

A) [Num Lock]
B) [Space]
C) [Tab]
D) [Enter]

Question 35

A function needs information to make a calculation.This information is known as a(n) ____.

A) argument
B) formula
C) reference
D) absolute reference

Question 36

In a worksheet, the boxes on the left containing numbers are known as ____ headings.

A) data
B) sheet
C) row
D) column

Question 37

To insert a column, click the column heading to the right of where you want the new one, and then click the Insert button in the ____ group.

A) Styles
B) Cells
C) Alignment
D) Font

Question 38

A ____ can contain one or more worksheets.

A) notebook
B) workbook
C) spreadbook
D) sheetbook

Question 39

You can refer to a cell by its ____, a column letter followed by a row number.

A) cell id
B) cell address
C) placement
D) formula

Question 40

_____ referencing is when you copy a formula to a new cell and Excel automatically replaces the original cell references with cell references that are in the same relative position as those in the original formula.

A) Relative cell
B) Absolute cell
C) Formula
D) Relational

Question 43

You are working on a very large spreadsheet that you know will print on several pages.
Describe how to include the page number on the bottom left of every page of your document.

Question 44

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns.
Describe how to center a title over all of the columns that make up your budget.

Question 46

Describe how to change the number format in a cell.

Question 47

Check the ____________________ text box in the Print Preview area to make sure your computer is set to the right printer.

Question 48

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns.
You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

Question 49

In addition to themes, you can add ______________ to individual cells to improve their appearance.

Question 50

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns.
You made a mistake in one of the formulas, how do you correct the error?

Question 51

A worksheet is a much more effective way to communicate data to an audience than a chart.

Question 53

Click the ____________________ button on the Page Layout tab to add a consistent look to all of the elements in your workbook.

Question 54

Describe how to change cell alignment.

Question 55

It is possible to move a chart to a new location on the worksheet after it has been created.

Question 56

A(n) ____________________ is information included at the top of every page in your worksheet.

Question 57

Describe how to enter data in an Excel worksheet.

Question 58

The ____________________ button allows you to merge several cells into one cell and center the text in the merged cell.

Question 59

You are working on a very large spreadsheet that you know will print on several pages.
Describe how you can visualize the entire document before you print it.

Question 61

Data series identify the values on each axis. __________________________

Question 62

The ____ is the horizontal line at the base of the chart that shows categories.

A) title axis
B) z-axis
C) x-axis
D) y-axis

Question 63

A chart layout is a predefined set of chart colors and fills.  __________________________

Question 64

The horizontal and vertical axes are included in the plot area.

Question 65

The chart background is an example of  a chart object.__________________________

Question 66

Clustered Column is a type of Column chart. __________________________

Question 67

The vertical axis provides values, not categories.

Question 68

A(n) data series is a sequence of related numbers that shows a trend. __________________________

Question 69

The ____ is the vertical line that defines the left edge of the chart and provides values.

A) title axis
B) z-axis
C) x-axis
D) y-axis

Question 70

You can move the legend of a chart to a new location using the Chart Elements menu. __________________________

Question 71

The chart area is also known as the plot area.

Question 72

A scatter chart is used for showing relative importance of values over a period of time.

Question 73

It is important to organize your rows and columns of data so that when you create a chart, it illustrates the points you want to make.

Question 74

A chart layout is a predefined arrangement of chart elements. __________________________

Question 75

In a worksheet, you select the cells that contain the data you want to chart, and then click the Recommended Charts button on the Insert tab to choose from a selection of chart types. __________________________

Question 76

Pointing to a sizing handle of a chart allows you to move it. __________________________

Question 77

The horizontal axis is also known as the y-axis.

Question 78

A data marker represents one value in a data series.

Question 79

A trendline is a line that connects high or low points in a data series and shows a trend.

Question 80

You can change one type of chart to another by clicking the Change Chart Type button on the Change Tools Design tab. __________________________