CGS2518 Exam One

studied byStudied by 266 people
0.0(0)
get a hint
hint

Workbook

1 / 41

Tags and Description

42 Terms

1

Workbook

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

New cards
2

.xlsx

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

New cards
3

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

New cards
4

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

New cards
5

Range

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

New cards
6

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

New cards
7

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

New cards
8

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)

New cards
9

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

New cards
10

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

New cards
11

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

New cards
12

=

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

New cards
13

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

New cards
14

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

New cards
15

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

New cards
16

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

New cards
17

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

New cards
18

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

New cards
19

Functions

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

New cards
20

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

New cards
21

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

New cards
22

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

New cards
23

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

New cards
24

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

New cards
25

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

New cards
26

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

New cards
27

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

New cards
28

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

New cards
29

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

New cards
30

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

New cards
31

Gradient

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

New cards
32

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

New cards
33

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

New cards
34

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.

New cards
35

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.

New cards
36

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.

New cards
37

Nested

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

New cards
38

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

New cards
39

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

New cards
40

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

New cards
41

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

New cards
42

Statistical

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

New cards

Explore top notes

note Note
studied byStudied by 3 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 13 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 8 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 39 people
Updated ... ago
4.0 Stars(1)
note Note
studied byStudied by 20 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 189 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 13 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 156 people
Updated ... ago
5.0 Stars(1)

Explore top flashcards

flashcards Flashcard51 terms
studied byStudied by 21 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard124 terms
studied byStudied by 20 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard101 terms
studied byStudied by 4 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard55 terms
studied byStudied by 5 people
Updated ... ago
5.0 Stars(2)
flashcards Flashcard170 terms
studied byStudied by 6 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard153 terms
studied byStudied by 16 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard150 terms
studied byStudied by 37 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard50 terms
studied byStudied by 1 person
Updated ... ago
5.0 Stars(1)