Excel stores spreadsheets in files called? The contents are located where? Workbooks; shown in the workbook windowWhat displays the cell reference of the active cell? Name boxThis button is used to select all of the cells in the active worksheet. Select all buttonThis is defined as the number along the left side of the worksheet window that identify the different rows in the worksheet. If you click on it is will select the entire worksheet rowRow headingThis is used to scroll the list of sheet tabs in the worksheetSheet tab scrolling buttonThe sheet currently displayed in the workbook window is called? Active sheet; the tab is white when highlighted. This displays the value or formula entered in the active cell. Formula barA workbook is made up of individual (blank). It is identified by a (blank), which appears in the (blank). sheet; sheet name; sheet tabThe color of inactive sheets are colored what? GrayEach intersection of a row and column is called what? CellWorksheet data is placed within separate what? CellsThis is the name given to the cell currently selected in the active worksheet. Active CellThis is outlined with a thick border and the corresponding row and column headings are highlighted. Active CellThis increases or decreases the display of content in the worksheet. The controls are found on the bottom right corner of the spreadsheet. Zoom controlsThese are the letters along the top of the worksheet window identify the different columns in the worksheet. You click a letter to select the entire column. Column HeadingsThis displays the contents of the spreadsheet laid our in a grid of rows and columns. Worksheet. This is a collection of text and numbers laid our in a rectangle grid. SpreadsheetThis is when you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. What-if analysisThis contains an Excel chart that provides a visual representation of worksheet data. Chart SheetEach cell within a worksheet is identified by what? Cell ReferenceA planning analysis worksheet contains what 4 questions?(1) What problems do I want to solve?
(2) What data do I need?
(3) What calculations do I need to enter?
(4) What form should my solution take? Text that doesn’t fit within the cell covers the cell(s) which way? the rightWorksheet cells can contain what? text, numbers, dates, timesThis is the term to describe any combination of letters, numbers, and symbols that form words and sentences. Text DataText Data is normally referred to as a (blank), because it contains a string of text characters. Text StringThis is referred to an any numerical value that can be used in a mathematical calculation. Number DataThese are commonly recognized formats for date and time values. Date and Time DataThis is the term given when the rest of a piece of text entry is hidden. TruncatedWhat two buttons do you press in order to create an insertion point that moves a new line within a cell. Alt and EnterThis is a feature of Excel that tries to anticipate the remaining characters by displaying text that begins with the same letters as a previous entry in the same column. Auto CompleteWhat to you press on the ribbon to force text that extends beyond a cells border to fit within the cell? Wrap TextIf a number exceeds a cell size, what do you see?#########This is known as a single point on a computer monitor or printout. pixelHow do you select multiple columns? By click and drag the pointer over multiple column headings. The height of an Excel row is measured in what? point or pixelsThis eliminates empty space by matching the row height or column width to it’s tallest or longest cell entry. AutofittingThis is when you remove data, leaving blank cells where the data had been. Clearing DataThis removes both the data and the cells. Deleting DataThis tab opens the backstage view, which provides access to commands for saving and printing the workbook. File TabThis verifies words in the active worksheet against the programs dictionary. You can replace or ignore the words it flags as misspelled. Spelling checkerA group of cells is called what? Cell range or rangeThis indicates whether you are in Ready mode or Edit mode. Status barThis tab inserts a new worksheet at the end of a workbookInsert Worksheet tabThis tab provides commands to change the way worksheets appear on printed pages. Page Layout tabThis is an expression that returns a value. FormulaThis is two or more distinct adjacent ranges. Nonadjacent rangeThese buttons change how the worksheet content is displayed- Normal view, Page layout view, or page break previewView buttonsThis is a group of cells in a single rectangular block of cells. Adjacent rangeThis locates text and values in the workbookFind CommandThis overwrites texts and values in the workbookReplace commandThis button inserts Excel functions to sum, average, or count all the values in a column or row, as well as display minimum or maximum value in a columnSum button; also known as the Autosum buttonThis indicates the location and size of a cell range. Range Reference/the active cell in the selected range is what color? whiteOne way to move a cell or range is to select it, position the pointer over the bottom border of the selection, and then drag the selection to a new location. this technique is called what? Drag and dropThis indicates the range reference of the new locationScreenTipThis will place the cell contents into computer memory or on the Clipboard. CuttingThis is the button pressed when you want to take what was cut and placed on clipboard, in order to put it into new cell. PasteA formula is written using (blank) that combine different values, resulting in a single value that is then displayed within the cell. OperatorsThe most common used operators are (blank) that perform addition, subtraction, multiplication, division and exponentiation. Arithmetic operatorsThis is a set of predefined rules used to determine the sequence in which operators are applies in a calculation. Order of precedenceWhat is the order of precedence? Parenthesis, Exponentiation (^), multiplication (*), and division (/), addition (+), and subtraction (-)A formula is displayed where? Formula barWhat mode would you work in to edit the cell content? Edit ModeFor greater speed and accuracy, you can use the Find command to locate a string of characters known as what? Search stringYou can replace text with new text characters with what? Replacement stringWhat three ways can you view a worksheet?(1) Normal view (2) Page Layout view (3) Page Break viewThis view is what view you see the Excel spreadsheet already in. Normal viewThis view shows how the worksheet will appear when printed. Page Layout viewThis view displays the location of the different page breaks within the worksheet. Page Break viewWhere are your three views locate? Page Layout buttonThis occurs when the page is taller than it is wide. Portrait orientationThis occurs when the page is wider than it is tall. Landscape orientationYou can view formulas in a workbook by switching to what view? Formula viewWhen this is done to a print, thus reducing the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed. ScalingThis copies and pastes formatting from one cell or range to another without duplicating any data. Format PainterIt what mode can you format a text string within a cell? Edit ModeThis is the specific design of a set of characters, including letters, numbers, punctuation marks, and symbols. TypefaceName examples of how a font can be formatted with a font style. Bold, italic, bold italic, underline, and colorWhat type of style is chosen to add a thousands separator and two decimal points, and line up values by their decimal points? Comma styleThis is a set of characters that employ the same typeface, such as Arial, Times New Roman, and CourierFontThis type of style lines up currency values by their currency symbol and decimal point; negative numbers are enclose in parentheses. Accounting StyleThis group located on the ribbon has buttons for setting the horizontal and vertical alignment, the orientation, indents, and text wrapping of text in a cell, as well as merging cells. Alignment groupCombining several cells into one cellMergeIncreasing or decreasing the size of textFont SizeFont sizes are measured in what? PointsThis is known a background color that can be added to cells to help differentiate parts if a worksheet or highlighted areasFill colorThis type of style formats numbers with with the symbol %. Percentage styleThis is a line you add along an edge of a cell to improve readability of the data. BorderThis is the process of changing a workbooks appearance by defining fonts, style, colors, and decorative features. It doesn’t affect the data itself, just the appearance. FormattingThis controls how fast the chart appears to recede from the viewer’s eye. PerspectiveThis type of chart combines two or more Excel chart types into a single graph. Combination ChartThis provides options for formatting the appearance of sparklines. The Sparkline Tools Design TabThis displays data values using a connected line rather than columns or bars. Line ChartThis is a conditional format that adds a horizontal bar to the background of a cell proportional in length to the cells value. Data BarThis is a graph that is displayed within a call. You can create a line, column and a win/loss. SparklineThis axis appears along the right side of the chart. Secondary AxisThis is a collection of formats for text, colors, images, and graphical effects applied throughout a workbook. ThemeThis is associated with a particular theme and used for headings and body text in the workbook. Theme fontThis is what is used when you don’t want to apply a font associated with a particular design. Text formatting this type of font retains its appearance no matter what them is used with the workbookNon-theme fontAn example of this font would be Times New Roman, and has decorative strokes at the end of each character. Serif fontsAn example of this font would be Arial, and does not include decorative strokes. Sans serif fontThese are the 12 colors that belong to the workbooks themeTheme colorsThis axis appears along the left side of the chartPrimary AxisThen range of values. ScaleThis type of chart uses a column cart turned on its side so that the length of each bar is based on its value. Bar ChartThis type of chart displays values in different categories as columns, the height of each column is based on its valueColumn ChartLines that connect each data label to its corresponding data marker. Leader LinesThis is the square or dot on the selection box that is used to change the objects width and height. Sizing HandleThis is a box surrounding the chart object that is used to move or resize the object. Selection BoxMerges the range into a single cell, but does not horizontally center the cell content. Merge CellsThis is the title given to the five variation, in which a different tint or shading is applied to the theme color. AccentsMerges each of the rows in the selected range across the columns in the rangeMerge AcrossThis reverses a merge, returning the merged cell back into a range of individual cells. Unmerge CellsThe Format Cells dialog box has six tabs, each focusing on a different set of formatting options. What are they? Number, Alignment, Font, Border, Fill, ProtectionThis provides options for formatting the appearance of numbers, including dates and numbers treated as text. Number formatThis provides options for how data is aligned within a cell. Alignment formatDark red, red, orange, yellow, light green, green light blue, blue, dark blue, and purpleStandard ColorsThis is created by specifying a mixture of red, blue, and green color values, making available 16. 7 million different colors. Custom ColorThis is the option that uses your Window default text and background colors, usually black text on white background. Automatic colorThis displays the values in a way that makes it easy for the reader to quickly understand and interpret them. Number FormatThis is a default Excel format, which displays values exactly as they are typed by the user. General number formatMerges the range into one cell and horizontally centers the content. Merge & CenterFont formatThis provides options for selecting font types, sizes, styles, and other formatting attributes such as underlining and font colors. This provides combination s of formats to customize the chartChart StylesThis contains the chart and all of the other chart elements. Chart AreaThis is a descriptive label or name for a chart. Chart TitleThis is part of the chart that contains the graphical representation of the data series. Plot AreaThis is a rectangular area that indicates the data markers associated with the data series. LegendEach value in a data series is represented by what? (Such as a column or pie slice)Data MarkerA chart in the shape of a circle that shows data values as a percentage of the whole. Pie ChartThis identifies the units at regular intervals on the chart axis. Tick marksThis provides options for adding and removing cell borders as well as selecting a line style and color. Border formatThis provides options for creating and applying background colors and patterns to cells. Fill formatThis provides options for locking or hiding cells to prevent their users from modifying their contents. Protection formatThis is a fast and efficient way of maintain a consistent look and feel throughout a workbook. Format PainterThis tab has options you can use to define print formattingPage Layout TabThis is information that appears in the top margin of each printed page. It includes a summary information such as the filename and the date. HeaderThis can be set this information to appear on every printed page, by specifying rows or columns to repeat on the top left or each page; use this button on the Layout tab to do this. Print TitlesThis displays alternate rows in an Excel table with different fill colors. Banded RowsThis is information that is printed in the bottom margin of each printed page. It often includes summary information such as the current page number and the number in the printout. FooterThis is a visual representation of a set of data values. Charts show trends or relationships that may not be readily apparent from numbers alone. Chart or GraphThe object in a worksheetEmbedded chartThis is the range that contains the data to display in the chart. Data SourceThis is the first row of the data range, identifies the data seriesSeries NameA data source is a collection of one or more (blank) which is a range of values that is plotted as a single unit on the chart. Data SeriesThis is the first column of the data range, which are the groups of categories that the series values belong to. Category ValuesThis is the data displayed in the chartSeries ValuesThis displays the series values from the data series. Vertical or value axisThis displays the category values from each data series. Horizontal or category axisYou can apply a collection of formats, called a style, to different cells using the Cell Styles button. Cell Styles ButtonThis appears when an excel table is selected. Table Tools TabThis formats the entire table as a single unit, once you identify the range. Table styleThis is the space between the page content and the edges of the pageMarginThis applies formatting only when a cells value meets a specified condition. This is often used to help analyze data. Conditional formatTreating the range of data as a distinct object in a worksheet. Excel tableName the six elements that can be turned on and off in the Table Style Options. Header Row, Total Row, First Column, Last Column, Banded Rows, Banded Columns. This will format the first row of the tableHeader RowThis will insert a new row at the bottom of the table that adds the column values. Total RowTests whether the value in A1 is less than or equal to the value in B1A1 <= B1Tests whether the value in A1 is not equal to the value in B1A1 <> B1The amount of money being loanedPrincipalThe amount added to the principal by the lenderInterestThe interest is equal to the percentage of principal for each period that the money has been lentSimple InterestThe interest is applied not only to the principal, but also to any accrued interest. Compound InterestTo calculate the costs associated with a loan or mortgage, what 5 pieces of information do you need?(1)The amount being borrowed (2) The annual interest rate (3) The number of payment periods per year (4) When loan payments are due (5) The length of the loan in terms of the number of payment periods. This provides different options for organizing chart elements. Chart layoutsThis formats the first column of the table. First ColumnThis formats the last column of the table. Last ColumnThis formats alternating rows in different colors. Banded RowsThis formats alternating columns in different colors. Banded ColumnsThis is a key that allows each color used in the worksheet and what it means, so others know why certain cells are highlighted. LegendThe region that is sent to the printer from the active sheet is known as what? Print AreaBy default, Excel prints as much of the content that fits on single page without resizing the content, and then inserts (blank) to continue printing the remaining worksheet content on successive pages. Automatic Page BreaksTo split the worksheet into logical segments, which you can do by inserting (blank) that specify exactly where the page break occurs. Manual Page BreaksFunctions are organized by the category in what library group? Function Library GroupCopies content and formats from a cell or range into an adjacent cell or range. The cell contents can be text, values, or formulas. Auto fillThis appears in the lower right corner of a selected cell or range. When it is dragged over adjacent cell or range will copy the content and formatting from the original cell into the selected range. Fill HandleThis appears after you complete the fill so you can select whether to copy cell content and formatting, extend the data series, fill only the cell formatting, or fill only cell content. Auto Fill Options ButtonPayments are expressed as (blank) because they are treated as expenses. Negative numbersTests whether the value in cell A1 is equal to the value in cell B1. A1= B1Tests whether the value in A1 is greater than the value in B1A1> B1Tests whether the value in A1 is less than the value in B1A1
In the Function Arguments dialog box, Pamela enters the number of payments for the ____ argument.
nperAbsolute references are marked with a ____.$Pamela is getting ready to purchase her first condominium. To get ready for the mortgage process, she gathers her Excel spreadsheets that contain all of her financial information.
Assuming Pamela is faithful to her monthly payments and her interest rate does not change, she should be able to calculate the ____ of the loan.
fvThere is a black ” plus sign” on the lower right edge of the cell that is the ____. fill handleTo change the order of operations, enclose part of the formula in ____. parenthesesThe contents of an active cell are displayed in the ____. formula barA(n) ____ is a group of cells. rangeTo view formulas, rather than the resulting values in a worksheet, switch to ____. formula viewRow headings identify each row using a different ____. numberAn Excel formula always begins with a(n) ____. equals signIn the figure above, the ____ replaces the current occurrence of the search string. Replace buttonIn ____ orientation, a page is taller than it is wide. portraitUsing AutoFill is ____ than copying and pasting.
AnswerfasterMost Recently Used is a ____. category in the Insert Function dialog box____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table. MixedPamela is getting ready to purchase her first condominium. To get ready for the mortgage process, she gathers her Excel spreadsheets that contain all of her financial information.
Pamela has been told by one bank that if approved, she will have to pay a compound interest. This means that ____.
interest paid is calculated on the principal and any previous interest payments that have been added to that principalIn the formula = IF(A1= B1, C1, C2), the result will be C2 if ____. A does not equal BFor most loan and investment calculations, you need to enter the annual interest rate ____ the number of times the interest is compounded during the year. divided byIn the following formula: = IF(A1=” YES”, ” DONE”, ” RESTART”), what happens if A1= ” NO”? The formula returns the text ” RESTART”. Copying a range of cells is similar to moving a range, except that you must press the ____ key while you drag the selection to its new location. CtrlThe active cell has a ____ border. thickThe characters +, -, *, and / are examples of ____. arithmetic operatorsTo select a large range of cells, click the first cell in the range, press and hold ____, and then click the last cell in the range. ShiftThe intersection of a row and column is known as a ____. cellIn the figure above, the formula shown SUM(H6: H9) appears in the ____. formula barCutting a selection sends it to the ____ until you paste it. ClipboardExcel stores its documents as files called ____. workbooksnper stands for the ____. total number of payment periods required to pay off the loanWhich of the following is not a comparison operator? ____ < Ajeesh has copied his data set to a new spreadsheet where he wants to draw attention to data that received above a 75% approval rating. To highlight these numbers, Ajeesh could apply ____. the Greater Than rule with Conditional FormattingOptions to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab. OrientationTo remove banded rows from an Excel table, first you need to select the ____ tab on the Ribbon. DesignYou can create a ____ color by specifying a mixture of red, blue, and green color values. customIn the above figure, table styles are shown above the following group label: ____. Table StylesBy default, numbers appear in the ____ and generally display values exactly as you type them. Ajeesh wants his team’s documents to have a common style and appear as a cohesive unit for a large end-of-year presentation. The easiest way to make all documents appear as a cohesive unit is to ____. save the styles and themes as permanent files for other members of his workgroup____ merges each of the rows in the selected range across the columns in the range.
AnswerGeneral number formatTo avoid splitting a worksheet in awkward places, you can insert a(n) ____ to specify a specific breaking point. manual page breakAjeesh is part of a team creating a number of files with Microsoft Office. Ajeesh is working with four other team members to create individual files for a joint presentation. Ajeesh is in charge of the Excel workbook for his team.
AnswerMerge AcrossThe header and footer sections include ____. a left, right, and center sectionWhat sign begins a formula?= Cells are referenced by what? Column then rowThis allow you to view the results of common calculations without entering a formula into your worksheet. AutocalculateThis does what = AVERAGE (B1: B6)? Calculates the average value of a list of numbers. This does what = COUNT(B1: B6)? Counts the number of values in a list of numbers. This does what = MAX (B1: B6)? Finds the largest value in a list of numbers. This does what = MIN (B1: B6)? Finds the smallest value in a list of numbers. This does what = Now(insert what you want)? Inserts date or timeThis does what = ROUND(B6, 2)? Rounds a number to a specific number of digitsThis does what = SUM(B1: B6)? Adds the list of numbersThe comma used in a formula means what? Used between cell references in a function to use the displayed cells and all cells between them to perform a calculation. The colon used in a formula means what? Used between cell references in a function to use the displayed cells and all cells between them to perform the calculation (range)What is placed at the end of a purpose statement? a periodThe titles of a worksheet need to be what? Merged and centered across the columns of my worksheet and aligned vertically within a merged cell at center. Alphabetical data needs to be aligned where? The left side of the cellNumerical data needs to be aligned where? The right side of the cell. ONBITS 211 SPECIFICALLY FOR YOUFOR ONLY$13. 90/PAGEOrder NowTags: