ML1 Excel MiD-Term Review Part 1

Approved & Edited by ProProfs Editorial Team

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 in-house 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.

Learn about Our Editorial Process

| By Teacherv

Teacherv

Community Contributor

Quizzes Created: 5 | Total Attempts: 507

Questions: 10 | Attempts: 162 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

ML1 Excel MiD-Term Review Part 1

Questions and Answers

1.

What is the keyboard command to undo a previous action?
- A.
  
  Alt ~
- B.
  
  ctrl b
- C.
  
  shift f3
- D.
  
  ctrl z
Correct Answer
D. ctrl z

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.

Rate this question:
2.

What is the symbol for auto-sum?
- A.
  
  A
- B.
  
  X
- C.
  
  ∑
- D.
  
  ∏
Correct Answer
C. ∑

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.

Rate this question:
3.

What is the keystroke to reveal all formulas?
- A.
  
  Ctrl ~
- B.
  
  Alt &
- C.
  
  Shift F7
- D.
  
  Ctrl x
Correct Answer
A. Ctrl ~

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.

Rate this question:
4.

What feature automatically copies a formula to a range?
- A.
  
  Ctrl x
- B.
  
  Paste function
- C.
  
  Autofill
- D.
  
  Paste
Correct Answer
C. Autofill

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.

Rate this question:
5.

A formula in MS Excel starts with
- A.
  
  ~
- B.
  
  =
- C.
  
  (
- D.
  
  0
Correct Answer
B. =
6.

An interest rate of 13.54% is represented as the decimal:
- A.
  
  0.001354
- B.
  
  0.1354
- C.
  
  13.54
- D.
  
  135.4
Correct Answer
B. 0.1354

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.

Rate this question:
7.

Which menu allows you to enter headers / footers?
- A.
  
  View
- B.
  
  Edit
- C.
  
  Format
- D.
  
  File
Correct Answer
D. File

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.

Rate this question:
8.

Which menu allows you to reset page orientation?
- A.
  
  Format
- B.
  
  Insert
- C.
  
  File
- D.
  
  View
Correct Answer
C. File

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.

Rate this question:
9.

The correct formula that sums up the range B2:B8 is:
- A.
  
  (B2+B8)
- B.
  
  SUM(B2:B8)
- C.
  
  =SUM(B2:B8)
- D.
  
  B2+B8
Correct Answer
C. =SUM(B2:B8)

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.

Rate this question:
10.

. Which of these formulas divides the value in cell D2 by 3?
- A.
  
  D2:3
- B.
  
  D2/3
- C.
  
  (D2/3)
- D.
  
  =D2/3
Correct Answer
D. =D2/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.

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, 2023

Quiz Edited by
ProProfs Editorial Team
Apr 01, 2009

Quiz Created by
Teacherv

Ml1 Excel Mid-term Review Part 1

What is the keyboard command to undo a previous action?

What is the symbol for auto-sum?

What is the keystroke to reveal all formulas?

What feature automatically copies a formula to a range?

A formula in MS Excel starts with

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

Which menu allows you to enter headers / footers?

Which menu allows you to reset page orientation?

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

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