The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our inhouse seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Most people today have a hard time when it comes to using Excel to its full potential, and this is common when it comes to using formulas. How good are your Microsoft Excel skills so far as a 7thgrader? Take up this revision quiz and get to see just how much you know when it comes to using it. All the best!
Questions and Answers
1.
Q1: What does this button mean?
A.
Align the text on the borders of the page.
B.
Extend the content on the entire length of the cell.
C.
Merge and center
Correct Answer C. Merge and center
Explanation The correct answer is "merge and center". This button is used to combine multiple cells into one and center the content within that merged cell.
Rate this question:
2.
If you copy the formula =$B$38 into another cell, the result will be:
A.
The column part will remain the same
B.
Both the column and row will remain the same
C.
Both will change
Correct Answer B. Both the column and row will remain the same
Explanation If the formula =$B$38 is copied into another cell, both the column and row will remain the same. This is because the use of the dollar sign ($) in front of the column and row reference makes them absolute references, which means they will not change when the formula is copied to another cell.
Rate this question:
3.
An Excel spreadsheet is primarily used for
A.
Writing formulas
B.
Making tables
C.
Making charts
D.
All of the above
Correct Answer D. All of the above
Explanation An Excel spreadsheet is a versatile tool that can be used for various purposes. It allows users to write formulas to perform calculations, create tables to organize data, and make charts to visualize information. Therefore, the correct answer is "all of the above" as all these functions can be performed using an Excel spreadsheet.
Rate this question:
4.
All forumulas in Excel begin with the following symbol =
A.
True
B.
False
Correct Answer A. True
Explanation All formulas in Excel begin with the symbol "=", indicating that the following characters are part of a formula and not regular text. This symbol is used to differentiate between data and calculations in Excel.
Rate this question:
5.
Which of the following option is a formula?
A.
=SUM(A1:A5)
B.
Add A1  A5
C.
A1 = A5
Correct Answer A. =SUM(A1:A5)
Explanation The correct answer is "=SUM(A1:A5)" because it follows the syntax of a formula in Excel. The equal sign at the beginning indicates that it is a formula, and the "SUM" function is used to add the values in the range A1 to A5.
Rate this question:
6.
The cell address in a formula is known as:
A.
Cell reference
B.
Cell mathematics
C.
Formularizing
Correct Answer A. Cell reference
Explanation The cell address in a formula is known as a cell reference. It is used to identify a specific cell or range of cells in a spreadsheet. When a formula is entered, it refers to the cell or cells specified by the cell reference to perform calculations or retrieve data. The cell reference can be absolute (fixed) or relative (adjustable) depending on whether it is intended to stay the same or change when copied to other cells.
Rate this question:
7.
Which formula below will add the value of B2 to the value of C3
A.
=B2+C3
B.
=6+4
C.
=B+C
Correct Answer A. =B2+C3
Explanation The correct answer is "=B2+C3" because it uses the addition operator (+) to add the value of cell B2 to the value of cell C3.
Rate this question:
8.
A ____________ is the basic unit of a
worksheet into which you enter data.
A.
Cell
B.
Tab
C.
Chart
Correct Answer A. Cell
Explanation A cell is the basic unit of a worksheet into which you enter data. It is a rectangular box that is formed by the intersection of a row and a column. Each cell can contain text, numbers, formulas, or other types of data. Cells are used to organize and manipulate data in a spreadsheet, allowing for easy data entry and analysis.
Rate this question:
9.
If i want to display the number as currency i should
A.
Insert the symbol of the currency in the cell
B.
Type the suitable currency symbol from the keyboard
C.
Format the number as currency
Correct Answer C. Format the number as currency
Explanation To display a number as currency, you need to format the number as currency. This can be done using formatting options in spreadsheet software such as Microsoft Excel or Google Sheets. By selecting the cell containing the number and applying the currency format, the software will automatically add the suitable currency symbol to the number. This ensures that the number is displayed correctly as currency.
Rate this question:
10.
When you copy a formula with relative cell
references down a row,____________.
A.
the row references change in the formula
B.
The column references change in the formula
C.
No references are changed in the formula
Correct Answer A. the row references change in the formula
Explanation When you copy a formula with relative cell references down a row, the row references change in the formula. This means that if the original formula refers to a cell in a specific row, when you copy the formula to a different row, the formula will automatically adjust the row reference to match the new location. This allows you to easily apply the same formula to multiple rows without manually updating the cell references.
Rate this question:
11.
The ____________ function is used to determine the lowest number in a
given range
A.
Sum
B.
Max
C.
Min
Correct Answer C. Min
Explanation The min function is used to determine the lowest number in a given range. It compares all the numbers in the range and returns the smallest one.
Rate this question:
12.
You can assign a ____ to a cell and Excel will calculate the result.
A.
Formula
B.
Value
C.
Reference
Correct Answer A. Formula
Explanation In Excel, you can assign a formula to a cell to calculate the result. A formula is a mathematical expression or equation that performs calculations using the values in other cells. By entering a formula in a cell, Excel automatically calculates the result based on the specified mathematical operations and references to other cells. This allows users to perform complex calculations and automate data analysis in Excel.
Rate this question:
13.
The arithmetic operator for division is ____.
A.
\
B.

C.
/
Correct Answer C. /
Explanation The arithmetic operator for division is "/". This symbol is used to divide one number by another and obtain the quotient or result of the division operation. It represents the concept of distributing a quantity into equal parts or groups.
Rate this question:
14.
The cell reference
A.
Contains column letter of the cell
B.
Contains row number of the cell
C.
Contains formula
Correct Answer(s) A. Contains column letter of the cell B. Contains row number of the cell
Explanation The cell reference contains the column letter of the cell, which indicates the column in which the cell is located. It also contains the row number of the cell, which indicates the row in which the cell is located. This combination of the column letter and row number uniquely identifies a cell in a spreadsheet. The cell reference does not contain the formula itself, but rather identifies the location of the cell within the spreadsheet.
Rate this question:
15.
Absolute cell reference of the cell a12 is:
A.
$a$12
B.
$a12$
C.
$a12
Correct Answer A. $a$12
Explanation The correct answer is $a$12 because the dollar signs before the column letter and row number indicate that the reference is absolute. This means that when the cell is copied and pasted to other cells, the reference will not change. In this case, both the column and row references are absolute, so the reference to cell A12 will remain the same regardless of where it is copied.
Rate this question:
16.
In formulas we just use relative cell references:
A.
True
B.
False
Correct Answer B. False
Explanation In formulas, we use a combination of absolute and relative cell references. Absolute cell references do not change when copied or filled, while relative cell references adjust based on the location they are copied to. Therefore, the statement that we only use relative cell references in formulas is false.
Rate this question:
17.
Profit=revenue*cost
A.
True
B.
False
Correct Answer B. False
Explanation The given statement "profit = revenue * cost" is incorrect. The correct formula to calculate profit is "profit = revenue  cost" as profit is the difference between revenue and cost, not their product. Therefore, the correct answer is False.
Rate this question:
18.
________ is a piece of data in a spreadsheet that can be altered.
Correct Answer variable
Explanation A variable is a piece of data in a spreadsheet that can be altered. In the context of spreadsheets, variables are used to store and manipulate values. They can be assigned different values and formulas can be applied to them to perform calculations. By changing the value of a variable, the corresponding data in the spreadsheet can be updated and recalculated. This flexibility allows users to easily modify and manipulate data within a spreadsheet.
Rate this question:
19.
_________ is a formula in a model . it makes the model work.
Correct Answer rule
Explanation In a model, a rule is a formula that provides instructions or guidelines for the functioning of the model. It defines the relationship between different variables and helps in making predictions or decisions based on the inputs provided. Without rules, a model would not be able to operate and generate meaningful results.
Rate this question:
20.
If you have the excel sheet::choose the correct answers:
A.
The active cell is b4
B.
The content of c3 is student1
C.
The cell reference which it's content 5 is b6
Correct Answer(s) A. The active cell is b4 C. The cell reference which it's content 5 is b6
Explanation The given answer is correct because it accurately states that the active cell is in B4 and the cell reference for the content 5 is in B6. This means that the currently selected cell in the Excel sheet is B4 and the value 5 is present in cell B6.
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.