Business Computer Applications: Spreadsheet Quiz
4.01 Objective: Spreadsheets in business.
Questions and Answers
- 1.
Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This is an example of which operation?
- A.
Embed
- B.
Fill Series
- C.
Freeze
- D.
Link
Correct Answer
C. FreezeExplanation
Ed's action of arranging his spreadsheet to view the cell range A1:A10 and Row 2 while working in cells on Row 179 is an example of the "Freeze" operation. Freezing allows the user to lock certain rows or columns in place while scrolling through the rest of the spreadsheet, ensuring that important information remains visible and easily accessible. In this case, Ed froze Row 2 so that he could still see it while working in Row 179.Rate this question:
-
- 2.
Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to calculate a final grade for each student?
- A.
Average
- B.
Count
- C.
If
- D.
Sum
Correct Answer
A. AverageExplanation
Mrs. Jay should use the "Average" function to calculate a final grade for each student. This function will calculate the average of all the test scores and daily grades, providing an overall representation of the student's performance. By using the average, Mrs. Jay can determine the student's final grade based on their overall performance throughout the term.Rate this question:
-
- 3.
Mr. Evans sorted the students athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?
- A.
Ascending
- B.
Desending
- C.
Primary
- D.
Secondary
Correct Answer
C. PrimaryExplanation
In this case, GPA is considered as the primary part of the sort operation because Mr. Evans sorted the students athletes in order based on their GPA. The primary part determines the main criterion for sorting the data, and in this scenario, it is the GPA.Rate this question:
-
- 4.
What Operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moves around the worksheet?
- A.
Embed
- B.
Freeze
- C.
Link
- D.
Fill series
Correct Answer
B. FreezeExplanation
Eve will use the Freeze operation to keep rows and columns visible so that they don't scroll off the screen as she moves around the worksheet. This feature allows her to lock specific rows or columns in place while scrolling through the rest of the worksheet, ensuring that important data remains visible at all times.Rate this question:
-
- 5.
What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost?
- A.
Average
- B.
Max
- C.
Min
- D.
Sum
Correct Answer
D. SumExplanation
The function "Sum" will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost. This is because the "Sum" function is used to add up a range of values, and in this case, it would be used to add the merchandise cost and the tax calculated at a rate of 7.5% of the merchandise cost.Rate this question:
-
- 6.
What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily work counts 50%?
- A.
Average
- B.
If
- C.
Max
- D.
Min
Correct Answer
A. AverageExplanation
Eva should use the average function to calculate her final grade because it takes into account the weights assigned to each component. Since her exam counts for 25%, her test grades count for 25%, and her daily work counts for 50%, the average function will calculate the weighted average of these components to determine her final grade.Rate this question:
-
- 7.
In the formula =f10*$J$4, F10 is an example of a/an?
- A.
Absolute reference
- B.
Mixed reference
- C.
Range
- D.
Relative reference
Correct Answer
D. Relative referenceExplanation
In the given formula, F10 is used as a reference without any dollar sign before the column letter and row number. This means that when the formula is copied to other cells, the reference will adjust relative to the new location. For example, if the formula is copied to cell G10, the reference will automatically change to G10. Therefore, F10 is an example of a relative reference.Rate this question:
-
- 8.
In the formula =f10*$j$4,$j$4 is an example of a/an?
- A.
Absolute reference
- B.
Mixed reference
- C.
Reange
- D.
Relative reference
Correct Answer
A. Absolute referenceExplanation
In the given formula, the use of dollar signs before the column and row reference ($j$4) indicates that it is an absolute reference. This means that when the formula is copied or dragged to other cells, the reference to cell $j$4 will not change. The value in cell $j$4 will always be multiplied with the value in cell F10, regardless of where the formula is copied.Rate this question:
-
- 9.
In the formula =$A1+B1, $A1 is an example of a/an:
- A.
Absolute reference
- B.
Mixed reference
- C.
Range
- D.
Relative reference
Correct Answer
B. Mixed referenceExplanation
In the given formula, =$A1+B1, $A1 is an example of a mixed reference. The dollar sign before the column letter "A" makes it an absolute reference, which means that the column will not change when the formula is copied to other cells. However, the absence of the dollar sign before the row number "1" makes it a relative reference, allowing the row number to change when the formula is copied. Therefore, it is considered a mixed reference.Rate this question:
-
- 10.
What formula will divide the value in Cell E5 by the value in Cell E6?
- A.
=E5/E6
- B.
=E5:E6
- C.
=E6/E5
- D.
=E6:E5
Correct Answer
A. =E5/E6Explanation
The correct formula to divide the value in Cell E5 by the value in Cell E6 is =E5/E6. This formula divides the value in E5 by the value in E6, resulting in the quotient of the division.Rate this question:
-
- 11.
A B C D E 1 Name Instrument Per Month Fee Number of Months Total Cost 2 Tom saxphone $ 45.00 10 $ 450.00 3 Joan clarinet $ 35.00 10 $ 350.00 4 Heather trumpet $ 60.00 5 $ 300.00 5 Stan drums $ 55.00 $ - 6 Jose flute $ 42.00 $ - 7 Total Rental Fee $ 1,100.00 In the MiddleSchool Band spreadsheet, what formula will calculate the total cost per year for the saxophone?
- A.
=B2*C2/10
- B.
=B2/10*C2
- C.
=C2/D2
- D.
=C2*D2
Correct Answer
D. =C2*D2Explanation
The formula =C2*D2 calculates the total cost per year for the saxophone. It multiplies the per month fee (C2) by the number of months (D2) to get the total cost.Rate this question:
-
- 12.
A B C D E 1 Name Instrument Per Month Fee Number of Months Total Cost 2 Tom saxphone $ 45.00 10 $ 450.00 3 Joan clarinet $ 35.00 10 $ 350.00 4 Heather trumpet $ 60.00 5 $ 300.00 5 Stan drums $ 55.00 $ - 6 Jose flute $ 42.00 $ - 7 Total Rental Fee $ 1,100.00 What format has been applied to Cells C1 and D1?
- A.
Border
- B.
Merge
- C.
Wrap
- D.
Shade
Correct Answer
C. WrapExplanation
Cells C1 and D1 have the "Wrap" format applied. This means that the text in these cells is wrapped within the cell, allowing it to be displayed on multiple lines if necessary. This format is used when the text in a cell is too long to fit in a single line and needs to be displayed in a more readable format.Rate this question:
-
- 13.
A B C D E 1 Name Instrument Per Month Fee Number of Months Total Cost 2 Tom saxphone $ 45.00 10 $ 450.00 3 Joan clarinet $ 35.00 10 $ 350.00 4 Heather trumpet $ 60.00 5 $ 300.00 5 Stan drums $ 55.00 $ - 6 Jose flute $ 42.00 $ - 7 Total Rental Fee $ 1,100.00 What formula is used to calculate the Toal Rental Fee?
- A.
=sum(E2:E6)
- B.
=sum(C2:E6)
- C.
=Total(c2:C6)*(D2:D6)
- D.
=Sum(D2:D6)
Correct Answer
A. =sum(E2:E6)Explanation
The correct answer is =sum(E2:E6). This formula is used to calculate the total rental fee by summing up the values in cells E2 to E6, which represent the total cost for each instrument.Rate this question:
-
- 14.
C4 is known as the_________ in spreadsheet
Correct Answer
cell addressExplanation
In a spreadsheet, each cell is assigned a unique identifier called a cell address. This address is used to reference and locate specific cells within the spreadsheet. C4 refers to a specific cell in the spreadsheet, and therefore it is known as the cell address.Rate this question:
- 15.
A file that contains one or more speadsheets
Correct Answer
WorkbookExplanation
A workbook is a file that contains one or more spreadsheets. It is a collection of worksheets where data can be organized and analyzed. This file format allows users to create, edit, and save multiple spreadsheets within a single document. Workbooks are commonly used in spreadsheet software like Microsoft Excel to manage and manipulate data efficiently.Rate this question:
- 16.
Text or numbers that will not be used in calculations is known as?
Correct Answer
labelExplanation
In the context of calculations, a label refers to text or numbers that are used for identification or description purposes but are not involved in any mathematical operations or calculations. Labels are typically used to provide information or context to the data being presented or analyzed. Therefore, in this context, text or numbers that will not be used in calculations are referred to as labels.Rate this question:
- 17.
Data that has potential to be used in calculation.
Correct Answer
valueExplanation
The given answer "value" is the correct answer because the question is asking for the term that represents data that can be used in calculations. "Value" is a commonly used term to refer to the numerical or quantitative data that can be used for calculations or analysis. It represents the actual numeric information that can be manipulated or processed in mathematical operations.Rate this question:
- 18.
Name the 4 functions that can be used?
Correct Answer
sum, average, maximun, minimum
sum, avg, max, minExplanation
The correct answer is "sum, average, maximum, minimum". These are the four functions that can be used. The functions "sum" and "average" are used to calculate the total sum and average value of a set of numbers, respectively. The functions "maximum" and "minimum" are used to find the highest and lowest values in a set of numbers, respectively.Rate this question:
- 19.
What is the default setting of a label?
Correct Answer
LeftExplanation
The default setting of a label is left-aligned. This means that the text within the label will be aligned to the left side of the label's container or bounding box. Left alignment is commonly used for labels as it provides a consistent and easy-to-read formatting for text.Rate this question:
- 20.
What is the default setting of a value?
Correct Answer
rightExplanation
The default setting of a value refers to the initial or pre-set value that is automatically assigned to a variable or parameter if no other value is specified. In this context, "right" could be interpreted as indicating that the default setting of a value is correct or accurate.Rate this question:
- 21.
What does ###### mean?
Correct Answer
cell is not large enough
cell is not big enough
cell is to smallExplanation
The correct answer is that "######" means "cell is not large enough, cell is not big enough, cell is too small". The use of multiple hashtags suggests that the word or phrase being censored is a repetition of the same concept. In this case, all three options convey the same meaning, indicating that the cell being referred to is not of sufficient size.Rate this question:
- 22.
Used to combine two or more cells;
Correct Answer
mergeExplanation
The term "merge" refers to the action of combining two or more cells together. This can be done in various software applications, such as spreadsheets or word processors, where cells can be merged to create a single, larger cell. By merging cells, the content within them can be aligned and formatted as a single unit, making it easier to organize and present data or information.Rate this question:
- 23.
Used to alighn multi-lined text within a cell
Correct Answer
WrapExplanation
The "Wrap" option is used to align multi-lined text within a cell. When this option is enabled, any text that exceeds the width of the cell will automatically wrap onto the next line, allowing all the content to be displayed without overlapping or truncation. This is particularly useful when dealing with lengthy text or when formatting cells to fit a specific width.Rate this question:
- 24.
A B C 1 Budget 2 Income 3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses 8 Rent 575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss $ 580.00 The placement of the individual income items in Cells A3:A6 and expense items in Cells A8:A15 is the result of which formatting?
- A.
Border
- B.
Indent
- C.
Merge
- D.
Wrap
Correct Answer
B. IndentExplanation
The placement of the individual income items in Cells A3:A6 and expense items in Cells A8:A15 is the result of using the "Indent" formatting. This formatting is used to create a hierarchical structure in the spreadsheet, where the income and expense items are indented to show that they are subcategories of the "Income" and "Expenses" categories respectively. This helps to organize and present the information in a clear and structured manner.Rate this question:
-
- 25.
A B C 1 Budget 2 Income 3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses 8 Rent 575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss $ 580.00 The Net Income/Loss value in Cell C16 is the result of which operation?
- A.
Addition
- B.
Division
- C.
Multiplication
- D.
Subtraction
Correct Answer
D. SubtractionExplanation
The correct answer is subtraction because the net income/loss value in Cell C16 is calculated by subtracting the total expenses (1620.00) from the total income (2200.00).Rate this question:
-
- 26.
A B C 1 Budget 2 Income 3 Paycheck 2,000.00 4 Birthday Money 150.00 5 Babysitting 50.00 6 Total Income 2200.00 7 Expenses 8 Rent 575.00 9 Power 95.00 10 Car Payment 375.00 11 Cable 75.00 12 Gas 100.00 13 Food 200.00 14 Entertainment 200.00 15 Total Expenses 1620.00 16 Net Income/Loss $ 580.00 Which operation was used to calculate the vaule in Cell C6?
- A.
Addition
- B.
Division
- C.
Multiplication
- D.
Subtraction
Correct Answer
A. AdditionExplanation
The value in Cell C6 was calculated using addition. This can be determined by looking at the values in Cells C3, C4, and C5, which represent the different sources of income. These values are added together to calculate the total income in Cell C6.Rate this question:
-
- 27.
What symbol is used for addition?
Correct Answer
+
plus signExplanation
The symbol used for addition is the plus sign (+). It is a commonly recognized symbol that represents the operation of adding two or more numbers together. The plus sign is used in mathematical equations and calculations to indicate the process of combining quantities to find a sum.Rate this question:
- 28.
What symbol is used for division?
Correct Answer
/
diagonalExplanation
The symbol used for division is "/". It is commonly referred to as the forward slash or simply the slash. In mathematics, it represents the operation of dividing one number by another. The term "diagonal" does not have any relation to division and is not used as a symbol for it.Rate this question:
- 29.
What symbol is used for multiplication?
Correct Answer
*
asteriskExplanation
The symbol used for multiplication is the asterisk (*), which is commonly referred to as an asterisk. This symbol is widely recognized and used in mathematical equations and computer programming languages to represent multiplication.Rate this question:
- 30.
What is the symbol for subtraction?
Correct Answer
-
minus signExplanation
The symbol for subtraction is "-," which is commonly known as the minus sign. It is used to indicate the operation of subtraction in mathematical equations. When placed between two numbers, it signifies that the second number should be subtracted from the first number. The minus sign is a fundamental symbol in mathematics and is widely recognized and used in various mathematical contexts.Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 26, 2010Quiz Created by
Tddavid
- Accounting Quizzes
- Advertising Quizzes
- Agriculture Quizzes
- Automotive Quizzes
- Brand Quizzes
- Business Accounting Quizzes
- Business Analyst Quizzes
- Business Development Quizzes
- Business Environment Quizzes
- Business Etiquette Quizzes
- Business Finance Quizzes
- Business Math Quizzes
- Business Organization Quizzes
- Business Plan Quizzes
- Business Process Quizzes
- Business Study Quizzes
- Business Technology Quizzes
- CEO Quizzes
- Collaboration Quizzes
- Company Quizzes
- Construction Quizzes
- Consumer Quizzes
- CSR Quizzes
- Customer Quizzes
- Customer Service Quizzes
- Development Quizzes
- Ecommerce Quizzes
- Employment Quizzes
- Entrepreneurship Quizzes
- Finance Quizzes
- Hospitality Quizzes
- Human Resources Quizzes
- Industry Quizzes
- International Business Quizzes
- Introduction To Business Quizzes
- Investment Quizzes
- Logistics Quizzes
- Management Quizzes
- Manufacturing Quizzes
- Marketing Quizzes
- Material Quizzes
- Media Quizzes
- Office Quizzes
- Organization Quizzes
- Principles Of Business Quizzes
- Printing Quizzes
- Product Quizzes
- Publishing Quizzes
- Real Estate Quizzes
- Retail Quizzes
- Sales Quizzes
- SAP Business One Quizzes
- Small Business Quizzes
- Source Quizzes
- Supply Quizzes
- Survey Quizzes
- Telecommunication Quizzes
- Trade Quizzes
- Training Quizzes
- Transportation Quizzes
- Warehouse Quizzes
- Welding Quizzes
Back to top