Lynda.com- Excel Essential Training (Office 365) Flashcards

Learn to create spreadsheets to use for estimating pipe organ projects.

1
Q

What is the menu system referred to as?

A

The ribbon.

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

How do you add items to Quick Access menu?

A

Click on an icon with a right click.

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

What is context sensitivity?

A

Use right click on the mouse to bring up context specific menus for different cells.

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

Can you right click on the left hand most column? (row numbers)

A

Yes, and you get a context specific menu with commands useful to that row.

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

Why is right click useful in Excel?

A

It puts menus close to where the action is, and means you do not have to go to the tool bar looking for commands.

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

Can you right click on an icon in the tool bar or the ribbon?

A

Yes, and you will receive more context.

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

Is a file a workbook.

A

Yes, a file is a workbook and a workbook is a file.

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

How are rows and columns identified?

A

Rows are identified by numbers and columns are identified by letters.

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

How do you return to row 1 and column A?

A

Hit Function Key and Left Arrow

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

What is the main box?

A

The Main Box indicates the cell you have highlighted or are working on.

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

Can a workbook have multiple sheets?

A

Yes

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

How can you use buttons to ask for help?

A

Slide over the button with the mouse and an explanation will arise.

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

Why does the menu bar remain in Excel?

A

It is a Mac standard.

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

What is the Excel Ribbon?

A

This is the Excel specific menu bar of tools. It is the user interface. You can view program capabilities without opening menus.

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

Where is the Auto Save feature in Excel?

A

Top left hand corner button.

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

Where is the worksheet search box?

A

Top right hand corner.

17
Q

Where and what is the Collapses Ribbon Button?

A

Top right hand corner. The small carrot button ^, collapses or expands the Excel Ribbon of tools.

18
Q

Where is the Screen Zoom Control?

A

Lower right corner