microsoft excel final exam - robert j. varholak...
Post on 28-Jun-2020
1 Views
Preview:
TRANSCRIPT
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()
ID: 8384 Due Date: January 15, 2016
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"
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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
ID: 8384 Due Date: January 15, 2016
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
Possible Points: 72 Factor: x1.00 Test Value: 72Answer Key
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.
ID: 8384 Due Date: January 15, 2016
top related