This preview shows pages 1 - 3 of a 11 page document.
to view the rest of the content
BA242 Mid-Term Exam Study Guide Ch. 1-5 &7-8Chapter One: Create, Navigate, Work with, and Print WorksheetsData plays a crucial part in supporting business. Without it, businesses cannot determine their effectiveness in the market, analyze profit or loss. Excel is a program that can be used to manage, analyze, and share information. With the help of Excel, businesses can reveal underlying trends, calculate values, make perditions, make recommendations, and display or share information with large or small amounts of data.Key Terms: Spreadsheet- is a collection of data that is organized in a row and column format.Cell- Intersection of each row and column. Row- horizontal set of cells that encompasses all the columns in a worksheet.Column- vertical set of cells that encompasses all the rows in a worksheet. Formula- is an equation that produces a result that may contain numbers, operators, text, and/or functions.Function- that is a built-in program that preforms a task with such as calculating a sum or average. Both formulas and functions must always start with the equal sign (=).Worksheet- a grid of columns and rows in which data is entered. Each instance of a spreadsheet is referred to as a worksheet. What-if analysis- you can change values in spreadsheet cells to investigate the outcome of the values in a worksheet. Record- a record is all of the categories of data that pertain to one person, place, thing, event, or idea and are formatted as a row in a worksheet. Field- is an item of information in a worksheet column that is associated with something of interest.
Workbook- file that contains one or more worksheets. Active Worksheet- is the worksheet that is visible in the Excel application window and is denoted by a white tab-unless tab color has been applied- with normal letters. Worksheet tabs are located at the bottom left side of the Excel window.Cell Reference- refers to a particular cell or range of cells within a formula or function instead of a value.Active Cell- is the recipient of action, such as a click, calculation, or paste. When the cell becomes active, the border around it changes to a thick, green line. Keyboard shortcut- is a keyboard equivalent for a software command that allows you to keep your hands on the keyboard instead of reaching for the mouse to make ribbon selections. Allow rapid navigation in a worksheet without using the mouse. Enter- Down one rowShift +Enter- Up one row Ctrl + Home- To Column A, row 1 (cell A1)Comment- is a text box, similar to a sticky note, that is attached to a cell in a worksheet in which you can enter notes or give instructions. Text data- consists of any combination of printable characters, including letters, numbers, and specific characters available on a standard key board. Numeric data- consists of numbers (0-9) in any form not combined with letters and specific characters such as the period (decimal point) and/ or hyphen (to indicate negative values). Date Value- data formatted as a date takes the form of a serial numbers, with serial number 1 representing January 1, 1990. Time data- represented as decimal value where .1 is 144 minutes, .01 is 14.4 minutes, and so on. Cell Range- refers to the cells in the worksheet that have been selected. Contiguous cell range- consists of multiple selected cells, all directly adjacent to one another.
Noncontiguous cell range- consists of multiple selected cells with at least one cell not directly adjacent to other cells. Clipboard- is a temporary storage location where information that was cut or copied is stored until you paste, move, or clear the information. Destination cell- the location cell to be modified by a move or paste operation. Merge & Center- feature, combines selected cells into a single cell and then centers the text within that single cell. White Space- refers to blank areas of a worksheet that do not contain data or documentation, regardless of actual color. AutoFit- feature, adjusts column width and row height automatically on the basis of the width and height of selected content. (reducing white space)AutoFill- copies information from one cell or a series in contiguous cells into contiguous cells in the direction in which the fill handle is dragged. A smart copy that will try to guess how you want values or formulas changed as you copy. Page Layout view- shows page margins, print header and footers, and page breaks. It presents a reasonable preview of how the worksheet will print on paper. Page Break Preview- does not show page margins, headers, or footers, but it allows to manually adjust the location of page breaks. This is helpful when you would like to force a page break after a set of summary values and/or between data categories, and print parts of data on a new page. Print Preview- is the backstage view of how a document, workbook, presentation, table, or other objects will appear when printed. Landscape orientation- indicates that the page is wider than it is tall. Portrait orientation- indicates that the page is taller than it is wide. Chapter Two: Formats, Functions, and Formulas
This is the end of the preview. Please
to view the rest of the content
Join more than 18,000+ college students at University of Tennessee - Knoxville who use StudySoup to get ahead