Test How Much Do You Know About Excel Sheets! Trivia

1. Is Ctrl + C the shortcut for copy selected text.

True

False

Ctrl + C is indeed the shortcut for copying selected text. This shortcut is commonly used in various applications and operating systems to quickly duplicate text or content. By pressing Ctrl + C, the selected text is copied to the clipboard, allowing the user to paste it elsewhere using the Ctrl + V shortcut. This functionality is widely recognized and utilized, making the statement true.

Explanation

Ctrl + C is indeed the shortcut for copying selected text. This shortcut is commonly used in various applications and operating systems to quickly duplicate text or content. By pressing Ctrl + C, the selected text is copied to the clipboard, allowing the user to paste it elsewhere using the Ctrl + V shortcut. This functionality is widely recognized and utilized, making the statement true.

2. What is the common excel math function to find the largest value in the selected range.

=Sum(B4,B5)

=Max(B2:B88)

=Min(B2:B88)

The correct answer is =Max(B2:B88). This is because the MAX function in Excel is used to find the largest value in a range of cells. In this case, the range is B2 to B88, and the MAX function will return the largest value within that range.

Explanation

The correct answer is =Max(B2:B88). This is because the MAX function in Excel is used to find the largest value in a range of cells. In this case, the range is B2 to B88, and the MAX function will return the largest value within that range.

3. The Pivot Table helps me to cross data and analyze it depending of what I am looking?

True

False

The given statement is true. A Pivot Table is a powerful tool in data analysis that allows users to cross-reference and analyze data based on their specific requirements. It provides a flexible and interactive way to summarize and organize large amounts of data, making it easier to identify patterns, trends, and relationships. By dragging and dropping different variables into rows, columns, and values, users can quickly generate meaningful insights and create customized reports. Overall, a Pivot Table is an effective tool for data exploration and analysis.

Explanation

The given statement is true. A Pivot Table is a powerful tool in data analysis that allows users to cross-reference and analyze data based on their specific requirements. It provides a flexible and interactive way to summarize and organize large amounts of data, making it easier to identify patterns, trends, and relationships. By dragging and dropping different variables into rows, columns, and values, users can quickly generate meaningful insights and create customized reports. Overall, a Pivot Table is an effective tool for data exploration and analysis.

4. What is the common excel math fuction for finding the average value of the selected range

=Median(A2:B3)

=Average(A2:C14)

=Max(B2:B88)

The correct answer is =Average(A2:C14). This is because the AVERAGE function in Excel is used to calculate the average value of a selected range of cells. In this case, the range A2:C14 is selected, and the AVERAGE function will calculate the average value of all the numbers in that range.

Explanation

The correct answer is =Average(A2:C14). This is because the AVERAGE function in Excel is used to calculate the average value of a selected range of cells. In this case, the range A2:C14 is selected, and the AVERAGE function will calculate the average value of all the numbers in that range.

5. Is Quick Analysis a way to easily display and summarize my data for meaningful conclusion?

True

False

Quick Analysis is a feature in Microsoft Excel that allows users to quickly analyze and summarize their data. It provides various tools and options to easily display data in different formats such as charts, tables, and sparklines. By using Quick Analysis, users can quickly identify patterns, trends, and outliers in their data, which helps in drawing meaningful conclusions. Therefore, the statement "Quick Analysis is a way to easily display and summarize my data for meaningful conclusion" is true.

Explanation

Quick Analysis is a feature in Microsoft Excel that allows users to quickly analyze and summarize their data. It provides various tools and options to easily display data in different formats such as charts, tables, and sparklines. By using Quick Analysis, users can quickly identify patterns, trends, and outliers in their data, which helps in drawing meaningful conclusions. Therefore, the statement "Quick Analysis is a way to easily display and summarize my data for meaningful conclusion" is true.

6. Vlookup will look for a piece of information in a large table of data and pull in any field from that table into your new table?

True

False

Vlookup is a function in Excel that allows you to search for a specific value in a large table of data and retrieve information from a different column within that table. It is commonly used to merge data from different sources or to extract specific information based on a matching criteria. Therefore, the statement that Vlookup can look for a piece of information in a large table of data and pull in any field from that table into your new table is true.

Explanation

Vlookup is a function in Excel that allows you to search for a specific value in a large table of data and retrieve information from a different column within that table. It is commonly used to merge data from different sources or to extract specific information based on a matching criteria. Therefore, the statement that Vlookup can look for a piece of information in a large table of data and pull in any field from that table into your new table is true.

7. You need to sort a column of names alphabetically. What do you do?

Select the column you need to sort. Click the Data tab and click the Sort button

Select the column you need to sort. Click the Insert tab and click the Group button

Manually arrange the data properly

To sort a column of names alphabetically, you need to select the column you want to sort and then click on the "Data" tab. From there, you can find the "Sort" button and click on it. This will arrange the names in alphabetical order. Manually arranging the data would be time-consuming and prone to errors, so using the sorting function is the most efficient and accurate method.

Explanation

To sort a column of names alphabetically, you need to select the column you want to sort and then click on the "Data" tab. From there, you can find the "Sort" button and click on it. This will arrange the names in alphabetical order. Manually arranging the data would be time-consuming and prone to errors, so using the sorting function is the most efficient and accurate method.

8. To count the numer of cells that contain numbers, which formula you use?

=If(A2>2,"Yes")

=sumcells(A1:A5)

=count(A1:A5)

The formula "=count(A1:A5)" is used to count the number of cells that contain numbers in the range A1 to A5. It is a function in Excel that returns the count of cells that contain numbers within a specified range.

Explanation

The formula "=count(A1:A5)" is used to count the number of cells that contain numbers in the range A1 to A5. It is a function in Excel that returns the count of cells that contain numbers within a specified range.

9. In a Vlookup formula. the __________- is the value to be found in the first column of the table, and can be a value, a reference, or text string

Table Array

Lookup Value

Col Index Num

The "Lookup Value" in a Vlookup formula is the value that needs to be found in the first column of the table. It can be a value, a reference, or a text string. This value is used as a reference to search for a corresponding value in the table.

Explanation

The "Lookup Value" in a Vlookup formula is the value that needs to be found in the first column of the table. It can be a value, a reference, or a text string. This value is used as a reference to search for a corresponding value in the table.

10. Is the next formula well type, =SumA5:A8

True

False

The next formula "=SumA5:A8" is not well-typed because it is missing a space between "Sum" and "A5:A8". In Excel, the correct formula should be "=SUM(A5:A8)" where "SUM" is the function and "A5:A8" is the range of cells to be summed. Therefore, the correct answer is False.

Explanation

The next formula "=SumA5:A8" is not well-typed because it is missing a space between "Sum" and "A5:A8". In Excel, the correct formula should be "=SUM(A5:A8)" where "SUM" is the function and "A5:A8" is the range of cells to be summed. Therefore, the correct answer is False.

11. Is Ctrl + Z the shortcut for format the Cells dialogue box?

True

False

The correct answer is False. Ctrl + Z is not the shortcut for formatting the Cells dialogue box. Ctrl + Z is the shortcut for undoing the previous action. To format the Cells dialogue box, you can use the shortcut Ctrl + 1.

Explanation

The correct answer is False. Ctrl + Z is not the shortcut for formatting the Cells dialogue box. Ctrl + Z is the shortcut for undoing the previous action. To format the Cells dialogue box, you can use the shortcut Ctrl + 1.

12. Tables can organize data for easier reading and analysis. How do you create a table?

After highlighting the data you need, select the insert tab and click on the Table button.

From the window tab, click the insert button and select table

Select your data and click the Page Layout tab. Click on the Table button

To create a table, you need to first highlight the data that you want to include in the table. Then, you should go to the insert tab and click on the Table button. This will prompt the creation of a table with the selected data.

Explanation

To create a table, you need to first highlight the data that you want to include in the table. Then, you should go to the insert tab and click on the Table button. This will prompt the creation of a table with the selected data.

13. The $ symbol in the formula will block the column A =$A4

True

False

The $ symbol in a formula is used to lock a specific cell reference in a formula. In this case, the $ symbol is used to lock the column A, while allowing the row number to change. This means that when the formula is copied to other cells, the column reference will remain the same, but the row reference will adjust accordingly. Therefore, the statement "The $ symbol in the formula will block the column A =$A4" is true.

Explanation

The $ symbol in a formula is used to lock a specific cell reference in a formula. In this case, the $ symbol is used to lock the column A, while allowing the row number to change. This means that when the formula is copied to other cells, the column reference will remain the same, but the row reference will adjust accordingly. Therefore, the statement "The $ symbol in the formula will block the column A =$A4" is true.

14. Is the next formula correct, =Vlookup(A5,$A$5:A10,0)

True

False

The next formula is not correct because the range in the VLOOKUP function should be specified with the column index as well. In this case, the range is only specified as $A$5:A10, missing the column index. The correct formula should be =VLOOKUP(A5,$A$5:$A$10,1,0).

Explanation

The next formula is not correct because the range in the VLOOKUP function should be specified with the column index as well. In this case, the range is only specified as $A$5:A10, missing the column index. The correct formula should be =VLOOKUP(A5,$A$5:$A$10,1,0).

15. The If error returns a value you specify if a formula evaluates to an error, otherwise, returns the result of the formula. =Iferror(value, value_if_error)

True

False

The statement is true because the IFERROR function in Excel is used to handle errors in formulas. It checks if a formula evaluates to an error, and if it does, it returns a specified value. If the formula does not result in an error, it returns the result of the formula itself. This allows for better error handling and prevents the formula from displaying an error message.

Explanation

The statement is true because the IFERROR function in Excel is used to handle errors in formulas. It checks if a formula evaluates to an error, and if it does, it returns a specified value. If the formula does not result in an error, it returns the result of the formula itself. This allows for better error handling and prevents the formula from displaying an error message.

16. How you can lock columns to remain visibly when I scroll down my worksheet?

I click the page layout option and the click breaks, insert break in top row

I click the view tab and in the window group I click "Freeze Pane" and then click freeze top row

Insert a pivot table with including the top row

By clicking the "Freeze Pane" option in the "View" tab's "Window" group and selecting "Freeze top row", the user can lock the top row of the worksheet. This means that when they scroll down, the top row will remain visible, allowing them to easily reference the column headers or any important information in that row.

Explanation

By clicking the "Freeze Pane" option in the "View" tab's "Window" group and selecting "Freeze top row", the user can lock the top row of the worksheet. This means that when they scroll down, the top row will remain visible, allowing them to easily reference the column headers or any important information in that row.

17. To adjust the column width or a row's height, you need to:

Click the format button under the cells tab.

Click the conditional formatting button under the styles tab

Click the Margings button under the Page Settup tab

To adjust the column width or a row's height in Excel, you need to click the format button under the cells tab. This button provides various formatting options, including adjusting the width of columns and the height of rows. By clicking on this button, you can easily modify the dimensions of the cells to fit your desired specifications.

Explanation

To adjust the column width or a row's height in Excel, you need to click the format button under the cells tab. This button provides various formatting options, including adjusting the width of columns and the height of rows. By clicking on this button, you can easily modify the dimensions of the cells to fit your desired specifications.

18. How can you highlight important numbers stand out from your excel table?

Right Click on the mouse and change the font of the cell

I click the Home Tab and then change the colors in the Font Options

To highlight important numbers and make them stand out from the rest of the excel table, the correct answer suggests using conditional formatting. By selecting the group of cells that need to be highlighted and clicking on the conditional formatting option in the Home Tab, specific formatting rules can be applied to those cells based on their values. This allows for customization such as changing the font color, background color, or adding data bars or color scales to emphasize the important numbers.

Explanation

To highlight important numbers and make them stand out from the rest of the excel table, the correct answer suggests using conditional formatting. By selecting the group of cells that need to be highlighted and clicking on the conditional formatting option in the Home Tab, specific formatting rules can be applied to those cells based on their values. This allows for customization such as changing the font color, background color, or adding data bars or color scales to emphasize the important numbers.

19. You have a large spreadsheet that is full of names. What do you need to do to search for a single person's name?

Under the Data tab, click the Filter button and select the search option.

Under the View tab, click the Zoom button and select the Find option

Under the Home tab, click the find & select button and select the find option

To search for a single person's name in a large spreadsheet, you need to go to the Data tab and click on the Filter button. Then, select the search option from the dropdown menu. This will enable you to search for and locate the specific name you are looking for in the spreadsheet.

Explanation

To search for a single person's name in a large spreadsheet, you need to go to the Data tab and click on the Filter button. Then, select the search option from the dropdown menu. This will enable you to search for and locate the specific name you are looking for in the spreadsheet.

20. The formula "IF SUM" is use when I want to return one value if a condition is true and another value if it's false

True

False

The formula "IF SUM" is not used to return one value if a condition is true and another value if it's false. The correct formula for this purpose is "IF". The "IF SUM" formula is not a valid formula in Excel or any other spreadsheet software.

Explanation

The formula "IF SUM" is not used to return one value if a condition is true and another value if it's false. The correct formula for this purpose is "IF". The "IF SUM" formula is not a valid formula in Excel or any other spreadsheet software.