The Ultimate Microsoft Excel Quiz!

1. 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 in a selected cell will make the font bold. This is a common shortcut used in various software programs, including spreadsheet applications like Microsoft Excel. By selecting a cell and using this shortcut, users can quickly and easily apply the bold formatting to the text in that cell.

Explanation

The statement is true because pressing the Ctrl+B key combination in a selected cell will make the font bold. This is a common shortcut used in various software programs, including spreadsheet applications like Microsoft Excel. By selecting a cell and using this shortcut, users can quickly and easily apply the bold formatting to the text in that cell.

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

True

False

The statement is true because using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the user to quickly arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or writing complex sorting algorithms, making it a convenient and efficient method for sorting data.

Explanation

The statement is true because using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the user to quickly arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or writing complex sorting algorithms, making it a convenient and efficient method for sorting data.

3. A worksheet is..

A symbol that represents a specific action

Refers to the change a formula makes when it is moved or copied to other cells with different data

A table of data that is organized into rows and columns

The correct answer is "A table of data that is organized into rows and columns." A worksheet is a type of document in spreadsheet software where data can be entered, stored, and organized. It consists of a grid-like structure with rows and columns, similar to a table, where data can be inputted and manipulated. Worksheets are commonly used for data analysis, calculations, and creating charts or graphs.

Explanation

The correct answer is "A table of data that is organized into rows and columns." A worksheet is a type of document in spreadsheet software where data can be entered, stored, and organized. It consists of a grid-like structure with rows and columns, similar to a table, where data can be inputted and manipulated. Worksheets are commonly used for data analysis, calculations, and creating charts or graphs.

4. What is the function of the autofit ?

A symbol that represents a specific action

A way of arranging data in a particular order

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

Autofit is a function that automatically adjusts the width of a column to fit the longest entry or changes the height of a row to fit the font. It ensures that all the data in a column or row is visible without any truncation or overlap. This feature is particularly useful when working with large amounts of data or when formatting a spreadsheet to make it more readable and organized.

Explanation

Autofit is a function that automatically adjusts the width of a column to fit the longest entry or changes the height of a row to fit the font. It ensures that all the data in a column or row is visible without any truncation or overlap. This feature is particularly useful when working with large amounts of data or when formatting a spreadsheet to make it more readable and organized.

5. 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 spreadsheet models, create charts, and perform mathematical operations. Therefore, the correct answer is "All of the above."

Explanation

A spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. Therefore, the correct answer is "All of the above."

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

True

False

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

Explanation

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

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

Yes, but it has to be saved as a different file name.

No, once it is saved it cannot be changed.

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

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

Explanation

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

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

Explanation

The correct answer is "All of the above" because you can print a range of cells by using a range name, you can print an entire workbook, and you can also print a single worksheet. This means that all of the given options are valid ways to print in Excel.

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

=ADD(J1-J8)

=SUM(J1:J8)

=J:1+J:8

=SUM J:1-8

The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to add up a range of cells. In this case, it will add up the values in column J between rows 1 and 8, which is specified by J1:J8.

Explanation

The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to add up a range of cells. In this case, it will add up the values in column J between rows 1 and 8, which is specified by J1:J8.

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

Comma

Currency

Percent

AdjustDecimal

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

Explanation

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

11. The divide symbol is

/

D

\

)

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

Explanation

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

12. What is a Chart?

It is a visual way to display and compare data

A way of arranging data in a particular order

A calculation that describes the relationship between cells

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

Explanation

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

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

B1-G10

B1.G10

B1;G10

B1:G10

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

Explanation

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

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

Explanation

Microsoft Excel 2007 is a spreadsheets package. It is a software application used for creating, editing, and analyzing data in the form of spreadsheets. Excel allows users to perform calculations, create charts and graphs, organize and manipulate data, and automate tasks using formulas and functions. It is widely used in business and finance for tasks such as budgeting, data analysis, and financial modeling.

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

Explanation

Excel does have a built-in format to display 4 digit year values. Therefore, there is no need to create a custom format for this purpose. This statement is true.

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

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

Explanation

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

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

Explanation

The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook. The sheet tabs are usually located at the bottom of the workbook window and can be clicked on to switch to a specific sheet.

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

Explanation

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

20. What is a workbook made up of?

Rows & Columns

Worksheets

Files

A workbook is made up of worksheets. Worksheets are individual sheets within a workbook where data can be organized and analyzed. Each worksheet consists of rows and columns that can be filled with data, formulas, and charts. Multiple worksheets can be created within a workbook to separate and organize different sets of data or calculations. Therefore, the correct answer is worksheets.

Explanation

A workbook is made up of worksheets. Worksheets are individual sheets within a workbook where data can be organized and analyzed. Each worksheet consists of rows and columns that can be filled with data, formulas, and charts. Multiple worksheets can be created within a workbook to separate and organize different sets of data or calculations. Therefore, the correct answer is worksheets.

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

Single Quotes

Double Quotes

Equal Sign

Parentheses

In Excel 2007, the equal sign is used to create a formula or function in a cell. This is because the equal sign indicates to Excel that the content in the cell is a formula or function and not just a regular text. By using the equal sign, users can perform calculations and manipulate data within the cells.

Explanation

In Excel 2007, the equal sign is used to create a formula or function in a cell. This is because the equal sign indicates to Excel that the content in the cell is a formula or function and not just a regular text. By using the equal sign, users can perform calculations and manipulate data within the cells.

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

Explanation

The Refresh Data button in the PivotTable toolbar updates the data in a PivotTable if any changes have been made. This button allows users to retrieve the most up-to-date information from the data source and reflect any modifications or additions in the PivotTable report. By clicking on this button, the PivotTable will refresh and display the latest data.

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

Explanation

Graphics objects on a chart are used to add emphasis to chart data, add interest to a chart, and help explain the chart data. By using graphics objects such as colors, shapes, and symbols, important data points or trends can be highlighted, making it easier for viewers to understand and interpret the information presented in the chart. Additionally, the use of graphics objects can make the chart visually appealing and engaging, capturing the attention of the audience and making the information more memorable. Therefore, all of the given options are correct.

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

Convert

Product

Change

All of above

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

Explanation

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

25. _____________ is the horizontal part of the spreadsheet.

Rows

Cell

Column

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

Explanation

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

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

Explanation

Freeze Panes is the correct answer because it allows users to keep certain rows or columns visible while scrolling through a large Excel sheet. This feature is helpful when working with large datasets and wanting to keep important information, such as headers or labels, always in view. By freezing panes, users can easily navigate through the sheet without losing track of important data.

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

Explanation

In an Excel formula, you would use "G17" to reference the cell located at column G row 17. The letter represents the column and the number represents the row, so "G17" specifies the cell at the intersection of column G and row 17.

28. Rows are identified by a _______________________

Cell

Column

Number

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

Explanation

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

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

Explanation

The function arguments dialog box provides information on how to use functions. It likely includes details about the input parameters that a function accepts and how to format them correctly. This information helps users understand how to properly utilize functions in their code.

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

True

False

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

Explanation

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

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

F1

Ctrl-End

F7

Crt-Home

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

Explanation

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

32. __________________ is the vertical part of the spreadsheet.

Row

Cell

Columns

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

Explanation

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

33. Columns are identified by a _______________ .

Letter

Number

Word

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

Explanation

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

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

Explanation

Formatting data refers to changing the way data is displayed, such as changing the font, color, or alignment. This does not alter the actual values or content of the data. The underlying data remains the same, and only the visual representation is modified. Therefore, formatting data does not affect the data itself, making the statement true.

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

True

False

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

Explanation

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

36. What is a Workbook?

A table of data that is organized into rows and columns

The Excel file that holds your worksheets

A built-in formula in Excel

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

Explanation

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

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

Shift

Tab

Esc

Alt

After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This is because the Tab key is used to move to the next cell in Excel, and accepting the entry means moving to the next cell after the existing entry is displayed.

Explanation

After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This is because the Tab key is used to move to the next cell in Excel, and accepting the entry means moving to the next cell after the existing entry is displayed.

38. How would you print formulas?

Click the Microsoft Office Button and then click Print.

Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

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

not-available-via-ai

Explanation

not-available-via-ai

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

Abbreviate all text

Reduce the font size to 8 pt

Click Wrap text

Delete one column

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

Explanation

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

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

Letters

Cell references

Symbols

Operators

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

Explanation

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

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

=A1+A2

=Add(A1+A2)

=together(A1:A2)

A1 plus A2

The correct answer is "=A1+A2". This formula is used to add the values in cells A1 and A2 together. The "+" operator is used to perform the addition operation in Excel.

Explanation

The correct answer is "=A1+A2". This formula is used to add the values in cells A1 and A2 together. The "+" operator is used to perform the addition operation in Excel.

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

Count

Average

Sum

The SUM formula can add all the numeric values in a range of cells and ignore those that are not numeric. It will then place the result in a different cell.

Explanation

The SUM formula can add all the numeric values in a range of cells and ignore those that are not numeric. It will then place the result in a different cell.

43. A Range in Microsoft Excel refers to...

A group of cells

A calculation that describes the relationship between cells

A way of arranging data in a particular order

A range in Microsoft Excel refers to a group of cells. This means that multiple cells can be selected and treated as a single unit. Ranges are commonly used for performing calculations, formatting data, and applying functions or formulas to a specific set of cells. By selecting a range, users can easily manipulate and analyze data within Excel, making it a fundamental feature of the software.

Explanation

A range in Microsoft Excel refers to a group of cells. This means that multiple cells can be selected and treated as a single unit. Ranges are commonly used for performing calculations, formatting data, and applying functions or formulas to a specific set of cells. By selecting a range, users can easily manipulate and analyze data within Excel, making it a fundamental feature of the software.

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

Explanation

The cell labeled F5 refers to the intersection of column F and row 5 in a spreadsheet.

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

Explanation

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell. Cells are used to store and manipulate data in Excel, and they are identified by their unique row and column reference.

46. 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 provided, the ribbon tab that is highlighted is the "Data" tab. This can be identified by the label on the tab and the specific layout and icons displayed within the tab.

Explanation

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

47. What term describes explanatory text attached to a cell

Callouts

Comments

Dialogs

Extensions

Comments are the correct answer because they are explanatory text attached to a cell in a spreadsheet or document. Comments provide additional information or explanations about the data or content in the cell, allowing users to provide context or clarification for others who may view or edit the document.

Explanation

Comments are the correct answer because they are explanatory text attached to a cell in a spreadsheet or document. Comments provide additional information or explanations about the data or content in the cell, allowing users to provide context or clarification for others who may view or edit the document.

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

Formula

Name Box

Title bar

When a formula is written in a cell, it appears in the active cell where it is being written and also in the formula bar. The formula bar is located at the top of the Excel window and displays the contents of the active cell, including any formulas that have been entered. Therefore, the correct answer is "Formula".

Explanation

When a formula is written in a cell, it appears in the active cell where it is being written and also in the formula bar. The formula bar is located at the top of the Excel window and displays the contents of the active cell, including any formulas that have been entered. Therefore, the correct answer is "Formula".

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

True

False

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

Explanation

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

50. 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 the user identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue to the user. The dark wide border helps prevent any confusion or mistakes when navigating through the spreadsheet and ensures that the user is aware of their current cell selection.

Explanation

The active cell on an Excel spreadsheet is indicated by a dark wide border. This border helps the user identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue to the user. The dark wide border helps prevent any confusion or mistakes when navigating through the spreadsheet and ensures that the user is aware of their current cell selection.

51.

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 cells within the range B3 to B6, inclusive.

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 cells within the range B3 to B6, inclusive.

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

53. 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 exponentiation, also known as raising a number to a power. This means that the number before the ^ symbol is raised to the power of the number after the ^ symbol. For example, if you have the formula "=2^3", it will calculate 2 raised to the power of 3, resulting in the value 8.

Explanation

The ^ key in an Excel formula is used to perform the mathematical operation of exponentiation, also known as raising a number to a power. This means that the number before the ^ symbol is raised to the power of the number after the ^ symbol. For example, if you have the formula "=2^3", it will calculate 2 raised to the power of 3, resulting in the value 8.

54. 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. It is used to manipulate data and perform various operations such as mathematical calculations, text manipulation, and logical operations. Functions in Excel are predefined formulas that can be used to simplify complex calculations and automate tasks. They are represented by a symbol or a combination of letters and symbols and are used by entering them into a cell along with the required arguments or parameters.

Explanation

A function is a built-in formula in Excel that performs a specific action or calculation. It is used to manipulate data and perform various operations such as mathematical calculations, text manipulation, and logical operations. Functions in Excel are predefined formulas that can be used to simplify complex calculations and automate tasks. They are represented by a symbol or a combination of letters and symbols and are used by entering them into a cell along with the required arguments or parameters.

55. 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 Excel calculates the value of A1 raised to the power of A2. It does not multiply the values or compare them, but instead performs an exponential calculation.

Explanation

The formula "=A1^A2" in Excel calculates the value of A1 raised to the power of A2. It does not multiply the values or compare them, but instead performs an exponential calculation.

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. This means that setting up a computerized spreadsheet may require an initial investment or expense, which can be seen as a disadvantage compared to other advantages such as flexibility of moving entries, speed of calculation, and ability to generate tables.

Explanation

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

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

All Except $

All Except

All Except =

All Except >=

The logical test in Excel can include various operators such as =, >=, , . However, it does not include the $ operator. The $ symbol is used in Excel to create absolute references in cell references. Therefore, the correct answer is "All Except $".

Explanation

The logical test in Excel can include various operators such as =, >=, , . However, it does not include the $ operator. The $ symbol is used in Excel to create absolute references in cell references. Therefore, the correct answer is "All Except $".

58. 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-contiguous cells or ranges by clicking on each of them individually. This is useful when you want to select specific cells or ranges from different parts of the worksheet without selecting everything in between. Holding down the SHIFT key would select a continuous range of cells, while holding down the ALT key does not have any specific function for selecting cells or ranges.

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-contiguous cells or ranges by clicking on each of them individually. This is useful when you want to select specific cells or ranges from different parts of the worksheet without selecting everything in between. Holding down the SHIFT key would select a continuous range of cells, while holding down the ALT key does not have any specific function for selecting cells or ranges.

59. =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.

not-available-via-ai

Explanation

not-available-via-ai

60. 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 screen and contains various tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View. Each tab contains specific commands and functions related to that category, making it easy to access and use different features of 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 screen and contains various tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View. Each tab contains specific commands and functions related to that category, making it easy to access and use different features of Excel.

61. 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 is the correct answer because it is a feature in Excel that allows users to change values in a spreadsheet and see how those changes affect the calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making. Track Changes, on the other hand, is a different feature in Excel that allows users to track and review changes made to a spreadsheet by multiple users.

Explanation

What-if analysis is the correct answer because it is a feature in Excel that allows users to change values in a spreadsheet and see how those changes affect the calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making. Track Changes, on the other hand, is a different feature in Excel that allows users to track and review changes made to a spreadsheet by multiple users.

62. 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 the Excel 2007 ribbon 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 the workbook.

Explanation

The Review tab in the Excel 2007 ribbon allows you to check spelling, add a comment, or protect your workbook. This tab contains various tools and options related to reviewing and editing the content of the workbook.

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

True

False

The statement is true because the Insert Function dialog box provides information and guidance on how to use functions in a specific software or program. It helps users understand the syntax, parameters, and purpose of different functions, making it easier for them to utilize the functions effectively in their work or calculations.

Explanation

The statement is true because the Insert Function dialog box provides information and guidance on how to use functions in a specific software or program. It helps users understand the syntax, parameters, and purpose of different functions, making it easier for them to utilize the functions effectively in their work or calculations.

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

True

False

The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis and vertically along the y-axis. These two directions allow for a complete view of the chart from different angles. However, rotating the chart in any other direction, such as along the z-axis, is not possible.

Explanation

The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis and vertically along the y-axis. These two directions allow for a complete view of the chart from different angles. However, rotating the chart in any other direction, such as along the z-axis, is not possible.

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

True

False

not-available-via-ai

Explanation

not-available-via-ai

66. 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. This means that the inner function is defined and declared inside the body of the outer function. The inner function can only be accessed and called from within the outer function. This nesting allows for better organization and encapsulation of code, as well as the ability to create helper functions that are specific to the outer function's functionality.

Explanation

A function inside another function is called a nested function. This means that the inner function is defined and declared inside the body of the outer function. The inner function can only be accessed and called from within the outer function. This nesting allows for better organization and encapsulation of code, as well as the ability to create helper functions that are specific to the outer function's functionality.

67. 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 move cell contents from one location to another within a spreadsheet. This can be done by clicking and holding on a cell, then dragging it to the desired location and releasing the mouse button. It is a convenient way to rearrange data and reorganize the layout of a spreadsheet.

Explanation

The drag and drop method allows you to move cell contents from one location to another within a spreadsheet. This can be done by clicking and holding on a cell, then dragging it to the desired location and releasing the mouse button. It is a convenient way to rearrange data and reorganize the layout of a spreadsheet.

68. 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 syntax for the IF function in Excel, where it checks if the value in cell B2 is greater than 50000. If it is, it returns the text "rich", otherwise it returns the text "poor".

Explanation

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

69. 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 if the condition is true, it returns one value, and if the condition is false, it returns another value. 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 if the condition is true, it returns one value, and if the condition is false, it returns another value. This function is commonly used in Excel and other spreadsheet programs to perform logical tests and make decisions based on the results.

70. 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 operator is used to concatenate or join text from two cells into one cell in Excel. It allows you to combine the contents of multiple cells into a single cell, creating a continuous string of text.

Explanation

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

71. 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 when the formula is copied or filled to other cells, the reference to cell A1 will not change. The dollar signs lock the row and column references, allowing the formula to always refer to the same cell regardless of where it is copied. This is useful when you want to refer to a specific cell in a formula that needs to be consistent throughout the spreadsheet.

Explanation

When a cell reference in an Excel formula has dollar signs like $A$1, it creates an absolute reference. This means that when the formula is copied or filled to other cells, the reference to cell A1 will not change. The dollar signs lock the row and column references, allowing the formula to always refer to the same cell regardless of where it is copied. This is useful when you want to refer to a specific cell in a formula that needs to be consistent throughout the spreadsheet.

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

By typing the data in A1 and merging cells A1:E1, the title will be centered across the top of the data. Merging cells allows the title to span multiple columns and by typing the data in A1, it ensures that the title is aligned with the center of the merged cells. This method is a simple and effective way to center the title in the given scenario.

Explanation

By typing the data in A1 and merging cells A1:E1, the title will be centered across the top of the data. Merging cells allows the title to span multiple columns and by typing the data in A1, it ensures that the title is aligned with the center of the merged cells. This method is a simple and effective way to center the title in the given scenario.

73. 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 to sort data in an Excel worksheet, you can use either the Sort A to Z and Sort Z to A buttons, the Quicksort Options, or the Sort command on the Formulas tab. All of these options can be used to sort data in Excel.

Explanation

The correct answer is "Any of the above". This is because to sort data in an Excel worksheet, you can use either the Sort A to Z and Sort Z to A buttons, the Quicksort Options, or the Sort command on the Formulas tab. All of these options can be used to sort data in Excel.

74. 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. Therefore, these two arguments are required in an IF function to specify the outcomes based on the condition being evaluated.

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. Therefore, these two arguments are required in an IF function to specify the outcomes based on the condition being evaluated.

75. 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 correct answer 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 correct answer is False.

76. 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 will automatically update to the current date every time the spreadsheet is opened or recalculated.

Explanation

The correct answer is =TODAY(). This function is used to display today's date and it will automatically update to the current date every time the spreadsheet is opened or recalculated.

77. 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. Pressing F2 allows the user to directly edit the text or formula within a selected cell, without needing to double-click or use the mouse to access the editing mode. This shortcut helps to streamline the editing process and improve efficiency when working with large amounts of data.

Explanation

F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software like Microsoft Excel. Pressing F2 allows the user to directly edit the text or formula within a selected cell, without needing to double-click or use the mouse to access the editing mode. This shortcut helps to streamline the editing process and improve efficiency when working with large amounts of data.

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

Go to the insert tab on the ribbon and select object. Choose Adobe Photoship Image from the box and select Ok

Microsoft Office is not compatible with Adobe products

Select Open from the Office Button. Browse to your image file, select the checkbox labeled Insert into current document and hit open.

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.

79. 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. By specifying -3 as the number of digits, the function rounds to the nearest multiple of 1000. In this case, the number 645123.875 is rounded to 645000, which is the nearest thousand.

Explanation

The function =Round(A5,-3) rounds the number in cell A5 to the nearest thousand. By specifying -3 as the number of digits, the function rounds to the nearest multiple of 1000. In this case, the number 645123.875 is rounded to 645000, which is the nearest thousand.

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

81. 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 word "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 return a logical value like "TRUE" or "FALSE".

Explanation

A formula with the COUNT() function does not show the word "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 return a logical value like "TRUE" or "FALSE".

82. 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 view that puts a blue line around each page that would be printed is the Page Break Preview. This view allows users to see how their document will be divided into pages when printed, with blue lines indicating where each page will start and end. It is useful for adjusting page breaks and formatting to ensure that the document is properly organized and does not have awkward page breaks.

Explanation

The view that puts a blue line around each page that would be printed is the Page Break Preview. This view allows users to see how their document will be divided into pages when printed, with blue lines indicating where each page will start and end. It is useful for adjusting page breaks and formatting to ensure that the document is properly organized and does not have awkward page breaks.

83. 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 manually applying each formatting option.

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 manually applying each formatting option.

84. 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. Excel 2007 increased the maximum number of rows from the previous version, which had only 65536 rows. This increase allows for a larger amount of data to be stored and analyzed in a single worksheet, making it more efficient for complex calculations and data analysis tasks.

Explanation

The number of rows in an Excel 2007 worksheet is 1048576. Excel 2007 increased the maximum number of rows from the previous version, which had only 65536 rows. This increase allows for a larger amount of data to be stored and analyzed in a single worksheet, making it more efficient for complex calculations and data analysis tasks.

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

Six

Seven

Four

Pie charts are most effective with six or fewer slices because having too many slices can make the chart cluttered and difficult to read. With fewer slices, it is easier to compare the sizes of each slice and understand the overall distribution of the data. Additionally, having too many slices can result in small angles, making it harder to accurately interpret the proportions represented by each slice. Therefore, limiting the number of slices to six or fewer ensures that the pie chart remains clear and easily understandable.

Explanation

Pie charts are most effective with six or fewer slices because having too many slices can make the chart cluttered and difficult to read. With fewer slices, it is easier to compare the sizes of each slice and understand the overall distribution of the data. Additionally, having too many slices can result in small angles, making it harder to accurately interpret the proportions represented by each slice. Therefore, limiting the number of slices to six or fewer ensures that the pie chart remains clear and easily understandable.

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

Color blindness is a condition where individuals have difficulty distinguishing certain colors, particularly red and green. This means that individuals with color blindness may struggle to differentiate between red and green text and background. Therefore, when creating an Excel workbook, it is recommended to avoid using red and green together to ensure that the content is accessible to individuals with color blindness.

Explanation

Color blindness is a condition where individuals have difficulty distinguishing certain colors, particularly red and green. This means that individuals with color blindness may struggle to differentiate between red and green text and background. Therefore, when creating an Excel workbook, it is recommended to avoid using red and green together to ensure that the content is accessible to individuals with color blindness.

87. 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 "Counts the number of characters in a cell."

Explanation

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

88. 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 Microsoft Excel. It displays the address or name of the selected cell, which allows users to easily identify and reference specific cells in a spreadsheet.

Explanation

The name of the active cell appears in the Name box. The Name box is located next to the Formula bar in Microsoft Excel. It displays the address or name of the selected cell, which allows users to easily identify and reference specific cells in a spreadsheet.

89. 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 specific conditions. It allows you to specify multiple criteria and only adds up the values that meet all of the specified conditions. This makes it a powerful tool for performing calculations on specific subsets of data within a range of cells.

Explanation

The SUMIFS function in Excel allows you to add up cell values based on specific conditions. It allows you to specify multiple criteria and only adds up the values that meet all of the specified conditions. This makes it a powerful tool for performing calculations on specific subsets of data within a range of cells.

90. 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 for quick and easy creation of charts without having to go through the menu options.

Explanation

Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows for quick and easy creation of charts without having to go through the menu options.

91. 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. Excel does have functions such as "Upper" which converts text to uppercase, "Lower" which converts text to lowercase, and "Proper" which capitalizes the first letter of each word. However, there is no specific function called "Uppercase" in Excel.

Explanation

The function "Uppercase" does not exist in Excel's function library. Excel does have functions such as "Upper" which converts text to uppercase, "Lower" which converts text to lowercase, and "Proper" which capitalizes the first letter of each word. However, there is no specific function called "Uppercase" in Excel.

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

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

Names Box

Define name

Paste name

Format cells

When you want to name a cell or range in Excel, you can use the "Names Box". This feature allows you to assign a specific name to a cell or range of cells, making it easier to reference and work with them in formulas and functions. By typing the desired name into the Names Box, you can quickly assign a meaningful and recognizable name to the selected cell or range.

Explanation

When you want to name a cell or range in Excel, you can use the "Names Box". This feature allows you to assign a specific name to a cell or range of cells, making it easier to reference and work with them in formulas and functions. By typing the desired name into the Names Box, you can quickly assign a meaningful and recognizable name to the selected cell or range.

94. 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 to reach a desired outcome or result. It is particularly useful when you have a specific target in mind and want to determine the input needed to achieve that goal. By specifying a target value and selecting the cell to be adjusted, Goal Seek will iteratively calculate the value needed in another cell to meet the desired result. This feature can be helpful in various scenarios, such as financial modeling, budgeting, and forecasting.

Explanation

Goal Seek is a feature in Excel that allows users to adjust the value in a cell to reach a desired outcome or result. It is particularly useful when you have a specific target in mind and want to determine the input needed to achieve that goal. By specifying a target value and selecting the cell to be adjusted, Goal Seek will iteratively calculate the value needed in another cell to meet the desired result. This feature can be helpful in various scenarios, such as financial modeling, budgeting, and forecasting.

95. When using a DataBar, changing the value of one cell in the range will not affect the bar size of all the other cells.

True

False

When using a DataBar, changing the value of one cell in the range will affect the bar size of all the other cells. DataBar is a conditional formatting feature in Microsoft Excel that allows you to visually represent the values in a range of cells using horizontal bars. The length of the bar is determined by the value in each cell, so changing the value of one cell will automatically adjust the bar size for all the other cells in the range. Therefore, the given statement is false.

Explanation

When using a DataBar, changing the value of one cell in the range will affect the bar size of all the other cells. DataBar is a conditional formatting feature in Microsoft Excel that allows you to visually represent the values in a range of cells using horizontal bars. The length of the bar is determined by the value in each cell, so changing the value of one cell will automatically adjust the bar size for all the other cells in the range. Therefore, the given statement is false.

96. 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. When a formula contains multiple functions, Excel first evaluates the innermost function and then uses the result of that function as an argument for the next outer function. This process continues until all functions have been evaluated. Therefore, the correct answer is False.

Explanation

Excel actually starts with the innermost function and then moves outward. When a formula contains multiple functions, Excel first evaluates the innermost function and then uses the result of that function as an argument for the next outer function. This process continues until all functions have been evaluated. Therefore, the correct answer is False.

97. 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 allows the user to input their typing as the contents of the cell, but the focus remains in the same cell. This means that after typing, the cursor does not move to another cell and the user can continue working within the same cell.

Explanation

Pressing CTRL + ENTER allows the user to input their typing as the contents of the cell, but the focus remains in the same cell. This means that after typing, the cursor does not move to another cell and the user can continue working within the same cell.

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

Alt+~

Ctrl+~

Ctrl+W

Ctrl+¬

Pressing the Ctrl+~ keys allows you to display all formulas in an active worksheet. This keyboard shortcut is useful for quickly viewing and checking the formulas used in a worksheet, especially when working with complex calculations or troubleshooting errors.

Explanation

Pressing the Ctrl+~ keys allows you to display all formulas in an active worksheet. This keyboard shortcut is useful for quickly viewing and checking the formulas used in a worksheet, especially when working with complex calculations or troubleshooting errors.

99. Two common wildcard characters that Excel recognizes are

* and /

< and >

* and ?

+ and –

In Excel, the asterisk (*) is a wildcard character that represents any number of characters, while the question mark (?) is a wildcard character that represents a single character. These wildcard characters are commonly used in Excel functions such as COUNTIF or SUMIF to perform searches or calculations on a range of cells that match a specific pattern or criteria.

Explanation

In Excel, the asterisk (*) is a wildcard character that represents any number of characters, while the question mark (?) is a wildcard character that represents a single character. These wildcard characters are commonly used in Excel functions such as COUNTIF or SUMIF to perform searches or calculations on a range of cells that match a specific pattern or criteria.

100. To open the Format Cells dialog box, press

Alt + 1

Ctrl + 1

Ctrl + Shift + 1

F1

Pressing Ctrl + 1 opens the Format Cells dialog box. This shortcut allows users to quickly access the formatting options for cells in a spreadsheet or document. By using Ctrl + 1, users can easily modify the appearance and formatting of selected cells, such as changing the font, applying borders, or adjusting the number format. This shortcut is commonly used in programs like Microsoft Excel and Word, providing a convenient way to customize the look and feel of data.

Explanation

Pressing Ctrl + 1 opens the Format Cells dialog box. This shortcut allows users to quickly access the formatting options for cells in a spreadsheet or document. By using Ctrl + 1, users can easily modify the appearance and formatting of selected cells, such as changing the font, applying borders, or adjusting the number format. This shortcut is commonly used in programs like Microsoft Excel and Word, providing a convenient way to customize the look and feel of data.

101. 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 find objects with a value greater than X or acquired after a certain date. These filters can be customized according to your requirements and help you narrow down the search results to only include the desired objects.

Explanation

Custom filters allow you to create specific criteria to find objects with a value greater than X or acquired after a certain date. These filters can be customized according to your requirements and help you narrow down the search results to only include the desired objects.

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

Alt+H

Alt+K

Control+K

Control+L

To add a hyperlink to a worksheet, the shortcut is Control+K. This shortcut allows users to quickly insert a hyperlink to a selected cell or text in the worksheet. By pressing Control+K, users can easily link to a website, a different worksheet, or even a specific location within the same worksheet. This shortcut saves time and provides a convenient way to create clickable links within the worksheet.

Explanation

To add a hyperlink to a worksheet, the shortcut is Control+K. This shortcut allows users to quickly insert a hyperlink to a selected cell or text in the worksheet. By pressing Control+K, users can easily link to a website, a different worksheet, or even a specific location within the same worksheet. This shortcut saves time and provides a convenient way to create clickable links within the worksheet.

103. You can select the current Row by pressing

Control + spacebar

Shift + spacebar

Alt spacebar

Shift + Tab

To select the current row, you need to press Shift + spacebar. This combination of keys highlights the entire row, allowing you to perform actions or make changes specifically to that row.

Explanation

To select the current row, you need to press Shift + spacebar. This combination of keys highlights the entire row, allowing you to perform actions or make changes specifically to that row.

104. 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 the functionality of adding or removing templates, macros, and wizards. This feature allows users to customize their system by adding new templates, macros, or wizards to enhance their workflow or remove any unnecessary ones. It provides flexibility and control over the available tools and resources within the system.

Explanation

The purpose of the Add-In Manager is to provide the functionality of adding or removing templates, macros, and wizards. This feature allows users to customize their system by adding new templates, macros, or wizards to enhance their workflow or remove any unnecessary ones. It provides flexibility and control over the available tools and resources within the system.

105. 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 shortcut allows you to enter the current date into a cell in Excel.

Explanation

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

106. You can press ___________ to move between open Workbook

F6

Control + F6

Shift + F6

Control + Page down

To move between open workbooks in Microsoft Excel, you can use the keyboard shortcut Control + F6. This shortcut allows you to quickly switch between different workbooks that are currently open in Excel. By pressing Control + F6, you can easily navigate and access the different workbooks without having to use the mouse or go through the menu options.

Explanation

To move between open workbooks in Microsoft Excel, you can use the keyboard shortcut Control + F6. This shortcut allows you to quickly switch between different workbooks that are currently open in Excel. By pressing Control + F6, you can easily navigate and access the different workbooks without having to use the mouse or go through the menu options.

107. 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 the data and display it in a clear and organized manner. By using a category axis, the values can be easily compared and understood by the audience.

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 the data and display it in a clear and organized manner. By using a category axis, the values can be easily compared and understood by the audience.

108. 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 that meet the specified criteria within the given range.

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 that meet the specified criteria within the given range.

109. An Excel spreadsheet is also called a _______________________ .

Document

Worksheet

Workbook

An Excel spreadsheet is also called a workbook because it contains multiple worksheets that are interconnected and can be used to organize and analyze data. The workbook acts as a container for all the worksheets and allows users to create, edit, and manipulate data in a structured manner. It provides a comprehensive platform for managing and manipulating data in a tabular format.

Explanation

An Excel spreadsheet is also called a workbook because it contains multiple worksheets that are interconnected and can be used to organize and analyze data. The workbook acts as a container for all the worksheets and allows users to create, edit, and manipulate data in a structured manner. It provides a comprehensive platform for managing and manipulating data in a tabular format.

110. 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 automatically generate a formula in the selected cell that adds up the values in the range it guesses you want to add. This means that Excel will look at the adjacent cells and determine the range based on the data in the column or row. The autosum button saves time by automatically creating the formula for you.

Explanation

When using the autosum button, Excel will automatically generate a formula in the selected cell that adds up the values in the range it guesses you want to add. This means that Excel will look at the adjacent cells and determine the range based on the data in the column or row. The autosum button saves time by automatically creating the formula for you.

111. =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 "=FUNCTION(argument1, argument2, ...)" format represents the general syntax of all functions in various programming languages or spreadsheet software. It indicates that a function is being called with one or more arguments enclosed in parentheses. The specific function name and arguments may vary, but the overall structure remains the same.

Explanation

This answer is correct because the "=FUNCTION(argument1, argument2, ...)" format represents the general syntax of all functions in various programming languages or spreadsheet software. It indicates that a function is being called with one or more arguments enclosed in parentheses. The specific function name and arguments may vary, but the overall structure remains the same.

112. 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, pressing any of the mentioned keys (Enter, Shift-Enter, Ctrl-Enter) from the keyboard will display the answer.

Explanation

After writing the formula, pressing any of the mentioned keys (Enter, Shift-Enter, Ctrl-Enter) from the keyboard will display the answer.

113. 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 when using VLOOKUP, if an exact match is not found, it will return the closest value that is less than the lookup value. This is useful when searching for approximate matches or when dealing with numerical data where an exact match may not be available.

Explanation

The purpose of range lookup in VLOOKUP is to identify the closest minimum value matches. This means that when using VLOOKUP, if an exact match is not found, it will return the closest value that is less than the lookup value. This is useful when searching for approximate matches or when dealing with numerical data where an exact match may not be available.

114. 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. This allows you to quickly apply a predefined set of formatting options to the selected cells, saving time and effort compared to manually formatting each element using the Toolbar or the Formatting dialog box. Using the Format Painter may work for copying the formatting of a single cell to others, but it may not be as efficient when formatting multiple cells with different formatting options.

Explanation

Applying a table style is the most efficient way to format several cells with a specific font, number format, alignment, and font color. This allows you to quickly apply a predefined set of formatting options to the selected cells, saving time and effort compared to manually formatting each element using the Toolbar or the Formatting dialog box. Using the Format Painter may work for copying the formatting of a single cell to others, but it may not be as efficient when formatting multiple cells with different formatting options.