The Ultimate 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 Octara

Octara

Community Contributor

Quizzes Created: 1 | Total Attempts: 20,036

| Attempts: 20,089

Quiz Lesson

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

1/114 Questions

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

About This Quiz

Welcome to the ultimate Microsoft Excel Quiz! Whether it’s for school, college, work or personal use, Excel is incredibly handy spreadsheet software that allows you to track and analyze data of all kinds. What do you know about the tool? Let’s take a look right now!

The Ultimate Microsoft Excel Quiz! - Quiz

Quiz Preview

2.

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

The statement is true because 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 writing complex sorting algorithms, making it a convenient and efficient method for sorting data.

Rate this question:

2
3.

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 is a type of document in spreadsheet software where data can be entered, stored, and organized. It consists of a grid-like structure with rows and columns, similar to a table, where data can be inputted and manipulated. Worksheets are commonly used for data analysis, calculations, and creating charts or graphs.

Rate this question:

2
4.

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 fit the longest entry or changes the height of a row to fit the font. It ensures that all the data in a column or row is visible without any truncation or overlap. This feature is particularly useful when working with large amounts of data or when formatting a spreadsheet to make it more readable and organized.

Rate this question:

5
5.

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. Therefore, the correct answer is "All of the above."

Rate this question:

3
6.

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 typing a function name within a formula into a cell, a list of functions that start with the letters you have typed will appear. This feature is known as autofill or autocomplete, and it helps users by providing suggestions and saving time in searching for the desired function. By displaying a list of functions that match the typed letters, it allows users to easily select the correct function without having to remember the exact name or syntax. Therefore, the statement is true.

Rate this question:

1
7.

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 allows the user to make changes to the data without having to save it as a different file name.

Rate this question:

1
8.

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 using a range name, you can print an entire workbook, and you can also print a single worksheet. This means that all of the given options are valid ways to print in Excel.

Rate this question:
9.

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 will add up the values in column J between rows 1 and 8, which is specified by J1:J8.

Rate this question:

2
10.

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

A. /

Explanation

The divide symbol is represented by the forward slash ("/"). It is commonly used in mathematical operations to indicate division.

Rate this question:

2
11.

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

A. Currency

Explanation

Currency number formatting style adds the dollar signs and commas to values. This formatting is commonly used to represent monetary values in a standardized and easily readable format. By adding the dollar sign and commas, it helps to visually distinguish and comprehend the value more effectively.

Rate this question:

3
12.

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 way to display and compare data. It allows for easy understanding and analysis of information by presenting it in a graphical format. Charts can be used to represent various types of data, such as numerical values, percentages, or categories. They provide a clear and concise representation of data, making it easier for users to identify patterns, trends, and relationships between different data points. By visually organizing and presenting data, charts help in making data-driven decisions and communicating information effectively.

Rate this question:

2
13.

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 the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The colon (:) is used to indicate a range of cells, and B1:G10 specifies the range from cell B1 to cell G10.

Rate this question:
14.

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 application used for creating, editing, and analyzing data in the form of spreadsheets. Excel allows users to perform calculations, create charts and graphs, organize and manipulate data, and automate tasks using formulas and functions. It is widely used in business and finance for tasks such as budgeting, data analysis, and financial modeling.

Rate this question:

7
15.

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 ability to connect to various databases and import data from them into a worksheet. Once the data is imported, it can be refreshed with just one click, allowing the user to update the results without having to manually re-import the data. This feature makes it convenient and efficient for users to work with database tables in Excel.

Rate this question:

3
16.

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. Therefore, there is no need to create a custom format for this purpose. This statement is true.

Rate this question:

2
17.

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:

1
18.

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 other users can open and edit the file, you should save it in the Excel 97-2003 Workbook (*.xls) format. This format is compatible with both Excel 97 and Excel 2000 versions, allowing all users to access the file regardless of the version they are using. Saving it in CSV or HTML formats may cause compatibility issues or loss of formatting, so the best option is to save it in the older Excel format for maximum compatibility.

Rate this question:

4
19.

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. The sheet tabs are usually located at the bottom of the workbook window and can be clicked on to switch to a specific sheet.

Rate this question:

4
20.

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 analyzed. Each worksheet consists of rows and columns that can be filled with data, formulas, and charts. Multiple worksheets can be created within a workbook to separate and organize different sets of data or calculations. Therefore, the correct answer is worksheets.

Rate this question:

3
21.

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 is because the equal sign indicates to Excel that the content in the cell is a formula or function and not just a regular text. By using the equal sign, users can perform calculations and manipulate data within the cells.

Rate this question:

1
22.

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

A. Rows

Explanation

Rows are the horizontal parts of a spreadsheet. They are used to organize and display data horizontally across the spreadsheet. Each row is identified by a number, starting from 1, and contains cells where data can be entered or displayed.

Rate this question:
23.

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

A. Number

Explanation

Rows in a table are typically identified by a unique number or index. This allows for easy referencing and organization of data within the table. By using a number to identify rows, it becomes easier to perform operations such as sorting, filtering, and searching for specific rows in the table. This number serves as a unique identifier for each row, distinguishing it from other rows in the table.

Rate this question:

5
24.

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 allows users to retrieve the most up-to-date information from the data source and reflect any modifications or additions in the PivotTable report. By clicking on this button, the PivotTable will refresh and display the latest data.

Rate this question:

3
25.

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 symbols, important data points or trends can be highlighted, making it easier for viewers to understand and interpret the information presented in the chart. Additionally, the use of graphics objects can make the chart visually appealing and engaging, capturing the attention of the audience and making the information more memorable. Therefore, all of the given options are correct.

Rate this question:

8
26.

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 that converts miles to kilometers, kilograms to pounds, and other units is the "convert" function. This function can be used to convert between different units of measurement, allowing for easy conversion from one system to another. It is a versatile function that can handle various types of conversions, making it the correct answer to the question.

Rate this question:

5
27.

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 a large Excel sheet. This feature is helpful when working with large datasets and wanting to keep important information, such as headers or labels, always in view. By freezing panes, users can easily navigate through the sheet without losing track of important data.

Rate this question:

2
28.

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, you would use "G17" to reference the cell located at column G row 17. The letter represents the column and the number represents the row, so "G17" specifies the cell at the intersection of column G and row 17.

Rate this question:

1
29.

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 about the input parameters that a function accepts and how to format them correctly. This information helps users understand how to properly utilize functions in their code.

Rate this question:

3
30.

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

A. False

Explanation

You can create more than one Excel table in a worksheet. This allows you to organize and analyze different sets of data separately within the same worksheet.

Rate this question:

3
31.

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 is the correct answer because it is commonly used as a shortcut key to check spelling and grammar in many software applications, including word processors and text editors. Pressing F7 typically opens the spell check tool, which scans the document for errors and suggests corrections. This key is often preferred by users due to its ease of use and accessibility.

Rate this question:

5
32.

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

A. Columns

Explanation

Columns are the vertical sections of a spreadsheet that run from top to bottom. They are used to organize and categorize data in a spreadsheet. Each column is labeled with a letter at the top to identify it, such as A, B, C, etc. Columns are used to input and display data in a spreadsheet, and they can be formatted and adjusted to fit the needs of the user.

Rate this question:

1
33.

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

A. Letter

Explanation

Columns in a document or spreadsheet are typically identified by a letter, such as A, B, C, and so on. This letter represents the column's position or index within the document, making it easier to reference and locate specific columns when working with data or performing calculations.

Rate this question:
34.

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 values or content of the data. The underlying data remains the same, and only the visual representation is modified. Therefore, formatting data does not affect the data itself, making the statement true.

Rate this question:

3
35.

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 of a table is the simplest and most convenient way to add a record. This is because it ensures that the new record is added at the end of the existing data without any need for sorting or rearranging. By entering data in the first blank row, the record will be automatically appended to the table, maintaining the order of the existing records. Therefore, the statement "True" is the correct answer.

Rate this question:

2
36.

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 in Excel refers to the Excel file that holds multiple worksheets or spreadsheets. It is the main container where you can store and organize your data, calculations, and analysis. A workbook can contain multiple worksheets, each of which can have its own data and formulas. It provides a convenient way to manage and manipulate data in a structured manner.

Rate this question:

1
37.

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 is because the Tab key is used to move to the next cell in Excel, and accepting the entry means moving to the next cell after the existing entry is displayed.

Rate this question:

1
38.

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

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 "Wrap text" is the correct answer because it allows the text to be displayed on multiple lines within a cell, making it visible without losing any data. This is a useful solution when the content is being truncated due to limited column width and increasing the worksheet width is not an option.

Rate this question:

1
40.

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 formula "=SUM(number1 [,number2 ,number3 ...])", the numbers that can be included as arguments are not limited to just numerical values. They can also be cell references, which refer to the values stored in specific cells within a spreadsheet. This allows for dynamic calculations based on the values in those cells.

Rate this question:

3
41.

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 "+" operator is used to perform the addition operation in Excel.

Rate this question:

2
42.

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 SUM formula can add all the numeric values in a range of cells and ignore those that are not numeric. It will then place the result in a different cell.

Rate this question:

2
43.

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 treated as a single unit. Ranges are commonly used for performing calculations, formatting data, and applying functions or formulas to a specific set of cells. By selecting a range, users can easily manipulate and analyze data within Excel, making it a fundamental feature of the software.

Rate this question:

2
44.

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. Cells are used to store and manipulate data in Excel, and they are identified by their unique row and column reference.

Rate this question:
45.

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

A. Data

Explanation

The correct answer is "Data" because in the figure provided, the ribbon tab that is highlighted is the "Data" tab. This can be identified by the label on the tab and the specific layout and icons displayed within the tab.

Rate this question:

2
46.

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 are explanatory text attached to a cell in a spreadsheet or document. Comments provide additional information or explanations about the data or content in the cell, allowing users to provide context or clarification for others who may view or edit the document.

Rate this question:

1
47.

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.

Rate this question:

2
48.

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 also in the formula bar. The formula bar is located at the top of the Excel window and displays the contents of the active cell, including any formulas that have been entered. Therefore, the correct answer is "Formula".

Rate this question:

2
49.

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

The statement is true because 3D charts, while visually appealing, can actually make it harder to interpret the data accurately. The use of depth and perspective in 3D charts can distort the sizes of the slices, making it difficult to determine which slice is larger or smaller. This can lead to a misrepresentation of the data and potentially misleading conclusions. Therefore, it is important to be cautious when using 3D charts and consider alternative chart types that present the data more accurately and clearly.

Rate this question:

4

Quiz Review Timeline (Updated): Apr 2, 2025 +

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

Current Version
Apr 02, 2025

Quiz Edited by
ProProfs Editorial Team
Mar 24, 2012

Quiz Created by
Octara

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!

identify the proficiency of Microsoft Excel quiz identify the proficiency of Microsoft Excel quiz

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

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

Back to top

The Ultimate Microsoft Excel Quiz!

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

Quiz Preview

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.

A worksheet is..

What is the function of the autofit ?

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.

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

You can print

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

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

What is a Chart?

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

Microsoft Excel 2007 is a ___________________?

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

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

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

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?

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

What is a workbook made up of?

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

_____________ is the horizontal part of the spreadsheet.

Rows are identified by a _______________________

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

Graphics objects on a chart are used to

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

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?

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

You can create maximum one Excel table in a worksheet

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

__________________ is the vertical part of the spreadsheet.

Columns are identified by a _______________ .

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

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

What is a Workbook?

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

How would you print formulas?

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:

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

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

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?

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?

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

What term describes explanatory text attached to a cell

The cell labeled F5 refers to

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.

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.