INTERMEDIATE TO ADVANCED EXCEL

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 Taff1

Taff1

Community Contributor

Quizzes Created: 1 | Total Attempts: 2,946

Questions: 7 | Attempts: 2,949 | Updated: Mar 21, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

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

This is just a little experiment for me to try out the site and for you to check out your Excell skills.

Questions and Answers

1.

You can use text in a formula.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
You may use text in a formula when referring to the name of a range: When A1=2 and is named "Cars", you can enter =CARS+3 and the result will be 5. You may also also use text as a logical answer; Using A1=2, the function =IF(A1>0,"TRUE","FALSE") will result as TRUE.

Rate this question:

2
0
2.

Conditional formatting allows you to restrict what data the user enters into a cell.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
Conditional formatting will change the format of the cell when a condition in the cell is met. Data validation is the tool for restricting what data can be entered into a cell.

Rate this question:
3.

How many data series can be used in a pie chart?
- A.
  
  0
- B.
  
  As many as you want.
- C.
  
  1
- D.
  
  7
Correct Answer
C. 1

Explanation
A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.

Rate this question:
4.

To set up subtotals the data must first be formatted as a table.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The subtotals tool is grayed out and cannot be used unless the table formatting is removed.

Rate this question:
5.

When creating a chart, you should never include total of the data.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
True, if you include the total it will skew the data with one column, pie slice or point being far greater, 50% of all the displayed data combined, with the actual data you are analyzing only distributed over 50% of the chart.

Rate this question:
6.

When sorting, you must highlight the entire column of the column you wish to sort by.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
This is false. If you highlight the entire column, it will only sort the highlighted column changing the data for each record. It is only necessary to select the cell at the top of the column when selecting sort criteria.

Rate this question:

1
0
7.

A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.

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
Dec 08, 2011

Quiz Created by
Taff1

Intermediate To Advanced Excel

You can use text in a formula.

Conditional formatting allows you to restrict what data the user enters into a cell.

How many data series can be used in a pie chart?

To set up subtotals the data must first be formatted as a table.

When creating a chart, you should never include total of the data.

When sorting, you must highlight the entire column of the column you wish to sort by.

A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.