1.
What is the correct equation you would insert in the cell to solve the following: 2 is what percent of 8?
Correct Answer
B. (2/8)*100
Explanation
2 divided by 8 reduces to 1 divided by 4, or one fourth which is 25%
2.
Determine what percentage 6 is of 24 by using the following equation 6/24*100?
Correct Answer
C. 25%
Explanation
The equation given, 6/24*100, calculates the percentage of 6 in relation to 24. By dividing 6 by 24 and then multiplying by 100, we get the result of 25. This means that 6 is 25% of 24.
3.
What are you trying to achieve by using the following symbol %?
Correct Answer
D. Calculate a percentage?
Explanation
The symbol % is commonly used to calculate a percentage. It represents a proportion or ratio out of 100. By using the % symbol, you can express a part of a whole as a percentage. For example, if you have 50 out of 100, you can represent it as 50%. This symbol is used in various fields such as mathematics, finance, and statistics to calculate and compare percentages.
4.
Which do you press to enter the current time in a cell?
Correct Answer
B. CTRL+; (semicolon)
Explanation
To enter the current time in a cell, you would press CTRL+; (semicolon). This keyboard shortcut allows you to quickly insert the current time into a selected cell in Microsoft Excel.
5.
Which Excel feature can summarise the data in a large table?
Correct Answer
C. Autoformat
Explanation
Autoformat is not the correct answer for this question. Autoformat is a feature in Excel that allows users to quickly apply a predefined format to a selected range of cells. It does not have the capability to summarize data in a large table. The correct answer for summarizing data in a large table would be Pivot Table. Pivot Tables allow users to analyze and summarize large amounts of data by creating customized tables, charts, and reports based on the data.
6.
Which option would you select to alter the formatting properties in a cell?
Correct Answer
A. Format Cells
Explanation
To alter the formatting properties in a cell, you would select "Format Cells" option. This option allows you to modify various formatting aspects such as font style, size, color, borders, alignment, and more. It provides a comprehensive range of formatting options to customize the appearance of the cell according to your preferences or the requirements of the data being displayed.
7.
Which of the following things can be entered in a cell?
Correct Answer(s)
A. Numbers
B. Words
C. Equations, Formulas or Functions
D. Fill Colour
Explanation
In a cell, various types of data can be entered including numbers, words, equations, formulas or functions, and fill color. Numbers can be entered to perform calculations or represent numerical values. Words can be entered as labels, titles, or any other textual information. Equations, formulas, or functions can be entered to perform complex calculations or manipulate data. Fill color can be entered to change the background color of a cell for visual differentiation or formatting purposes.
8.
Which formula can add all the numeric values in a range of cells, ignoring those that are not numeric, and place the result in a different cell?
Correct Answer
C. Sum
Explanation
The formula that can add all the numeric values in a range of cells, ignoring those that are not numeric, and place the result in a different cell is the "Sum" formula. This formula calculates the total sum of all the numeric values within a specified range of cells and disregards any non-numeric values.
9.
To select a column the easiest method is to...?
Correct Answer
C. Click the column heading
Explanation
To select a column, the easiest method is to click the column heading. This is because the column heading represents the entire column and clicking on it automatically selects the entire column. This method is quicker and more efficient compared to the other options provided. Double-clicking any cell in the column may only select that specific cell, dragging from the top cell to the last cell may be time-consuming, and clicking the column label may not necessarily select the entire column. Therefore, clicking the column heading is the most straightforward and effective way to select a column.
10.
If you press _____, the cell accepts your typing as its contents but the focus stays in the cell
Correct Answer
B. CTRL + ENTER
Explanation
Pressing CTRL + ENTER allows the user to enter the content into the cell, but the focus remains in the same cell. This means that after typing the content, the user can continue editing or formatting the cell without having to navigate away from it.