 |
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".
|
- Applications like Excel are called "Word Processing Software”?
The answer is here
Answer: x
Applications like Excel are called "Spreadsheet Software".
Review: What is Excel?
- To print a table created in Excel, first you should click the File tab?
The answer is here.
- To start Excel, you should right-click the computer's desktop?
The 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
- An Excel worksheet is saved as a "file" on the computer?
The answer is here.
- An Excel worksheet is made up of a collection of workbooks?
The answer is here.
- You can adjust the cell width to the appropriate length by double-clicking?
The answer is here.
- You can select text that you have entered already and make it the table header when using the "Create Table" dialog box?
The answer is here.
- Using the Auto Fill option, you can easily set the color and design of the table?
The answer is here.
- You can change the page orientation when the Print Preview is displayed?
The answer is here.
- In Excel, you can perform calculations and create graphs using data you have entered?
The answer is here.
- Using a proportional font will result in poor visual balance because the width of each character is different?
The 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
- You can repeat the last action by using the "Repeat" function?
The answer is here.
- You always have to check the layout of a worksheet before you actually get to print it?
The answer is here.
Answer: o
Basic page settings are configured from “Page Setup” in the “Page Layout” tab.
Review: Let's print a worksheet
- You can set the background color of a cell from the Border tab on the Format cells dialog box?
The 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
- You can only draw basic shapes such as circles, rectangles, and lines?
The answer is here.
- You can drag the shapes that you created and move them around anywhere in a worksheet?
The answer is here.
- In order to use a formula, you have to first enter the equals sign (=) in a cell?
The answer is here.
- A circular reference is a problem that must always be corrected?
The 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
- Decimal places are preset and are not customizable?
The answer is here.
- You can define different formats for positive and negative numbers?
The answer is here.
- You can control whether to display the gridlines in the printout?
The answer is here.
- You can create your own template by saving it as Excel Template?
The answer is here.
