microsoft excel final exam - robert j. varholak...

Bucktail High School

Computer Skills 1: 8(A‑F)

Microsoft Excel Final Exam

Due Date: January 15, 2016

Instructors:

ID: 8384

Name: Score: / 100

/2Question 1

A _____________ is the intersection point of a column and a row.

Row

Cell

Column

/2Question 2

Columns are identi�ied by a _______________ .

Numbers

Words

Letters

/2Question 3

When you print a spreadsheet where could you put your name, where you do not seeit on the sheet until you print it? (You put your name here on every activity that we did)

Filter

Headers

Data Validation

Freeze Panes

ID: 8384 Due Date: January 15, 2016

Name:

/2Question 4

You cannot insert comments on each cell.

True

False

/2Question 5

These run horizontally across the top of your spreadsheet and are represented by letters:

Columns

Cursors

Landscapes

Rows

/2Question 6

What function allows you to see the average of all the content in the range of cells?

=Sum()

=Count()

=Average()

=If()


Name:

/2Question 7

Every formula begins with an ____________.

comma

plus sin

equal sin

parentheses

/2Question 8

All functions have arguments. There are no functions which work without providingthem arguments or ranges of cells.

True

False

/2Question 9

In the following formula: =Count(A1:G10), what happens when you hit enter?

Formula returns a number counted from the range A1:G10 of all the cells that had a number in it.

Formula returns the value "RESTART"

Formula returns the value "YES"

Formula returns the value "DONE"


Name:

/2Question 10

When you want to print a spreadsheet that will have the text printed sideways, this is referred to as:

Portrait

Vertical

Horizontal

Landscape

/2Question 11

Spreadsheets are contained in a:

(Provide the best possible answer)

Workbook

Sheet

File

Function

/2Question 12

An Excel spreadsheet is also called a _______________________ .

Worksheet

Workbook

Document


Name:

/2Question 13

Microsoft Excel is an __________program. (Provide the best possible answer)

Software

Touch Screen

Spreadsheet

Electronic

/2Question 14

Which of the Excel 2011 ribbon tabs allows you to change the font, make text larger,and has options for borders within your workbook dealing with formatting?

Review

Preview

Home

Data

/2Question 15

How would you Recognize the Cell Address?

By Formula Bar

Cell Reference

By Name Box


Name:

/2Question 16

You can use spreadsheet packages like the Microsoft Excel program to___________________.

Create charts

Perform mathematical operations

All of the above

Design speadsheets models

/2Question 17

These run vertically and are represented by numbers:

Columns

Sums

Landscape

Rows

/2Question 18

In your spreadsheet you want to select a series of cells that are not in order to select them all atonce, what key do you hold to do this?

ESC

Shift

Command

Control


Name:

/2Question 19

Which is the part of the Excel screen where you can �ind all the commands or buttons,depending on the tab you selected before?

Formula Bar

Tab

Ribbon

/2Question 20

Which formula can add the all numeric values in a range of cells, ignoring those which are notnumeric, and place the result in a different cell?

Average

Sum

Count

/2Question 21

When a formula is written in a cell. It appears in the the active cell in which it is beingwritten and in the ___________ bar as well.

Name Box

Title Bar

Formula


Name:

/2Question 22

To add two cells (A1 and A2) together you use the following formula

=Add(A1+A2)

=together(A1:A2)

A1 plus A2

=A1+A2

/2Question 23

When in a cell if you start to type anything and make an error, what key on the keyboard can youclick to get out of the cell with no changes made or affected?

Return

Delete

Command

ESC

/2Question 24

Which is not an advantage of using computerized spreadsheets?

Speed of calculation

Ability of generate tables

Cost of initial setup

Flexibility of moving entries


Name:

/2Question 25

As you begin to type a function name within a formula into a cell, a list of functionsthat begin with the letters you typed appears.

True

False

/2Question 26

You can use the drag and drop method to:

Delete cells contents

Add cell contents

Move cell contents

Copy cell contents

/2Question 27

In order to select a series of cells in order to select them all at once, what key do you hold to dothis?

Shift

Delete

Return

Command


Name:

/2Question 28

You can modify an exisiting chart by changing data in the data table?

True

False

/2Question 29

If you have data that runs across �ive columns, from column A to column E, one way tocenter a title across the top of the data would be to:

Type the data in A1 and Merge cells A1:E1

Type the data in C1

Choose Center from the Format menu

Type the data in A1 and Merge cells A1:A5

/2Question 30

When a worksheet is printed, the grid lines that surround the cells are printed bydefault.

True

False


Name:

/2Question 31

What does the SUM function do?

Add all the numbers in a range of cells

Returns a subtotal in a list or database

Subtract all content in that range of cells

Add up cell values based on a condition

/2Question 32

A Range in Microsoft Excel refers to:

A calculation that describes the relationship between cells

A way of arranging data in a particular order

A group of cells

/2Question 33

When printing, __________________ would be if you wanted the paper to be printed longways up and down.

landscape

margin

portrait

Name:

/2Question 34

When using Excel 2011 which sign is used to create a formula or function in a cell?

Double Quotes

Equal Sign

Parentheses

Single Quotes

/2Question 35

What is the maximum number of rows that can be entered on a single Excel 2011sheet?

Over 1 million

64000

256

65536

/2Question 36

Which sort of a program is the Microsoft Excel 2007 ?

Word Processing Package

Spreadsheets Package

Graphics Package

Multimedia Package


Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key

Instructions for grading: Grade each question and tally the score to obtain the total test points. If thefactor does not equal 1, multiply the total points by the factor to obtain the student's final score.

Question 1

A _____________ is the intersection point of a column and a row.

Cell

2 possible pts.

Question 2

Columns are identi�ied by a _______________ .

Letters

2 possible pts.

Question 3

When you print a spreadsheet where could you put your name, where you do not see it on thesheet until you print it? (You put your name here on every activity that we did)

Headers

2 possible pts.



Question 4

You cannot insert comments on each cell.

False

2 possible pts.

Question 5

These run horizontally across the top of your spreadsheet and are represented by letters:

Columns

2 possible pts.

Question 6

What function allows you to see the average of all the content in the range of cells?

=If()

2 possible pts.



Question 7

Every formula begins with an ____________.

plus sin

2 possible pts.

Question 8

All functions have arguments. There are no functions which work without providing themarguments or ranges of cells.

True

2 possible pts.

Question 9

In the following formula: =Count(A1:G10), what happens when you hit enter?

Formula returns a number counted from the range A1:G10 of all the cells that had a number in it.

2 possible pts.



Question 10

When you want to print a spreadsheet that will have the text printed sideways, this is referred to as:

Landscape

2 possible pts.

Question 11

Spreadsheets are contained in a:

(Provide the best possible answer)

Workbook

2 possible pts.

Question 12

An Excel spreadsheet is also called a _______________________ .

Worksheet

2 possible pts.



Question 13

Microsoft Excel is an __________program. (Provide the best possible answer)

Spreadsheet

2 possible pts.

Question 14

Which of the Excel 2011 ribbon tabs allows you to change the font, make text larger, and hasoptions for borders within your workbook dealing with formatting?

Home

2 possible pts.

Question 15

How would you Recognize the Cell Address?

Cell Reference

By Name Box

2 possible pts.



Question 16

You can use spreadsheet packages like the Microsoft Excel program to ___________________.

All of the above

2 possible pts.

Question 17

These run vertically and are represented by numbers:

Rows

2 possible pts.

Question 18

In your spreadsheet you want to select a series of cells that are not in order to select them all at once, what key doyou hold to do this?

Command

2 possible pts.



Question 19

Which is the part of the Excel screen where you can �ind all the commands or buttons, dependingon the tab you selected before?

Ribbon

2 possible pts.

Question 20

Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and placethe result in a different cell?

Sum

2 possible pts.

Question 21

When a formula is written in a cell. It appears in the the active cell in which it is being written andin the ___________ bar as well.

Formula

2 possible pts.



Question 22

To add two cells (A1 and A2) together you use the following formula

=A1+A2

2 possible pts.

Question 23

When in a cell if you start to type anything and make an error, what key on the keyboard can you click to get out ofthe cell with no changes made or affected?

ESC

2 possible pts.

Question 24

Which is not an advantage of using computerized spreadsheets?

Cost of initial setup

2 possible pts.



Question 25

As you begin to type a function name within a formula into a cell, a list of functions that begin withthe letters you typed appears.

True

2 possible pts.

Question 26

You can use the drag and drop method to:

Move cell contents

2 possible pts.

Question 27

In order to select a series of cells in order to select them all at once, what key do you hold to do this?

Shift

2 possible pts.



Question 28

You can modify an exisiting chart by changing data in the data table?

True

2 possible pts.

Question 29

If you have data that runs across �ive columns, from column A to column E, one way to center a titleacross the top of the data would be to:

Type the data in A1 and Merge cells A1:E1

2 possible pts.

Question 30

When a worksheet is printed, the grid lines that surround the cells are printed by default.

False

2 possible pts.



Question 31

What does the SUM function do?

Add all the numbers in a range of cells

2 possible pts.

Question 32

A Range in Microsoft Excel refers to:

A group of cells

2 possible pts.

Question 33

When printing, __________________ would be if you wanted the paper to be printed long ways up anddown.

portrait

2 possible pts.


Question 34

When using Excel 2011 which sign is used to create a formula or function in a cell?

Equal Sign

2 possible pts.

Question 35

What is the maximum number of rows that can be entered on a single Excel 2011 sheet?

Over 1 million

2 possible pts.

Question 36

Which sort of a program is the Microsoft Excel 2007 ?

Spreadsheets Package

2 possible pts.


microsoft excel final exam - robert j. varholak...

Documents