Identify The Proficiency Of Microsoft Excel Quiz

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 Lopeze761

Lopeze761

Community Contributor

Quizzes Created: 1 | Total Attempts: 180

| Attempts: 190

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

1/122 Questions

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

Identify The Proficiency Of Microsoft Excel Quiz - Quiz

About This Quiz

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

Quiz Preview

2.

The Insert Function dialog box tells you how to use functions.
- True
- False
Correct Answer

A. True

Explanation

The Insert Function dialog box provides instructions on how to use functions. It guides users on the steps to follow in order to correctly utilize functions in their calculations or formulas. This can be helpful for users who are not familiar with the specific syntax or parameters required for a particular function. By providing guidance and instructions, the Insert Function dialog box assists users in effectively using functions in their work.

Rate this question:
3.

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
- True
- False
Correct Answer

A. True

Explanation

The statement is true because when adding a record to a table, it is common practice to enter the data in the first blank row. This ensures that the data is organized sequentially and makes it easier to locate and manage the records. By entering the data in the first blank row, it also avoids any potential conflicts or overwriting of existing data in the table.

Rate this question:
4.

In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets.
- True
- False
Correct Answer

A. False

Explanation

In Excel, charts can remain linked or connected to the data sources even if they appear in different worksheets. This can be achieved by selecting the chart, going to the "Design" tab, and clicking on "Select Data". From there, you can update the data range for the chart to ensure it is linked to the correct data source. Therefore, the statement that charts do not remain linked or connected to the data sources if they appear in different worksheets is false.

Rate this question:
5.

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 remain hidden as long as the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only way to make the row visible again is to unhide it manually. Therefore, the statement is true.

Rate this question:
6.

Formatting data only change the appearance of data, it does not affect the data itself.
- True
- False
Correct Answer

A. True

Explanation

Formatting data refers to changing the way data is displayed, such as changing the font, color, or alignment. This does not alter the actual content or value of the data. For example, if a number is formatted to display with two decimal places, it does not change the actual value of the number. Similarly, if text is formatted to be bold or italic, it does not change the actual text itself. Therefore, formatting data only affects the visual representation of the data and does not impact the underlying data itself.

Rate this question:
7.

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 organize the data in either ascending (A to Z) or descending (Z to A) order based on the selected sort field. This eliminates the need for manual sorting and makes the process more efficient. Therefore, the statement "True" accurately reflects the given explanation.

Rate this question:
8.

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 you to create multiple tables within a single worksheet to organize and analyze data in different ways. Each table can have its own set of columns and rows, and you can apply different formatting and calculations to each table independently. This feature is useful when you have multiple sets of data that you want to manage separately within the same worksheet.

Rate this question:
9.

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 start with the letters you have typed will appear. This feature is available in most spreadsheet software, such as Microsoft Excel and Google Sheets, to assist users in quickly finding and selecting the desired function without having to remember the exact name or syntax.

Rate this question:
10.

What function offers you the possibility to view different results depending on the entered condition?
- =If()
- =Sum()
- =SumIf()
Correct Answer

A. =If()

Explanation

The IF() function offers the possibility to view different results depending on the entered condition. It allows you to specify a condition and provides two possible outcomes based on whether the condition is true or false. This function is commonly used in Excel and other spreadsheet programs to perform logical tests and make decisions based on the results.

Rate this question:
11.

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, data entered into a cell can still be edited by double-clicking on the cell. This allows the user to make changes to the data even after the file has been saved.

Rate this question:
12.

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 users easily identify which cell is currently selected and ready for input or editing. The other options, such as a dotted border or a blinking border, are not commonly used to indicate the active cell in Excel.

Rate this question:
13.

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 can be selected and manipulated together as a single unit. Ranges are commonly used for performing calculations, applying formatting, or entering data across a specific set of cells. By selecting a range, users can easily perform operations on multiple cells simultaneously, saving time and effort.

Rate this question:
14.

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 is a table of data that is organized into rows and columns. It is a tool used in spreadsheet programs, such as Microsoft Excel, to store and manipulate data. Worksheets allow users to input and organize data in a structured manner, making it easier to analyze and perform calculations on the data. The rows and columns provide a grid-like structure that helps in organizing and referencing the data effectively.

Rate this question:
15.

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 that allows for the display and comparison of data. It provides a visual way to present information in a clear and organized manner, making it easier to understand and analyze. Charts can be used to show trends, patterns, and relationships between different data points, making it a valuable tool for data analysis and decision-making.

Rate this question:
16.

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

Pressing the Tab key allows you to accept the existing entry in the column that matches the characters you have typed in Excel. This key is used to move to the next cell in the row, and when an existing entry matches the characters you have typed, pressing Tab confirms and accepts that entry.

Rate this question:
17.

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 spreadsheets models, create charts, and perform mathematical operations. It provides a wide range of functions and features that allow users to organize and analyze data efficiently. With the ability to input data, apply formulas, and generate visual representations, Excel is a versatile tool for various tasks related to data manipulation and analysis.

Rate this question:
18.

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 the correct answer because it allows users to keep certain rows or columns visible while scrolling through the rest of the sheet. This feature is useful when working with large datasets or when needing to reference specific information in a spreadsheet without losing sight of it. By freezing panes, users can easily navigate through the sheet while keeping important information in view.

Rate this question:
19.

Which of the following would you use in an Excel formula to reference the cell located at column G row 17?
- G(17)
- G17
- Cgr17
- A cell is a dynamic value and cannot be referenced in a formula.
Correct Answer

A. G17

Explanation

In Excel, to reference a specific cell, you need to use the column letter followed by the row number. In this case, "G17" is the correct answer as it refers to the cell located at column G and row 17.

Rate this question:
20.

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.

Rate this question:
21.

What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2
- Multiply the value in A1 by the value in A2
- Raise the value in cell A1 to the power of A2
- Change cell values in A1 and A2 to text
- Compare the values in A1 and A2 and display the larger one
Correct Answer

A. Raise the value in cell A1 to the power of A2

Explanation

The formula "=A1^A2" in an Excel spreadsheet would raise the value in cell A1 to the power of A2.

Rate this question:
22.

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 add up a range of cells. In this case, it is specifying the range from cell J1 to J8, which means it will sum the values in all the cells in column J between rows 1 and 8.

Rate this question:
23.

When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.
- Formula
- Name Box
- Title bar
Correct Answer

A. Formula

Explanation

When a formula is written in a cell, it appears in the active cell where it is being written and in the formula bar as well. The formula bar displays the formula that is entered in the active cell, allowing users to view and edit the formula easily. This feature helps users keep track of the formulas they have entered and make any necessary changes.

Rate this question:
24.

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.

Rate this question:
25.

A Logical test in Excel can contain =, >=, <=, >,<, <>, $
- All Except $
- All Except
- All Except =
- All Except >=
Correct Answer

A. All Except $

Explanation

The correct answer is "All Except $". This means that all of the logical test operators listed in the question are valid except for the "$" symbol. The "$" symbol is not a valid operator for logical tests in Excel.

Rate this question:
26.

Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
- =AND()
- =NOT()
- =OR()
- =COUNT()
Correct Answer

A. =COUNT()

Explanation

A formula with the COUNT() function does not show the words "TRUE" or "FALSE" as a result. The COUNT() function is used to count the number of cells in a range that contain numbers. Therefore, it does not produce a logical result of "TRUE" or "FALSE" like the other logical functions such as AND(), NOT(), or OR().

Rate this question:
27.

What function would you use to display today's date so that tomorrow it will updates automatically
- =TODAY()
- =[date]
- =[system date]
- =datevalue()
Correct Answer

A. =TODAY()

Explanation

The correct answer is =TODAY(). This function is used to display today's date, and it automatically updates to the current date every time the spreadsheet is opened or recalculated. Therefore, if you use this function to display today's date, it will automatically update to tomorrow's date when the new day begins.

Rate this question:
28.

What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?
- Goal Seek
- Forcasting
- TrendLine
- Scenario Summary
Correct Answer

A. Goal Seek

Explanation

Goal Seek is a feature in Excel that allows users to adjust the value in a cell in order to achieve a desired outcome or result. It is commonly used in financial modeling or data analysis to find the input value needed to reach a specific goal. By specifying a target value and changing a specific cell, Goal Seek iteratively calculates the value needed to achieve the desired result. This feature is helpful for scenario analysis, sensitivity analysis, and decision-making processes.

Rate this question:
29.

A function inside another function is called a _____________ function.
- Nested
- Round
- Complex
- None of the above
Correct Answer

A. Nested

Explanation

A function inside another function is called a nested function because it is enclosed within the scope of the outer function. This allows the nested function to access variables and parameters from the outer function, creating a hierarchical structure. The nesting of functions can be useful for organizing code and creating modular and reusable components.

Rate this question:
30.

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

A. /

Explanation

The divide symbol is represented by the forward slash (/). It is commonly used in mathematics to indicate division between two numbers or quantities. The forward slash is a widely recognized symbol for division and is used in mathematical equations and expressions to separate the numerator and denominator.

Rate this question:
31.

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 the statement implies that 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 needs.

Rate this question:
32.

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. By incorporating graphics objects such as colors, shapes, and images, the chart becomes more visually appealing and engaging. These elements can also be strategically placed to highlight important data points or trends, making it easier for viewers to understand and interpret the information presented in the chart. Therefore, all of the given options are correct.

Rate this question:
33.

Which function converts miles to kilometers, kilograms to pounds, and so on?
- Convert
- Product
- Change
- All of above
Correct Answer

A. Convert

Explanation

The function "Convert" is the correct answer because it is a general term used to describe the action of converting one unit of measurement to another. In this case, it can be used to convert miles to kilometers, kilograms to pounds, and other similar conversions. The other options, "Product" and "Change," do not specifically refer to the act of conversion. The option "All of above" is incorrect because it includes options that are not related to conversion.

Rate this question:
34.

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

A. True

Explanation

This statement is true because in most charting software or applications, you have the ability to modify an existing chart. This can include changing the chart type, adding or removing data series, adjusting the formatting, and updating the chart title or axis labels. Modifying an existing chart allows you to make updates or improvements to the visual representation of your data without having to recreate the entire chart from scratch.

Rate this question:
35.

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 displaying monetary values to make them more readable and standardized. The dollar sign indicates the currency symbol, while the commas are used to separate thousands, millions, and so on. This formatting style helps to improve clarity and ease of understanding when dealing with financial data.

Rate this question:
36.

Excel has a builtin format to display 4 digit year values, so you do not need to create one.
- True
- False
Correct Answer

A. True

Explanation

Excel does have a built-in format to display 4 digit year values, which means that users do not need to create their own format. This format can be easily applied to any cell or range of cells containing year values, saving time and effort for the user. Therefore, the statement is true.

Rate this question:
37.

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. By starting a cell entry with an equal sign, Excel recognizes that it is a formula or function and evaluates it accordingly. The equal sign is the key symbol that indicates to Excel that a calculation or operation needs to be performed.

Rate this question:
38.

Columns are identified by a _______________ .
- Letter
- Number
- Word
Correct Answer

A. Letter

Explanation

Columns are identified by a letter in many systems and formats, such as spreadsheets or databases. Each column is typically assigned a unique letter as its identifier, which allows for easy reference and organization of data. This letter-based identification system is commonly used because it provides a clear and concise way to distinguish between different columns in a table or dataset.

Rate this question:
39.

Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- Count
- Average
- Sum
Correct Answer

A. Sum

Explanation

The formula that can add all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the SUM formula. The SUM formula adds up all the numbers in a given range and ignores any non-numeric values. It provides the total sum of the numeric values in the range, making it the appropriate formula for this scenario.

Rate this question:
40.

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 function that automatically adjusts the width of a column to accommodate the longest entry in that column or changes the height of a row to fit the font size.

Rate this question:
41.

Ctrl+B key makes the shortcut for making font in selected cell bold.
- True
- False
Correct Answer

A. True

Explanation

The statement is true because pressing the Ctrl+B key combination is a shortcut for making the font in a selected cell bold.

Rate this question:
42.

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:
43.

Which mathematical operation is performed by the ^ key in an Excel formula?
- Multiplication
- Factorial
- Power
- Logical
Correct Answer

A. Power

Explanation

The ^ key in an Excel formula is used to perform the mathematical operation of raising a number to a power. It is used to calculate exponential values, where a number is multiplied by itself a certain number of times. This operation is commonly used in various mathematical calculations, such as calculating compound interest or exponential growth.

Rate this question:
44.

You can select the current Row by pressing
- Control + spacebar
- Shift + spacebar
- Alt spacebar
- Shift + Tab
Correct Answer

A. Shift + spacebar

Explanation

Pressing Shift + spacebar allows you to select the current row. This key combination is commonly used to select multiple cells in a row or to highlight the entire row in a spreadsheet or table.

Rate this question:
45.

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

A. False

Explanation

The statement suggests that when a worksheet is printed, the grid lines that surround the cells are printable by default. However, this statement is incorrect. By default, the grid lines are not printed when a worksheet is printed. If the user wants to print the grid lines, they need to manually enable the option to print grid lines before printing the worksheet.

Rate this question:
46.

You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
- True
- False
Correct Answer

A. True

Explanation

A 3D chart can be rotated in two directions, horizontally along the x-axis and vertically along the y-axis. This means that you can change the angle and perspective of the chart by rotating it either left or right, and up or down. The statement is true because there are only two possible directions of rotation for a 3D chart.

Rate this question:
47.

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

Click Wrap text is the correct answer because it allows the text to be displayed in multiple lines within a cell, making it visible without truncating or losing any data. This feature automatically adjusts the height of the cell to accommodate the wrapped text. It is a practical solution when there is limited space and the content needs to be fully visible without sacrificing any information.

Rate this question:
48.

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 data in the form of spreadsheets. It offers a wide range of features and tools that allow users to perform calculations, create charts and graphs, organize and manipulate data, and automate tasks. Excel is widely used in various industries for financial analysis, data management, project planning, and many other purposes.

Rate this question:
49.

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

A. Columns

Explanation

Columns are the vertical parts of a spreadsheet. They run from the top to the bottom of the sheet and are identified by letters at the top of the spreadsheet. Each column contains multiple cells, which are the individual boxes where data can be entered. Therefore, the correct answer is "Columns."

Rate this question:

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

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
Dec 13, 2016

Quiz Created by
Lopeze761

Recent Quizzes

How Well Do You Know MS EXCEL? How Well Do You Know MS EXCEL?

The Ultimate Microsoft Excel Trivia Knowledge! Quiz The Ultimate Microsoft Excel Trivia Knowledge! Quiz

Microsoft Excel Trivia Quiz Questions! Microsoft Excel Trivia Quiz Questions!

End of Term - Year 9 End of Term - Year 9

Take The Ultimate Quiz On Microsoft Excel! Take The Ultimate Quiz On Microsoft Excel!

Can you pass this Microsoft Excel Exam Quiz? Can you pass this Microsoft Excel Exam Quiz?

Identify The Proficiency Of Microsoft Excel Quiz

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

Quiz Preview

The Insert Function dialog box tells you how to use functions.

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.

In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets.

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

Formatting data only change the appearance of data, it does not affect the data itself.

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 create maximum one Excel table in a worksheet

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.

What function offers you the possibility to view different results depending on the entered condition?

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

On an Excel spreadsheet the active cell is indicated by

A Range in Microsoft Excel refers to...

A worksheet is..

What is a Chart?

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

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

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

Which of the following would you use in an Excel formula to reference the cell located at column G row 17?

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

What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2

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

When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.

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

A Logical test in Excel can contain =, >=, <=, >,<, <>, $

Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

What function would you use to display today's date so that tomorrow it will updates automatically

What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?

A function inside another function is called a _____________ function.

The divide symbol is

You can print

Graphics objects on a chart are used to

Which function converts miles to kilometers, kilograms to pounds, and so on?

You can modify an exisiting chart?

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

Excel has a builtin format to display 4 digit year values, so you do not need to create one.

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

Columns are identified by a _______________ .

Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

What is the function of the autofit ?

Ctrl+B key makes the shortcut for making font in selected cell bold.

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

Which mathematical operation is performed by the ^ key in an Excel formula?

You can select the current Row by pressing

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

You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.

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:

Microsoft Excel 2007 is a ___________________?

__________________ is the vertical part of the spreadsheet.