Test 2 Flashcards
What is the difference between a workbook and a worksheet?
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.
What is it called when you create a single cell by combining two or more selected cells?
Merging Cells
How is a cell range represented in Excel; how would you write out the range?
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.
What is the Name Box?
An element of the Excel window that displays the name of the selected cell, table, chart, or object. Displays in the upper-left corner.
What is the difference between an Absolute Cell Reference and a Relative Cell Reference?
Absolute Cell References do not automatically adjust when copied like Relative References do.
_____ are identified by letters (A, B, C, D, etc.).
Column Headings
This is the cell’s unique address; the intersection of the column and row. An example would be A1.
Cell Reference
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.
The Fill Handle
How can you select all of the cells in a worksheet (all columns and all rows)?
Select All box (located in the upper-left corner of the worksheet between column A and row 1)
Where is the Formula Bar located and what is its purpose?
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.
What button can you use to copy formatting from one cell to another?
Format Painter
What do we call a graphic representation of numeric data?
Chart
What button allows you to quickly combine multiple cells into one single cell and center them at the same time?
Merge & Center
What button/gallery on the Home tab allows you to quickly apply preformatted styles to a cell or a range of cells?
Cell Styles
How can “explode” or make a piece of a pie chart separate from the rest of the chart?
Select just that piece, or data point, on the chart and then drag it away from the rest of the chart.
How do you begin a formula in Excel?
With the equal sign (=)
If you want to multiply in a formula, what symbol do you use?
The asterisk (*)
What type of cell reference is this: B4?
Relative Cell Reference
What type of cell reference is this: $C$8?
Absolute Cell Reference
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?
The Range Finder
What is one way you can insert a function?
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
What is the difference between a formula and a function?
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.
What is the NOW function?
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.
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.
Logical Function
What is the formula/syntax for an IF Function?
=IF(logical_test, value_if_true, value_if_false)
In a formula or function, what is a “constant value”?
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.
