Excel Midterm Review Flashcards


Set Details Share
created 7 years ago by Alyssa_Smith
1,716 views
Subjects:
excel
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:

1

A ____ is a prewritten formula that is built into Microsoft Excel

Function

2

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra

Operations

3

Cell References that automatically adjust in a copied and pasted formula are called ____ references

Relative

4

One popular metaphor for visualizing a file system is an upside-down _____

Tree

5

When using the PMT function to calculate monthly loan payments, the interest rate and the number of payments should be based on the interest rate per month and the total ___ to pay off the loan

Months

6

The ___ options button lists error-checking options following the assignment of an invalid formula to a cell

Trace Error

7

The ___ function calculates the interest rate charged or received during each payment period

RATE

8

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range

AVERAGE

9

A table name can include

Numbers, letters, and underscores

10

The ____ function determines the lowest number in the range

MIN

11

You can use the ____ to check which cells are referenced in the formula assigned to the active cell

Range Finder

12

Conditional formats in Excel

Icon sets, cell highlighting, and data bars

13

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent

Accounting number format

14

This part of the Excel screen displays the contents of the active cell

Forumla Address Bar

15

In Excel, _____ view allows you to create or modify a worksheet while viewing how it will look in printed format

Page Layout

16

To start a new line in a cell, press the ____ keys

ALT + ENTER

17

The _____ function calculates the amount paid into an investment or loan during each payment period

PMT

18

In Excel, a cell reference that remains constant when a formula is copied down a column is referred to as an _____ reference

Absolute

19

Excel's ____ view allows you to modify a worksheet's print layout, providing a method to quickly adjust the breaks between pages

Page Break Preview

20

A ______ chart provides a simple way to show trends and variations in a range of data within a single cell

Sparkline

21

You should use a ____ chart to show the relationship or proportion of parts to a whole

Pie

22

A ____ is a separate sheet in a workbook that contains only a chart

Chart Sheet

23

A pie chart with one of more slices offset is called a ___

Exploded Pie Chart

24

If the formula in a cell references a range of cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message

=REF!

25

____ order arranges labels in alphabetical order, from A to Z

Ascending

26

Information created in Excel is saved in a file called a _____

Workbook

27

To deselect a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ___ on the shortcut menu

Ungroup Sheets

28

Which of the following formulas contains an absolute cell reference

=$B$8

29

The ____ function is useful when you want to assign a value to a cell based on a logical test

IF

30

____ refers to cells not wide enough to display the entire numeric entry

#####

31

When you set up an Excel worksheet, you should use cell references in formulas whenever possible, rather than ___ values

Constant

32

_____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell

Goal

33

The ____ function is a logical function that returns a TRUE value if all of the logical conditions are TRUE and a false value if all the logical conditions are false

AND

34

When you retrieve a particular value from a lookup table, the ____ value is the value you are trying to find

Lookup

35

The top level of the file system in PC-nomenclature is known as the _____

Root Directory

36

The default cell format in Excel is ____

General

37

After you filter a column, the ___ Filter command becomes available so you can remove the filter and redisplay all the records

Clear

38

When a worksheet group is selected, the ___ includes text to indicate the sheets are in fact grouped

Title Bar

39

The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE

OR

40

When Excel automatically fills the rest of a table column with a formula entered into an empty table column, this is referred to as a ____ column

Calculated

41

Microsoft Excel's Goal Seek changes the ____ values to produce the resulting values you seek to determine

Input

42

One way to display formulas in Excel is by pressing this key combination

Ctrl + `

43

The COUNT function _____

Counts the number of cells that contain numbers within the selected range

44

When copying or moving cells, if data already exists in the destination cells, Excel ___

Replaces the contents

45

This type of excel chart is used to depict trends and change over time intervals

Line

46

This part of the excel screen displays the cell reference of the active cell

Name Box

47

By default, files created with Excel 2013 are saved with the ____ extension

.xlsx

48

A _____ is a group of adjacent cells in an Excel worksheet

Range

49

Which of the following chart types is characterized as always having one data series?

Pie

50

There are 3 general types of cell entries that a user can enter into the cells of an Excel worksheet. These include: texts, numbers, and _____

Formulas