Success Academy Microsoft Excel Quiz

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 Dkintaudi

Dkintaudi

Community Contributor

Quizzes Created: 3 | Total Attempts: 837

Questions: 12 | Attempts: 199 | Updated: Jan 23, 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

Success Academy Microsoft Excel Quiz - Quiz

The following is a short Quiz over Excel

Questions and Answers

1.

The advantage of using a spreadsheet is
- A.
  
  Calculations can be done automatically
- B.
  
  Changing data automatically updates calculations (as long as Excel is not set to calculate manually)
- C.
  
  More flexibility than word tables
- D.
  
  All of the above
Correct Answer
D. All of the above

Explanation
The advantage of using a spreadsheet is that calculations can be done automatically, changing data automatically updates calculations (as long as Excel is not set to calculate manually), and it provides more flexibility than word tables.

Rate this question:
2.

The intersection of a row and a column is called
- A.
  
  Data
- B.
  
  A field
- C.
  
  A cell
- D.
  
  An equation
Correct Answer
C. A cell

Explanation
A cell is the correct answer because it refers to the intersection of a row and a column in a table or spreadsheet. It is the smallest unit of data in a table and contains a single piece of information.

Rate this question:
3.

When you are typing an equation into a cell the first thing that must be entered is
- A.
  
  The first cell referenced
- B.
  
  Parenthesis
- C.
  
  Quotation marks
- D.
  
  An equal sign
Correct Answer
D. An equal sign

Explanation
When typing an equation into a cell, the first thing that must be entered is an equal sign. This is because the equal sign is used to indicate that the content of the cell is a formula or equation, rather than just a regular text entry. The equal sign tells the spreadsheet software to calculate the result of the equation based on the values and functions entered after it. Without the equal sign, the content of the cell will be treated as plain text.

Rate this question:
4.

Labels are used in a spreadsheet to
- A.
  
  Tell the computer what we are doing
- B.
  
  Help us identify the information
- C.
  
  Do the calculations
- D.
  
  Set up the equations
Correct Answer
B. Help us identify the information

Explanation
Labels are used in a spreadsheet to help us identify the information. By assigning labels to different rows and columns, we can easily understand and categorize the data present in the spreadsheet. This allows us to quickly locate and analyze specific information without confusion or ambiguity. Labels provide a clear and organized structure to the spreadsheet, making it easier for users to navigate and work with the data effectively.

Rate this question:
5.

The cell labeled F5 refers to
- A.
  
  Row F column 5
- B.
  
  Functions available in cells
- C.
  
  Column F row 5
- D.
  
  Function key F4
Correct Answer
C. Column F row 5

Explanation
The cell labeled F5 refers to the intersection of column F and row 5. This means that it is the cell located in the fifth row and the letter F column.

Rate this question:
6.

There are three types of data found in a spreadsheet
- A.
  
  Data, words, numbers
- B.
  
  Equations, data, numbers
- C.
  
  Numbers, formulas, labels
- D.
  
  Words, numbers, labels
Correct Answer
C. Numbers, formulas, labels

Explanation
The correct answer is "numbers, formulas, labels." In a spreadsheet, numbers are used to represent numerical data, formulas are used to perform calculations and manipulate data, and labels are used to provide descriptions or titles for data. These three types of data are commonly found and used in spreadsheets for organizing and analyzing information.

Rate this question:
7.
- A.
  
  C2+C3
- B.
  
  D3+C4
- C.
  
  D3+C3
- D.
  
  None of the above
Correct Answer
B. D3+C4
8.
- A.
  
  =$c$3*e3
- B.
  
  =c3*e3
- C.
  
  =$c$3*d3
- D.
  
  24
Correct Answer
A. =$c$3*e3
9.

A constant is another name for this type of data
- A.
  
  Number
- B.
  
  Equation
- C.
  
  Formula
- D.
  
  Description
Correct Answer
A. Number

Explanation
A constant is another name for a fixed value that does not change. In the context of data, a number can be considered a constant because it represents a specific value that remains unchanged. Equations, formulas, and descriptions, on the other hand, are not considered constants as they involve variables or descriptive information that can vary. Therefore, the correct answer is number.

Rate this question:
10.

What are columns in Excel ordinarily labeled with?
- A.
  
  Numbers
- B.
  
  Functions
- C.
  
  Formulas
- D.
  
  Alphabet letters
Correct Answer
D. Alphabet letters

Explanation
Columns in Excel are ordinarily labeled with alphabet letters. Each column is assigned a unique letter starting from A and going up to Z, then continuing with AA, AB, AC, and so on. This labeling system allows users to easily identify and reference specific columns within a worksheet.

Rate this question:
11.

What are rows in Excel ordinarily labeled with?
- A.
  
  Letters of the Alphabet
- B.
  
  Numbers
- C.
  
  Functions
- D.
  
  Formulas
Correct Answer
B. Numbers

Explanation
Rows in Excel are ordinarily labeled with numbers. Each row is identified by a number, starting from 1 and increasing as you move down the spreadsheet. This allows users to easily reference and navigate through different rows in Excel. The letters of the alphabet are used to label columns in Excel, not rows. Functions and formulas are used within cells to perform calculations and manipulate data, but they do not directly label rows.

Rate this question:
12.

Which keyboard shortcut will always take you immediately to the top left corner of your worksheet, no matter where your cell pointer happens to be located?
- A.
  
  Alt + Page Up
- B.
  
  Ctrl + HOME
- C.
  
  HOME
- D.
  
  Shift + Tab
Correct Answer
B. Ctrl + HOME

Explanation
The keyboard shortcut Ctrl + HOME will always take you immediately to the top left corner of your worksheet, regardless of where your cell pointer is located. This shortcut is commonly used to quickly navigate to the beginning of a worksheet, making it easier to access and work with data in the worksheet.

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

Quiz Edited by
ProProfs Editorial Team
Mar 15, 2011

Quiz Created by
Dkintaudi

Success Academy Microsoft Excel Quiz

The advantage of using a spreadsheet is

The intersection of a row and a column is called

When you are typing an equation into a cell the first thing that must be entered is

Labels are used in a spreadsheet to

The cell labeled F5 refers to

There are three types of data found in a spreadsheet

A constant is another name for this type of data

What are columns in Excel ordinarily labeled with?

What are rows in Excel ordinarily labeled with?

Which keyboard shortcut will always take you immediately to the top left corner of your worksheet, no matter where your cell pointer happens to be located?