Microsoft Excel Proficiency Trivia Questions

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 Daminda Chandimal

Daminda Chandimal

Community Contributor

Quizzes Created: 1 | Total Attempts: 227

| Attempts: 227

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

1/122 Questions

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

About This Quiz

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

Microsoft Excel Proficiency Trivia Questions - Quiz

Quiz Preview

2.

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 total sum of a range of cells. In this case, the range is specified as J1:J8, which means it will sum the values in column J from row 1 to row 8.

Rate this question:
3.

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 on the left is divided by the number on the right.

Rate this question:
4.

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. This implies that the chart can be edited or updated according to new data or requirements.

Rate this question:
5.

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

When there is only one sort field, using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data. These buttons allow the data to be sorted in ascending (A to Z) or descending (Z to A) order based on the selected field.

Rate this question:
6.

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 the capability to connect to various database systems and retrieve data from tables. Once the connection is established and the data is imported into an Excel worksheet, you can set up a refresh option that allows you to update the data with just one click. This ensures that the results in the worksheet are always up to date with the database table.

Rate this question:

1
7.

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 on the input parameters that a function requires, as well as any optional arguments and their respective data types. This information helps users understand the correct way to use functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.

Rate this question:
8.

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

The function of the autofit is to automatically adjust the width of a column to fit the longest entry or change the height of a row to fit the font. This feature is useful in spreadsheet programs or table editors where the content of cells may vary in length or font size. Autofit ensures that all the content is visible within the cell without any truncation or overlapping.

Rate this question:
9.

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 the file can be opened and edited by all users, you should save it as an Excel 97-2003 Workbook (*.xls) format. This format is compatible with both Excel 97 and Excel 2000, allowing the person working on Excel 97 and Excel 2000 to open and edit the file without any compatibility issues. Saving it in CSV or HTML format may cause formatting and functionality loss, so choosing the Excel 97-2003 Workbook format is the best option.

Rate this question:
10.

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

A. False

Explanation

The given statement is false. It is possible to insert comments on each cell in certain applications such as Microsoft Excel or Google Sheets. Comments can be used to provide additional information or explanations about the data in a cell, making it easier for others to understand the content of the spreadsheet.

Rate this question:
11.

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 the Excel 2007 ribbon allows you to check spelling, add a comment, or protect your workbook. This tab contains various tools and options for reviewing and editing your workbook, such as the Spelling button for spell-checking, the New Comment button for adding comments to cells, and the Protect Workbook button for protecting your workbook with a password.

Rate this question:
12.

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
Correct Answer

A. B1:G10

Explanation

The correct answer is B1:G10. This is because the colon (:) is used to indicate a range of cells, and B1:G10 represents a range that starts from cell B1 and goes over to column G and down to row 10.

Rate this question:
13.

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 dealing with monetary values to make them easier to read and understand. The dollar sign indicates the currency being used, while the commas are used to separate thousands, millions, and so on. This formatting style is especially useful when working with large numbers or financial data.

Rate this question:
14.

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 other words, it is the cell located in the fifth row and the sixth column.

Rate this question:
15.

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 in a selected cell will make the font in that cell bold. This is a common shortcut used in many software programs, including spreadsheet applications like Microsoft Excel.

Rate this question:
16.

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 in Excel is a built-in formula that performs a specific action or calculation on data. It is used to manipulate and analyze data in a spreadsheet. Functions can be used to perform mathematical operations, manipulate text, calculate dates and times, and much more. They are predefined formulas that can be easily applied to cells or ranges in a worksheet to automate calculations and save time.

Rate this question:
17.

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

The correct answer is a table of data that is organized into rows and columns. A worksheet in the context of computer software, such as Microsoft Excel, refers to a document or file that contains a grid-like structure where data can be entered, organized, and manipulated. This grid is typically divided into rows and columns, forming a table-like structure. Users can input data into individual cells, perform calculations using formulas, and analyze and present the data in various ways. Worksheets are commonly used for tasks such as budgeting, data analysis, and creating charts or graphs.

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.

Rate this question:
19.

_____________ is the horizontal part of the spreadsheet.
- Rows
- Cell
- Column
Correct Answer

A. Rows

Explanation

Rows are the horizontal part of a spreadsheet. They are identified by numbers and contain cells where data can be entered. Each row represents a separate record or data entry in the spreadsheet.

Rate this question:
20.

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 in the PivotTable toolbar updates the data in a PivotTable if any changes have been made. This button is used to refresh the PivotTable and reflect any new data or changes made to the source data. By clicking on the Refresh Data button, the PivotTable will be updated with the latest information, ensuring that the analysis and calculations are based on the most up-to-date data.

Rate this question:
21.

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

One advantage of using computerized spreadsheets is the flexibility of moving entries, as it allows users to easily rearrange and reorganize data as needed. Another advantage is the speed of calculation, as computerized spreadsheets can perform complex calculations quickly and accurately. Additionally, computerized spreadsheets have the ability to generate tables, making it easier to present and analyze data. However, the cost of initial setup is not an advantage, as it refers to the expenses associated with acquiring and setting up the necessary hardware and software, which can be a drawback for some users.

Rate this question:
22.

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 visual representation of data without altering the underlying values or calculations. This can include changing the font, color, alignment, or adding borders to cells. The purpose of formatting is to enhance the readability and presentation of data. However, formatting does not modify the actual data or its values. Therefore, the statement that formatting only changes the appearance of data and does not affect the data itself is true.

Rate this question:
23.

The ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.
- What-if analysis
- Track Changes
Correct Answer

A. What-if analysis

Explanation

What-if analysis allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. This feature is useful for exploring different scenarios and understanding how changes in input variables can impact the outcome. It helps in making informed decisions and analyzing the sensitivity of the model to different inputs. Track Changes, on the other hand, is a different feature in Excel that allows you to track and review changes made to a workbook by different users.

Rate this question:
24.

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 clear and concise way to present information in a graphical format, making it easier to understand and analyze trends, patterns, and relationships within the data. By using different types of charts, such as bar graphs, pie charts, or line graphs, data can be visually organized and interpreted, enabling users to make informed decisions based on the information presented.

Rate this question:
25.

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 the only option that accurately describes the action of converting one unit of measurement to another. This function can be used to convert miles to kilometers, kilograms to pounds, and any other unit of measurement. Therefore, "convert" is the appropriate choice for this question.

Rate this question:
26.

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

Clicking the "Wrap text" option allows the text to be displayed on multiple lines within a single cell, instead of being truncated. This ensures that all the content is visible without losing any data.

Rate this question:
27.

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. It is a software program used for creating, organizing, and analyzing data in a tabular format. Excel allows users to perform calculations, create charts and graphs, and manipulate data using various functions and formulas. It is widely used in business and academic settings for tasks such as budgeting, financial analysis, and data management.

Rate this question:
28.

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

Entering data in the first blank row is the simplest and most convenient way to add a record to a table because it ensures that the new record is added at the end of the existing data. This method avoids any potential conflicts or errors that may arise when trying to insert a record in a specific location within the table. Additionally, it allows for easy organization and readability of the table, as new records are appended to the bottom.

Rate this question:
29.

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 means that any changes made to the data in the source worksheet will be automatically reflected in the chart, regardless of which worksheet the chart is located in. 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:

1
30.

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 the workbook and reopen it, the row will still be hidden. This feature allows you to temporarily hide certain rows of data without permanently deleting them. To unhide the row, you would need to activate the workbook and manually unhide the row.

Rate this question:
31.

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:

1
32.

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

The correct answer states that data entered into a cell can be edited after saving the file. This can be done by double-clicking on the cell where the data is located, allowing for changes to be made.

Rate this question:
33.

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 multiple cells simultaneously. By selecting a range, users can easily perform operations on a specific set of cells, making data management and analysis more efficient.

Rate this question:
34.

What is a workbook made up of?
- Rows & Columns
- Worksheets
- Files
Correct Answer

A. Worksheets

Explanation

A workbook is made up of worksheets. Worksheets are individual sheets within a workbook where data can be organized and manipulated. Each worksheet consists of rows and columns, forming a grid-like structure. Multiple worksheets can be created within a workbook to organize and analyze different sets of data. Therefore, the correct answer is worksheets.

Rate this question:
35.

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

A. Number

Explanation

Rows in a table are typically identified by a unique number, such as a row number or index. This allows for easy referencing and manipulation of specific rows within the table. Each row is assigned a distinct number, which serves as its identifier. This number is used to differentiate one row from another and is crucial for performing operations on individual rows in a table.

Rate this question:
36.

Reference to the above image of Command Group "Alignment" which of the following tabs consist it:
- View
- Formatting
- Home
Correct Answer

A. Home

Explanation

The Command Group "Alignment" consists of the tabs: View, Formatting, and Home.

Rate this question:
37.

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 an Excel formula, to reference the cell located at column G row 17, you would use "G17". This is the correct answer because it follows the standard Excel notation for referencing cells, where the column letter is followed by the row number. In this case, "G" represents the column and "17" represents the row, so combining them gives us "G17" as the correct reference.

Rate this question:
38.

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, with options for sorting, filtering, and manipulating data. It allows users to perform various data-related tasks such as importing and exporting data, creating data tables, and applying data analysis tools.

Rate this question:
39.

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 of cell A1 and A2 together. The plus sign (+) is the arithmetic operator for addition in Excel. By using this formula, the sum of the two cells is calculated and displayed in the cell where the formula is entered.

Rate this question:
40.

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 using graphics objects such as colors, shapes, and images, the chart becomes more visually appealing and engaging for the audience. Additionally, these graphics can be used to highlight important data points or trends, making it easier for viewers to understand the information being presented. Therefore, all of the given options are correct explanations for the use of graphics objects on a chart.

Rate this question:
41.

What term describes explanatory text attached to a cell
- Callouts
- Comments
- Dialogs
- Extensions
Correct Answer

A. Comments

Explanation

Comments are the correct answer because they refer to explanatory text that can be attached to a cell in a spreadsheet or document. Comments provide additional information or clarification about the content of the cell and are often used for collaboration and communication purposes. They can be viewed by hovering over or selecting the cell, making them a helpful tool for providing context and annotations within a document.

Rate this question:
42.

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 to distinguish the currently selected cell from the rest of the cells on the spreadsheet. It allows the user to easily identify and manipulate the active cell, such as entering data or performing calculations. The other options, a dotted border and a blinking border, are not commonly used to indicate the active cell in Excel.

Rate this question:
43.

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

In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers that can be used as arguments can either be numbers or cell references. Cell references allow you to refer to specific cells in a spreadsheet and use their values in calculations. Therefore, in this context, cell references are a valid option for the numbers that can be used in the SUM formula.

Rate this question:
44.

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

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

A. True

Explanation

The statement is true because the Insert Function dialog box is a feature in many software applications, such as Microsoft Excel, that provides a user-friendly interface for selecting and inserting functions into a cell or formula. It typically includes a search bar, a list of available functions, and a description or explanation of how to use each function. This dialog box serves as a helpful tool for users who may not be familiar with all the available functions or how to properly use them.

Rate this question:
46.

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

A. Letter

Explanation

Columns are identified by a letter in order to differentiate them from each other. Each column is assigned a unique letter, starting from A and going up to Z. This allows for easy reference and organization of data within a spreadsheet or table. By using letters to identify columns, it becomes simpler to locate and manipulate specific data within a larger dataset.

Rate this question:
47.

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 option to print a specific range of cells that you have named, or you can print the entire workbook which includes all the worksheets within it. Additionally, you can choose to print only a single worksheet if that is what you need. Therefore, all of these options are available for printing.

Rate this question:
48.

To name a cell or range, you use the _______________
- Names Box
- Define name
- Paste name
- Format cells
Correct Answer

A. Names Box

Explanation

To name a cell or range, you would use the "Names Box". This feature allows you to assign a specific name to a cell or range of cells in order to easily reference them in formulas or navigate to them within a worksheet. By using the Names Box, you can create more meaningful and descriptive names for cells or ranges, making it easier to understand and work with your data.

Rate this question:
49.

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, to run a spell check on the document. Pressing F7 will prompt the software to scan the text for any spelling or grammar errors and provide suggestions for corrections. It is a convenient and efficient way to ensure that written content is free from errors and maintains a professional standard.

Rate this question:

Quiz Review Timeline (Updated): Sep 13, 2023 +

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

Current Version
Sep 13, 2023

Quiz Edited by
ProProfs Editorial Team
Oct 13, 2015

Quiz Created by
Daminda Chandimal

Recent Quizzes

BASIC 6 COMPUTING QUIZ BASIC 6 COMPUTING QUIZ

Data Analyst Excel Test Data Analyst Excel Test

9th Grade Excel Test 9th Grade Excel Test

Keystone Bank Pre-Training Assessment Keystone Bank Pre-Training Assessment

Test How Much Do You Know About Excel Sheets! Trivia Test How Much Do You Know About Excel Sheets! Trivia

Microsoft Excel Proficiency Test Microsoft Excel Proficiency Test

Back to top

Microsoft Excel Proficiency Trivia Questions

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.

Quiz Preview

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

The divide symbol is

You can modify an exisiting chart?

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 have results of any database table into Excel Worksheet, and by one click you can refresh the results?

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

What is the function of the autofit ?

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?

You cannot insert comments on each cell.

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

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

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

The cell labeled F5 refers to

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

A Function is?

A worksheet is..

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

_____________ is the horizontal part of the spreadsheet.

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

Which is not an advantage of using computerized spreadsheets?

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

The ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.

What is a Chart?

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

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 ___________________?

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.

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

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

A Range in Microsoft Excel refers to...

What is a workbook made up of?

Rows are identified by a _______________________

Reference to the above image of Command Group "Alignment" which of the following tabs consist it:

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

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

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

Graphics objects on a chart are used to

What term describes explanatory text attached to a cell

On an Excel spreadsheet the active cell is indicated by

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

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

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

Columns are identified by a _______________ .

You can print

To name a cell or range, you use the _______________

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