Search Header Logo
MS EXCEL

MS EXCEL

Assessment

Presentation

Computers

University

Practice Problem

Medium

Created by

Yolande Cole

Used 29+ times

FREE Resource

39 Slides • 24 Questions

1

MS EXCEL

Welcome to Excel!

Slide image

2

Slide image

3

4

Slide image

5

Slide image

6

Multiple Choice

Excel file is saved as a ____________

1

Document

2

workbook

3

worksheets

4

Presentation

7

Slide image

8

Multiple Choice

The entry bar is also known as (AKA):
1
name box
2
formula bar
3
status bar
4
none of the above

9

Slide image

10

Multiple Choice

When you insert a row, where does Excel place it in relation to the cursor position?

1

Above the current row.

2

You must copy and paste any existing data down one row to have a blank row at the cursor position.

11

Multiple Choice

Question image
This is a:
1
ribbon
2
group
3
tab
4
none of the above

12

Multiple Choice

Question image
This is the:
1
tab
2
title bar
3
group
4
none of the above

13

Multiple Choice

Question image

What is the name of the cell that is colored blue?

1

A

2

B

3

2B

4

B2

14

Multiple Choice

Which is a formula using MS Excel using addition.

1

2 + 3 =

2

= A + B

3

=A2+B3

4

A2+B3

15

Multiple Choice

Question image
The Quick Access Toolbar is:
1
customizable
2
found at the bottom of the screen
3
found on the right side of the screen
4
none of the above

16

Multiple Choice

What is the symbol for division when using MS EXCEL.

1

/

2

+

3

*

4

-

17

Multiple Choice

How are ROWS in MS EXCEL spreadsheet named?

1

numbers

2

letters

3

cells

4

columns

18

Multiple Choice

Which is NOT a term used in Excel?

1

Workbook

2

Worksheet

3

Cell

4

Document

19

Multiple Choice

A program using a table comprising of rows, columns and cells.

1

MS Word

2

MS PowerPoint

3

MS Outlook

4

MS Excel

20

Multiple Choice

Which new workbook option displays the title, Book1, when it is created?

1

A blank workbook.

2

A workbook created from a template.

21

Multiple Choice

Why would you enter labels into the worksheet?

1

Labels should be used when you need to enter text only.

2

Labels are entered for report titles or column headings only.

3

Labels identify the values and help outline the mathematical relationships.

4

d.Labels identify where and how the values should appear.

22

Slide image

23

Multiple Choice

What does every formula in MS EXCEL start with?

1

+

2

-

3

=

4

*

24

Multiple Choice

To select an entire row, where would you click?

1

The cell in column A for that row.

2

Click the row header for the row you want to select.

3

Click the column header where your cell is in the row you want to select.

4

Click the row number in the Name Box and press ENTER.

25

Multiple Choice

What is an EXCEL Spreadsheet used to make?

1

Calendar

2

Publisher

3

Graph

4

Card

26

Slide image

27

Multiple Choice

Which key can you press to activate the Go To command?

1

F1

2

CTRL+H

3

Ctrl+G

4

F6

28

Slide image

29

Multiple Choice

How is the COLUMN in a MS Excel Spreadsheet named?

1

Numbers

2

Letters

3

Cells

4

Columns

30

Slide image

31

Multiple Choice

A program using a table comprising of rows, columns and cells.

1

MS Word

2

MS PowerPoint

3

MS Outlook

4

MS Excel

32

Slide image

33

Slide image

34

Slide image

35

Multiple Choice

Can be used travel from cell to cell in a spreadsheet:
1
tab
2
enter
3
arrow keys
4
all of the above

36

Slide image

37

Multiple Choice

What is the difference between a workbook and a worksheet?

1

A workbook is the actual file that contains the worksheets, which turn contain the data.

2

A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

38

Slide image

39

Multiple Choice

What displays when you activate the Cut or Copy command?

1

A dialog box appears prompting you to proceed with the command.

2

A marquee appears around the selected cells for the Cut or Copy command.

40

Slide image

41

Slide image

42

Slide image

43

Multiple Choice

Which is the best way to set a column to a specific width?

1

On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement.

2

Press CTRL+W to specify the width for the column.

44

Slide image

45

Slide image

46

Slide image

47

Slide image

48

Slide image

49

Slide image

50

Slide image

51

Slide image

52

Slide image

53

Slide image

54

Slide image

55

Slide image

56

Slide image

57

Slide image

58

Slide image

59

Slide image

60

Slide image

61

Slide image

62

Slide image

63

Slide image

MS EXCEL

Welcome to Excel!

Slide image

Show answer

Auto Play

Slide 1 / 63

SLIDE