NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets
Total questions: 35
Worksheet time: 35mins
Name
Class
Date
1.
The intersection of a Row and Column in a Spreadsheet
a)
Rectangle
b)
Range
c)
AutoFill
d)
Cell
2.
A1:D4 is an example of a cell...
a)
Range
b)
Selection
c)
Formula
d)
Choice
3.
Which way does a row go?
a)
Horizontal
b)
Vertical
4.
Which way does a Column go?
a)
Horizontal
b)
Vertical
5.
If A3:J8 is given, what is it referring to?
a)
Only cell A3
b)
Only cell J8
c)
Only the two cells A3 and J8
d)
The range of cells A3 through J8
6.
Spreadsheet rows are easily identified by:
a)
Letters
b)
Roman Numerals
c)
Numbers
d)
Colors
7.
Spreadsheet columns are easily identified by:
a)
Roman Numerals
b)
Numbers
c)
Letters
d)
Colors
8.
Which of these assignments would a Spreadsheet program NOT be used for?
a)
Creating a Budget
b)
Writing a Research Paper
c)
Tracking Sales
d)
Tracking Inventory
9.
Which of the following is an example of a Cell Address?
a)
Column C
b)
=SUM
c)
Row 1
d)
Z10
10.
Which of the following is NOT an example of a Cell Address?
a)
XFD1048576
b)
A1:D1
c)
A1
d)
Z10
11.
What is the correct example of a range?
a)
3B:7C
b)
B3:C7
c)
B3-C7
d)
B:3:C:7
12.
Which type of chart is pictured here?
a)
Pie
b)
Line
c)
Bar
d)
Statistical
13.
Which type of chart is pictured here?
a)
Pie
b)
Line
c)
Column
d)
Bar
14.
What type of chart is pictured here?
a)
Pie Chart
b)
Line Chart
c)
Column Chart
d)
Bar Chart
15.
There's a list of information in Cell Range A1:D1.. Where is this list?
a)
In a Column
b)
In a Row
c)
In a Chart
d)
In a Circle
16.
There's a list of information in Cell Range A1:A30.. Where is this list?
a)
In a Column
b)
In a Chart
c)
In a Row
d)
In a Circle
17.
If you want numbers to be formatted quickly to look like dollar amounts, what would you format them as?
a)
Percent
b)
Bold
c)
Numerals
d)
Currency
18.
If I want to make a cell a particular color, which button would I click on?
a)
Orange Arrow
b)
Red Arrow
c)
Blue Arrow
d)
Green Arrow
19.
If I want to make several individual cells become 1 bigger cell, which button would I click on?
a)
Orange Arrow
b)
Red Arrow
c)
Blue Arrow
d)
Green Arrow
20.
If I want to make my cells have borders, which button would I click on?
a)
Orange Arrow
b)
Red Arrow
c)
Blue Arrow
d)
Green Arrow
21.
The part of a formula within a cell that does NOT change when it is copied and pasted is known as:
a)
Relative Value
b)
Absolute Value
c)
Function
d)
AutoSum
22.
The cell in your worksheet that has been selected. It will have bolder grid lines around it is known as:
a)
Merged Cell
b)
Formula Bar
c)
Active Cell
d)
Total:
23.
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected is known as:
a)
AutoFill
b)
AutoFit
c)
AutoSum
d)
AutoCopy
24.
A function that automatically identifies and adds ranges of cells in your worksheet is known as:
a)
AutoAdd
b)
AutoFit
c)
AutoSum
d)
AutoCopy
25.
The lines on your worksheet that separate the columns and rows are known as the:
a)
Spreadsheet
b)
Borders
c)
Dotted Lines
d)
Cell Grid
26.
A combination of numbers and symbols used to express a calculation within a cell is known as a:
a)
Formula
b)
Equation
c)
Function
d)
Addition
27.
A, B, C, D.... and
1, 2, 3, 4... represent:
1, 2, 3, 4... represent:
a)
Function Symbols
b)
Headings
c)
Borders
d)
Labels
28.
"Name", "Totals", "Colors", etc. represent:
a)
Charts
b)
Headings
c)
Borders
d)
Labels
29.
A dropdown menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet is known as a:
a)
Equation
b)
Function
c)
Formula
d)
Merged Cell
30.
The command line above the worksheet where text, numbers, and formulas are entered into a worksheet is known as a:
a)
Formula Bar
b)
Title Bar
c)
A1
d)
Ribbon
31.
The part of a formula within a cell that changes when it is copied and pasted RELATIVE to where you are putting it is known as:
a)
Absolute Value
b)
Tabs
c)
Relative Value
d)
Function
32.
The tabs you see at the bottom of your workbook file that represent worksheets within a workbook are known as:
a)
Documents
b)
Groups
c)
Note Pages
d)
Sheet Tabs
33.
A software program that organizes data into rows and columns for calculating and financial application is known as:
a)
Document
b)
Spreadsheet
c)
Presentation
d)
Drawing
34.
An Excel or Sheets file that contains individual worksheets is known as:
a)
Workfile
b)
Spreadsheet
c)
Workbook
d)
Portfolio
35.
A "page" within an Excel or Sheets workbook that contains columns, rows, and cells - also called a Spreadsheet is known as:
a)
Worksheet
b)
Document
c)
Workbook
d)
Data File
Reset
