Excel Test Review Flashcards

1
Q

New workbooks typically contain how many worksheets?

A

1

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

What is the small green square in the bottom right of a cell called?

A

The fill handle

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

What should you do if there are columns you need but don’t want to display

A

Hide the columns

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

What does it mean when you see ##### in a cell

A

Your columns are not wide enough

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

the range is specified by

A

Top left and bottom right cells

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

What is not one of the tabs in excel

A

Mailings

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

Where can you find more alignment options

A

the format alignment dialogue box

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

The default number format is

A

General

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

What is the best way to make sure your worksheet prints on only one page

A

Use the fit to option (found in backstage print options)

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

What does pressing the enter key while in a cell do

A

The value is set, and the cell below becomes the active cell

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

What can you not do directly from backstage print screen view

A

Switch to formula view and print formulas

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

What’s the best practice for centering a column over multiple columns

A

Use the merge and center alignment

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

Which of the following is not considered an excel element

A

Print Preview

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

Which of the following is not a way to widen a column

A

In the page layout tab, scale to fit group select automatic in width drop down box

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

What paste option would you choose if you wanted to maintain the formatting of the copied cell but not its contents

A

Formatting

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

How is text aligned by default

A

Left (numeric to right)

17
Q

T or F: Its acceptable to use values in formulas if you know those values will never change

A

T

18
Q

T or F: You can select a range by using a name box

A

T

19
Q

T or F: You can move a range by using cut and paste commands

A

T

20
Q

T or F: When you copy and paste a range the relative references does not change

A

F

21
Q

T or F: Displaying cell formulas can help you find errors in the cell formulas more easily

A

T

22
Q

T or F: The fill handle allows you to copy paste formulas to adjacent cells

A

T

23
Q

T or F: There are only 4 different paste options in excel

A

F