Vocab for Computer Applications

The type of cell reference that refers to cells by their fixed position in a worksheet is:

A. Absolute B. Relative C. Exponentiation A. Absolute

A cell surrounded by a black border and ready to receive data is the:

A. Active cell B. Address cell C. Reference cell A. Active cell

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:

A. AutoComplete B. AutoFill C. Fill handle B. AutoFill

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

A. AutoFit B. Quick Analysis tool C. Range finder A. AutoFit

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

A. AutoFit B. Quick Analysis tool C. Range finder B. Quick Analysis tool

A feature that outlines cells in color to indicate which cells are used in a formula is called:

A. AutoFit B. Quick Analysis tool C. Range finder C. Range finder

The default format that Excel applies to numbers is the:

A. Comma format B. Accounting format C. General format C. General format

The data that displays in the Formula Bar is referred to as the:

A. Constant value B. Formula C. Underlying value C. Underlying value

The function that retrieves and then displays the date and time from your computer is the:

A. DATE function B. NOW function C. CALENDAR function B. NOW function

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

A. Data bar B. Detail bar C. Filter A. Data bar

The labels along the lower border of the workbook window that identify each worksheet are the:

A. Data bars B. Sheet tabs C. Detail sheets B. Sheet tabs

The area along the bottom of a chart that identifies the categories of data is the:

A. Data point B. Value axis C. Category axis C. Category axis

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

A. Embedded charts B. Sparklines C. Chart styles B. Sparklines

A series of rows and columns that contains related data and that is managed independently from other data is an Excel:

A. Excel table B. Pane C. Detail sheet A. Excel table

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

A. Filtering B. Sorting C. Scaling A. Filtering

The process if arranging data in a specific order based on the value in each field is called:

A. Filtering B. Sorting C. Scaling B. Sorting

A command that joins selected cells in worksheet into one larger cell and centers the contents in the merged cell:

A. Middle Align B. Merge & Center C. Center B. Merge & Center

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

A. Name box B. Select all box C. Split box B. Select all box

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:

A. Name box B. Status bar C. Formula bar A. Name box

An element in the excel window that displays the value or formula contained in the active cell is the:

A. Name box B. Status bar C. Formula bar C. Formula bar

The Excel command that enables you to specify rows and columns to repeat on each printed page is:

A. Navigate B. Print tiles C. Conditional format B. Print tiles

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

A. Pixels B. Operators C. Data points B. Operators

A worksheet where totals from other worksheets are displayed and summarized is a:

A. Summary sheets B. Detail sheets C. Table A. Summary sheets

The worksheets that contain the details of the information summarized on a summary sheet are called:

A. Summary sheets B. Detail sheets C. Tables B. Detail sheets

The process of moving within a worksheet or workbook:

A. filter B. Sort C. Navigate C. Navigate