# Microsoft Excel 2007 Test: 4th Grade 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.
| By Chassan
C
Chassan
Community Contributor
Quizzes Created: 2 | Total Attempts: 3,432
Questions: 24 | Attempts: 644

Settings

Microsoft Excel 2007 has many features that can’t be taught at one go and are taught progressively throughout our school years. Do you know the basics of how to use an excel sheet? Take up the quiz and refresh your memory on its use.

• 1.

### Which of the following is the CORRECT way to re-size a row or column?

• A.

Move your mouse over the area where the letter or number is until it turns into two arrows, then pull in the direction you want to go.

• B.

Click on the corner of nowhere then drag the mouse down.

• C.

Shake the mouse around in a big circle while saying, "COMPUTER, RESIZE NOW!"

• D.

Move your mouse between the cells until it turns into two arrows, then pull in the direction you want to go.

A. Move your mouse over the area where the letter or number is until it turns into two arrows, then pull in the direction you want to go.
Explanation
To resize a row or column, you need to move your mouse over the area where the letter or number is until it turns into two arrows. Then, you can pull in the direction you want to go. This action allows you to adjust the size of the row or column according to your preference.

Rate this question:

• 2.

### Which way does a COLUMN go?

• A.

Left and Right

• B.

Up and Down

• C.

Corner to Corner

• D.

Circle to Circle

B. Up and Down
Explanation
A column goes up and down because it is a vertical structure that extends from a base to a top point. It is typically used to support weight or provide architectural elegance. The other options mentioned, such as left and right, corner to corner, and circle to circle, do not accurately describe the direction in which a column goes.

Rate this question:

• 3.

### Which way do ROWS go?

• A.

Corner to Corner

• B.

Up and Down

• C.

Left and Right

• D.

C. Left and Right
Explanation
Rows typically go from left to right. This is the standard direction in which rows are arranged, especially in written or printed content.

Rate this question:

• 4.

### When you click the corner of nowhere, what happens?

• A.

All cells are re-sized.

• B.

All cell colors are changed to a different color.

• C.

All cells are copied, same as CTRL + C.

• D.

All cells are highlighted.

D. All cells are highlighted.
Explanation
When you click the corner of nowhere, all cells are highlighted. This means that the selection of cells is expanded to include the entire worksheet. It is a way to quickly select all the cells in the worksheet without having to manually drag the mouse or use keyboard shortcuts.

Rate this question:

• 5.

### Which of the following is a good example of the use of the PIE chart?

• A.

Comparing the Speed of Five Different Cars

• B.

Showing Election Results

• C.

Showing the Growth of Three Different Plants Over the Period of 8 Weeks

• D.

Showing How Much Money is Saved in One Year

B. Showing Election Results
Explanation
A PIE chart is a circular statistical graphic that is divided into slices to represent the proportion of different categories in a whole. Showing election results is a good example of using a PIE chart because it allows for a visual representation of the percentage of votes each candidate received. The chart can easily show the distribution of votes among multiple candidates, making it a clear and effective way to present election data.

Rate this question:

• 6.

### Which of the following is a good example of a line chart?

• A.

Showing election results between three people who ran for President.

• B.

Showing the names and phone numbers of three different people.

• C.

There are no line charts in Excel.

• D.

Showing the savings of four students for a trip over 12 months.

D. Showing the savings of four students for a trip over 12 months.
Explanation
The correct answer is "Showing the savings of four students for a trip over 12 months." A line chart is a type of graph that displays data points connected by line segments, which is suitable for showing the trend or change in data over time. In this example, the line chart would show the savings of four students over a period of 12 months, allowing for a visual representation of how their savings fluctuated over time.

Rate this question:

• 7.

### Which of the following is an example of how you could use AutoSum?

• A.

Creating a pie chart showing the SUM of oranges a farmer has.

• B.

Finding the SUM of the amount of apples a farmer has picked over 12 months.

• C.

Putting an AutoBorder around several cells to make them stand out.

• D.

I don't know.

B. Finding the SUM of the amount of apples a farmer has picked over 12 months.
Explanation
AutoSum is a feature in Excel that automatically calculates the sum of a selected range of cells. In this case, using AutoSum to find the sum of the amount of apples a farmer has picked over 12 months would involve selecting the range of cells containing the monthly apple quantities and clicking on the AutoSum button. This would quickly give the total sum of apples picked over the 12-month period.

Rate this question:

• 8.

### Putting a ________around cells will create a visible line around (or where you specifically want) the cells.

• A.

Border

• B.

Autosum

• C.

Color

• D.

Merge

A. Border
Explanation
Putting a border around cells will create a visible line around (or where you specifically want) the cells. This helps to visually separate and define the boundaries of the cells, making it easier to read and interpret the data within the cells. Borders can be customized in terms of color, thickness, and style to suit the specific formatting needs of the cells.

Rate this question:

• 9.

### What do we call it when we combine two or more cells together?

• A.

Copy

• B.

Merge

• C.

Highlight

• D.

Chart

B. Merge
Explanation
When we combine two or more cells together, it is called merging. Merging cells allows us to create a single cell by combining multiple adjacent cells into one. This can be useful for formatting purposes, such as creating a title that spans across multiple columns or rows.

Rate this question:

• 10.

### Which of the following is NOT a type of chart?

• A.

Pie

• B.

Bar

• C.

Line

• D.

Zigzag

D. Zigzag
Explanation
Zigzag is not a type of chart because it does not represent data in a visual form. Pie, bar, and line charts are commonly used to display data in a visual and organized manner. However, zigzag does not have a specific representation or structure to convey data effectively.

Rate this question:

• 11.

### You are in cell A1.  You type into cell A1 the word "Names" and press ENTER; which cell are you in now?

• A.

A1

• B.

A2

• C.

B1

• D.

B2

B. A2
Explanation
When you type into a cell and press ENTER, the active cell moves down to the cell directly below it. So, after typing "Names" into cell A1 and pressing ENTER, you will be in cell A2.

Rate this question:

• 12.

### Excel would be the best program to use if you wanted to write a large paper for school.

• A.

False

• B.

True

• C.

It depends

• D.

I don't know

A. False
Explanation
Excel is not the best program to use for writing a large paper for school. Excel is primarily used for creating spreadsheets and performing calculations, not for writing lengthy documents. Programs like Microsoft Word or Google Docs are more suitable for writing papers as they provide features like formatting options, spell check, and page layout settings that are specifically designed for writing and editing text.

Rate this question:

• 13.

### Excel would be the best program to create a slide show with pictures of this year's talent show.

• A.

Maybe

• B.

True

• C.

False

• D.

I don't know

C. False
Explanation
Excel is a spreadsheet program and is not designed for creating slide shows with pictures. Programs like PowerPoint or Keynote would be more suitable for this purpose as they are specifically designed for creating presentations with multimedia elements such as pictures.

Rate this question:

• 14.

### Excel would be a good choice for creating a graph showing the different running speeds of various animals.

• A.

True

• B.

False

• C.

Maybe

• D.

I don't know

A. True
Explanation
Excel would be a good choice for creating a graph showing the different running speeds of various animals because Excel is a powerful tool for organizing and analyzing data. It has built-in charting capabilities that allow users to create visually appealing and customizable graphs. With Excel, one can easily input the data for the running speeds of different animals and create a graph that visually represents the differences in their speeds. Additionally, Excel provides various chart types and options to further enhance the graph and present the data in a clear and meaningful way.

Rate this question:

• 15.

### If you wanted to put an image of a puppy in your Excel spreadsheet, which of the following might be a good choice to use to insert a picture of a puppy quickly?

• A.

Clip Art

• B.

Word Art

• C.

Screen Snapshot

• D.

Digital Camera Picture

A. Clip Art
Explanation
Clip art is a good choice to quickly insert a picture of a puppy in an Excel spreadsheet. Clip art refers to pre-made images or illustrations that can be easily inserted into documents. It provides a wide range of ready-to-use pictures, including animals like puppies, making it a convenient option for adding visuals to a spreadsheet without the need for external sources or tools. Word art, screen snapshots, and digital camera pictures are not specifically designed for quick insertion of images and may require additional steps or equipment.

Rate this question:

• 16.

### You want to create a seating chart of many 4th grade classes using Excel.  You do NOT want to open Excel more than once.  What can you use to put all of your seating charts into one Excel file?

• A.

Sheets

• B.

Pillows

• C.

Tabs

• D.

Windows

A. Sheets
Explanation
To create a seating chart of multiple 4th grade classes using Excel without opening it more than once, you can use "Sheets." Sheets is a feature in Excel that allows you to create multiple worksheets within a single Excel file. Each sheet can be dedicated to a specific class, making it convenient to organize and manage the seating charts for all the classes in one file.

Rate this question:

• 17.

### What AutoSum function might you use if you wanted to know a general idea of the test scores in 4B?

• A.

Average

• B.

Sum

• C.

Divide

• D.

Multiply

A. Average
Explanation
To get a general idea of the test scores in 4B, the AutoSum function that should be used is "Average". This function calculates the average or mean of a set of numbers. By using the Average function, the total test scores in 4B can be divided by the number of scores to determine the average score, which gives a general idea of the overall performance in the class.

Rate this question:

• 18.

### Excel is a program created by who?

• A.

Apple

• B.

Dell

• C.

Microsoft

• D.

C. Microsoft
Explanation
Excel is a program created by Microsoft. Microsoft is a renowned technology company that has developed various software products, including Excel. Excel is a widely used spreadsheet program that allows users to perform calculations, create tables, and analyze data. It is a part of the Microsoft Office suite and is known for its powerful features and user-friendly interface.

Rate this question:

• 19.

### OH NO!  You just accidentally deleted ALL of your work you were doing; how might you immediately fix this?

• A.

Save Button

• B.

Fix Button

• C.

Redo Button

• D.

Undo Button

D. Undo Button
Explanation
The Undo Button allows you to reverse the most recent action, in this case, deleting all of your work. By clicking the Undo Button, you can restore the deleted work and fix the mistake immediately.

Rate this question:

• 20.

### Columns are labeled as ________________________ and rows are labeled as _______________.

• A.

They are all the same

• B.

Letter with a number

• C.

Numbers; letters

• D.

Letters; numbers

D. Letters; numbers
Explanation
The correct answer is "letters; numbers". This means that the columns in the given context are labeled with letters, while the rows are labeled with numbers.

Rate this question:

• 21.

### ________________is a way to organize information in Excel by lining words up from A to Z or Z to A.

• A.

Lining Up

• B.

Organizing

• C.

Alphabetizing

• D.

Sorting

D. Sorting
Explanation
Sorting is a way to organize information in Excel by lining words up from A to Z or Z to A. It arranges the data in a specific order based on the selected column, either in ascending (A to Z) or descending (Z to A) order. This helps in easily locating and analyzing the data in a systematic manner.

Rate this question:

• 22.

### We use cell styles to do what?

• A.

Easily set a quick look (color, size, etc.) for a cell.

• B.

Easily set a quick AutoSum for a cell.

• C.

Quickly set bold only on a cell.

• D.

To put certain words or numbers into a cell.

A. Easily set a quick look (color, size, etc.) for a cell.
Explanation
Cell styles are used to easily set a quick look for a cell, including color, size, and other formatting options. By applying a cell style, users can quickly customize the appearance of a cell without manually adjusting each formatting attribute individually. This saves time and ensures consistency throughout a spreadsheet.

Rate this question:

• 23.

### What is a good example of conditional formatting?

• A.

Coloring test score cells according to grades.

• B.

Coloring a certain cell a certain color depending on you feel at that point in time.

• C.

Automatically resizing cells as needed.

• D.

Excel does not have such a feature.

A. Coloring test score cells according to grades.
Explanation
Conditional formatting is a feature in Excel that allows users to apply formatting to cells based on specific conditions or criteria. In this case, coloring test score cells according to grades would be a good example of conditional formatting. For example, if the score is above a certain threshold, the cell could be colored green to indicate a high grade, while a score below the threshold could be colored red to indicate a low grade. This helps to visually highlight and differentiate different levels of performance.

Rate this question:

• 24.

### In ROW 5 you have three cells with some numbers in them.  Let's say you click on ROW 5 at the left and then press the BOLD button, what will happen to the numbers in ROW 3?

• A.

They will become bold since a row was highlighted.

• B.

Nothing, because ROW 5 is highlighted only.

• C.

Nothing, because ROW 4 is highlighted only.

• D.

It is not possible to click on a row from the left.

B. Nothing, because ROW 5 is highlighted only.
Explanation
Clicking on ROW 5 and pressing the BOLD button will only affect the cells in ROW 5. The numbers in ROW 3 will not become bold because ROW 3 is not highlighted.

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
• Nov 10, 2009
Quiz Created by
Chassan

Related Topics