Microsoft Excel 2007 Test: 4th Grade Quiz!

24 Questions | By Chassan | Last updated: Mar 21, 2022 | Total Attempts: 395

Questions

Settings

Create your own Quiz

Microsoft Excel 2007 Test: 4th Grade Quiz! - Quiz

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.

Questions and Answers

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.
2.

Which way does a COLUMN go?
- A.
  
  Left and Right
- B.
  
  Up and Down
- C.
  
  Corner to Corner
- D.
  
  Circle to Circle
3.

Which way do ROWS go?
- A.
  
  Corner to Corner
- B.
  
  Up and Down
- C.
  
  Left and Right
- D.
  
  Thank you please drive through.
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.
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
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.
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.
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
9.

What do we call it when we combine two or more cells together?
- A.
  
  Copy
- B.
  
  Merge
- C.
  
  Highlight
- D.
  
  Chart
10.

Which of the following is NOT a type of chart?
- A.
  
  Pie
- B.
  
  Bar
- C.
  
  Line
- D.
  
  Zigzag
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
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
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
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
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
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
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
18.

Excel is a program created by who?
- A.
  
  Apple
- B.
  
  Dell
- C.
  
  Microsoft
- D.
  
  Google
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
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
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
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.
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.
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.