Identify The Proficiency Of Microsoft Excel Quiz

1. The divide symbol is

/

D

\

)

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.

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.

2. You can print

A range of cells by range name

An entire workbook

A single worksheet

All of the above

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.

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.

3. You can modify an exisiting chart?

True

False

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.

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.

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

True

False

This statement is true because Excel has the capability to import data from various sources, including databases. By using the appropriate data connection and query, users can retrieve the results of any database table and display it in an Excel worksheet. Additionally, Excel provides the option to set up automatic data refresh, allowing users to update the data with just one click.

Explanation

This statement is true because Excel has the capability to import data from various sources, including databases. By using the appropriate data connection and query, users can retrieve the results of any database table and display it in an Excel worksheet. Additionally, Excel provides the option to set up automatic data refresh, allowing users to update the data with just one click.

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

True

False

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.

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.

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

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

9. You can create maximum one Excel table in a worksheet

True

False

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.

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.

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

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.

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.

11. On an Excel spreadsheet the active cell is indicated by

A dark wide border

A dotted border

A blinking border

None of the above

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.

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.

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

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.

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.

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

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.

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.

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

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.

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.

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

Design speadsheets models.

Create charts.

Perform mathematical operations

All of the above

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.

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.

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

The formula "=A1^A2" in an Excel spreadsheet would 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.

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

All Except $

All Except

All Except =

All Except >=

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.

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.

18. A function inside another function is called a _____________ function.

Nested

Round

Complex

None of the above

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.

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.

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

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.

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.

20. Columns are identified by a _______________ .

Letter

Number

Word

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.

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.

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

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.

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.

22. What is the function of the autofit ?

A symbol that represents a specific action

A way of arranging data in a particular order

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.

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.

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

Matrix

Window

Sheet

Cell

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell.

Explanation

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell.

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

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.

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.

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

True

False

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

Explanation

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

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

Go to file - save as - save as type - excel 4.0 worksheet

Right click on the worksheet tab and select delete

Right click on the worksheet and select insert - entire column

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.

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.

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

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.

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.

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

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.

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.

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

Sheet Tabs

Book Tabs

Menu Bar

The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook.

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.

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

Convert

Product

Change

All of above

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.

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.

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

Comma

Currency

Percent

AdjustDecimal

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.

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.

32. How would you print formulas?

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.

To print formulas, you need to first go to the Formulas tab and point to Formula Auditing. Then, click on Show Formulas to display the formulas instead of the calculated values. After that, click on the Microsoft Office Button and select Print to print the formulas.

Explanation

To print formulas, you need to first go to the Formulas tab and point to Formula Auditing. Then, click on Show Formulas to display the formulas instead of the calculated values. After that, click on the Microsoft Office Button and select Print to print the formulas.

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

True

False

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.

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.

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

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.

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.

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

A function is a built-in formula in Excel that performs a specific action or calculation on data. It is a predefined formula that simplifies complex calculations and allows users to perform various tasks such as mathematical operations, statistical analysis, and data manipulation. Functions in Excel are represented by symbols and are used to automate calculations and save time for users.

Explanation

A function is a built-in formula in Excel that performs a specific action or calculation on data. It is a predefined formula that simplifies complex calculations and allows users to perform various tasks such as mathematical operations, statistical analysis, and data manipulation. Functions in Excel are represented by symbols and are used to automate calculations and save time for users.

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

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.

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.

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

To ensure that all users can open and edit the file, you should save it in the Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing users with different versions of Excel to access the file without any issues. Saving it in this format ensures that the file can be opened and edited by all users, regardless of the Excel version they are using.

Explanation

To ensure that all users can open and edit the file, you should save it in the Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing users with different versions of Excel to access the file without any issues. Saving it in this format ensures that the file can be opened and edited by all users, regardless of the Excel version they are using.

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

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.

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.

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

=TODAY()

=[date]

=[system date]

=datevalue()

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.

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.

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

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.

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.

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

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.

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.

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

Single Quotes

Double Quotes

Equal Sign

Parentheses

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.

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.

43. To open the Format Cells dialog box, press

Alt + 1

Ctrl + 1

Ctrl + Shift + 1

F1

To open the Format Cells dialog box, you need to press Ctrl + 1. This keyboard shortcut allows you to quickly access the Format Cells option, where you can modify the formatting of cells in a spreadsheet. By pressing Ctrl + 1, you can easily make changes to the font, number format, alignment, borders, and other formatting options for selected cells.

Explanation

To open the Format Cells dialog box, you need to press Ctrl + 1. This keyboard shortcut allows you to quickly access the Format Cells option, where you can modify the formatting of cells in a spreadsheet. By pressing Ctrl + 1, you can easily make changes to the font, number format, alignment, borders, and other formatting options for selected cells.

44. When creating an Excel workbook, you should avoid using ______ text and background together, since this is the most common form of color blindness.

Red and green

Yellow and blue

Black and white

Red and yellow

When creating an Excel workbook, it is advised to avoid using red and green text and background together. This is because red-green color blindness is the most common form of color blindness. People with this condition have difficulty distinguishing between red and green colors, so using these colors together can make it challenging for them to read and understand the content in the workbook.

Explanation

When creating an Excel workbook, it is advised to avoid using red and green text and background together. This is because red-green color blindness is the most common form of color blindness. People with this condition have difficulty distinguishing between red and green colors, so using these colors together can make it challenging for them to read and understand the content in the workbook.

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

Multiplication

Factorial

Power

Logical

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.

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.

46. Rows are identified by a _______________________

Cell

Column

Number

Rows are identified by a number in a table or spreadsheet. Each row is assigned a unique number to distinguish it from other rows. This numbering system allows for easy reference and organization of data within the table or spreadsheet. By using numbers to identify rows, it becomes simpler to locate and manipulate specific rows of data when needed.

Explanation

Rows are identified by a number in a table or spreadsheet. Each row is assigned a unique number to distinguish it from other rows. This numbering system allows for easy reference and organization of data within the table or spreadsheet. By using numbers to identify rows, it becomes simpler to locate and manipulate specific rows of data when needed.

47. The cell labeled F5 refers to

Row F column 5

Column F row 5

Functions available in cells

Function key F4

The cell labeled F5 refers to the intersection of column F and row 5. In a spreadsheet, each cell is identified by its column letter and row number. In this case, the cell labeled F5 is located in column F and row 5.

Explanation

The cell labeled F5 refers to the intersection of column F and row 5. In a spreadsheet, each cell is identified by its column letter and row number. In this case, the cell labeled F5 is located in column F and row 5.

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

True

False

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.

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.

49. To format a cell like an already formated one you can use ------------------------------- .

The Fill down command

The Autosum command

The Format Painter command

None of the above.

The Format Painter command allows you to copy the formatting from one cell and apply it to another cell. This is useful when you want to format a cell in the same way as another cell without having to manually adjust all the formatting settings. The Format Painter command saves time and ensures consistency in formatting throughout the spreadsheet.

Explanation

The Format Painter command allows you to copy the formatting from one cell and apply it to another cell. This is useful when you want to format a cell in the same way as another cell without having to manually adjust all the formatting settings. The Format Painter command saves time and ensures consistency in formatting throughout the spreadsheet.

50. Microsoft Excel 2007 is a ___________________?

Word Processing Package

Graphics Package

Spreadsheets Package

Multimedia Package

None of the above

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.

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.

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

F1

Ctrl-End

F7

Crt-Home

F7 can be used to check spelling and grammar. This key is commonly used in word processing software, such as Microsoft Word, to initiate the spell check feature. When pressed, it scans the document for any spelling or grammar errors and provides suggestions for corrections.

Explanation

F7 can be used to check spelling and grammar. This key is commonly used in word processing software, such as Microsoft Word, to initiate the spell check feature. When pressed, it scans the document for any spelling or grammar errors and provides suggestions for corrections.

52. __________________ is the vertical part of the spreadsheet.

Row

Cell

Columns

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

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

53. _____________ is the horizontal part of the spreadsheet.

Rows

Cell

Column

The horizontal part of a spreadsheet is referred to as rows. Rows are numbered from top to bottom and contain data organized horizontally. Each row is identified by a number, and it represents a separate record or entry in the spreadsheet.

Explanation

The horizontal part of a spreadsheet is referred to as rows. Rows are numbered from top to bottom and contain data organized horizontally. Each row is identified by a number, and it represents a separate record or entry in the spreadsheet.

54. In an IF Function the required arguments are ____________

The Logical test and value if test is true, value if test is false

The Logical test and the three possible outcomes

The Logical test plus initial outcome plus true and false

Logical test and value if true, value if test is false plus formatting options

The correct answer is the Logical test and value if test is true, value if test is false. In an IF function, the logical test is used to evaluate a condition and determine whether it is true or false. If the logical test is true, the value if test is true is returned. If the logical test is false, the value if test is false is returned. These two arguments are required in an IF function to specify the possible outcomes based on the evaluation of the logical test.

Explanation

The correct answer is the Logical test and value if test is true, value if test is false. In an IF function, the logical test is used to evaluate a condition and determine whether it is true or false. If the logical test is true, the value if test is true is returned. If the logical test is false, the value if test is false is returned. These two arguments are required in an IF function to specify the possible outcomes based on the evaluation of the logical test.

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

Show Detail

Refresh Data

Show Detail

Group

The Refresh Data button in the PivotTable toolbar is used to update the data in a PivotTable if any changes have been made. This button ensures that the PivotTable reflects the most current data by refreshing the data source and recalculating the PivotTable based on any changes that have occurred.

Explanation

The Refresh Data button in the PivotTable toolbar is used to update the data in a PivotTable if any changes have been made. This button ensures that the PivotTable reflects the most current data by refreshing the data source and recalculating the PivotTable based on any changes that have occurred.

56. Which is not an advantage of using computerized spreadsheets?

Flexibility of moving entries

Speed of calculation

Ability of generate tables

Cost of initial setup

The cost of initial setup is not an advantage of using computerized spreadsheets. Unlike other advantages such as flexibility of moving entries, speed of calculation, and ability to generate tables, the initial setup cost is a drawback as it may require purchasing the spreadsheet software or subscribing to a service. Once the initial setup cost is incurred, the advantages of using computerized spreadsheets can be realized.

Explanation

The cost of initial setup is not an advantage of using computerized spreadsheets. Unlike other advantages such as flexibility of moving entries, speed of calculation, and ability to generate tables, the initial setup cost is a drawback as it may require purchasing the spreadsheet software or subscribing to a service. Once the initial setup cost is incurred, the advantages of using computerized spreadsheets can be realized.

57. You can use the drag and drop method to

Copy cell contents

Delete cells contents

Add cell contents

Move cell contents

The drag and drop method allows you to easily move cell contents from one location to another within a spreadsheet. By clicking and holding on a cell, you can drag it to a new location and drop it there, effectively moving the contents of the cell to the new location. This method is commonly used when rearranging data or reorganizing a spreadsheet.

Explanation

The drag and drop method allows you to easily move cell contents from one location to another within a spreadsheet. By clicking and holding on a cell, you can drag it to a new location and drop it there, effectively moving the contents of the cell to the new location. This method is commonly used when rearranging data or reorganizing a spreadsheet.

58. You cannot insert comments on each cell.

True

False

The correct answer is False because you can insert comments on each cell in various spreadsheet software like 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.

Explanation

The correct answer is False because you can insert comments on each cell in various spreadsheet software like 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.

59. What is the short key to enter the current date in a cell?

CTRL+SHIFT+: (colon)

CTRL+ ; (semicolon)

CTRL+F10

None of these

The correct answer is CTRL+ ; (semicolon). This keyboard shortcut allows the user to enter the current date in a cell.

Explanation

The correct answer is CTRL+ ; (semicolon). This keyboard shortcut allows the user to enter the current date in a cell.

60. The number of rows in an Excel 2007 worksheet is:

65536

256

64536

1048576

The number of rows in an Excel 2007 worksheet is 1048576. This is the maximum number of rows that can be used in a single worksheet in Excel 2007. This large number of rows allows for extensive data entry and analysis in Excel, making it a powerful tool for managing and organizing data.

Explanation

The number of rows in an Excel 2007 worksheet is 1048576. This is the maximum number of rows that can be used in a single worksheet in Excel 2007. This large number of rows allows for extensive data entry and analysis in Excel, making it a powerful tool for managing and organizing data.

61. After you merge a range into a single cell, you can't realign its content.

True

False

When you merge a range into a single cell, you can still realign its content. Merging cells allows you to combine multiple cells into one, which can be useful for formatting purposes. However, it does not restrict you from changing the alignment of the content within the merged cell. Therefore, the correct answer is false.

Explanation

When you merge a range into a single cell, you can still realign its content. Merging cells allows you to combine multiple cells into one, which can be useful for formatting purposes. However, it does not restrict you from changing the alignment of the content within the merged cell. Therefore, the correct answer is false.

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

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 the B1 represents the starting cell while G10 represents the ending cell of the range.

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 the B1 represents the starting cell while G10 represents the ending cell of the range.

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

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.

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.

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

A workbook refers to the Excel file that holds your worksheets. It is the main file in Excel where you can create, edit, and save multiple worksheets. Each workbook can contain multiple sheets or tabs, allowing you to organize and manage your data efficiently. The workbook serves as a container for all the data, formulas, formatting, and other elements within Excel. It provides a centralized location for you to work on your data and perform various tasks using the different worksheets it contains.

Explanation

A workbook refers to the Excel file that holds your worksheets. It is the main file in Excel where you can create, edit, and save multiple worksheets. Each workbook can contain multiple sheets or tabs, allowing you to organize and manage your data efficiently. The workbook serves as a container for all the data, formulas, formatting, and other elements within Excel. It provides a centralized location for you to work on your data and perform various tasks using the different worksheets it contains.

65. You use ______ filters to find all objects with a value greater than X or acquired after a certain date

Custom

Criteria

Index

Pivot

Custom filters allow you to create specific criteria to search for objects with values greater than X or acquired after a certain date. With custom filters, you can define the conditions and parameters that meet your requirements, enabling you to easily find the desired objects.

Explanation

Custom filters allow you to create specific criteria to search for objects with values greater than X or acquired after a certain date. With custom filters, you can define the conditions and parameters that meet your requirements, enabling you to easily find the desired objects.

66. When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?

Changes the cell format to currency with a dollar sign as the default

Allows only numbers to be input into the cell

Generates an error

Creates an absolute reference

When a cell reference in an Excel formula has dollar signs like $A$1, it creates an absolute reference. This means that the reference will always point to the same cell, regardless of where the formula is copied or moved to. The dollar signs lock the column and row of the referenced cell, making it fixed. This is useful when you want to refer to a specific cell and ensure that its reference does not change when the formula is copied or filled.

Explanation

When a cell reference in an Excel formula has dollar signs like $A$1, it creates an absolute reference. This means that the reference will always point to the same cell, regardless of where the formula is copied or moved to. The dollar signs lock the column and row of the referenced cell, making it fixed. This is useful when you want to refer to a specific cell and ensure that its reference does not change when the formula is copied or filled.

67. You can select the current Row by pressing

Control + spacebar

Shift + spacebar

Alt spacebar

Shift + Tab

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.

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.

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

=If()

=Sum()

=SumIf()

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.

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.

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

Hold down the CTRL key

Hold down the SHIFT key

Hold down the ALT key

To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. Holding down the CTRL key allows you to select multiple non-adjacent cells or ranges by clicking on each cell or range individually. This feature is useful when you need to select specific cells or ranges scattered throughout a worksheet without selecting everything in between.

Explanation

To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. Holding down the CTRL key allows you to select multiple non-adjacent cells or ranges by clicking on each cell or range individually. This feature is useful when you need to select specific cells or ranges scattered throughout a worksheet without selecting everything in between.

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

=A1+A2

=Add(A1+A2)

=together(A1:A2)

A1 plus A2

The correct answer is =A1+A2. This formula is used to add the values in cells A1 and A2 together. The plus sign (+) is the arithmetic operator used to perform addition in Excel. By using this formula, the values in A1 and A2 will be added and the result will be displayed.

Explanation

The correct answer is =A1+A2. This formula is used to add the values in cells A1 and A2 together. The plus sign (+) is the arithmetic operator used to perform addition in Excel. By using this formula, the values in A1 and A2 will be added and the result will be displayed.

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

3D charts may look visually appealing, but they can actually make it harder to accurately interpret the data. The use of depth and perspective in a 3D chart can make it difficult to accurately compare the sizes of different slices or bars in the chart. This can lead to a distorted understanding of the relationships between the values being represented. Therefore, it is true that 3D charts can obscure the relationship between values in the chart.

Explanation

3D charts may look visually appealing, but they can actually make it harder to accurately interpret the data. The use of depth and perspective in a 3D chart can make it difficult to accurately compare the sizes of different slices or bars in the chart. This can lead to a distorted understanding of the relationships between the values being represented. Therefore, it is true that 3D charts can obscure the relationship between values in the chart.

72. Pressing ENTER moves the selection one cell to the right by default.

True

False

Pressing ENTER moves the selection one cell down by default, not one cell to the right.

Explanation

Pressing ENTER moves the selection one cell down by default, not one cell to the right.

73. What key should be used to edit the content of a cell?

F1

F2

F3

F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software like Microsoft Excel. When F2 is pressed, the selected cell becomes editable, allowing the user to make changes to the cell's content.

Explanation

F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software like Microsoft Excel. When F2 is pressed, the selected cell becomes editable, allowing the user to make changes to the cell's content.

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

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 particularly useful when you want to explore different scenarios or understand the impact of different inputs on the final results. By changing the values and observing the resulting calculations, you can make informed decisions or predictions based on the data.

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 particularly useful when you want to explore different scenarios or understand the impact of different inputs on the final results. By changing the values and observing the resulting calculations, you can make informed decisions or predictions based on the data.

75. Except for the ______________ function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

=AND()

=NOT()

=OR()

=COUNT()

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().

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().

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

True

False

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.

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.

77. Which of Excel's ribbon tabs is shown in the figure below?

Review

Home

Data

View

The correct answer is "Data" because in the figure below, the ribbon tab highlighted is labeled "Data". This tab is typically used for managing and analyzing data in Excel, including functions such as sorting, filtering, and creating charts.

Explanation

The correct answer is "Data" because in the figure below, the ribbon tab highlighted is labeled "Data". This tab is typically used for managing and analyzing data in Excel, including functions such as sorting, filtering, and creating charts.

78. The "Go To" dialogue appears when you press the _____________ key from keyboard.

F5

F6

F7

The "Go To" dialogue appears when you press the F5 key from the keyboard.

Explanation

The "Go To" dialogue appears when you press the F5 key from the keyboard.

79. Which function does not exist in Excel's function library?

Upper

Lower

Proper

Uppercase

The function "Uppercase" does not exist in Excel's function library. This function is not available in Excel and cannot be used to convert text to uppercase. Excel does provide the functions "Upper", "Lower", and "Proper" for changing the case of text, but "Uppercase" is not a valid function in Excel.

Explanation

The function "Uppercase" does not exist in Excel's function library. This function is not available in Excel and cannot be used to convert text to uppercase. Excel does provide the functions "Upper", "Lower", and "Proper" for changing the case of text, but "Uppercase" is not a valid function in Excel.

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

View

Formatting

Home

The correct answer is "Home" because in the image of the Command Group "Alignment," the tab that is highlighted and selected is the "Home" tab. This indicates that the Alignment command group is located within the Home tab in the user interface.

Explanation

The correct answer is "Home" because in the image of the Command Group "Alignment," the tab that is highlighted and selected is the "Home" tab. This indicates that the Alignment command group is located within the Home tab in the user interface.

81.

What is the correct forumla to calculate an average between cells B3 and B6?

=SUM(B3+B4+B5+B6)/4

=AVE(B3:B6)

=AVERAGE(B3:B6)

=AVERAGE(B3+B4+B5+B6)/4

=AVE(B3+B4+B5+B6)/4

The correct formula to calculate an average between cells B3 and B6 is =AVERAGE(B3:B6). This formula calculates the average of all the values within the range B3 to B6.

Explanation

The correct formula to calculate an average between cells B3 and B6 is =AVERAGE(B3:B6). This formula calculates the average of all the values within the range B3 to B6.

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

Ribbon

Formula Bar

Tab

The ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and is divided into multiple tabs, such as Home, Insert, Page Layout, Formulas, etc. Each tab contains different groups of related commands and functions that you can use to perform various tasks in Excel.

Explanation

The ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and is divided into multiple tabs, such as Home, Insert, Page Layout, Formulas, etc. Each tab contains different groups of related commands and functions that you can use to perform various tasks in Excel.

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

Letters

Cell references

Symbols

Operators

In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers can be either numbers or cell references. This means that instead of directly inputting a number, you can refer to a cell that contains a number. This allows for dynamic calculations where the values in the referenced cells can be changed, and the formula will automatically update the sum accordingly.

Explanation

In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers can be either numbers or cell references. This means that instead of directly inputting a number, you can refer to a cell that contains a number. This allows for dynamic calculations where the values in the referenced cells can be changed, and the formula will automatically update the sum accordingly.

84. Which of the following functions is correctly written?

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

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

IF(B2>50000,rich,poor)

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

The correct answer is "=IF(B2>50000,"rich","poor")". This is the correct format for the IF function in Excel. The IF function is used to perform a logical test, and if the test evaluates to true, it returns one value, and if it evaluates to false, it returns another value. In this case, if the value in cell B2 is greater than 50000, the function will return "rich", otherwise it will return "poor".

Explanation

The correct answer is "=IF(B2>50000,"rich","poor")". This is the correct format for the IF function in Excel. The IF function is used to perform a logical test, and if the test evaluates to true, it returns one value, and if it evaluates to false, it returns another value. In this case, if the value in cell B2 is greater than 50000, the function will return "rich", otherwise it will return "poor".

85. =Sheet1!D9+Sheet1!E9

This would select D9 and E9 and create an average from sheet2

This would select D9 and E9 and add the two together from sheet2

This would select D9 and E9 and add the two together from sheet1

This forumla doesn't do anything.

The given formula "=Sheet1!D9+Sheet1!E9" selects the values from cells D9 and E9 in Sheet1 and adds them together. It does not involve any other sheets or calculate an average.

Explanation

The given formula "=Sheet1!D9+Sheet1!E9" selects the values from cells D9 and E9 in Sheet1 and adds them together. It does not involve any other sheets or calculate an average.

86. To sort data in an Excel worksheet you can use the ______.

Sort A to Z and Sort Z to A buttons

Quicksort Options

Sort command on the Formulas tab

Any of the above

The correct answer is "Any of the above". This is because all three options mentioned - Sort A to Z and Sort Z to A buttons, Quicksort Options, and Sort command on the Formulas tab - can be used to sort data in an Excel worksheet.

Explanation

The correct answer is "Any of the above". This is because all three options mentioned - Sort A to Z and Sort Z to A buttons, Quicksort Options, and Sort command on the Formulas tab - can be used to sort data in an Excel worksheet.

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

Data

Review

Preview

Home

The Review tab in Excel 2007 allows you to check spelling, add a comment, or protect your workbook. This tab contains various tools and options related to reviewing and editing the content of your workbook. It provides features such as spell check, inserting comments for collaboration, protecting the workbook to restrict editing or access, and other reviewing tools like track changes and compare.

Explanation

The Review tab in Excel 2007 allows you to check spelling, add a comment, or protect your workbook. This tab contains various tools and options related to reviewing and editing the content of your workbook. It provides features such as spell check, inserting comments for collaboration, protecting the workbook to restrict editing or access, and other reviewing tools like track changes and compare.

88. After writing the formula you have to press _____________________ key from the keyboard to see the answer.

Enter

Shift-Enter

Ctrl-Enter

Any of the above

After writing the formula, you can press any of the mentioned keys (Enter, Shift-Enter, or Ctrl-Enter) from the keyboard to see the answer.

Explanation

After writing the formula, you can press any of the mentioned keys (Enter, Shift-Enter, or Ctrl-Enter) from the keyboard to see the answer.

89. What term describes explanatory text attached to a cell

Callouts

Comments

Dialogs

Extensions

Comments are the correct answer because they are a form of explanatory text that can be attached to a cell in a spreadsheet or document. Comments are used to provide additional information or context about the content of the cell, allowing users to add notes or explanations for themselves or others who may be viewing or editing the document.

Explanation

Comments are the correct answer because they are a form of explanatory text that can be attached to a cell in a spreadsheet or document. Comments are used to provide additional information or context about the content of the cell, allowing users to add notes or explanations for themselves or others who may be viewing or editing the document.

90. The view that puts a blue line around each page that would be printed is the _____.

Print Preview

Normal

Page Break Preview

Split View

The correct answer is "Page Break Preview" because this view allows the user to see where page breaks will occur when the document is printed. It helps in adjusting the content and formatting accordingly to ensure that the printed pages are organized and visually appealing. The blue lines indicate the boundaries of each page, making it easier for the user to identify and make necessary adjustments.

Explanation

The correct answer is "Page Break Preview" because this view allows the user to see where page breaks will occur when the document is printed. It helps in adjusting the content and formatting accordingly to ensure that the printed pages are organized and visually appealing. The blue lines indicate the boundaries of each page, making it easier for the user to identify and make necessary adjustments.

91. What is a workbook made up of?

Rows & Columns

Worksheets

Files

A workbook is made up of worksheets. Worksheets are individual pages within a workbook where data can be entered, organized, and analyzed. Each worksheet can contain rows, columns, and cells to store and manipulate data. Multiple worksheets can be created within a workbook to organize data into different categories or sections. Therefore, worksheets are an essential component of a workbook, allowing users to work with and manage data effectively.

Explanation

A workbook is made up of worksheets. Worksheets are individual pages within a workbook where data can be entered, organized, and analyzed. Each worksheet can contain rows, columns, and cells to store and manipulate data. Multiple worksheets can be created within a workbook to organize data into different categories or sections. Therefore, worksheets are an essential component of a workbook, allowing users to work with and manage data effectively.

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

True

False

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.

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.

93. You can use an operator to concatenate (join) text from two cells into one cell. Which operator is that?

& (ampersand)

$ (Dollar)

Alt spacebar

All of the previous options

The correct answer is "&" (ampersand). The ampersand is used as the concatenation operator in Excel to join text from two cells into one cell. It allows you to combine the contents of multiple cells into a single cell, creating a single string of text.

Explanation

The correct answer is "&" (ampersand). The ampersand is used as the concatenation operator in Excel to join text from two cells into one cell. It allows you to combine the contents of multiple cells into a single cell, creating a single string of text.

94. Which of the following is the correct syntax for the COUNTIF function?

=COUNTIF(criteria, field_name, list_range)

=COUNTIF(criteria, field_range)

=COUNTIF(field_range, criteria)

=COUNTIF(list_range, field_name, criteria_range)

=COUNTIF(field_name, list_range, criteria_range)

The correct syntax for the COUNTIF function is =COUNTIF(field_range, criteria). This means that you need to provide the range of cells where you want to count, followed by the criteria or condition that you want to apply to those cells. The function will then count the number of cells in the range that meet the specified criteria.

Explanation

The correct syntax for the COUNTIF function is =COUNTIF(field_range, criteria). This means that you need to provide the range of cells where you want to count, followed by the criteria or condition that you want to apply to those cells. The function will then count the number of cells in the range that meet the specified criteria.

95. What does SUMIFS function do?

Add up cell values based on a condition

Add all the numbers in a range of cells

Returns a subtotal in a list or database

All of Above

The SUMIFS function in Excel allows you to add up cell values based on multiple conditions. It is used to calculate the sum of a range of cells that meet specific criteria. This function is useful when you want to perform calculations on a subset of data that meets certain criteria, such as adding up sales for a specific product or summing expenses for a particular month. By specifying the conditions in the formula, you can easily calculate the desired sum.

Explanation

The SUMIFS function in Excel allows you to add up cell values based on multiple conditions. It is used to calculate the sum of a range of cells that meet specific criteria. This function is useful when you want to perform calculations on a subset of data that meets certain criteria, such as adding up sales for a specific product or summing expenses for a particular month. By specifying the conditions in the formula, you can easily calculate the desired sum.

96. What does the LEN() function do?

Deletes Trailing spaces

Splits the Cell contents

Counts the number of characters in a cell

All of the choices

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

Explanation

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

97. To name a cell or range, you use the _______________

Names Box

Define name

Paste name

Format cells

To name a cell or range, you 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 functions. By using the Names Box, you can create a more organized and efficient spreadsheet by giving meaningful names to important cells or ranges.

Explanation

To name a cell or range, you 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 functions. By using the Names Box, you can create a more organized and efficient spreadsheet by giving meaningful names to important cells or ranges.

98. When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters

True

False

When you clear a filter, only the specific filter that you cleared will be cleared. The other filters in the worksheet will remain unaffected. Therefore, the given statement is false.

Explanation

When you clear a filter, only the specific filter that you cleared will be cleared. The other filters in the worksheet will remain unaffected. Therefore, the given statement is false.

99. What is the keyboard shortcut for creating a chart from the selected cells?

F3

F7

F9

F11

Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows users to quickly generate a chart without having to go through the menu options or use the mouse. It is a convenient and efficient way to visualize data and analyze trends.

Explanation

Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows users to quickly generate a chart without having to go through the menu options or use the mouse. It is a convenient and efficient way to visualize data and analyze trends.

100. If you press _____, the cell accepts your typing as its contents but the focus stays in the same cell.

ENTER

CTRL + ENTER

TAB

INSERT

Pressing CTRL + ENTER in a cell accepts the typing as its contents but keeps the focus in the same cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell. This can be useful when you want to quickly input data in multiple cells without having to navigate to each cell individually.

Explanation

Pressing CTRL + ENTER in a cell accepts the typing as its contents but keeps the focus in the same cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell. This can be useful when you want to quickly input data in multiple cells without having to navigate to each cell individually.

101. In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?

Formula returns the value "DONE"

Formula will show an error

Formula returns the value "RESTART"

Formula returns the value "YES"

If A1 is equal to "NO", the formula will return the value "RESTART".

Explanation

If A1 is equal to "NO", the formula will return the value "RESTART".

102. Two common wildcard characters that Excel recognizes are

* and /

< and >

* and ?

+ and –

The correct answer is * and ?. In Excel, the asterisk (*) is used as a wildcard character to represent any number of characters in a cell or range of cells. This can be useful for searching and filtering data. The question mark (?) is another wildcard character that represents a single character. It can be used to find cells with a specific pattern or to replace a single character in a text string. These wildcard characters provide flexibility and efficiency when working with data in Excel.

Explanation

The correct answer is * and ?. In Excel, the asterisk (*) is used as a wildcard character to represent any number of characters in a cell or range of cells. This can be useful for searching and filtering data. The question mark (?) is another wildcard character that represents a single character. It can be used to find cells with a specific pattern or to replace a single character in a text string. These wildcard characters provide flexibility and efficiency when working with data in Excel.

103. If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.

True

False

If you insert a new row at the top of the table, the new row does not become the header row and is not formatted with the table style. The header row remains the same and any new row added will have the same formatting as the other rows in the table.

Explanation

If you insert a new row at the top of the table, the new row does not become the header row and is not formatted with the table style. The header row remains the same and any new row added will have the same formatting as the other rows in the table.

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

True

False

The function arguments dialog box provides information on how to use functions. This suggests that the statement is true.

Explanation

The function arguments dialog box provides information on how to use functions. This suggests that the statement is true.

105. When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells.

True

False

When using a databar, changing the value of one cell in the range will affect the barsize of all the other cells. This is because databars are conditional formatting tools that visually represent the values in a range of cells. The length of the databar is determined by the relative value of each cell compared to the other cells in the range. Therefore, changing the value of one cell will cause the barsize of all the other cells to adjust accordingly.

Explanation

When using a databar, changing the value of one cell in the range will affect the barsize of all the other cells. This is because databars are conditional formatting tools that visually represent the values in a range of cells. The length of the databar is determined by the relative value of each cell compared to the other cells in the range. Therefore, changing the value of one cell will cause the barsize of all the other cells to adjust accordingly.

106. The name of the active cell appeares in the -----------------------.

Formula Bar

Name box

Column

The name of the active cell appears in the Name box. The Name box is located next to the formula bar in Excel and displays the cell reference or range name of the currently selected cell. It allows users to easily identify and reference specific cells or ranges within a worksheet.

Explanation

The name of the active cell appears in the Name box. The Name box is located next to the formula bar in Excel and displays the cell reference or range name of the currently selected cell. It allows users to easily identify and reference specific cells or ranges within a worksheet.

107. What is the shortcut to add a hyperlink to your worksheet?

Alt+H

Alt+K

Control+K

Control+L

The shortcut to add a hyperlink to your worksheet is Control+K.

Explanation

The shortcut to add a hyperlink to your worksheet is Control+K.

108. If a formula contains several functions, Excel starts with the outermost function and then moves inward.

True

False

Excel actually starts with the innermost function and then moves outward. This means that if a formula contains multiple functions, Excel will first evaluate the innermost function and then use the result in the next outer function, and so on. Therefore, the correct answer is false.

Explanation

Excel actually starts with the innermost function and then moves outward. This means that if a formula contains multiple functions, Excel will first evaluate the innermost function and then use the result in the next outer function, and so on. Therefore, the correct answer is false.

109. Using the autosum button will place in the selected cell _____.

The sum of values in the cell's column

Nothing until you selects a range of cells

The sum of the cell's row unless you change the range

A formula which will add values in the range Excel guesses you want to add

When using the autosum button, Excel will place a formula in the selected cell that will add the values in the range it guesses you want to add. This means that Excel will automatically calculate the sum of the values in the column of the selected cell.

Explanation

When using the autosum button, Excel will place a formula in the selected cell that will add the values in the range it guesses you want to add. This means that Excel will automatically calculate the sum of the values in the column of the selected cell.

110. If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:

Type the data in A1 and Merge cells A1:A5

Type the data in A1 and Merge cells A1:E1

Type the data in C1

Choose Center from the Format menu

To center a title across the top of the data, you need to type the data in cell A1 and then merge the cells A1 to E1. This will combine all the cells from column A to column E into one cell, allowing the title to be centered across the entire row.

Explanation

To center a title across the top of the data, you need to type the data in cell A1 and then merge the cells A1 to E1. This will combine all the cells from column A to column E into one cell, allowing the title to be centered across the entire row.

111. What is the purpose of the Add-In Manager?

To allow administrative control over all projects on the system

To add or remove templates, macros and wizards

To allow insertion or deletion of data over the internet

To create and manage additional protocols and data types for use in custom forms

The purpose of the Add-In Manager is to provide a tool for users to easily add or remove templates, macros, and wizards within a system. It allows users to customize their experience by adding or removing these features based on their needs and preferences. This functionality helps to enhance productivity and efficiency by providing users with the ability to tailor their system to their specific requirements.

Explanation

The purpose of the Add-In Manager is to provide a tool for users to easily add or remove templates, macros, and wizards within a system. It allows users to customize their experience by adding or removing these features based on their needs and preferences. This functionality helps to enhance productivity and efficiency by providing users with the ability to tailor their system to their specific requirements.

112. You can display all formulas in an active worksheet by pressing the _____ keys

Alt+~

Ctrl+~

Ctrl+W

Ctrl+¬

Pressing the Ctrl+~ keys in an active worksheet allows you to display all formulas. This keyboard shortcut is useful when you want to view and check the formulas used in the worksheet rather than the calculated results.

Explanation

Pressing the Ctrl+~ keys in an active worksheet allows you to display all formulas. This keyboard shortcut is useful when you want to view and check the formulas used in the worksheet rather than the calculated results.

113. An Excel spreadsheet is also called a _______________________ .

Document

Worksheet

Workbook

An Excel spreadsheet is also called a workbook because it contains multiple worksheets or tabs where data can be organized and manipulated. A workbook can consist of several sheets, each of which can be used for different purposes or calculations. It serves as a container for all the data and calculations in an Excel file, allowing users to work on multiple related sheets within a single file.

Explanation

An Excel spreadsheet is also called a workbook because it contains multiple worksheets or tabs where data can be organized and manipulated. A workbook can consist of several sheets, each of which can be used for different purposes or calculations. It serves as a container for all the data and calculations in an Excel file, allowing users to work on multiple related sheets within a single file.

114. Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?

=Round(A5,-3)

=Round(A5,-2)

=Round(A5,-1)

=Round(A5,1)

The function =Round(A5,-3) rounds the number in cell A5 to the nearest thousand. The -3 as the second argument specifies that the rounding should be done to the thousands place. In this case, the number 645123.875 will be rounded to 645,000.

Explanation

The function =Round(A5,-3) rounds the number in cell A5 to the nearest thousand. The -3 as the second argument specifies that the rounding should be done to the thousands place. In this case, the number 645123.875 will be rounded to 645,000.

115. Which of the following methods allows you to insert an Adobe Photoshop Image into your Excel spreadsheet?

Microsoft Office is not compatible with Adobe products

Simply drag and drop your Adobe Photoshop image file directly onto the worksheet you want to add it to

To insert an Adobe Photoshop Image into an Excel spreadsheet, you need to go to the insert tab on the ribbon and select object. From the box that appears, choose Adobe Photoshop Image and select Ok. This method allows you to add the image to your spreadsheet.

Explanation

To insert an Adobe Photoshop Image into an Excel spreadsheet, you need to go to the insert tab on the ribbon and select object. From the box that appears, choose Adobe Photoshop Image and select Ok. This method allows you to add the image to your spreadsheet.

116. Pie charts are most effective with ___________ or fewer slices.

Six

Seven

Four

Pie charts are most effective with six or fewer slices because when there are too many slices, the chart becomes cluttered and difficult to read. With fewer slices, it is easier for the viewer to compare the sizes of each slice and understand the overall distribution of the data. This allows for better visual communication and comprehension of the information being presented.

Explanation

Pie charts are most effective with six or fewer slices because when there are too many slices, the chart becomes cluttered and difficult to read. With fewer slices, it is easier for the viewer to compare the sizes of each slice and understand the overall distribution of the data. This allows for better visual communication and comprehension of the information being presented.

117. All functions have arguments. There are no functions which work without providing them arguments.

True

False

The statement is false because there are functions called "void functions" that do not require any arguments. These functions are designed to perform a specific task without needing any input from the user. They are typically used for tasks such as printing a message or performing a simple calculation. Therefore, not all functions require arguments to work.

Explanation

The statement is false because there are functions called "void functions" that do not require any arguments. These functions are designed to perform a specific task without needing any input from the user. They are typically used for tasks such as printing a message or performing a simple calculation. Therefore, not all functions require arguments to work.

118. =FUNCTION(argument1,argument2, ...) Is ________.

The syntax of writing optional arguments.

An example of a formula.

The general syntax of all functions.

The general syntax of all formulas.

This answer is correct because the statement "Is ________" is followed by options that describe different aspects related to functions. Among these options, the one that best fits the given statement is "The general syntax of all functions." This option suggests that the function syntax includes the use of arguments, which are enclosed in parentheses and separated by commas. Therefore, this answer correctly explains the given correct answer.

Explanation

This answer is correct because the statement "Is ________" is followed by options that describe different aspects related to functions. Among these options, the one that best fits the given statement is "The general syntax of all functions." This option suggests that the function syntax includes the use of arguments, which are enclosed in parentheses and separated by commas. Therefore, this answer correctly explains the given correct answer.

119. What chart object is a horizontal/vertical line extending across the plot area aiding reading values

Catogory Axis

Data Marker

Data Point

Grid line

A category axis is a chart object that is a horizontal or vertical line extending across the plot area, aiding in reading values. It helps to categorize and label data points on the chart, making it easier to interpret and understand the information being presented.

Explanation

A category axis is a chart object that is a horizontal or vertical line extending across the plot area, aiding in reading values. It helps to categorize and label data points on the chart, making it easier to interpret and understand the information being presented.

120. You can press ___________ to move between open Workbook

F6

Control + F6

Shift + F6

Control + Page down

Pressing Control + F6 allows you to move between open workbooks in Microsoft Excel. This keyboard shortcut is useful when you have multiple workbooks open and need to switch between them quickly.

Explanation

Pressing Control + F6 allows you to move between open workbooks in Microsoft Excel. This keyboard shortcut is useful when you have multiple workbooks open and need to switch between them quickly.

121. The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:

Use Format Painter

Format each element using the Toolbar

Select all and use the Formatting dialog box

Apply a table style

Applying a table style is the most efficient way to format several cells with a specific font, number format, alignment, and font color. Table styles allow you to quickly apply a predefined set of formatting options to a range of cells, saving time and effort compared to individually formatting each element using the Toolbar or the Formatting dialog box. The Format Painter can also be used to copy the formatting from one cell to another, but it may not be as efficient when formatting multiple cells.

Explanation

Applying a table style is the most efficient way to format several cells with a specific font, number format, alignment, and font color. Table styles allow you to quickly apply a predefined set of formatting options to a range of cells, saving time and effort compared to individually formatting each element using the Toolbar or the Formatting dialog box. The Format Painter can also be used to copy the formatting from one cell to another, but it may not be as efficient when formatting multiple cells.

122. What is the purpose of range lookup in VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)?

To identify exact matches

To identify closest min value matches

To identify closest max value matches

To identify postive values

The purpose of range lookup in VLOOKUP is to identify the closest minimum value matches. This means that if the lookup_value is not found in the table_array, it will return the closest value that is smaller than the lookup_value. This is useful when you want to find an approximate match or when you are working with numerical data and want to find the closest value.

Explanation

The purpose of range lookup in VLOOKUP is to identify the closest minimum value matches. This means that if the lookup_value is not found in the table_array, it will return the closest value that is smaller than the lookup_value. This is useful when you want to find an approximate match or when you are working with numerical data and want to find the closest value.