Excel Flashcards

1
Q

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

a. database
c. expression
b. spreadsheet
d. formula

A

spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

a. KeyTips
c. ShortTips
b. ScreenTips
d. shortcuts

A

shortcuts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

a. Touch Mode
c. Tap Mode
b. Click Mode
d. Normal Mode

A

touch mode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

“AZ” is an example of a ____.

a. column heading
c. cell reference
b. row heading
d. Name box

A

column heading

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

To go to column A of the current row, press ____.

a. Ctrl + Home
c. Shift + Tab
b. Home
d. Tab + Enter

A

home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

An Excel worksheet can have a maximum of ____ columns in a worksheet.

a. 156
c. 16,384
b. 256
d. 17 million

A

16384

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

To make A1 the active cell, you should press which of the following keys?

a. Page Up
c. Home
b. Page Down
d. Ctrl + Home

A

ctrl + home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You can move to the previous or next sheet by pressing the ____ keys.

a. Alt + Page Up or Alt + Page Down
c. Tab + Page Up or Tab + Page Down
b. Ctrl + Page Up or Ctrl + Page Down
d. F4 + Page Up or F4 + Page Down

A

Ctrl + Page Up or Ctrl + Page Down

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

a. semi-colon
c. colon
b. period
d. comma

A

colon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The characters +, -, *, and / are examples of ____.

a. formulas
c. arithmetic operators
b. values
d. calculations

A

arithmetic operators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

An Excel formula always begins with a(n) ____.

a. parentheses
c. plus sign
b. equals sign
d. colon

A

equal sign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The formula used to multiply cell A1 by cell C1 is ____.

a. =A1C1
c. =A1/C1
b. C1
A1
d. A1*C1

A

=A1*C1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A(n) ____ is a group of cells in a rectangular block.

a. cluster
c. selection
b. adjunct
d. range

A

range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

In the figure above, Box 1 points to the formula =F13*G13 in the ____.

a. address box
c. formula box
b. address bar
d. formula bar

A

formula bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

In the figure above Box 3, points to color coded ____ references.

a. cell
c. row
b. formula
d. function

A

cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

In the figure above, Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

a. cell F13
c. cell G13
b. cell H13
d. cell H13

A

cell H13

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

a. right
c. down
b. up
d. left

A

right

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

a. Ctrl + Enter
c. Alt + E
b. Alt + Enter
d. Ctrl + E

A

Alt + Enter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is the result of the expression =50+20/10*5?

a. 60
c. 25
b. 1
d. 50

A

60

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

To change the order of operations, enclose part of the formula in ____.

a. brackets
c. parentheses
b. italics
d. quotation marks

A

parentheses

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

a. color coding
c. highlighting
b. bolding
d. italicizing

A

color coding

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

To switch to ____ mode, you double-click the cell.

a. Insert
c. Edit
b. Copy
d. Paste

A

edit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

a. QuickFit
c. Full Column
b. AutoFit
d. Longest

A

autofit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

____ makes it easier to enter repetitive text in cells.

a. Editing mode
c. AutoComplete
b. AutoFit
d. AutoFill

A

auto complete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Which of the following takes precedence over multiplication?

a. division
c. addition
b. exponentiation
d. subtraction

A

exponentiation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

____ enters text based on patterns it finds in the data.

a. AutoComplete
c. AutoFit
b. Flash Fill
d. Fill

A

flash fill

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

In ____ orientation, a page is taller than it is wide.

a. natural
c. portrait
b. landscape
d. basic

A

portrait

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

____ displays the location of the different page breaks within the worksheet.

a. Normal
c. Page Break Preview
b. Page Preview
d. Page Break Layout

A

page break preview

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

a. shrink
c. scale
b. size
d. scroll

A

scale

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

according to the order of operation in Excel:

a. Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
b. Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.
c. Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.
d. Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

A

Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

To move the active cell up one row, press ____.

a. Shift + Enter
c. Shift + Tab
b. Ctrl + Tab
d. Ctrl + Enter

A

shift enter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Which of the following will not change the location of the active cell?

a. drag and drop
c. clicking another cell
b. scrolling
d. clicking a column heading

A

scrolling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

a. an outline of the new location of the selected range
b. the range
c. a cell reference of the old location
d. shortcut tip

A

an outline of the new location of the selected range

34
Q

hat is the syntax for a SUM formula adding the values of cell F6 to F9?

a. /SUM(F9:F6)
c. =END(F6:F9)
b. =SUM(F6/F9)
d. =SUM(F6:F9)

A

=SUM(F6:F9)

35
Q

Ctrl + G is used to access the ____.

a. Go to Next worksheet command
b. G column
c. Go to a location in the worksheet command
d. formula view

A

Go to a location in the worksheet command

36
Q

mm/dd/yyyy is known as ____.

a. a text string
c. a date format
b. text data
d. number data

A

a date format

37
Q

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

a. Ctrl + V
c. Ctrl + C
b. Ctrl + G
d. Ctrl + S

A

Ctrl + S

38
Q

To move or copy a range of cells, select the correct order:

  1. Move the pointer over the border of the selection until the pointer changes shape.
  2. Select the cell or range you want to move or copy.
  3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

a. 1,2,3
c. 1,3,2
b. 3,2,1
d. 2,1,3

A

2,1,3

39
Q

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

A

cube

40
Q

The ____ category of Excel functions returns (true-false) values

a. Information
c. Logical
b. Statistical
d. Math & Trig

A

logical

41
Q

Which of the following is a Statistical function?

a. INT
c. ROUND
b. RAND
d. AVERAGE

A

AVERAGE

42
Q

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

a. Location
c. Reference
b. Information
d. Description

A

information

43
Q

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

a. Go
c. Insert
b. Select
d. Next

A

go

44
Q

The numbers, text, or cell references used by the function to return a value are called ____.

a. expressions
c. data
b. arguments
d. values

A

arguments

45
Q

Which of the following is a Math & Trig function? ____

a. INT
c. MIN
b. COUNT
d. AVERAGE

A

INT

46
Q

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

a. complex
c. absolute
b. logical
d. nested

A

nested

47
Q

Referring to the figure above, the last entry shown in Column K is 644.7953813. There is a black “plus sign” on the lower right edge of the cell that is the ____.

a. fill handle
c. formula finder
b. Auto Fill Options button
d. function finder

A

fill handle

48
Q

Referring to the figure above, the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

a. fill handle
c. formula finder
b. Auto Fill Options button
d. function finder

A

Auto Fill Options button

49
Q

Referring to the figure above, which number represents the COUNT function?

a. 1
c. 3
b. 2
d. 4

A

2

50
Q

Referring to the figure above, which number refers difference between the scheduled and
attended workouts.

a. 1
c. 3
b. 2
d. 4

A

4

51
Q

In the following formula: =IF(A1=”YES”, “DONE”, “RESTART”), what happens if A1= “NO”?

a. The formula returns the text “RESTART”.
b. The formula returns the text “DONE”.
c. The formula returns the text “NO”.
d. The formula returns the text “NO, RESTART”.

A

The formula returns the text “RESTART”.

52
Q

Which of the following is not a date function? ____

a. YEAR
c. AND
b. NOW
d. TODAY

A

AND

53
Q

The ____ function returns the maximum value in the range.

a. TOP
c. MAX
b. FIRST
d. MOST

A

MAX

54
Q

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

a. cell
c. absolute
b. relative
d. formula

A

relative

55
Q

Absolute references are marked with a ____.

a. <
c. $
b. :
d. !

A

$

56
Q

When you copy a formula that contains an absolute reference to a new location, the reference ____.

a. is updated automatically
c. becomes bold
b. does not change
d. has a dotted outline in its cell

A

does not change

57
Q

Use ____ references when you want different formulas to refer to the same cell.

a. mixed
c. absolute
b. relative
d. fixed

A

absolute

58
Q

Another name for the middle value is the ____ value.

a. mode
c. median
b. center
d. relative

A

median

59
Q

____ arguments may provide more control over the returned value.

a. Relative
c. Optional
b. Required
d. Absolute

A

optional

60
Q

FUNCTION(argument1, argument2, …) is ____.

a. the syntax of writing optional arguments
b. an example of a formula
c. the general syntax of all functions
d. the general syntax of all formulas

A

the general syntax of all functions

61
Q

If an optional argument is not included, Excel assumes a(n) ____ value for it.

a. default
c. static
b. generic
d. absolute

A

default

62
Q

Excel functions are organized into ____ categories.

a. 8
c. 11
b. 10
d. 12

A

12

63
Q

Which of the following is not an Excel function category? ____

a. Math & Trig
c. Statistical
b. Algebra
d. Text

A

algebra

64
Q

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

a. SUM
c. COUNTA
b. COUNT
d. AUTOSUM

A

COUNT

65
Q

In “SUM(number1 [, number2, number3, …])”, number 1, number 2, and number 3 may be numbers or ____.

a. letters
c. symbols
b. cell references
d. operators

A

cell references

66
Q

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

a. Location
c. Reference
b. Information
d. Description

A

Information

67
Q

In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

a. The average of the values in the range A1:A100 is added to the integer.
b. The average of the integer value is calculated.
c. The average of the values in the range A1:A100 is calculated.
d. The integer portion of the value is extracted.

A

The average of the values in the range A1:A100 is calculated.

68
Q

When you nest functions, you should have ____.

a. the equal sign
b. the same number of left and right parentheses
c. at least two functions
d. the correct number of brackets

A

the same number of left and right parentheses

69
Q

The Insert Function button is in the ____ group.

a. Calculation
c. Sort & Filter
b. Function Library
d. Home

A

function library

70
Q

The Insert Function dialog box has a(n) ____ option.

a. search
c. find and replace
b. formatting
d. expand/collapse

A

search

71
Q

The fill handle copies ____.

a. content only
c. content and formats
b. formats only
d. formats and cell references

A

content and formats

72
Q

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.

a. functions
c. cell references
b. content
d. left-aligns

A

content

73
Q

Using AutoFill, what would be the extended series of the initial entry Jan? ___

a. uary
c. Kan, Lan, Man, Nan
b. Feb, Mar, Apr
d. Jan1, Jan2, Jan3,

A

Feb, Mar, Apr

74
Q

A logical function is a function that works with values that are either ____.

a. right or wrong
c. positive or negative
b. absolute or relative
d. true or false

A

true or false

75
Q

In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.

a. A is equal to B
c. A1+B1 is equal to C1
b. A does not equal B
d. A1>B1 is equal to C2

A

A does not equal B

76
Q

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

a. Absolute
c. Mixed
b. Relative
d. Matched

A

mixed

77
Q

=IF(G22= ”x ”, SUM(H22:J22), “ ”) with display ______ if G22 is not equal to “x”.

a. a blank cell
c. dashes
b. the result of the SUM
d. False

A

a blank cell

78
Q

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

a. Sum
c. Lookup
b. Average
d. Find

A

lookup

79
Q

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

a. #VALUE
c. #ERROR
b. #N/A
d. #NULL

A

N/A

80
Q

One way to perform a _________ is by changing one or more of the input values
to see how they affect the calculated results.

a. goal seek
c. search
b. function
d. what-if analysis

A

what-if analysis