NEW
Font size
WorksheetsSpreadsheet lesson 1-2
Total questions: 20
Worksheet time: 10mins
1. A spreadsheet program is used to store data in:
a. a database
b. a text document
c. rows and columns
d. letters and numbers
2. Spreadsheet rows are easily identified by
a. numbers
b. letters
c. Roman numerals.
d. colors
Which of the following is an example of a cell reference?
a. Column C
a. =SUM
b. Row 1
c. A5
Which button is used to format data as a percentage?
a. $
b. ¶
c. #
d. %
What keyboard shortcut will select all the cells in a spreadsheet?
Shift + A
Ctrl + A
Alt + A
Tab + A
1. Combining multiple cells in your spreadsheet is called:
a. formatting
b. aligning
c. merging
d. mixing
Spreadsheet columns are easily identified by:
a. Roman numerals
a. numbers
a. letters
a. colors
The keyboard shortcut for PASTE is:
a. CTRL + A
b. CTRL + V
c. SHIFT + C
d. SHIFT + V
1. What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?
a. Percent
b. Currency
c. Comma
d. Increase Decimal
When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:
1. the left side of the cell
b. the top of the cell
c. the right side of the cell
d. the bottom of the cell
Study the example. Which type of chart is shown?
Bar chart
Scatter chart
Column chart
Line chart
Study the example. Which type of chart is shown?
Line chart
Pie chart
Bar chart
Column chart
Which type of chart is divided into portions representing data percentages?
Column chart
Bar chart
Line chart
Pie chart
Which of the following allows a user to easily sort multiple series of data?
Fill handle
Table
Chart
Function
In a horizontal bar chart, which bar represents the greatest amount or value of the data being illustrated?
The longest bar
The shortest bar
The bar at the top of the chart
The bar at the bottom of the chart
Ernesto's group has made a massive spreadsheet containing data from several sources. Which feature could the group use to easily sort a series of data to help improve their understanding of the information?
Chart
Function
Range
Table
Which chart element identifies the data series that each color represents on the chart?
Vertical axis
Legend
Horizontal axis
Title
Study the following example table:
Which statement about this table is true?
All fields in this table have been sorted alphabetically.
This table includes different data types and sums the values.
All fields in this table use the same data type.
This table can sum only one type of data.
Which of the following lists the types of charts shown in the correct order?
Column, pie, bar
Pie, line, scatter
Column, pie, line
Bar, pie, line
Gary wants a graphical representation of his project data that illustrates the relationships between time and height. What should Gary use to represent this data?
A cell range
A column
A chart
A table
