Download NVCC ITE 140 Exam 1 – Complete Questions & Verified Answers Introduction to Web Design and more Exams Web Design and Development in PDF only on Docsity!
NVCC ITE 140 Exam 1 – Complete Questions & Verified Answers
Introduction to Web Design & Software Tools | 2025 Exam
A chart value that originates in a worksheet cell is referred to as ________.- CORRECT ANSWER ✔✔ a data point A defined set of formatting characteristics such as font, font size, and font color are known as a ________.- CORRECT ANSWER ✔✔ cell style A text value in Excel is also referred to as a ________.- CORRECT ANSWER ✔✔ label All formulas begin with an ________.- CORRECT ANSWER ✔✔ = Comma Style format displays a number with ________.- CORRECT ANSWER ✔✔ two decimal places Hold down the ________ key to select nonadjacent cells.- CORRECT ANSWER ✔✔ Ctrl In Excel 2016, row headings are identified by ________.- CORRECT ANSWER ✔✔ numbers The Percent Style button formats selected cells as a percentage with ________.- CORRECT ANSWER ✔✔ zero decimal places The ________ displays the current cell mode, the page number, and the zoom buttons.- CORRECT ANSWER ✔✔ status bar The default number format for cells is the ________ number format.- CORRECT ANSWER ✔✔ General The keyboard shortcut to display Print Preview is ________.- CORRECT ANSWER ✔✔ Ctrl + F The value axis is also known as the ________.- CORRECT ANSWER ✔✔ y-axis
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.- CORRECT ANSWER ✔✔ Sparklines To display the document properties, click the ________ tab.- CORRECT ANSWER ✔✔ File Using a touchscreen, which of the following actions is the same as right clicking the mouse?- CORRECT ANSWER ✔✔ Press and hold for a few seconds What are the two contextual tabs that display under Chart Tools when a chart is selected?- CORRECT ANSWER ✔✔ Format and Design When a cell is part of an active formula, it is surrounded with ________.- CORRECT ANSWER ✔✔ a colored border with small boxes on each side When preparing a document for printing, a ________ indicates that only the columns to the left will be printed on the first page.- CORRECT ANSWER ✔✔ vertical dotted line between columns When using a touchscreen, which of the following actions is the same as clicking an item?- CORRECT ANSWER ✔✔ Tap the item When you type data in a cell and press Enter, what cell becomes the active cell?- CORRECT ANSWER ✔✔ The cell below When you type text in a cell it is ________.- CORRECT ANSWER ✔✔ left-aligned Where is the fill handle located?- CORRECT ANSWER ✔✔ In the lower right corner of a selected cell Which of the following does not display to the right side of a selected chart?- CORRECT ANSWER ✔✔ Move Chart button
In the Excel window, where does [Group] display when worksheets are grouped?- CORRECT ANSWER ✔✔ On the title bar On your keyboard, which two symbols function identically in date formats?- CORRECT ANSWER ✔✔ The hyphen key and the forward slash key Sheet tab names are ________ when they are grouped.- CORRECT ANSWER ✔✔ Underlined The COUNT function counts the number of cells in a range that ________.- CORRECT ANSWER ✔✔ contain a number The COUNTIF function has two arguments ________.- CORRECT ANSWER ✔✔ the range of cells to check and the criteria The MEDIAN function finds ________.- CORRECT ANSWER ✔✔ the middle value in a range of cells The ________ is the temporary storage location for cell contents copied from a worksheet.- CORRECT ANSWER ✔✔ Clipboard The quickest way to repeat an action in Excel is the ________ function key.- CORRECT ANSWER ✔✔ F To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ________.- CORRECT ANSWER ✔✔ red diamond What are the default names of worksheets?- CORRECT ANSWER ✔✔ Sheet1, Sheet2, etc. What does a data bar in a cell represent?- CORRECT ANSWER ✔✔ The value of a cell relative to other cells What is a pane bounded by?- CORRECT ANSWER ✔✔ Vertical or Horizontal bars
What is a summary sheet?- CORRECT ANSWER ✔✔ A worksheet where totals from other worksheets are displayed What is an Excel table?- CORRECT ANSWER ✔✔ A series of rows and columns that contains related data that can be managed independently from other data in a worksheet What is the keyboard shortcut for flash fill?- CORRECT ANSWER ✔✔ Ctrl + E When formatting a worksheet to be printed, ________ show where page breaks are located.- CORRECT ANSWER ✔✔ dotted lines Where do sheet tabs display in a workbook?- CORRECT ANSWER ✔✔ Lower area of the workbook window Where does Excel's NOW function retrieve the date from?- CORRECT ANSWER ✔✔ The computer's clock Which of the following Excel features recognizes a pattern in the data of a worksheet?- CORRECT ANSWER ✔✔ Flash Fill Which of the following is FALSE about the NOW function?- CORRECT ANSWER ✔✔ It remains constant even when the workbook is opened. Which of the following is FALSE about worksheet tabs?- CORRECT ANSWER ✔✔ The active worksheet tab displays in red font. Which of the following is NOT a way to insert the SUM function into a cell?- CORRECT ANSWER ✔✔ Ctrl + = A ________ in a pie chart identifies the pie slices.- CORRECT ANSWER ✔✔ data label A chart and all of its elements is known as the ________.- CORRECT ANSWER ✔✔ chart area
When you print a chart sheet, how is it automatically formatted?- CORRECT ANSWER ✔✔ It is centered on the page. Where is the Format Painter button located?- CORRECT ANSWER ✔✔ On the mini toolbar and the Home tab Which of the following displays trends over time?- CORRECT ANSWER ✔✔ A line chart Which of the following is NOT one of the three spatial dimensions of 3-D?- CORRECT ANSWER ✔✔ Height Which of the following is TRUE about a pie chart?- CORRECT ANSWER ✔✔ It shows the relationship of each part to a whole. Which of the following is the first order of operations?- CORRECT ANSWER ✔✔ Expressions within parentheses Which of the following is the second order of operations?- CORRECT ANSWER ✔✔ Exponentiation Which of the following resides along the left side of a column chart?- CORRECT ANSWER ✔✔ The y-axis Which symbol represents that a cell is an absolute cell reference in a function or formula?- CORRECT ANSWER ✔✔ $ You must select ________ on a worksheet to create a pie chart.- CORRECT ANSWER ✔✔ two ranges ________ is a group of related data points represented by data markers.- CORRECT ANSWER ✔✔ A data series ________ is an Excel tool that finds the input needed to arrive at a desired result.- CORRECT ANSWER ✔✔ Goal Seek
A ________ is a list of values that are acceptable for a range of cells.- CORRECT ANSWER ✔✔ Validation List A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.- CORRECT ANSWER ✔✔ Green A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________.- CORRECT ANSWER ✔✔ Trace Precedents command A data tables is useful for all of the following except for ________.- CORRECT ANSWER ✔✔ determining the Future value (Fv) A defined name provides a logical reference to ________.- CORRECT ANSWER ✔✔ Data A method to find a specific value for a cell by adjusting the value of one other cell is ________.- CORRECT ANSWER ✔✔ Goal Seek A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n) ________.- CORRECT ANSWER ✔✔ data table A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.- CORRECT ANSWER ✔✔ Data validation A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value is called a ________.- CORRECT ANSWER ✔✔ defined name All of the following are methods to define a name for a cell or group of cells except: ________.- CORRECT ANSWER ✔✔ Select the range, click in the Formula bar, and then type the name. An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.- CORRECT ANSWER ✔✔ VLOOKUP
In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________.- CORRECT ANSWER ✔✔ rate The Error Checking button displays as a ________.- CORRECT ANSWER ✔✔ yellow diamond The Future value (Fv) at the end of the time period in an Excel function is usually ________ for loans.- CORRECT ANSWER ✔✔ zero The ________ command checks for common errors that occur when using formulas.- CORRECT ANSWER ✔✔ Error Checking The ________ function looks up values in a table array arranged in horizontal rows.- CORRECT ANSWER ✔✔ HLOOKUP The amount charged for the use of borrowed money is called ________.- CORRECT ANSWER ✔✔ interest The location within which a defined name is recognized without qualification is referred to as the ________.- CORRECT ANSWER ✔✔ scope The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ________.- CORRECT ANSWER ✔✔ a what-if analysis The total amount that a series of future payment is worth is called the ________.- CORRECT ANSWER ✔✔ Principle To see how different interest rates affect a monthly payment, use a ________.- CORRECT ANSWER ✔✔ one-variable data table To see how different interest rates and different payment periods will affect a monthly payment, use a ________.- CORRECT ANSWER ✔✔ two-variable data table
Use the ________ command to locate and resolve an error in a formula.- CORRECT ANSWER ✔✔ Trace Error Using various interest rates to determine the amount of loan payments is an example of using ________.- CORRECT ANSWER ✔✔ What-If Analysis When you start typing a formula, such as =SUM(B Excel will display the ________, which contains all of Excel's built in functions starting with the letter B.- CORRECT ANSWER ✔✔ Formula Auto Complete list ________ cells are cells that are referred to by a formula in another cell.- CORRECT ANSWER ✔✔ Precedent ________ displays arrows that indicate what cells are affected by the value of the currently selected cell.- CORRECT ANSWER ✔✔ Trace Dependents command ________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.- CORRECT ANSWER ✔✔ Lookup ________ is the process of examining a worksheet for errors in formulas.- CORRECT ANSWER ✔✔ Auditing A ________ is a single piece of information that is stored in every record.- CORRECT ANSWER ✔✔ Field A defined set of formatting characteristics for a cell, such as fonts, font sizes, number formats, cell borders, and cell shading is known as a(n) ________.- CORRECT ANSWER ✔✔ Cell Style A hyperlink in a worksheet may take you to which of the following locations ________.- CORRECT ANSWER ✔✔ another location in the worksheet or the company intranet A pre-designed set of colors, fonts, lines, and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.- CORRECT ANSWER ✔✔ theme
Saving an Excel worksheet as a CSV file separates the cells of each row with ________.- CORRECT ANSWER ✔✔ commas Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.- CORRECT ANSWER ✔✔ tab delimited text file Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.- CORRECT ANSWER ✔✔ horizontal and vertical Subtotaled rows that are totaled and summarized are referred to as ________ data.- CORRECT ANSWER ✔✔ detail The Page Break view shows where the page breaks will occur by displaying ________.- CORRECT ANSWER ✔✔ blue dashed lines and the page number on the worksheet The defined table range will automatically display as the ________ range in the Advanced Filter dialog box.- CORRECT ANSWER ✔✔ List The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.- CORRECT ANSWER ✔✔ field The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.- CORRECT ANSWER ✔✔ show and hide The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as ________.- CORRECT ANSWER ✔✔ panes To apply complex criteria to a single column, use a(n) ________.- CORRECT ANSWER ✔✔ custom filter
To freeze column and row titles on the screen so that they are visible while you scroll, which of the following command(s) would you use?- CORRECT ANSWER ✔✔ Freeze Panes To move to a specific cell or range of cells in a large worksheet use the ________ command.- CORRECT ANSWER ✔✔ Go To To move to cells that have special characteristics, are blank, or contain constants, use the ________ command.- CORRECT ANSWER ✔✔ Go To Special To save an Excel file in another file format, use the ________ command.- CORRECT ANSWER ✔✔ Save As To tile multiple open worksheets on the screen, use the ________ command.- CORRECT ANSWER ✔✔ Arrange All Use a(n) ________ to apply complex criteria to a single column.- CORRECT ANSWER ✔✔ Custom filter Which of the following are some frequently and commonly used file formats for Excel?- CORRECT ANSWER ✔✔ Excel Template, Excel 97-2003 Workbook, CSV or tab delimited Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row?- CORRECT ANSWER ✔✔ Record Which of the following file formats is commonly used to import data into a database program?- CORRECT ANSWER ✔✔ CSV You can create a custom table style by clicking ________.- CORRECT ANSWER ✔✔ Format as table You can force the data in a worksheet into a selected number of pages by using the ________ command.- CORRECT ANSWER ✔✔ Scaling You can save an Excel file as a text file with which of the following file
Column and row titles that describe the values in the column or row are known as ________.- CORRECT ANSWER ✔✔ labels Column charts present data graphically in ________ columns.- CORRECT ANSWER ✔✔ vertical If you need to make changes to a template after it is protected, you must first remove the ________.- CORRECT ANSWER ✔✔ protection If you try to enter data in a protected cell, a message displays informing you that the cell is protected and therefore ________.- CORRECT ANSWER ✔✔ read-only If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner, you should use ________.- CORRECT ANSWER ✔✔ standardization In order for individuals completing your form to type their data into designated cells, the cells must be ________.- CORRECT ANSWER ✔✔ unlocked Objects that make up a chart are called ________.- CORRECT ANSWER ✔✔ chart elements Sparklines are ________.- CORRECT ANSWER ✔✔ tiny charts that fit within a cell and give a visual trend summary alongside your data Templates can have built-in ________ that display the results of calculations based on the data that is entered into the template.- CORRECT ANSWER ✔✔ formulas The Select locked cells option enables you to click the locked cell and ________ the formulas.- CORRECT ANSWER ✔✔ view The Text Pane displays to the ________ of the SmartArt diagram.- CORRECT ANSWER ✔✔ left
The Text Pane includes ________ in which you can type text into a SmartArt graphic.- CORRECT ANSWER ✔✔ Placeholders The ________ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis.- CORRECT ANSWER ✔✔ scale The area bounded by the axes, including all the data series is called ________.- CORRECT ANSWER ✔✔ plot area The entire chart with all of its elements is called the ________.- CORRECT ANSWER ✔✔ chart area The key that defines the colors assigned to categories in a chart is called a(n) ________.- CORRECT ANSWER ✔✔ legend The two main reasons for creating templates for commonly used forms in an organization are ________.- CORRECT ANSWER ✔✔ standardization and protection To add a shape to a lower level of an organization chart, right-click the shape, click Add Shape, and then click ________.- CORRECT ANSWER ✔✔ Add Shape Below To delete a box from a SmartArt organization chart, a ________ border must display around the box.- CORRECT ANSWER ✔✔ solid line To display trends over time, use a ________ chart.- CORRECT ANSWER ✔✔ line To make comparisons among related data, use a ________ chart.- CORRECT ANSWER ✔✔ column To prevent others from altering the formulas or changing other template components, you should use ________.- CORRECT ANSWER ✔✔ protection When creating a column chart, selecting ________ for the data helps the
