Excel quiz

Excel: Test your current understanding with a quiz

Doctor

Until now, you've learned the basics of Excel. Now, let's test what you've learned about the features and actions of Excel. Don't worry even if you answer some problems incorrectly. It's alright. You'll naturally learn as you use Excel several times.

Read each question. Then, check for the answer by clicking "click here for answer". If text is correct Answer shows "o" if it’s wrong Answer shows "x".

  1. Applications like Excel are called "Word Processing Software”?

ShowThe answer is here

Answer: x   

Applications like Excel are called "Spreadsheet Software".

Review: What is Excel?

  1. To print a table created in Excel, first you should click the File tab?

ShowThe answer is here.

  1. To start Excel, you should right-click the computer's desktop?

ShowThe answer is here.

Answer: x

To start Excel, click Start, and then click Microsoft Office – Microsoft Excel 2010 from All Programs in the Start menu.

Review: Let's start and quit Excel

  1. An Excel worksheet is saved as a "file" on the computer?

ShowThe answer is here.

  1. An Excel worksheet is made up of a collection of workbooks?

ShowThe answer is here.

Answer: x

A workbook is a collection of worksheets.

Review: Let's learn basic worksheet concepts

  1. You can adjust the cell width to the appropriate length by double-clicking?

ShowThe answer is here.

  1. You can select text that you have entered already and make it the table header when using the "Create Table" dialog box?

ShowThe answer is here.

Answer: o

Review: Let's create a table

  1. Using the Auto Fill option, you can easily set the color and design of the table?

ShowThe answer is here.

Answer: x

The Auto Fill option is a feature used when entering a data series.

Review: Let's use the Auto Fill option

  1. You can change the page orientation when the Print Preview is displayed?

ShowThe answer is here.

  1. In Excel, you can perform calculations and create graphs using data you have entered?

ShowThe answer is here.

  1. Using a proportional font will result in poor visual balance because the width of each character is different?

ShowThe answer is here.

Answer: x

Proportional fonts are created by considering the shapes of the characters, and provide good visual balance when the characters are put into lines.

Review: Available font list

  1. You can repeat the last action by using the "Repeat" function?

ShowThe answer is here.

Answer: o

You can repeat the action that you performed last by using the "Repeat" button.

Review: Let's Undo/Redo/Repeat an action

  1. You always have to check the layout of a worksheet before you actually get to print it?

ShowThe answer is here.

Answer: o

Basic page settings are configured from “Page Setup” in the “Page Layout” tab.

Review: Let's print a worksheet

  1. You can set the background color of a cell from the Border tab on the Format cells dialog box?

ShowThe answer is here.

Answer: x

In order to set the background color, you have to choose the Fill tab on the Format cells dialog box.

Review: Let's decorate a cell

  1. You can only draw basic shapes such as circles, rectangles, and lines?

ShowThe answer is here.

Answer: x

In addition to the basic shapes, you can also draw freeform shapes.

Review: Let's draw shapes and connectors

  1. You can drag the shapes that you created and move them around anywhere in a worksheet?

ShowThe answer is here.

  1. In order to use a formula, you have to first enter the equals sign (=) in a cell?

ShowThe answer is here.

  1. A circular reference is a problem that must always be corrected?

ShowThe answer is here.

Answer: x

There are cases where you can make good use of circular reference. In these cases, you need to specify the number of times to iterate the calculation.

Review: Let's correct or use a circular reference

  1. Decimal places are preset and are not customizable?

ShowThe answer is here.

Answer: x

The format code is highly customizable so that you can create or configure your own format.

Review: Let’s learn the basics of the format code.

  1. You can define different formats for positive and negative numbers?

ShowThe answer is here.

  1. You can control whether to display the gridlines in the printout?

ShowThe answer is here.

  1. You can create your own template by saving it as Excel Template?

ShowThe answer is here.

Answer: o

Review: Saving the created worksheet

 
 
Applies to:
Excel 2010, Excel 2007