Test 2

Question 1

What is the difference between a workbook and a worksheet?

Answer 1

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines. The term worksheet is interchangeable with “spreadsheet”. A workbook is the overall Excel file. You can have multiple worksheets in one workbook.

Question 2

What is it called when you create a single cell by combining two or more selected cells?

Answer 2

Merging Cells

Question 3

How is a cell range represented in Excel; how would you write out the range?

Answer 3

With a colon (:) to represent the word “through”. For example, if you wanted to select the range cell A1 through cell A5, this would be written as A1:A5.

Question 4

What is the Name Box?

Answer 4

An element of the Excel window that displays the name of the selected cell, table, chart, or object. Displays in the upper-left corner.

Question 5

What is the difference between an Absolute Cell Reference and a Relative Cell Reference?

Answer 5

Absolute Cell References do not automatically adjust when copied like Relative References do.

Question 6

_____ are identified by letters (A, B, C, D, etc.).

Answer 6

Column Headings

Question 7

This is the cell’s unique address; the intersection of the column and row. An example would be A1.

Answer 7

Cell Reference

Question 8

A small black square located in the lower-right corner of the active cell that lets you fill a series, copy formulas, or copy formatting.

Answer 8

The Fill Handle

Question 9

How can you select all of the cells in a worksheet (all columns and all rows)?

Answer 9

Select All box (located in the upper-left corner of the worksheet between column A and row 1)

Question 10

Where is the Formula Bar located and what is its purpose?

Answer 10

The Formula Bar is located directly above the Column Headings (A, B, C) next to the Insert Function button. It allows you to edit the contents of cells and shows the formulas provided in cells.

Question 11

What button can you use to copy formatting from one cell to another?

Answer 11

Format Painter

Question 12

What do we call a graphic representation of numeric data?

Answer 12

Chart

Question 13

What button allows you to quickly combine multiple cells into one single cell and center them at the same time?

Answer 13

Merge & Center

Question 14

What button/gallery on the Home tab allows you to quickly apply preformatted styles to a cell or a range of cells?

Answer 14

Cell Styles

Question 15

How can “explode” or make a piece of a pie chart separate from the rest of the chart?

Answer 15

Select just that piece, or data point, on the chart and then drag it away from the rest of the chart.

Question 16

How do you begin a formula in Excel?

Answer 16

With the equal sign (=)

Question 17

If you want to multiply in a formula, what symbol do you use?

Answer 17

The asterisk (*)

Question 18

What type of cell reference is this: B4?

Answer 18

Relative Cell Reference

Question 19

What type of cell reference is this: $C$8?

Answer 19

Absolute Cell Reference

Question 20

When writing a formula inside a cell, Excel will outline the specific cells being used in the formula in different colors in order to help you verify which cells are referenced. What is this feature called?

Answer 20

The Range Finder

Question 21

What is one way you can insert a function?

Answer 21

1) Type the function
2) Under the Formulas tab
3) Insert Function button next to Formula Bar
4) Type = and then the first letter of the function
5) Common ones available under Sum button

Question 22

What is the difference between a formula and a function?

Answer 22

A formula is an equation that you specify in a cell; whereas a function is a predefined formula that Excel has already built for you, and then you use to perform calculations on specific values in a particular order. Example is the SUM function.

Question 23

What is the NOW function?

Answer 23

Excel function that retrieves the date and time from your computer’s calendar and clock and inserts the information into the selected cell. Think of it as a date and time stamp on your workbook that automatically adjusts.

Question 24

What do we call a function that works with values that are either true or false? An IF function is an example of this type of function.

Answer 24

Logical Function

Question 25

What is the formula/syntax for an IF Function?

Answer 25

=IF(logical_test, value_if_true, value_if_false)

Question 26

In a formula or function, what is a “constant value”?

Answer 26

A constant is a number, text, date, or time that you type into a cell. For example, if you have the function =SUM(A1:A5)/100, the number 100 is a constant value. While the contents of cells A1 through A5 might change, you will always divide that end result by 100, no matter what.