Studied by 266 people

0.0(0)

get a hint

hint

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