Microsoft Excel Proficiency Test

1. You can modify an exisiting chart?

True

False

The statement suggests that it is possible to make changes or alterations to an existing chart.

Explanation

The statement suggests that it is possible to make changes or alterations to an existing chart.

2. 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 working with monetary values to make them easier to read and understand. By adding the dollar sign, it indicates that the value represents a specific amount of currency. The commas are used to separate thousands, millions, and so on, making large numbers more manageable and visually appealing.

Explanation

The currency number formatting style adds dollar signs and commas to values. This formatting is commonly used when working with monetary values to make them easier to read and understand. By adding the dollar sign, it indicates that the value represents a specific amount of currency. The commas are used to separate thousands, millions, and so on, making large numbers more manageable and visually appealing.

3. 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. It uses the colon (:) to indicate the range of cells.

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. It uses the colon (:) to indicate the range of cells.

4. 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 refers to a table of data that is organized into rows and columns. It is a document where data can be entered, manipulated, and analyzed. Worksheets are commonly used in spreadsheet software, such as Microsoft Excel, to perform calculations, create charts, and present data in a structured format.

Explanation

A worksheet refers to a table of data that is organized into rows and columns. It is a document where data can be entered, manipulated, and analyzed. Worksheets are commonly used in spreadsheet software, such as Microsoft Excel, to perform calculations, create charts, and present data in a structured format.

5. 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 "+" symbol is the mathematical operator for addition in Excel, and by using it between the cell references A1 and A2, the sum of their values is calculated.

Explanation

The correct answer is "=A1+A2". This formula is used to add the values in cells A1 and A2 together. The "+" symbol is the mathematical operator for addition in Excel, and by using it between the cell references A1 and A2, the sum of their values is calculated.

6. 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 sign is necessary to indicate that the content of the cell is a formula and needs to be calculated. By using the equal sign, Excel knows to interpret the text in the cell as a mathematical expression or a function that should be executed. Without the equal sign, Excel will treat the content as plain text.

Explanation

In Excel 2007, the equal sign (=) is used to create a formula or function in a cell. This sign is necessary to indicate that the content of the cell is a formula and needs to be calculated. By using the equal sign, Excel knows to interpret the text in the cell as a mathematical expression or a function that should be executed. Without the equal sign, Excel will treat the content as plain text.

7. 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 feature that automatically adjusts the width of a column to accommodate the longest entry or the height of a row to fit the font. This ensures that all the data in a spreadsheet is visible and properly formatted, without any text being cut off or hidden. It saves time and effort by automatically resizing the columns or rows to optimize the display of data.

Explanation

Autofit is a feature that automatically adjusts the width of a column to accommodate the longest entry or the height of a row to fit the font. This ensures that all the data in a spreadsheet is visible and properly formatted, without any text being cut off or hidden. It saves time and effort by automatically resizing the columns or rows to optimize the display of data.

8. 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 is used to update the data in a PivotTable if any changes have been made. This button allows users to refresh the PivotTable with the most current data from the data source. By clicking on the Refresh Data button, any new or updated data will be pulled into the PivotTable, ensuring that the information displayed is accurate and up to date.

Explanation

The Refresh Data button is used to update the data in a PivotTable if any changes have been made. This button allows users to refresh the PivotTable with the most current data from the data source. By clicking on the Refresh Data button, any new or updated data will be pulled into the PivotTable, ensuring that the information displayed is accurate and up to date.

9. The divide symbol is

/

D

\

)

The correct answer is "/". The divide symbol is commonly represented by a forward slash (/) in mathematics and computer programming. It is used to indicate the division operation between two numbers, where the number before the slash is divided by the number after the slash. For example, 10 / 2 means dividing 10 by 2, resulting in a quotient of 5.

Explanation

The correct answer is "/". The divide symbol is commonly represented by a forward slash (/) in mathematics and computer programming. It is used to indicate the division operation between two numbers, where the number before the slash is divided by the number after the slash. For example, 10 / 2 means dividing 10 by 2, resulting in a quotient of 5.

10. 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 users to create multiple tables in a single worksheet, each with its own set of columns and rows. This feature is useful when organizing and analyzing different sets of data within the same worksheet.

Explanation

The statement is false because you can create multiple Excel tables in a worksheet. Excel allows users to create multiple tables in a single worksheet, each with its own set of columns and rows. This feature is useful when organizing and analyzing different sets of data within the same worksheet.

11. 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 spreadsheets. It allows users to input and manipulate data, perform calculations, create charts and graphs, and organize information in a tabular format. Microsoft Excel is widely used in various industries and professions for financial analysis, data management, budgeting, and other tasks that involve organizing and analyzing numerical data.

Explanation

Microsoft Excel 2007 is a spreadsheets package. This software is specifically designed for creating, editing, and analyzing spreadsheets. It allows users to input and manipulate data, perform calculations, create charts and graphs, and organize information in a tabular format. Microsoft Excel is widely used in various industries and professions for financial analysis, data management, budgeting, and other tasks that involve organizing and analyzing numerical data.

12. 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. These objects can include things like shapes, images, and icons that are strategically placed on the chart to draw attention to specific data points or highlight important information. By using graphics objects, the chart becomes more visually appealing and easier to understand for the audience.

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. These objects can include things like shapes, images, and icons that are strategically placed on the chart to draw attention to specific data points or highlight important information. By using graphics objects, the chart becomes more visually appealing and easier to understand for the audience.

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

True

False

By default, when a worksheet is printed, the grid lines that surround the cells are not printable. This means that when you print a worksheet, only the content within the cells will be printed without the grid lines. However, it is possible to change this default setting and make the grid lines printable if desired.

Explanation

By default, when a worksheet is printed, the grid lines that surround the cells are not printable. This means that when you print a worksheet, only the content within the cells will be printed without the grid lines. However, it is possible to change this default setting and make the grid lines printable if desired.

14. 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 arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or using more complex sorting methods, making it a convenient option for simple data sorting tasks.

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 arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or using more complex sorting methods, making it a convenient option for simple data sorting tasks.

15. You cannot insert comments on each cell.

True

False

The given statement is false because you can indeed insert comments on each cell in certain applications or software, such as Microsoft Excel or Google Sheets. Comments can be added to provide additional information or context about the data in a particular cell, allowing users to add notes or explanations for themselves or others who may be viewing or editing the spreadsheet.

Explanation

The given statement is false because you can indeed insert comments on each cell in certain applications or software, such as Microsoft Excel or Google Sheets. Comments can be added to provide additional information or context about the data in a particular cell, allowing users to add notes or explanations for themselves or others who may be viewing or editing the spreadsheet.

16. 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. In a spreadsheet, cells are organized in a grid with columns labeled alphabetically and rows labeled numerically. Therefore, when referring to a specific cell, the column letter is mentioned first followed by the row number. In this case, F5 refers to the cell in column F and row 5.

Explanation

The cell labeled F5 refers to the intersection of column F and row 5 in a spreadsheet. In a spreadsheet, cells are organized in a grid with columns labeled alphabetically and rows labeled numerically. Therefore, when referring to a specific cell, the column letter is mentioned first followed by the row number. In this case, F5 refers to the cell in column F and row 5.

17. 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. It offers various functionalities that allow users to organize and analyze data effectively.

Explanation

A spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. It offers various functionalities that allow users to organize and analyze data effectively.

18. 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 begin with the letters you typed will appear. This feature is designed to help users easily find and select the desired function without having to remember the exact syntax or name of the function. It saves time and reduces the chances of errors in formula creation.

Explanation

When you start typing a function name within a formula in a cell, a list of functions that begin with the letters you typed will appear. This feature is designed to help users easily find and select the desired function without having to remember the exact syntax or name of the function. It saves time and reduces the chances of errors in formula creation.

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

Explanation

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

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

Review

Home

Data

View

The figure below shows the ribbon tabs in Excel, and the tab that is highlighted is the "Data" tab. This tab is used for managing and analyzing data in Excel, including functions related to sorting, filtering, and data analysis.

Explanation

The figure below shows the ribbon tabs in Excel, and the tab that is highlighted is the "Data" tab. This tab is used for managing and analyzing data in Excel, including functions related to sorting, filtering, and data analysis.

21. 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. By clicking on a specific sheet tab, users can quickly access and view the content of that particular sheet. The sheet tabs are located at the bottom of the workbook interface, making it convenient for users to switch between sheets without having to search through menus or toolbars.

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. By clicking on a specific sheet tab, users can quickly access and view the content of that particular sheet. The sheet tabs are located at the bottom of the workbook interface, making it convenient for users to switch between sheets without having to search through menus or toolbars.

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

not-available-via-ai

Explanation

not-available-via-ai

23. 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 such as the number and type of arguments required, as well as any additional parameters or options that can be used. This information helps users understand how to properly utilize functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.

Explanation

The function arguments dialog box provides information on how to use functions. It likely includes details such as the number and type of arguments required, as well as any additional parameters or options that can be used. This information helps users understand how to properly utilize functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.

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

Explanation

The correct answer is "All of the above" because you can print a range of cells by range name, an entire workbook, or a single worksheet. This means that you have the flexibility to choose what you want to print based on your specific needs.

25. 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 stay hidden until the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only time the row will be visible again is when you have the workbook open and active.

Explanation

When you hide a row in a workbook, it will stay hidden until the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only time the row will be visible again is when you have the workbook open and active.

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. 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 are selected and grouped together to form a range. This allows users to perform operations or calculations on multiple cells simultaneously, making it easier to manipulate and analyze data in Excel. Ranges can be used for various purposes such as entering data, applying formatting, or performing calculations using formulas or functions.

Explanation

A range in Microsoft Excel refers to a group of cells. This means that multiple cells are selected and grouped together to form a range. This allows users to perform operations or calculations on multiple cells simultaneously, making it easier to manipulate and analyze data in Excel. Ranges can be used for various purposes such as entering data, applying formatting, or performing calculations using formulas or functions.

28. Rows are identified by a _______________________

Cell

Column

Number

Rows in a table are identified by a number. Each row is assigned a unique number to differentiate it from other rows in the table. This number serves as a reference point to access or manipulate specific rows of data in the table.

Explanation

Rows in a table are identified by a number. Each row is assigned a unique number to differentiate it from other rows in the table. This number serves as a reference point to access or manipulate specific rows of data in the table.

29. 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. This key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. By holding down the CTRL key, you can add or remove cells from the selection without losing the previously selected ones. This is useful when you want to perform operations on multiple separate areas of a spreadsheet without having to select them all at once.

Explanation

To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. This key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. By holding down the CTRL key, you can add or remove cells from the selection without losing the previously selected ones. This is useful when you want to perform operations on multiple separate areas of a spreadsheet without having to select them all at once.

30. 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. In Excel, a workbook can contain multiple worksheets, each of which can have its own set of data and calculations. It serves as the container for all the data, formulas, and formatting within Excel.

Explanation

A workbook refers to the Excel file that holds your worksheets. In Excel, a workbook can contain multiple worksheets, each of which can have its own set of data and calculations. It serves as the container for all the data, formulas, and formatting within Excel.

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

Matrix

Window

Sheet

Cell

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell. A cell is the basic unit of a spreadsheet and is identified by a unique address, such as A1 or C3. It can contain data, formulas, or functions and is used for organizing and manipulating information in Excel.

Explanation

The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell. A cell is the basic unit of a spreadsheet and is identified by a unique address, such as A1 or C3. It can contain data, formulas, or functions and is used for organizing and manipulating information in Excel.

32. 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 can be expensive 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 can be expensive compared to other advantages such as flexibility of moving entries, speed of calculation, and ability to generate tables.

33. 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 of data that allows for easy comparison and analysis. It uses different types of graphs, such as bar charts or line graphs, to present data in a clear and organized manner. By visually displaying data, charts make it easier to identify patterns, trends, and relationships between different data points. They are commonly used in presentations, reports, and data analysis to effectively communicate information to an audience.

Explanation

A chart is a visual representation of data that allows for easy comparison and analysis. It uses different types of graphs, such as bar charts or line graphs, to present data in a clear and organized manner. By visually displaying data, charts make it easier to identify patterns, trends, and relationships between different data points. They are commonly used in presentations, reports, and data analysis to effectively communicate information to an audience.

34. 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 contains multiple tabs, each representing a different set of commands related to specific functions or features in Excel. The ribbon provides easy access to various tools and options for creating, formatting, and manipulating data 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 contains multiple tabs, each representing a different set of commands related to specific functions or features in Excel. The ribbon provides easy access to various tools and options for creating, formatting, and manipulating data in Excel.

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

Letters

Cell references

Symbols

Operators

The correct answer is "Cell references". In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers inside the parentheses can be either actual numbers or cell references. Cell references allow you to perform calculations using the values stored in specific cells, making it easier to update and modify calculations without changing the formula itself.

Explanation

The correct answer is "Cell references". In the "=SUM(number1 [,number2 ,number3 ...])" formula, the numbers inside the parentheses can be either actual numbers or cell references. Cell references allow you to perform calculations using the values stored in specific cells, making it easier to update and modify calculations without changing the formula itself.

36. 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 easily identify which cell is currently selected and ready for data entry or manipulation. The other options, such as a dotted border or a blinking border, are not typically 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 the user easily identify which cell is currently selected and ready for data entry or manipulation. The other options, such as a dotted border or a blinking border, are not typically used to indicate the active cell in Excel.

37. 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 find the sum of a range of cells. In this case, it is specifying the range as column J between rows 1 and 8, which is J1:J8. This formula will add up the values in those cells and give the total sum.

Explanation

The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to find the sum of a range of cells. In this case, it is specifying the range as column J between rows 1 and 8, which is J1:J8. This formula will add up the values in those cells and give the total sum.

38. 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 can indeed be visually attractive, but they can also make it difficult to accurately interpret the values in the chart. This is because the use of three dimensions can obscure the relationship between the different slices or data points. In particular, it can be challenging to determine which slice is larger or smaller when viewing a 3D chart. Therefore, the statement that 3D charts can obscure the relationship between values is true.

Explanation

3D charts can indeed be visually attractive, but they can also make it difficult to accurately interpret the values in the chart. This is because the use of three dimensions can obscure the relationship between the different slices or data points. In particular, it can be challenging to determine which slice is larger or smaller when viewing a 3D chart. Therefore, the statement that 3D charts can obscure the relationship between values is true.

39. 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, regardless of the version of Excel they are using, can open and edit the file, you should save it as an Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing all users to access and edit the file without any compatibility issues.

Explanation

To ensure that all users, regardless of the version of Excel they are using, can open and edit the file, you should save it as an Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing all users to access and edit the file without any compatibility issues.

40. 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 a feature called "Data Connection" that allows users to connect to various data sources, including database tables. Once the connection is established, users can import the data into an Excel worksheet. By setting up automatic data refresh options, users can easily update the data in the worksheet with just one click, ensuring that the results are always up to date.

Explanation

This statement is true because Excel has a feature called "Data Connection" that allows users to connect to various data sources, including database tables. Once the connection is established, users can import the data into an Excel worksheet. By setting up automatic data refresh options, users can easily update the data in the worksheet with just one click, ensuring that the results are always up to date.

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

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 click Wrap text. This will automatically adjust the height of the cells to fit the content, allowing all text to be visible without losing any data.

Explanation

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 click Wrap text. This will automatically adjust the height of the cells to fit the content, allowing all text to be visible without losing any data.

42. 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 a feature in Excel 2007 that allows users to keep specific rows or columns visible at all times while scrolling through the sheet. This is useful when working with large datasets or tables, as it allows users to easily reference important information in the frozen rows or columns without losing sight of them. By freezing panes, users can improve their productivity and efficiency when navigating and analyzing data in Excel.

Explanation

Freeze Panes is a feature in Excel 2007 that allows users to keep specific rows or columns visible at all times while scrolling through the sheet. This is useful when working with large datasets or tables, as it allows users to easily reference important information in the frozen rows or columns without losing sight of them. By freezing panes, users can improve their productivity and efficiency when navigating and analyzing data in Excel.

43. 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. Pressing F7 will initiate a spell check and grammar check, highlighting any errors or inconsistencies in the text. This feature is useful for ensuring that written content is free from spelling mistakes and grammatical errors.

Explanation

F7 can be used to check spelling and grammar. This key is commonly used in word processing software such as Microsoft Word. Pressing F7 will initiate a spell check and grammar check, highlighting any errors or inconsistencies in the text. This feature is useful for ensuring that written content is free from spelling mistakes and grammatical errors.

44. __________________ is the vertical part of the spreadsheet.

Row

Cell

Columns

Columns refer to the vertical part of a spreadsheet. In a spreadsheet, data is organized into rows and columns, with columns running vertically from top to bottom. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to categorize and organize data in a spreadsheet, allowing users to easily enter and manipulate data in a structured manner.

Explanation

Columns refer to the vertical part of a spreadsheet. In a spreadsheet, data is organized into rows and columns, with columns running vertically from top to bottom. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to categorize and organize data in a spreadsheet, allowing users to easily enter and manipulate data in a structured manner.

45. 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. The function 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. The function 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".

46. 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 be used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range.

Explanation

The SUM formula can be used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range.

47. 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 provides various tools and options for reviewing and editing your spreadsheet, such as spell check, comments, and workbook protection.

Explanation

The Review tab in Excel 2007 allows you to check spelling, add a comment, or protect your workbook. This tab provides various tools and options for reviewing and editing your spreadsheet, such as spell check, comments, and workbook protection.

48. Columns are identified by a _______________ .

Letter

Number

Word

Columns are identified by a letter because in many systems and applications, columns in a table or spreadsheet are typically labeled with letters, such as A, B, C, etc. This letter indicates the column's position and helps in referencing and organizing data within the table or spreadsheet.

Explanation

Columns are identified by a letter because in many systems and applications, columns in a table or spreadsheet are typically labeled with letters, such as A, B, C, etc. This letter indicates the column's position and helps in referencing and organizing data within the table or spreadsheet.

49. 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 in a document or spreadsheet application will make the font in that cell bold. This is a commonly used shortcut for applying the bold formatting to text.

Explanation

The statement is true because pressing the Ctrl+B key combination in a selected cell in a document or spreadsheet application will make the font in that cell bold. This is a commonly used shortcut for applying the bold formatting to text.

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

51. 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 programming languages to perform conditional calculations or display different values based on certain criteria.

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 programming languages to perform conditional calculations or display different values based on certain criteria.

52. 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 calculations, logical operations, text manipulation, and more. Functions in Excel are represented by symbols and can be used to manipulate and analyze data in a specific way.

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 calculations, logical operations, text manipulation, and more. Functions in Excel are represented by symbols and can be used to manipulate and analyze data in a specific way.

53. 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 done by selecting the chart, going to the "Design" tab in the Chart Tools, and clicking on the "Select Data" button. From there, you can choose the data range for the chart and update it as needed, even if the data is in a different worksheet. 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 done by selecting the chart, going to the "Design" tab in the Chart Tools, and clicking on the "Select Data" button. From there, you can choose the data range for the chart and update it as needed, even if the data is in a different worksheet. Therefore, the statement that charts do not remain linked or connected to the data sources if they appear in different worksheets is false.

54. 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 style. It does not alter the actual values or content of the data. Therefore, formatting data only affects the visual representation of the data without changing the underlying data itself.

Explanation

Formatting data refers to changing the way data is displayed, such as changing the font, color, or style. It does not alter the actual values or content of the data. Therefore, formatting data only affects the visual representation of the data without changing the underlying data itself.

55. 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 means that the entry will be selected and the cursor will move to the next cell in the column, allowing the user to continue entering data without having to manually select the next cell.

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 means that the entry will be selected and the cursor will move to the next cell in the column, allowing the user to continue entering data without having to manually select the next cell.

56. 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 the value if test is true and value if test is false are used to specify the outcomes based on the result 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 the value if test is true and value if test is false are used to specify the outcomes based on the result of the logical test.

57. 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 refers to the feature in Excel that allows users to change values in a spreadsheet and observe the impact of those changes on calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making purposes. 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 refers to the feature in Excel that allows users to change values in a spreadsheet and observe the impact of those changes on calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making purposes. 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.

58. 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 that allow users to organize and analyze data. Each worksheet consists of rows and columns, where data can be entered, formatted, and calculated. Multiple worksheets can be created within a workbook to separate and categorize different sets of data or information. Overall, worksheets are an essential component of a workbook and are used to store and manipulate data effectively.

Explanation

A workbook is made up of worksheets. Worksheets are individual sheets within a workbook that allow users to organize and analyze data. Each worksheet consists of rows and columns, where data can be entered, formatted, and calculated. Multiple worksheets can be created within a workbook to separate and categorize different sets of data or information. Overall, worksheets are an essential component of a workbook and are used to store and manipulate data effectively.

59. 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, which means you can change the angle of view from left to right, and vertically along the y-axis, which means you can change the angle of view from top to bottom. These two directions of rotation allow you to explore and analyze the chart from different perspectives.

Explanation

The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis, which means you can change the angle of view from left to right, and vertically along the y-axis, which means you can change the angle of view from top to bottom. These two directions of rotation allow you to explore and analyze the chart from different perspectives.

60. 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 that runs across five columns, one way is to type the title in cell A1 and then merge cells A1 to E1. This will combine the cells into one and allow the title to be centered across all five columns.

Explanation

To center a title across the top of the data that runs across five columns, one way is to type the title in cell A1 and then merge cells A1 to E1. This will combine the cells into one and allow the title to be centered across all five columns.

61. _____________ 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 in cells. Each row 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 in cells. Each row represents a separate record or entry in the spreadsheet.

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

63. 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) will display the number in thousands. The -3 in the function represents the number of decimal places to round to. By rounding to -3 decimal places, the number will be rounded to the nearest thousand.

Explanation

The function =Round(A5,-3) will display the number in thousands. The -3 in the function represents the number of decimal places to round to. By rounding to -3 decimal places, the number will be rounded to the nearest thousand.

64. 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 that can be used to describe the process of converting one unit of measurement to another. In this case, it can be used to convert miles to kilometers, kilograms to pounds, and any other similar conversions.

Explanation

The function "convert" is the correct answer because it is a general term that can be used to describe the process of converting one unit of measurement to another. In this case, it can be used to convert miles to kilometers, kilograms to pounds, and any other similar conversions.

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

True

False

By default, pressing ENTER moves the selection one cell down, not one cell to the right.

Explanation

By default, pressing ENTER moves the selection one cell down, not one cell to the right.

66. 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 easily copy the formatting of 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 adjusting the formatting settings. By selecting the cell with the desired formatting and using the Format Painter command, you can quickly apply the same formatting to another cell or range of cells.

Explanation

The Format Painter command allows you to easily copy the formatting of 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 adjusting the formatting settings. By selecting the cell with the desired formatting and using the Format Painter command, you can quickly apply the same formatting to another cell or range of cells.

67.

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

68. 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 new record is added at the end of the existing data and maintains the sequential order of the table. It is also convenient as it eliminates the need to search for an appropriate location to insert the new record.

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 new record is added at the end of the existing data and maintains the sequential order of the table. It is also convenient as it eliminates the need to search for an appropriate location to insert the new record.

69. 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. This means that users do not need to create a custom format for this purpose. Therefore, the statement is true.

Explanation

Excel does have a built-in format to display 4 digit year values. This means that users do not need to create a custom format for this purpose. Therefore, the statement is true.

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

Six

Seven

Four

Pie charts are most effective with six or fewer slices because the more slices there are, the more difficult it becomes to accurately compare the sizes of the different slices. With too many slices, the chart can become cluttered and confusing, making it harder for the viewer to understand the data being presented. By limiting the number of slices to six or fewer, the pie chart remains clear and easy to interpret.

Explanation

Pie charts are most effective with six or fewer slices because the more slices there are, the more difficult it becomes to accurately compare the sizes of the different slices. With too many slices, the chart can become cluttered and confusing, making it harder for the viewer to understand the data being presented. By limiting the number of slices to six or fewer, the pie chart remains clear and easy to interpret.

71. What term describes explanatory text attached to a cell

Callouts

Comments

Dialogs

Extensions

Comments are used to provide explanatory text or notes attached to a cell in various software applications, such as spreadsheets or programming environments. They allow users to add additional information or context to a specific cell, which can be helpful for collaboration or documentation purposes. Comments are typically displayed as small pop-up windows or icons next to the cell, and can be viewed or edited as needed.

Explanation

Comments are used to provide explanatory text or notes attached to a cell in various software applications, such as spreadsheets or programming environments. They allow users to add additional information or context to a specific cell, which can be helpful for collaboration or documentation purposes. Comments are typically displayed as small pop-up windows or icons next to the cell, and can be viewed or edited as needed.

72. =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 correct answer is "This would select D9 and E9 and add the two together from sheet1." This is because the formula "=Sheet1!D9+Sheet1!E9" is referencing cells D9 and E9 from Sheet1 and adding their values together.

Explanation

The given correct answer is "This would select D9 and E9 and add the two together from sheet1." This is because the formula "=Sheet1!D9+Sheet1!E9" is referencing cells D9 and E9 from Sheet1 and adding their values together.

73. 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 use the column letter followed by the row number. In this case, "G17" would be the correct answer as it references the cell located at column G and row 17.

Explanation

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

74. 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 tomorrow's date when the spreadsheet is opened on a new day.

Explanation

The correct answer is =TODAY(). This function is used to display today's date and it will automatically update to tomorrow's date when the spreadsheet is opened on a new day.

75. 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 the cell, dragging it to the desired location, and then releasing the mouse button to drop the contents into the new cell.

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 the cell, dragging it to the desired location, and then releasing the mouse button to drop the contents into the new cell.

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

True

False

The statement is false. After merging a range into a single cell, you can still realign its content. Merging cells is a formatting feature that combines multiple cells into one larger cell, but it does not affect the alignment or formatting options for the content within the merged cell. You can still adjust the alignment, font size, and other formatting settings for the content within the merged cell.

Explanation

The statement is false. After merging a range into a single cell, you can still realign its content. Merging cells is a formatting feature that combines multiple cells into one larger cell, but it does not affect the alignment or formatting options for the content within the merged cell. You can still adjust the alignment, font size, and other formatting settings for the content within the merged cell.

77. 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, making it easy to identify the active cell. This feature is useful for quickly navigating and referencing 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, making it easy to identify the active cell. This feature is useful for quickly navigating and referencing specific cells in a spreadsheet.

78. 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 raises the value in cell A1 to the power of A2.

Explanation

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

79. 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 in which it is being written and in the Formula bar as well. The Formula bar is located above the worksheet and displays the contents of the active cell, including any formulas. This allows the user to view and edit the formula easily.

Explanation

When a formula is written in a cell, it appears in the active cell in which it is being written and in the Formula bar as well. The Formula bar is located above the worksheet and displays the contents of the active cell, including any formulas. This allows the user to view and edit the formula easily.

80. 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 logical function =COUNT() 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 meet a specified condition. It returns a numerical value, not a logical value. Therefore, it is the only function among the options that does not show "TRUE" or "FALSE" as a result.

Explanation

A formula with the logical function =COUNT() 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 meet a specified condition. It returns a numerical value, not a logical value. Therefore, it is the only function among the options that does not show "TRUE" or "FALSE" as a result.

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

Explanation

A function inside another function is called a nested function.

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

Multiplication

Factorial

Power

Logical

The ^ key in an Excel formula is used for the mathematical operation of exponentiation or raising a number to a power. It is used to calculate the result of a number raised to a certain exponent. For example, if we have the formula "=2^3" in Excel, it will calculate 2 raised to the power of 3, resulting in 8. Therefore, the correct answer is Power.

Explanation

The ^ key in an Excel formula is used for the mathematical operation of exponentiation or raising a number to a power. It is used to calculate the result of a number raised to a certain exponent. For example, if we have the formula "=2^3" in Excel, it will calculate 2 raised to the power of 3, resulting in 8. Therefore, the correct answer is Power.

83. 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 statement "all filters in the worksheet are cleared, if the worksheet contains more than one filter" 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 statement "all filters in the worksheet are cleared, if the worksheet contains more than one filter" is false.

84. 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). This operator is used to concatenate or join text from two cells into one cell. It is commonly used in Excel formulas to combine text strings or cell references. For example, if cell A1 contains "Hello" and cell B1 contains "World", the formula "=A1&B1" would result in "HelloWorld" in another cell.

Explanation

The correct answer is "&" (ampersand). This operator is used to concatenate or join text from two cells into one cell. It is commonly used in Excel formulas to combine text strings or cell references. For example, if cell A1 contains "Hello" and cell B1 contains "World", the formula "=A1&B1" would result in "HelloWorld" in another cell.

85. Two common wildcard characters that Excel recognizes are

* and /

< and >

* and ?

+ and –

Excel recognizes the wildcard characters * and ?. The asterisk (*) represents any number of characters, while the question mark (?) represents a single character. These wildcard characters are often used in Excel formulas and functions to perform pattern matching and find specific values or text within a range of cells. The asterisk can be used to match any combination of characters, while the question mark matches any single character.

Explanation

Excel recognizes the wildcard characters * and ?. The asterisk (*) represents any number of characters, while the question mark (?) represents a single character. These wildcard characters are often used in Excel formulas and functions to perform pattern matching and find specific values or text within a range of cells. The asterisk can be used to match any combination of characters, while the question mark matches any single character.

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

View

Formatting

Home

not-available-via-ai

Explanation

not-available-via-ai

87. 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. In this view, users can see where each page will break when printed, allowing them to make adjustments to ensure the content is displayed and printed correctly.

Explanation

The view that puts a blue line around each page that would be printed is the Page Break Preview. In this view, users can see where each page will break when printed, allowing them to make adjustments to ensure the content is displayed and printed correctly.

88. 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 that affects the ability to distinguish between certain colors. The most common form of color blindness is red-green color blindness, where individuals have difficulty differentiating between shades of red and green. Therefore, when creating an Excel workbook, it is advisable to avoid using red and green text and background together to ensure that the content is easily readable for individuals with color blindness.

Explanation

Color blindness is a condition that affects the ability to distinguish between certain colors. The most common form of color blindness is red-green color blindness, where individuals have difficulty differentiating between shades of red and green. Therefore, when creating an Excel workbook, it is advisable to avoid using red and green text and background together to ensure that the content is easily readable for individuals with color blindness.

89. 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 the logical operators (=, >=, , ) are allowed in a logical test in Excel, except for the dollar sign ($). The dollar sign is not a valid logical operator in Excel.

Explanation

The correct answer is "All Except $". This means that all the logical operators (=, >=, , ) are allowed in a logical test in Excel, except for the dollar sign ($). The dollar sign is not a valid logical operator in Excel.

90. 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 you can sort data in an Excel worksheet using 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 allow you to arrange the data in ascending or descending order based on a specific column or criteria.

Explanation

The correct answer is "Any of the above". This is because you can sort data in an Excel worksheet using 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 allow you to arrange the data in ascending or descending order based on a specific column or criteria.

91. 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. Then, choose Adobe Photoshop Image from the box 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. Then, choose Adobe Photoshop Image from the box and select Ok. This method allows you to add the image to your spreadsheet.

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

True

False

The Insert Function dialog box provides information and guidance on how to use functions in a software program or application. It offers a step-by-step process or instructions on how to input and utilize different functions effectively. Therefore, the statement "The Insert Function dialog box tells you how to use functions" is true.

Explanation

The Insert Function dialog box provides information and guidance on how to use functions in a software program or application. It offers a step-by-step process or instructions on how to input and utilize different functions effectively. Therefore, the statement "The Insert Function dialog box tells you how to use functions" is true.

93. 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 such as Microsoft Excel. Pressing F2 allows the user to enter the editing mode for the selected cell, where they can make changes to the content. This key is convenient for quickly editing cell contents without the need to use the mouse or navigate through menus.

Explanation

F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software such as Microsoft Excel. Pressing F2 allows the user to enter the editing mode for the selected cell, where they can make changes to the content. This key is convenient for quickly editing cell contents without the need to use the mouse or navigate through menus.

94. 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 Excel 2007.

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 Excel 2007.

95. 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 you to input the desired content into the cell, but it keeps the focus in the same cell. This means that after typing the content, you can continue editing or formatting the cell without having to move to another cell.

Explanation

Pressing CTRL + ENTER allows you to input the desired content into the cell, but it keeps the focus in the same cell. This means that after typing the content, you can continue editing or formatting the cell without having to move to another cell.

96. 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 not change when the formula is copied or filled to other cells. The dollar signs lock the row and column references, making them fixed and absolute. This is useful when you want to refer to a specific cell or range of cells in a formula, regardless of where 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 not change when the formula is copied or filled to other cells. The dollar signs lock the row and column references, making them fixed and absolute. This is useful when you want to refer to a specific cell or range of cells in a formula, regardless of where the formula is copied or filled.

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

Alt+H

Alt+K

Control+K

Control+L

Control+K is the shortcut to add a hyperlink to your worksheet. This shortcut allows you to quickly insert a hyperlink to a website, a file, or a specific location within the workbook. By selecting the text or object you want to turn into a hyperlink and using Control+K, you can easily create a clickable link that navigates to the specified destination.

Explanation

Control+K is the shortcut to add a hyperlink to your worksheet. This shortcut allows you to quickly insert a hyperlink to a website, a file, or a specific location within the workbook. By selecting the text or object you want to turn into a hyperlink and using Control+K, you can easily create a clickable link that navigates to the specified destination.

98. 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 means that if the value of one cell increases, the barsize for that cell will also increase, and if the value decreases, the barsize will decrease accordingly. Therefore, the statement "changing the value of one cell in the range will not affect the barsize of all the other cells" is incorrect.

Explanation

When using a databar, changing the value of one cell in the range will affect the barsize of all the other cells. This means that if the value of one cell increases, the barsize for that cell will also increase, and if the value decreases, the barsize will decrease accordingly. Therefore, the statement "changing the value of one cell in the range will not affect the barsize of all the other cells" is incorrect.

99. 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 one or more conditions. It is a versatile function that can be used to perform calculations on a range of cells that meet specific criteria. By specifying the range of cells to be evaluated and the conditions that must be met, the function will only add up the values that satisfy the given criteria. This allows for more precise and targeted calculations, making it a useful tool for data analysis and reporting.

Explanation

The SUMIFS function in Excel allows you to add up cell values based on one or more conditions. It is a versatile function that can be used to perform calculations on a range of cells that meet specific criteria. By specifying the range of cells to be evaluated and the conditions that must be met, the function will only add up the values that satisfy the given criteria. This allows for more precise and targeted calculations, making it a useful tool for data analysis and reporting.

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

F3

F7

F9

F11

Pressing F11 on the keyboard creates a chart from the selected cells.

Explanation

Pressing F11 on the keyboard creates a chart from the selected cells.

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. 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 you to adjust the value in a cell to achieve a desired outcome or result. It is particularly useful in scenarios where you have a target value in mind and need to determine the input value needed to reach that target. By specifying the desired outcome and adjusting the input value, Goal Seek automatically calculates the necessary value to achieve the desired result. This feature is commonly used in financial analysis, forecasting, and decision-making processes.

Explanation

Goal Seek is a feature in Excel that allows you to adjust the value in a cell to achieve a desired outcome or result. It is particularly useful in scenarios where you have a target value in mind and need to determine the input value needed to reach that target. By specifying the desired outcome and adjusting the input value, Goal Seek automatically calculates the necessary value to achieve the desired result. This feature is commonly used in financial analysis, forecasting, and decision-making processes.

103. 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 dialog box, where you can make changes to the formatting of cells in a spreadsheet or document. By pressing Ctrl + 1, you can easily modify the font, 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 dialog box, where you can make changes to the formatting of cells in a spreadsheet or document. By pressing Ctrl + 1, you can easily modify the font, alignment, borders, and other formatting options for selected cells.

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

True

False

This statement is false because there are functions called "void functions" that do not require any arguments. Void functions are used when a function does not need any input from the user and does not return any value. Therefore, not all functions have arguments and there are functions that can work without providing them arguments.

Explanation

This statement is false because there are functions called "void functions" that do not require any arguments. Void functions are used when a function does not need any input from the user and does not return any value. Therefore, not all functions have arguments and there are functions that can work without providing them arguments.

105. 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 option allows you to quickly apply a predefined set of formatting options to the selected cells, saving time and effort compared to individually formatting each element using the toolbar or formatting dialog box. Using the format painter can also be a viable option, but it may require more steps if you have multiple cells to format.

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 option allows you to quickly apply a predefined set of formatting options to the selected cells, saving time and effort compared to individually formatting each element using the toolbar or formatting dialog box. Using the format painter can also be a viable option, but it may require more steps if you have multiple cells to format.

106. 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," "Lower," and "Proper" that can be used to change 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. Excel does have functions such as "Upper," "Lower," and "Proper" that can be used to change the case of text, but "Uppercase" is not a valid function in Excel.

107. 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 several functions, Excel will first evaluate the innermost function and then use the result of that function as an argument for the next outer function, and so on, until it reaches the outermost function. 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 several functions, Excel will first evaluate the innermost function and then use the result of that function as an argument for the next outer function, and so on, until it reaches the outermost function. Therefore, the correct answer is False.

108. 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. By pressing CTRL+ ;, the current date will be automatically inserted into the selected cell. This shortcut can be useful when you need to quickly add the current date to your spreadsheet without typing it manually.

Explanation

The correct answer is CTRL+ ; (semicolon). This shortcut allows you to enter the current date into a cell in Excel. By pressing CTRL+ ;, the current date will be automatically inserted into the selected cell. This shortcut can be useful when you need to quickly add the current date to your spreadsheet without typing it manually.

109. 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 unchanged and retains its formatting.

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 unchanged and retains its formatting.

110. 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 for filtering objects. In this case, you can use custom filters to find all objects with a value greater than X or acquired after a certain date. This means that you can customize the filters to meet your specific requirements and search for objects based on specific conditions.

Explanation

Custom filters allow you to create specific criteria for filtering objects. In this case, you can use custom filters to find all objects with a value greater than X or acquired after a certain date. This means that you can customize the filters to meet your specific requirements and search for objects based on specific conditions.

111. 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 Excel. This keyboard shortcut is useful when you have multiple workbooks open and need to switch between them quickly. It helps to improve efficiency and productivity while working with multiple files simultaneously.

Explanation

Pressing Control + F6 allows you to move between open workbooks in Excel. This keyboard shortcut is useful when you have multiple workbooks open and need to switch between them quickly. It helps to improve efficiency and productivity while working with multiple files simultaneously.

112. 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 you use the autosum button, Excel will automatically generate a formula in the selected cell that adds up the values in the range that it guesses you want to add. This means that it will create a formula that sums up the values in the column of the selected cell.

Explanation

When you use the autosum button, Excel will automatically generate a formula in the selected cell that adds up the values in the range that it guesses you want to add. This means that it will create a formula that sums up the values in the column of the selected cell.

113. 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/vertical line extending across the plot area aiding reading values. It helps to organize and categorize data on the chart by displaying the categories or groups along the horizontal or vertical axis. This allows users to easily interpret and compare the values associated with each category.

Explanation

A category axis is a chart object that is a horizontal/vertical line extending across the plot area aiding reading values. It helps to organize and categorize data on the chart by displaying the categories or groups along the horizontal or vertical axis. This allows users to easily interpret and compare the values associated with each category.

114. An Excel spreadsheet is also called a _______________________ .

Document

Worksheet

Workbook

An Excel spreadsheet is not only a single document or worksheet, but it is a collection of multiple worksheets and other elements such as charts, macros, and data connections. This collection of worksheets and other elements is referred to as a workbook. Therefore, a workbook is the correct term to describe an Excel spreadsheet.

Explanation

An Excel spreadsheet is not only a single document or worksheet, but it is a collection of multiple worksheets and other elements such as charts, macros, and data connections. This collection of worksheets and other elements is referred to as a workbook. Therefore, a workbook is the correct term to describe an Excel spreadsheet.

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

Alt+~

Ctrl+~

Ctrl+W

Ctrl+¬

Pressing Ctrl+~ keys allows you to display all formulas in an active worksheet. This keyboard shortcut is useful when you want to view and check the formulas used in the worksheet for accuracy and troubleshooting purposes.

Explanation

Pressing Ctrl+~ keys allows you to display all formulas in an active worksheet. This keyboard shortcut is useful when you want to view and check the formulas used in the worksheet for accuracy and troubleshooting purposes.

116. 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 the Shift + spacebar keys. This combination allows you to highlight the entire row in a table or spreadsheet.

Explanation

To select the current row, you need to press the Shift + spacebar keys. This combination allows you to highlight the entire row in a table or spreadsheet.

117. 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 or functions. By using the Names Box, you can quickly define and manage named ranges in your spreadsheet.

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 or functions. By using the Names Box, you can quickly define and manage named ranges in your spreadsheet.

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 given statement "Is ________" is asking for the function that fills in the blank. The correct answer is "The general syntax of all functions" because the syntax of a function typically includes the function name followed by parentheses that can contain one or more arguments. This syntax applies to all functions in general, regardless of the specific function being used.

Explanation

This answer is correct because the given statement "Is ________" is asking for the function that fills in the blank. The correct answer is "The general syntax of all functions" because the syntax of a function typically includes the function name followed by parentheses that can contain one or more arguments. This syntax applies to all functions in general, regardless of the specific function being used.

119. 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 the function will count the number of cells within the specified field_range that meet the given criteria.

Explanation

The correct syntax for the COUNTIF function is =COUNTIF(field_range, criteria). This means that the function will count the number of cells within the specified field_range that meet the given criteria.

120. 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, or Ctrl-Enter) from the keyboard will display the answer. The specific key to be pressed may vary depending on the software or application being used.

Explanation

After writing the formula, pressing any of the mentioned keys (Enter, Shift-Enter, or Ctrl-Enter) from the keyboard will display the answer. The specific key to be pressed may vary depending on the software or application being used.

121. 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 add or remove templates, macros, and wizards. This tool allows users to customize their system by adding or removing these features, which can enhance their productivity and efficiency. Templates provide pre-designed formats for documents, macros automate repetitive tasks, and wizards guide users through complex processes. The Add-In Manager gives users control over these features, allowing them to tailor their system to their specific needs and preferences.

Explanation

The purpose of the Add-In Manager is to add or remove templates, macros, and wizards. This tool allows users to customize their system by adding or removing these features, which can enhance their productivity and efficiency. Templates provide pre-designed formats for documents, macros automate repetitive tasks, and wizards guide users through complex processes. The Add-In Manager gives users control over these features, allowing them to tailor their system to their specific needs and preferences.

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. Range lookup allows the function to find the nearest match that is less than or equal to the lookup value. This is useful when the exact match is not available in the table, and you want to retrieve the closest value that is less than or equal to the lookup value.

Explanation

The purpose of range lookup in VLOOKUP is to identify the closest minimum value matches. Range lookup allows the function to find the nearest match that is less than or equal to the lookup value. This is useful when the exact match is not available in the table, and you want to retrieve the closest value that is less than or equal to the lookup value.