Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

busi 520 final > quiz 1 > Flashcards

quiz 1 Flashcards

1
Q

In Excel, what keystroke combination quickly inserts the current time?

A

(Ctrl and semi-colon)

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

In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to the right)?

A

Ctrl+Pg dn

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

When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely saved in either .csv, .xls or .xlsx format.

A

False

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

What (are) last in the order of precedence rules (PEMDAS).

A

Addition and subtraction from left to right

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

A quick way to apply the currency format is to press Ctrl+Shift+$.

A

True

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

If A1=2, then the resulting value of =3+5*A1 is

A

13

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

In Excel, what keystroke combination inserts cells?

A

Ctrl+Shift+plus

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

What keystroke combination switches between currently open workbooks?

A

Ctrl+tab

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

REF! means invalid numerical values in a formula or function.

A

False

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

In Excel, what keystroke combination moves one screen to the right within the current worksheet?

A

Alt+Pg dn

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

COUNT(number1, number 2, …) determines the sum of a list of values.

A

False

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

In Excel, what keystroke combination quickly applies a border around the selected cell or range?

A

Ctrl+Shift+&

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

In Excel, after having copied something, what keystroke combination performs a Paste operation?

A

Ctrl+v

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

In Excel, what keystroke combination quickly applies the number format to two decimal places?

A

Ctrl+Shift+!

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

In Excel, what keystroke combination selects the current row?

A

Shift+space

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

$B1 is an example of a(n) _____ reference.

A

mixed

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

If A1=2, the resulting value of =3*A1^3 is

A

24

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

The error message #NAME? means that there is

A

unrecognized text in a formula

19
Q

In Excel, what keystroke combination quickly inserts the current date?

A

(Ctrl and semi-colon)

20
Q

In Excel, what keystroke combination toggles between displaying formulas and displaying values?

A

Ctrl and left quote.

21
Q

In Excel, what keystroke combination changes the cell reference type (to absolute, mixed, mixed, relative) while entering/editing a formula?

A

F4

22
Q

In Excel, after selecting a range of cells, what keystroke combination deletes those cells? (not just deletes the contents of cells, but deletes the actual cells, so that other cells adjust to replace the deleted cells)

A

Ctrl+minus

23
Q

A quick way to apply the percent format is to press Ctrl+Shift+%.

A

True

24
Q

In Excel, what keystroke combination performs an “undo” of the last action?

A

Ctrl+z

25
Q

If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula?

A

$B$4-SUM(C2:C6)

26
Q

In Excel, what keystroke combination moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values?

A

Ctrl+right arrow

27
Q

In Excel, what keystroke combination shows the format cells dialog window?

A

Ctrl+1

28
Q

In order to maintain consistency within your workbooks, it is important to format cells with formulas (outputs) using the same colors as cells containing assumptions and/or values (inputs).

A

False

29
Q

In Excel, what keystroke combination selects right, to the end of the current row of contiguous (adjacent) cells?

A

Ctrl+Shift+right arrow

30
Q

The COUNTA function ignores cells with text

A

False

31
Q

If multiple horizontal cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of selected cells?

A

Ctrl+r

32
Q

B1 is an example of a _____ cell reference.

A

relative

33
Q

In Excel, after having copied something, what keystroke combination quickly performs a Paste Special operation?

A

Ctrl+Alt+v

34
Q

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is

A

0

35
Q

If multiple cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of selected cells?

A

Ctrl+d

36
Q

In Excel, what keystroke combination quickly applies the General format?

A

(Ctrl, Shift and tilde)

37
Q

The best way to center titles is to use the Merge & Center toolbar/ribbon button.

A

False

38
Q

A workbook’s documentation sheet should always be showing when saving the file a final time (right before submitting the file), so that when someone opens your file, the documentation sheet will be the first sheet seen.

A

True

39
Q

In Excel, what keystroke combination selects the current column?

A

Ctrl+space

40
Q

Using cell references is preferable to directly inputting values into a formula.

A

True

41
Q

The wrong argument type or operand is shown by

A

VALUE!

42
Q

You should always adjust column widths first, before attempting to Wrap Text for the column headings.

A

False

43
Q

The error message ###### means that there is(are)

A

insufficient width in cell to display data, or negative date/time

busi 520 final (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions