1.
A ________________ consists of a grid made from columns and rows?
Correct Answer
C. Spreadsheet
Explanation
A spreadsheet consists of a grid made from columns and rows. It is a software tool used for organizing, analyzing, and storing data in a structured manner. The grid layout allows users to input data into individual cells, which can be organized and manipulated using various functions and formulas. Spreadsheets are commonly used for tasks such as budgeting, financial analysis, and data management.
2.
What is not a basic part of a spreadsheet?
Correct Answer
A. Formula
Explanation
A formula is not a basic part of a spreadsheet. A formula is a mathematical expression used to perform calculations or manipulate data within a spreadsheet. It is used to perform operations on the data entered in cells, rows, or columns. While cells, rows, and columns are basic components of a spreadsheet that organize and display data, a formula is a tool that allows users to perform calculations and automate processes within the spreadsheet.
3.
Which of the following data can be put inside a cell?
Correct Answer
C. Constant
Explanation
A constant can be put inside a cell. A constant is a fixed value that does not change. In a spreadsheet, a cell can hold various types of data, including numbers, text, formulas, and constants. Constants are often used to represent fixed values or parameters in calculations or formulas. They can be used to define variables or values that remain constant throughout the spreadsheet. By entering a constant into a cell, it can be referenced in other cells or used in calculations to ensure consistency and accuracy in the spreadsheet.
4.
In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
Correct Answer
Rows
rows
Row
row
Explanation
The correct answer is rows. In a spreadsheet, rows are the horizontal spaces that go across the window. They are used to organize and display data in a tabular format. Each row typically contains cells, where data can be entered or calculated. By using rows, users can easily navigate and manipulate data in a spreadsheet by scrolling up and down.
5.
In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
Correct Answer
Column
column
Columns
Column
Explanation
The correct answer is "Column, column, Columns, Column." In a spreadsheet, a column refers to the vertical space that runs across the window. It is used to organize and categorize data in a tabular format, making it easier to read and analyze. Each column is labeled with a letter or a combination of letters to identify it uniquely. By understanding the concept of columns, users can efficiently navigate and manipulate data within a spreadsheet.
6.
_____________ are used to designate each column's location.
Correct Answer
Letters
Letter
letters
letter
Explanation
The question is asking for the correct term used to designate each column's location. The term used to designate each column's location is "letters" or "Letter" as both terms are plural and can be used interchangeably. The other options "letters" and "letter" are incorrect as they are either singular or not capitalized.
7.
___________ are used to designate each row's location.
Correct Answer
Numbers
Number
numbers
number
Explanation
The correct answer is "numbers" and "number". In this context, the word "numbers" refers to multiple rows, while "number" refers to a single row. These terms are used to identify and differentiate the location of each row in a given context.
8.
In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
Correct Answer
B. Cell
Explanation
A cell in a spreadsheet is defined as the space where a specified row and column intersect. It is the basic unit in a spreadsheet where data can be entered, such as numbers, labels, and formulas.
9.
Name this cell:
Correct Answer
B6
b6
Explanation
The correct answer is B6,b6 because the question is asking for the name of a cell, and the options provided are B6 and b6. Both B6 and b6 are valid cell names and can refer to a specific cell in a spreadsheet.
10.
In the spreadsheet below, provide an example of a label?
Correct Answer
computer ledger
car loan
interest
# of payments
Monthly Pmt.
Explanation
The correct answer is all the options provided (computer ledger, car loan, interest, # of payments, Monthly Pmt.) because these are all examples of labels that can be used in a spreadsheet. Labels are used to identify and categorize data in a spreadsheet, making it easier to understand and analyze the information. In this case, the options provided are all examples of labels that could be used to categorize different types of financial data.
11.
True or False: Labels do not have a value associated with them
Correct Answer
A. True
Explanation
Labels do not have a value associated with them because they are used solely for identification or categorization purposes. Unlike variables or constants, labels do not store or represent any specific data or information. They are typically used to provide names or descriptions to elements in a program or to mark certain sections of code for easier navigation and organization. Therefore, the statement "Labels do not have a value associated with them" is true.
12.
True or False: Constants are entires that do not have a specified value
Correct Answer
B. False
Explanation
This statement is incorrect. Constants are entries that have a specified value and cannot be changed during the execution of a program. They are used to store values that are fixed and do not change throughout the program's execution. Therefore, the correct answer is False.
13.
In the spreadsheet below, provide an example of a constant:
Correct Answer
$12,000.00
9.60%
60
Explanation
The given answer provides three examples of constants in a spreadsheet. The first example, $12,000.00, represents a constant value of $12,000.00. The second example, 9.60%, represents a constant interest rate of 9.60%. The third example, 60, represents a constant value of 60. These values are considered constants because they do not change and can be used in calculations or formulas throughout the spreadsheet without any variation.
14.
All formulas must begin with what?
Correct Answer
=
Explanation
In mathematical equations, the equal sign (=) is used to indicate that the expression on the left side is equal to the expression on the right side. Therefore, all formulas must begin with the equal sign to establish the relationship between the different parts of the equation.
15.
____________ are entires that have equations that calculates the value to display.
n
Correct Answer
D. Formulas
Explanation
Formulas are entries that have equations that calculate the value to display. In a spreadsheet or any other data entry system, formulas are used to perform calculations or manipulate data based on specified conditions or mathematical operations. They allow users to automate calculations and update values dynamically based on the input data.
16.
Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?
Correct Answer
=B1*B2
=b1*b2
Explanation
The formula "=B1*B2" and "=b1*b2" both represent the multiplication of the values in cell B1 (23 hours) and B2 ($5.36 per hour). By multiplying these values together, the formula calculates the total amount of money made.
17.
The ___________ function takes all of the values in each of the specified cells and totals their values
Correct Answer
SUM
sum
Explanation
The SUM function is used to add up the values in a range of cells. It takes all of the values in each of the specified cells and totals their values. The function can be written as "SUM" or "sum" in most spreadsheet software.
18.
The _________ function adds all of the indicated cells together and divides by the total number of cells.
Correct Answer
Average
average
Explanation
The average function is used to calculate the average of a range of cells. It adds up all the values in the indicated cells and then divides the sum by the total number of cells. This provides the average value of the range.
19.
The two most widely used charts are the:
Correct Answer
bar
pie
bar and pie
pie and bar
Pie and Bar
Bar and Pie
Explanation
The correct answer is "bar and pie". This answer includes all the possible combinations of the two most widely used charts, which are bar and pie charts.
20.
Name the three basic parts of a spreadsheet?
Correct Answer
coloum and cell and row
column and row and cell
cell and row and column
row and column and cell
row and cell and column
Explanation
The correct answer is "column and row and cell, cell and row and column, row and column and cell, row and cell and column". This answer is correct because it includes all three basic parts of a spreadsheet, which are columns, rows, and cells. A spreadsheet is made up of columns, which are vertical, rows, which are horizontal, and cells, which are the intersection points of columns and rows where data can be entered.
21.
In a spreadsheet, each cell may have three types of data in them: Name all three
Correct Answer
constant and label and formula
label and clonstant and formula
formula and constant and label
formula and label and constant
label and formula and constant
constant and formula and label
Explanation
In a spreadsheet, each cell may have three types of data in them: constant, label, and formula.
22.
What is the symbol for multiplication?
Correct Answer
*
Explanation
The symbol for multiplication is "*", which is commonly used in mathematical equations and computer programming languages. It represents the operation of multiplying two or more numbers together to find their product. This symbol is widely recognized and used worldwide to denote multiplication.
23.
What is the symbol for division?
Correct Answer
/
Explanation
The symbol "/" is commonly used to represent division in mathematical equations. It is a widely recognized symbol for dividing one quantity by another.
24.
What is the symbol for addition?
Correct Answer
+
Explanation
The symbol "+" is universally recognized as the symbol for addition. It is used to indicate the operation of combining two or more numbers to find their sum. This symbol has been widely adopted in mathematics and is taught to students from a young age. It is a simple and concise representation of addition, making it easy to understand and use in calculations.
25.
What is the symbol for subtraction?
Correct Answer

Explanation
The symbol "" is used to represent subtraction in mathematics. It is commonly known as the minus sign or hyphen. When used between two numbers, it indicates that the second number should be subtracted from the first number. For example, in the expression 5  3, the minus sign indicates that 3 should be subtracted from 5, resulting in a value of 2. Therefore, the symbol "" is the correct answer for the question.