7th Grade: Microsoft Excel Exam! Trivia Quiz
Settings
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!
- 1.
![Q1: What does this button mean? - ProProfs]( "Q1: What does this button mean?")
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
- 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
- 3.An Excel spreadsheet is primarily used for
- A.
Writing formulas
- B.
Making tables
- C.
Making charts
- D.
All of the above
- 4.All forumulas in Excel begin with the following symbol =
- A.
True
- B.
False
- 5.Which of the following option is a formula?
- A.
=SUM(A1:A5)
- B.
Add A1 - A5
- C.
A1 = A5
- 6.The cell address in a formula is known as:
- A.
Cell reference
- B.
Cell mathematics
- C.
Formularizing
- 7.Which formula below will add the value of B2 to the value of C3
- A.
=B2+C3
- B.
=6+4
- C.
=B+C
- 8.A ____________ is the basic unit of a worksheet into which you enter data.
- A.
Cell
- B.
Tab
- C.
Chart
- 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
- 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
- 11.The ____________ function is used to determine the lowest number in a given range
- A.
Sum
- B.
Max
- C.
Min
- 12.You can assign a ____ to a cell and Excel will calculate the result.
- A.
Formula
- B.
Value
- C.
Reference
- 13.The arithmetic operator for division is ____.
- A.
\
- B.
|
- C.
/
- 14.The cell reference
- A.
Contains column letter of the cell
- B.
Contains row number of the cell
- C.
Contains formula
- 15.Absolute cell reference of the cell a12 is:
- A.
$a$12
- B.
$a12$
- C.
$a12
- 16.In formulas we just use relative cell references:
- A.
True
- B.
False
- 17.Profit=revenue*cost
- A.
True
- B.
False
- 18.________ is a piece of data in a spreadsheet that can be altered.
- 19._________ is a formula in a model . it makes the model work.
- 20.
![If you have the excel sheet::choose the correct answers: - ProProfs]( "If you have the excel sheet::choose the correct answers:")
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
Back to top