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 Study Guide
A chart value that originates in a worksheet cell is referred to as ________. a data point A defined set of formatting characteristics such as font, font size, and font color are known as a ________. cell style A text value in Excel is also referred to as a ________. label All formulas begin with an ________. = Comma Style format displays a number with ________. two decimal places Hold down the ________ key to select nonadjacent cells. Ctrl In Excel 2016, row headings are identified by ________. numbers The Percent Style button formats selected cells as a percentage with ________. zero decimal places The ________ displays the current cell mode, the page number, and the zoom buttons. status bar The default number format for cells is the ________ number format. General The keyboard shortcut to display Print Preview is ________. Ctrl + F The value axis is also known as the ________. y-axis Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________. Sparklines
To display the document properties, click the ________ tab. File Using a touchscreen, which of the following actions is the same as right clicking the mouse? Press and hold for a few seconds What are the two contextual tabs that display under Chart Tools when a chart is selected? Format and Design When a cell is part of an active formula, it is surrounded with ________. 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. vertical dotted line between columns When using a touchscreen, which of the following actions is the same as clicking an item? Tap the item When you type data in a cell and press Enter, what cell becomes the active cell? The cell below When you type text in a cell it is ________. left-aligned Where is the fill handle located? In the lower right corner of a selected cell Which of the following does not display to the right side of a selected chart? Move Chart button Which of the following is FALSE about a workbook? It can contain only one worksheet. Which of the following is NOT a way to create a formula? By using a Function button on the status bar Which of the following is NOT one of the default calculations displayed by Auto Calculate? Maximum Which of the following is NOT part of the Accounting Number Format? Three decimal places Which of the following is the default number format in Excel 2016?
The quickest way to repeat an action in Excel is the ________ function key. F To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ________. red diamond What are the default names of worksheets? Sheet1, Sheet2, etc. What does a data bar in a cell represent? The value of a cell relative to other cells What is a pane bounded by? Vertical or Horizontal bars What is a summary sheet? A worksheet where totals from other worksheets are displayed What is an Excel table? 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? Ctrl + E When formatting a worksheet to be printed, ________ show where page breaks are located. dotted lines Where do sheet tabs display in a workbook? Lower area of the workbook window Where does Excel's NOW function retrieve the date from? The computer's clock Which of the following Excel features recognizes a pattern in the data of a worksheet? Flash Fill Which of the following is FALSE about the NOW function? It remains constant even when the workbook is opened. Which of the following is FALSE about worksheet tabs? The active worksheet tab displays in red font.
Which of the following is NOT a way to insert the SUM function into a cell? Ctrl + = A ________ in a pie chart identifies the pie slices. data label A chart and all of its elements is known as the ________. chart area A(n) ________ refers to a cell by its fixed position in the worksheet. absolute cell reference AutoFill will fill a series when you establish a pattern ________. with two or more cells How can you identify the Chart Elements button when you select a chart? It is a green plus sign. If you edit data in a worksheet that is associated with a pie chart ________. the pie slices will be automatically updated In Goal Seek, the ________ box contains the formula that calculates the information you seek. Set cell In Goal Seek, you enter the specific value that you want to achieve in the ________ box. To value In a line chart, which of the following resides along the bottom of the chart? The x-axis The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________. what-if analysis To size a chart proportionately, hold down the ________ key and ________. Shift; drag a corner sizing handle To what extent can a pie chart be rotated? Up to 360 degrees Use the ________ key to select A5:A8 and D5:D8. Ctrl
A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________. Trace Precedents command A data tables is useful for all of the following except for ________. determining the Future value (Fv) A defined name provides a logical reference to ________. Data A method to find a specific value for a cell by adjusting the value of one other cell is ________. 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) ________. 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 ________. 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 ________. defined name All of the following are methods to define a name for a cell or group of cells except: ________. 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. VLOOKUP An advantage to naming a range of cells is that you can use the name in a ________. Formula An indicator that shows the relationship between the active cell and its related cell is called a(n) ________. tracer arrow Apply styles to cells, such as Headings and Titles and Data and Model, by using the ________ command in the Styles group. Cell Styles Cells that are referred to by a formula in another cell are called ________. precedent cells Defined names can contain ________.
uppercase and lowercase letters Each of the following is a rule for defining names except: ________. Defined names can contain spaces. Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages. relationships For lookup functions to work properly, the data in the table array must be sorted ________. in ascending order In a cell that contains a function, to copy the VALUE to another to cell—rather than the function—use the ________. Paste Special command to display commands for Paste Values In a lookup formula, the defined range is referred to as the ________. table array In the Data Validation dialog box, you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data. ScreenTip In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________. rate The Error Checking button displays as a ________. yellow diamond The Future value (Fv) at the end of the time period in an Excel function is usually ________ for loans. zero The ________ command checks for common errors that occur when using formulas. Error Checking The ________ function looks up values in a table array arranged in horizontal rows. HLOOKUP The amount charged for the use of borrowed money is called ________. interest The location within which a defined name is recognized without qualification is referred to as the ________. scope
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) ________. Cell Style A hyperlink in a worksheet may take you to which of the following locations ________. 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 ________. theme A series of rows that contains related data is known as a ________. List A theme combines font sets for ________. text and headings An organized collection of facts related to a specific topic is known as a ________. database Before printing or distributing a large worksheet, the Print Preview option enables you to see ________. orientation and page breaks By default, Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file extension ________. .xlsx Clicking a ________ will take you to another location in the worksheet, another file location, a webpage on the intranet, or to your organization's Internet. hyperlink Fonts are associated with different themes and can be customized by ________. mixing Colors and Fonts from any of the supplied themes Hyperlinks can be attached to which of the following items? Text and Graphics If the file to which a hyperlink refers to is moved or renamed, or a webpage to which a hyperlink refers has a new address, which of the following do you need to do to the hyperlink to make it work correctly? Modify the hyperlink to reflect the change If you want every one of the comparison criteria that you specify to be true, you would use the ________.
And comparison operator Instead of displaying a filtered list, you can copy the results of a filter to another area of your worksheet for comparison purposes; this action is known as ________. Extracting Saving an Excel worksheet as a CSV file separates the cells of each row with ________. commas Saving an Excel worksheet as a ________ separates the cells of each row with tab characters. tab delimited text file Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify. horizontal and vertical Subtotaled rows that are totaled and summarized are referred to as ________ data. detail The Page Break view shows where the page breaks will occur by displaying ________. 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. 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. field The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click. 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 ________. panes To apply complex criteria to a single column, use a(n) ________. 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? Freeze Panes
Chart A ________ is a graphic representation of trends in a data series. Trendline A ________ is a visual representation of information and ideas. SmartArt graphic A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________. embedded A group of related data plotted in a chart is called a data ________. series After text is entered and formatted in your template, add ________ to the cells where you want the result of the calculations to display. formulas An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called ________. Recommended Charts An organization chart depicts ________ within an organization. Reporting Relationships Charts can be placed on a separate sheet called a ________. chart sheet Column and row titles that describe the values in the column or row are known as ________. labels Column charts present data graphically in ________ columns. vertical If you need to make changes to a template after it is protected, you must first remove the ________. protection If you try to enter data in a protected cell, a message displays informing you that the cell is protected and therefore ________. 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 ________.
standardization In order for individuals completing your form to type their data into designated cells, the cells must be ________. unlocked Objects that make up a chart are called ________. chart elements Sparklines are ________. 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. formulas The Select locked cells option enables you to click the locked cell and ________ the formulas. view The Text Pane displays to the ________ of the SmartArt diagram. left The Text Pane includes ________ in which you can type text into a SmartArt graphic. Placeholders The ________ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis. scale The area bounded by the axes, including all the data series is called ________. plot area The entire chart with all of its elements is called the ________. chart area The key that defines the colors assigned to categories in a chart is called a(n) ________. legend The two main reasons for creating templates for commonly used forms in an organization are ________. 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 ________.
