1.
You need to sort a column of names alphabetically. What do you do?
Correct Answer
A. Select the column you need to sort. Click the Data tab and click the Sort button
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.
2.
How you can lock columns to remain visibly when I scroll down my worksheet?
Correct Answer
B. I click the view tab and in the window group I click "Freeze Pane" and then click freeze top 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.
3.
Tables can organize data for easier reading and analysis. How do you create a table?
Correct Answer
A. After highlighting the data you need, select the insert tab and click on the Table button.
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.
4.
How can you highlight important numbers stand out from your excel table?
Correct Answer
C. I select the group of cells that I want to work with, then on the Home Tab,I click conditional fomating on the menu
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.
5.
To adjust the column width or a row’s height, you need to:
Correct Answer
A. Click the format button under the cells tab.
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.
6.
You have a large spreadsheet that is full of names. What do you need to do to search for a single person’s name?
Correct Answer
A. Under the Data tab, click the Filter button and select the search option.
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.
7.
Is Ctrl + C the shortcut for copy selected text.
Correct Answer
A. 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.
8.
Is Ctrl + Z the shortcut for format the Cells dialogue box?
Correct Answer
B. False
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.
9.
What is the common excel math fuction for finding the average value of the selected range
Correct Answer
B. =Average(A2:C14)
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.
10.
What is the common excel math function to find the largest value in the selected range.
Correct Answer
B. =Max(B2:B88)
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.
11.
To count the numer of cells that contain numbers, which formula you use?
Correct Answer
C. =count(A1:A5)
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.
12.
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?
Correct Answer
A. 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.
13.
Is Quick Analysis a way to easily display and summarize my data for meaningful conclusion?
Correct Answer
A. 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.
14.
The Pivot Table helps me to cross data and analyze it depending of what I am looking?
Correct Answer
A. True
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.
15.
The $ symbol in the formula will block the column A =$A4
Correct Answer
A. 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.
16.
Is the next formula well type, =SumA5:A8
Correct Answer
B. 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.
17.
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
Correct Answer
B. False
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.
18.
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)
Correct Answer
A. True
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.
19.
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
Correct Answer
B. Lookup Value
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.
20.
Is the next formula correct, =Vlookup(A5,$A$5:A10,0)
Correct Answer
B. False
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).