Ml1 Excel Mid-term Review Part 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Teacherv
T
Teacherv
Community Contributor
Quizzes Created: 5 | Total Attempts: 514
| Attempts: 162 | Questions: 10
Please wait...
Question 1 / 10
0 %
0/100
Score 0/100
1. What is the symbol for auto-sum?

Explanation

The symbol for auto-sum is ∑. This symbol is commonly used in mathematics and spreadsheets to represent the summation of a series of numbers. It indicates that the values within a specified range should be added together.

Submit
Please wait...
About This Quiz
Excel Quizzes & Trivia

This quiz assesses knowledge of Microsoft Excel, covering undo commands, auto-sum, formula revelation, autofill features, formula syntax, and decimal representation of interest rates.

2. A formula in MS Excel starts with

Explanation

not-available-via-ai

Submit
3. The correct formula that sums up the range B2:B8 is:

Explanation

The correct formula that sums up the range B2:B8 is =SUM(B2:B8). This formula calculates the sum of all the values in the range B2 to B8. By using the SUM function and specifying the range B2:B8, it adds up all the numbers in that range and provides the sum as the result.

Submit
4. . Which of these formulas divides the value in cell D2 by 3?

Explanation

The correct answer is "=D2/3" because the equal sign at the beginning indicates that it is a formula. "D2" refers to the value in cell D2, and "/3" divides that value by 3. Therefore, the formula "=D2/3" divides the value in cell D2 by 3.

Submit
5. An interest rate of 13.54% is represented as the decimal:

Explanation

The interest rate of 13.54% is represented as the decimal 0.1354. To convert a percentage to a decimal, divide the percentage by 100. In this case, dividing 13.54 by 100 gives us 0.1354.

Submit
6. What feature automatically copies a formula to a range?

Explanation

Autofill is the feature that automatically copies a formula to a range. When you enter a formula in a cell and use Autofill by dragging the fill handle, the formula is automatically copied and adjusted for each cell in the range. This saves time and effort in manually copying and pasting the formula to each cell.

Submit
7. What is the keyboard command to undo a previous action?

Explanation

The keyboard command "ctrl z" is used to undo a previous action. By pressing these keys simultaneously, the user can revert the last action performed on the computer. This command is commonly used in various applications and software to quickly undo mistakes or changes made.

Submit
8. What is the keystroke to reveal all formulas?

Explanation

Pressing "ctrl ~" is the keystroke to reveal all formulas in Microsoft Excel. This shortcut allows users to switch between showing the formulas and the results in the cells.

Submit
9. Which menu allows you to reset page orientation?

Explanation

The correct answer is "File" because the File menu typically contains options related to managing and manipulating the document or file. In this case, resetting the page orientation would be considered a document-related action rather than a formatting or insertion action, making the File menu the most appropriate location for this option.

Submit
10. Which menu allows you to enter headers / footers?

Explanation

The File menu typically allows users to perform actions related to the overall document, such as saving, printing, or opening a new file. In some word processing software, the File menu may also include options to enter headers and footers, which are sections of text that appear at the top or bottom of every page in a document. Therefore, the correct answer is File.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 01, 2009
    Quiz Created by
    Teacherv
Cancel
  • All
    All (10)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What is the symbol for auto-sum?
A formula in MS Excel starts with
The correct formula that sums up the range B2:B8 is:
. Which of these formulas divides the value in cell D2 by 3?
An interest rate of 13.54% is represented as the decimal:
What feature automatically copies a formula to a range?
What is the keyboard command to undo a previous action?
What is the keystroke to reveal all formulas?
Which menu allows you to reset page orientation?
Which menu allows you to enter headers / footers?
Alert!

Advertisement