Microsoft Excel Proficiency Test

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Coolhausworks

Coolhausworks

Community Contributor

Quizzes Created: 2 | Total Attempts: 665

| Attempts: 263

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

1/122 Questions

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
- B1-G10
- B1.G10
- B1;G10
- B1:G10

About This Quiz

This quiz is created to identify the proficiency of users about Microsoft Excel.

Quiz Preview

2.

You can modify an exisiting chart?
- True
- False
Correct Answer

A. True

Explanation

The statement suggests that it is possible to make changes or alterations to an existing chart.

Rate this question:
3.

Which number formatting style adds the dollar signs and commas to values?
- Comma
- Currency
- Percent
- AdjustDecimal
Correct Answer

A. Currency

Explanation

The currency number formatting style adds dollar signs and commas to values. This formatting is commonly used when working with monetary values to make them easier to read and understand. By adding the dollar sign, it indicates that the value represents a specific amount of currency. The commas are used to separate thousands, millions, and so on, making large numbers more manageable and visually appealing.

Rate this question:
4.

A worksheet is..
- A symbol that represents a specific action
- Refers to the change a formula makes when it is moved or copied to other cells with different data
- A table of data that is organized into rows and columns
Correct Answer

A. A table of data that is organized into rows and columns

Explanation

A worksheet refers to a table of data that is organized into rows and columns. It is a document where data can be entered, manipulated, and analyzed. Worksheets are commonly used in spreadsheet software, such as Microsoft Excel, to perform calculations, create charts, and present data in a structured format.

Rate this question:
5.

To add two cells (A1 and A2) together you use the following formula
- =A1+A2
- =Add(A1+A2)
- =together(A1:A2)
- A1 plus A2
Correct Answer

A. =A1+A2

Explanation

The correct answer is "=A1+A2". This formula is used to add the values in cells A1 and A2 together. The "+" symbol is the mathematical operator for addition in Excel, and by using it between the cell references A1 and A2, the sum of their values is calculated.

Rate this question:
6.

When using Excel 2007 which sign is used to create a formula or function in a cell?
- Single Quotes
- Double Quotes
- Equal Sign
- Parentheses
Correct Answer

A. Equal Sign

Explanation

In Excel 2007, the equal sign (=) is used to create a formula or function in a cell. This sign is necessary to indicate that the content of the cell is a formula and needs to be calculated. By using the equal sign, Excel knows to interpret the text in the cell as a mathematical expression or a function that should be executed. Without the equal sign, Excel will treat the content as plain text.

Rate this question:
7.

What is the function of the autofit ?
- A symbol that represents a specific action
- A way of arranging data in a particular order
- Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
Correct Answer

A. Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

Explanation

Autofit is a feature that automatically adjusts the width of a column to accommodate the longest entry or the height of a row to fit the font. This ensures that all the data in a spreadsheet is visible and properly formatted, without any text being cut off or hidden. It saves time and effort by automatically resizing the columns or rows to optimize the display of data.

Rate this question:
8.

Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?
- Show Detail
- Refresh Data
- Show Detail
- Group
Correct Answer

A. Refresh Data

Explanation

The Refresh Data button is used to update the data in a PivotTable if any changes have been made. This button allows users to refresh the PivotTable with the most current data from the data source. By clicking on the Refresh Data button, any new or updated data will be pulled into the PivotTable, ensuring that the information displayed is accurate and up to date.

Rate this question:
9.

The divide symbol is
- /
- D
- \
- )
Correct Answer

A. /

Explanation

The correct answer is "/". The divide symbol is commonly represented by a forward slash (/) in mathematics and computer programming. It is used to indicate the division operation between two numbers, where the number before the slash is divided by the number after the slash. For example, 10 / 2 means dividing 10 by 2, resulting in a quotient of 5.

Rate this question:
10.

How would you print formulas?
- Click the Microsoft Office Button and then click Print.
- Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.
- Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.
Correct Answer

A. Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.
11.

When a worksheet is printed, the grid lines that surround the cells are printable by default.
- True
- False
Correct Answer

A. False

Explanation

By default, when a worksheet is printed, the grid lines that surround the cells are not printable. This means that when you print a worksheet, only the content within the cells will be printed without the grid lines. However, it is possible to change this default setting and make the grid lines printable if desired.

Rate this question:
12.

You can create maximum one Excel table in a worksheet
- True
- False
Correct Answer

A. False

Explanation

The statement is false because you can create multiple Excel tables in a worksheet. Excel allows users to create multiple tables in a single worksheet, each with its own set of columns and rows. This feature is useful when organizing and analyzing different sets of data within the same worksheet.

Rate this question:
13.

Microsoft Excel 2007 is a ___________________?
- Word Processing Package
- Graphics Package
- Spreadsheets Package
- Multimedia Package
- None of the above
Correct Answer

A. Spreadsheets Package

Explanation

Microsoft Excel 2007 is a spreadsheets package. This software is specifically designed for creating, editing, and analyzing spreadsheets. It allows users to input and manipulate data, perform calculations, create charts and graphs, and organize information in a tabular format. Microsoft Excel is widely used in various industries and professions for financial analysis, data management, budgeting, and other tasks that involve organizing and analyzing numerical data.

Rate this question:
14.

Graphics objects on a chart are used to
- Add emphasis to chart data
- Add interest to a chart
- Help explain the chart data
- All of Above
Correct Answer

A. All of Above

Explanation

Graphics objects on a chart are used to add emphasis to chart data, add interest to a chart, and help explain the chart data. These objects can include things like shapes, images, and icons that are strategically placed on the chart to draw attention to specific data points or highlight important information. By using graphics objects, the chart becomes more visually appealing and easier to understand for the audience.

Rate this question:
15.

You cannot insert comments on each cell.
- True
- False
Correct Answer

A. False

Explanation

The given statement is false because you can indeed insert comments on each cell in certain applications or software, such as Microsoft Excel or Google Sheets. Comments can be added to provide additional information or context about the data in a particular cell, allowing users to add notes or explanations for themselves or others who may be viewing or editing the spreadsheet.

Rate this question:
16.

The cell labeled F5 refers to
- Row F column 5
- Column F row 5
- Functions available in cells
- Function key F4
Correct Answer

A. Column F row 5

Explanation

The cell labeled F5 refers to the intersection of column F and row 5 in a spreadsheet. In a spreadsheet, cells are organized in a grid with columns labeled alphabetically and rows labeled numerically. Therefore, when referring to a specific cell, the column letter is mentioned first followed by the row number. In this case, F5 refers to the cell in column F and row 5.

Rate this question:
17.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
- True
- False
Correct Answer

A. True

Explanation

Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the user to quickly arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or using more complex sorting methods, making it a convenient option for simple data sorting tasks.

Rate this question:
18.

You can use a spreadsheets package like the Microsoft Excel To _________________
- Design speadsheets models.
- Create charts.
- Perform mathematical operations
- All of the above
Correct Answer

A. All of the above

Explanation

A spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. It offers various functionalities that allow users to organize and analyze data effectively.

Rate this question:
19.

As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
- True
- False
Correct Answer

A. True

Explanation

When you start typing a function name within a formula in a cell, a list of functions that begin with the letters you typed will appear. This feature is designed to help users easily find and select the desired function without having to remember the exact syntax or name of the function. It saves time and reduces the chances of errors in formula creation.

Rate this question:
20.

The _________________ displays the name of the sheets in the workbook.
- Sheet Tabs
- Book Tabs
- Menu Bar
Correct Answer

A. Sheet Tabs

Explanation

The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook. By clicking on a specific sheet tab, users can quickly access and view the content of that particular sheet. The sheet tabs are located at the bottom of the workbook interface, making it convenient for users to switch between sheets without having to search through menus or toolbars.

Rate this question:
21.

Once data is entered into a cell, can it be edited after saving the file?
- Yes, but it has to be saved as a different file name.
- No, once it is saved it cannot be changed.
- Yes, even after saving the file, double click on the cell where data is to be changed to edit
Correct Answer

A. Yes, even after saving the file, double click on the cell where data is to be changed to edit

Explanation

After saving the file, the data entered into a cell can still be edited by double-clicking on the cell. This action allows the user to make changes to the data without having to save the file as a different name.

Rate this question:
22.

Which of Excel’s ribbon tabs is shown in the figure below?
- Review
- Home
- Data
- View
Correct Answer

A. Data

Explanation

The figure below shows the ribbon tabs in Excel, and the tab that is highlighted is the "Data" tab. This tab is used for managing and analyzing data in Excel, including functions related to sorting, filtering, and data analysis.

Rate this question:
23.

You can print
- A range of cells by range name
- An entire workbook
- A single worksheet
- All of the above
Correct Answer

A. All of the above

Explanation

The correct answer is "All of the above" because you can print a range of cells by range name, an entire workbook, or a single worksheet. This means that you have the flexibility to choose what you want to print based on your specific needs.

Rate this question:
24.

The function arguments dialog box tells you how to use functions.
- True
- False
Correct Answer

A. True

Explanation

The function arguments dialog box provides information on how to use functions. It likely includes details such as the number and type of arguments required, as well as any additional parameters or options that can be used. This information helps users understand how to properly utilize functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.

Rate this question:
25.

Once you hide a row, it remains hidden as long as the workbook is active.
- True
- False
Correct Answer

A. True

Explanation

When you hide a row in a workbook, it will stay hidden until the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only time the row will be visible again is when you have the workbook open and active.

Rate this question:
26.

A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
- Go to file - save as - save as type - excel 4.0 worksheet
- Right click on the worksheet tab and select delete
- Right click on the worksheet and select insert - entire column
Correct Answer

A. Right click on the worksheet tab and select delete

Explanation

To remove a worksheet from a workbook, the correct sequence of events is to right click on the worksheet tab and select delete. This action will delete the selected worksheet from the workbook.

Rate this question:
27.

To select several cells or ranges that are not touching each other, you would _____ while selecting
- Hold down the CTRL key
- Hold down the SHIFT key
- Hold down the ALT key
Correct Answer

A. Hold down the CTRL key

Explanation

To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. This key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. By holding down the CTRL key, you can add or remove cells from the selection without losing the previously selected ones. This is useful when you want to perform operations on multiple separate areas of a spreadsheet without having to select them all at once.

Rate this question:
28.

What is a Workbook?
- A table of data that is organized into rows and columns
- The Excel file that holds your worksheets
- A built-in formula in Excel
Correct Answer

A. The Excel file that holds your worksheets

Explanation

A workbook refers to the Excel file that holds your worksheets. In Excel, a workbook can contain multiple worksheets, each of which can have its own set of data and calculations. It serves as the container for all the data, formulas, and formatting within Excel.

Rate this question:
29.

A Range in Microsoft Excel refers to...
- A group of cells
- A calculation that describes the relationship between cells
- A way of arranging data in a particular order
Correct Answer

A. A group of cells

Explanation

A range in Microsoft Excel refers to a group of cells. This means that multiple cells are selected and grouped together to form a range. This allows users to perform operations or calculations on multiple cells simultaneously, making it easier to manipulate and analyze data in Excel. Ranges can be used for various purposes such as entering data, applying formatting, or performing calculations using formulas or functions.

Rate this question:
30.

What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?
- Matrix
- Window
- Sheet
- Cell
Correct Answer

A. Cell

Explanation

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell. A cell is the basic unit of a spreadsheet and is identified by a unique address, such as A1 or C3. It can contain data, formulas, or functions and is used for organizing and manipulating information in Excel.

Rate this question:
31.

Rows are identified by a _______________________
- Cell
- Column
- Number
Correct Answer

A. Number

Explanation

Rows in a table are identified by a number. Each row is assigned a unique number to differentiate it from other rows in the table. This number serves as a reference point to access or manipulate specific rows of data in the table.

Rate this question:
32.

Which is not an advantage of using computerized spreadsheets?
- Flexibility of moving entries
- Speed of calculation
- Ability of generate tables
- Cost of initial setup
Correct Answer

A. Cost of initial setup

Explanation

The cost of initial setup is not an advantage of using computerized spreadsheets. This means that setting up a computerized spreadsheet can be expensive compared to other advantages such as flexibility of moving entries, speed of calculation, and ability to generate tables.

Rate this question:
33.

What is a Chart?
- It is a visual way to display and compare data
- A way of arranging data in a particular order
- A calculation that describes the relationship between cells
Correct Answer

A. It is a visual way to display and compare data

Explanation

A chart is a visual representation of data that allows for easy comparison and analysis. It uses different types of graphs, such as bar charts or line graphs, to present data in a clear and organized manner. By visually displaying data, charts make it easier to identify patterns, trends, and relationships between different data points. They are commonly used in presentations, reports, and data analysis to effectively communicate information to an audience.

Rate this question:
34.

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?
- Ribbon
- Formula Bar
- Tab
Correct Answer

A. Ribbon

Explanation

The ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and contains multiple tabs, each representing a different set of commands related to specific functions or features in Excel. The ribbon provides easy access to various tools and options for creating, formatting, and manipulating data in Excel.

Rate this question:
35.

in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
- Letters
- Cell references
- Symbols
- Operators
Correct Answer

A. Cell references

Explanation

The correct answer is "Cell references". In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers inside the parentheses can be either actual numbers or cell references. Cell references allow you to perform calculations using the values stored in specific cells, making it easier to update and modify calculations without changing the formula itself.

Rate this question:
36.

Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?
- Headers
- Filter
- Freeze Panes
- Data Validation
Correct Answer

A. Freeze Panes

Explanation

Freeze Panes is a feature in Excel 2007 that allows users to keep specific rows or columns visible at all times while scrolling through the sheet. This is useful when working with large datasets or tables, as it allows users to easily reference important information in the frozen rows or columns without losing sight of them. By freezing panes, users can improve their productivity and efficiency when navigating and analyzing data in Excel.

Rate this question:
37.

On an Excel spreadsheet the active cell is indicated by
- A dark wide border
- A dotted border
- A blinking border
- None of the above
Correct Answer

A. A dark wide border

Explanation

The active cell on an Excel spreadsheet is indicated by a dark wide border. This border helps the user easily identify which cell is currently selected and ready for data entry or manipulation. The other options, such as a dotted border or a blinking border, are not typically used to indicate the active cell in Excel.

Rate this question:
38.

Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?
- =ADD(J1-J8)
- =SUM(J1:J8)
- =J:1+J:8
- =SUM J:1-8
Correct Answer

A. =SUM(J1:J8)

Explanation

The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to find the sum of a range of cells. In this case, it is specifying the range as column J between rows 1 and 8, which is J1:J8. This formula will add up the values in those cells and give the total sum.

Rate this question:
39.

Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.
- True
- False
Correct Answer

A. True

Explanation

3D charts can indeed be visually attractive, but they can also make it difficult to accurately interpret the values in the chart. This is because the use of three dimensions can obscure the relationship between the different slices or data points. In particular, it can be challenging to determine which slice is larger or smaller when viewing a 3D chart. Therefore, the statement that 3D charts can obscure the relationship between values is true.

Rate this question:
40.

One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?
- Template
- Excel 97-2003 Workbook (*.xls)
- CSV
- HTML
Correct Answer

A. Excel 97-2003 Workbook (*.xls)

Explanation

To ensure that all users, regardless of the version of Excel they are using, can open and edit the file, you should save it as an Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing all users to access and edit the file without any compatibility issues.

Rate this question:
41.

A Function is?
- A symbol that represents a specific action
- A way of arranging data in a particular order
- A built-in formula in Excel
Correct Answer

A. A built-in formula in Excel

Explanation

A function is a built-in formula in Excel that performs a specific action or calculation on data. It is a predefined formula that simplifies complex calculations and allows users to perform various tasks such as mathematical calculations, logical operations, text manipulation, and more. Functions in Excel are represented by symbols and can be used to manipulate and analyze data in a specific way.

Rate this question:
42.

Which of the following keys/key can be used to check spelling and grammar?
- F1
- Ctrl-End
- F7
- Crt-Home
Correct Answer

A. F7

Explanation

F7 can be used to check spelling and grammar. This key is commonly used in word processing software such as Microsoft Word. Pressing F7 will initiate a spell check and grammar check, highlighting any errors or inconsistencies in the text. This feature is useful for ensuring that written content is free from spelling mistakes and grammatical errors.

Rate this question:
43.

What does the LEN() function do?
- Deletes Trailing spaces
- Splits the Cell contents
- Counts the number of characters in a cell
- All of the choices
Correct Answer

A. Counts the number of characters in a cell

Explanation

The LEN() function is used to count the number of characters in a cell. It does not delete trailing spaces or split the cell contents. Therefore, the correct answer is "Counts the number of characters in a cell."

Rate this question:
44.

You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?
- True
- False
Correct Answer

A. True

Explanation

This statement is true because Excel has a feature called "Data Connection" that allows users to connect to various data sources, including database tables. Once the connection is established, users can import the data into an Excel worksheet. By setting up automatic data refresh options, users can easily update the data in the worksheet with just one click, ensuring that the results are always up to date.

Rate this question:
45.

After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.
- Shift
- Tab
- Esc
- Alt
Correct Answer

A. Tab

Explanation

After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This means that the entry will be selected and the cursor will move to the next cell in the column, allowing the user to continue entering data without having to manually select the next cell.

Rate this question:
46.

If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:
- Abbreviate all text
- Reduce the font size to 8 pt
- Click Wrap text
- Delete one column
Correct Answer

A. Click Wrap text

Explanation

If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to click Wrap text. This will automatically adjust the height of the cells to fit the content, allowing all text to be visible without losing any data.

Rate this question:
47.

__________________ is the vertical part of the spreadsheet.
- Row
- Cell
- Columns
Correct Answer

A. Columns

Explanation

Columns refer to the vertical part of a spreadsheet. In a spreadsheet, data is organized into rows and columns, with columns running vertically from top to bottom. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to categorize and organize data in a spreadsheet, allowing users to easily enter and manipulate data in a structured manner.

Rate this question:
48.

Which of the following functions is correctly written?
- =IF(B2>50000,"rich","poor")
- =IF(B2>50000."rich","poor")
- IF(B2>50000,rich,poor)
- =IF(B2>50000),"rich","poor"))
Correct Answer

A. =IF(B2>50000,"rich","poor")

Explanation

The correct answer is =IF(B2>50000,"rich","poor"). This is the correct syntax for the IF function in Excel. The function checks if the value in cell B2 is greater than 50000. If it is, it returns the text "rich", otherwise it returns the text "poor".

Rate this question:
49.

Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?
- Data
- Review
- Preview
- Home
Correct Answer

A. Review

Explanation

The Review tab in Excel 2007 allows you to check spelling, add a comment, or protect your workbook. This tab provides various tools and options for reviewing and editing your spreadsheet, such as spell check, comments, and workbook protection.

Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 20, 2023

Quiz Edited by
ProProfs Editorial Team
Jun 29, 2015

Quiz Created by
Coolhausworks

Microsoft Excel Proficiency Test

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.

Quiz Preview

You can modify an exisiting chart?

Which number formatting style adds the dollar signs and commas to values?

A worksheet is..

To add two cells (A1 and A2) together you use the following formula

When using Excel 2007 which sign is used to create a formula or function in a cell?

What is the function of the autofit ?

Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?

The divide symbol is

How would you print formulas?

When a worksheet is printed, the grid lines that surround the cells are printable by default.

You can create maximum one Excel table in a worksheet

Microsoft Excel 2007 is a ___________________?

Graphics objects on a chart are used to

You cannot insert comments on each cell.

The cell labeled F5 refers to

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

You can use a spreadsheets package like the Microsoft Excel To _________________

As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.

The _________________ displays the name of the sheets in the workbook.

Once data is entered into a cell, can it be edited after saving the file?

Which of Excel’s ribbon tabs is shown in the figure below?

You can print

The function arguments dialog box tells you how to use functions.

Once you hide a row, it remains hidden as long as the workbook is active.

A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?

To select several cells or ranges that are not touching each other, you would _____ while selecting

What is a Workbook?

A Range in Microsoft Excel refers to...

What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?

Rows are identified by a _______________________

Which is not an advantage of using computerized spreadsheets?

What is a Chart?

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?

in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.

Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?

On an Excel spreadsheet the active cell is indicated by

Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?

Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.

One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?

A Function is?

Which of the following keys/key can be used to check spelling and grammar?

What does the LEN() function do?

You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?

After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.

If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:

__________________ is the vertical part of the spreadsheet.

Which of the following functions is correctly written?

Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?