CGS2518 Exam One

Workbook

Workbook

In Microsoft Excel, the file you create and edit is called a: a) Form b) Ledger c) Table d) Workbook e) Record

.xlsx

By default, Excel 2019 files are saved with this extension a) .xls b) .xlsx c) .csv d) .xbk e) .ods

name box

When you click on a cell to activate it, the cell address appears in the: a. formula window b. name box c. task bar d. dropdown menu e. comment bubble

Backspace

When you want to delete characters in a cell to the left of the insertion point press: a. Delete b. Enter c. Edit d. Backspace e. End

Range

A rectangular group of cells in Excel is called a(n): a. Column b. Display c. Selection d. Object e. Range

Press Ctrl+A

To quickly select all the cells in a worksheet: a. Double-click b. Right-click c. Press Ctrl+A d. Press Enter e. Click on the first column heading

On the Clipboard

After you select and cut cells, the cells are temporarily placed: a. On the Clipboard b. In the address window c. In the context menu d. In the Formula bar e. On the Home tab window

Values

In an Excel worksheet dates and times are: a. Labels (chunks of text) b. Decimals (e.g. 0.125) c. Values (e.g. 43565.125) d. Formats (e.g. MM/dd/yyyy mm:ss) e. Series (e.g. 1)

Freeze Panes

When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select: a. A filter b. Freeze Panes c. Split Window d. Zoom to selection e. Splitter bar

Merge and Center

Use this button to combine two or more cells into one cell and center the text over a group of columns. a. Combine Elements b. Format Title Cells c. Group and Merge d. Merge and Center e. Increase Indent

Formulas

This Excel feature allows users to use common arithmetic operations to perform a calculation: a. Formulas b. Formatting c. Filters d. Insertions e. Components

=

This symbol alerts Excel that you are entering a formula and not text: a. * b. $ c. = d. # e. ^t

An error message that begins with a number sign (#)

When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns: a. An error message that begins with an exclamation point (!) b. A blank cell c. An error message that begins with a number sign (#) d. A green alert e. A red alert

Evaluate Formula

The Excel tool button that allows you to step through each part of a formula is called: a. Trace Precedents b. Trace Dependents c. Error Checking d. Evaluate Formula e. Watch Window

Relative

When you are creating formulas using a cell location, the default cell reference is: a. Relative b. Absolute c. Constant d. Fixed e. Mixed

Absolute

This type of cell reference does not change when copied and remains in a fixed position during operations: a. Relative b. Absolute c. Constant d. Fixed e. Mixed

F4

A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is: a. F1 b. F5 c. ^$ d. Ctrl+* e. F4

Items in parentheses

It is important to remember that Excel calculates these operations before any others are performed: a. Exponents b. Items in parentheses c. Mathematical expressions d. Fixed cell references e. Mixed cell references

Functions

Excel comes with many built-in formulas called: a. Formulas b. Factors c. Functions d. Operations e. Calculations

AutoCalculate

This Excel feature allows you to view totals, averages, or other statistical information without creating a formula: a. AutoCalculate b. AutoSum c. AutoCount d. AutoFunction e. AutoRun

PMT

This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate: a. STDEV b. AMORLINK c. PMT d. PERCLOAN e. PAYPCT

IF

This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false: a. COUNT b. LOOKUP c. HLOOKUP d. IF e. EVAL

3D cell reference

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a: a. 3D cell reference b. Link c. LOOKUP d. Relative cell reference e. FINDIF

Chart

When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate: a. Report b. Chart c. Timeline d. Data layout e. Slide

Category label

The text label that describes each data series in a chart is called the: a. Chart object b. Field name c. Category label d. Selectable component e. Source label

On the horizontal axis

In a histogram chart, the category labels are shown: a. On the horizontal axis b. On the vertical axis c. In the chart legend d. In the chart title e. On both axes

Chart sheet

An Excel chart that is displayed on its own sheet in the workbook is called a: a. Standalone b. Graphic element c. Chart sheet d. Diagram e. Schematic

Format tab

To apply changes to your chart Shape Fill, Shape Outline, or Shape Effects separately, use the: a. Format tab b. Element pane c. WordArt d. Chart type e. Character tab

Pie chart

The type of chart that shows percentages of a whole and has no axes is a: a. Line graph b. Pie chart c. Percentage chart d. Bar graph e. Sheet chart

Trendline

The Excel chart element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the: a. Legend b. Tick mark c. Trendline d. Gridline e. Chart analyzer

Gradient

A variegated blend of colors in a chart element is called a: a. Shadow b. Tint c. Gradient d. Blended fill e. Saturation

Combination chart

A chart that includes two chart types such as a line chart and a column chart is referred to as a: a. Mixed display b. Dual data display c. Radar chart d. Combination chart e. Custom chart

Sparkline

A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is called a/an: a. Sparkline b. Forecast point c. Predictor d. MiniChart e. Conditional chart

COUNTIFS.

The Statistical function that does computations only after data meets multiple criteria is: a. STDEV.S. b. COUNTIFS. c. ROUND. d. STDEV.P. e. RANK.EQ.

SUMIFS

The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is: a. AVERAGEIFS. b. COUNTIFS. c. ROUNDIF. d. SUMIFS. e. RANK.EQ.

True

In an OR function, if any one of the arguments is true, the result is: a. Logical. b. False. c. Inconclusive. d. Circular. e. True.

Nested

A function within a function is described as: a. Complex. b. Dependent. c. Secondary. d. Parenthetical. e. Nested.

INDEX

This function displays the contents of the cell at the intersection of an identified column and row: a. INTERSECT b. ADDRESS c. INDEX d. AUTOFIND e. AGGREGATE

Array

A range of cells that you select in which to apply a function is called a(n): a. Objective. b. Function range. c. Target. d. Array. e. Grid

Text

Which type of function would you use to format a value as a label? a. Logical b. Text c. Financial d. Math & Trig e. Lookup and Reference

TEXTJOIN

What text function that includes a delimiter argument allows you to join or combine strings of text? a. CONCAT b. TEXTJOIN c. EXACT d. REPLACE e. TRIM

Statistical

The Standard Deviation functions are found in this category: a. Financial. b. Logical. c. Text. d. Math & Trig. e. Statistical.