Microsoft Excel - Level 1 | Attempts: 2103

2.

Determine what percentage 6 is of 24 by using the following equation 6/24*100?

30%
24%
25%
6%

Correct Answer

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

Rate this question:

3.

What are you trying to achieve by using the following symbol %?

Create a total?
Deduct from equation?
Total up the sum?
Calculate a percentage?

Correct Answer

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

Rate this question:

4.

Which do you press to enter the current time in a cell?

CTRL+SHIFT+: (colon)
CTRL+; (semicolon)
CTRL+F10

Correct Answer

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

Rate this question:

0

5.

Which Excel feature can summarise the data in a large table?

Data Validation
Conditonal Formatting
Autoformat
Pivot Table

Correct Answer

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

Rate this question:

1

6.

Which option would you select to alter the formatting properties in a cell?

Format Cells
Pick from List
Insert
Clear contents

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.

Rate this question:

7.

Which of the following things can be entered in a cell?

Numbers
Words
Equations, Formulas or Functions
Fill Colour

Correct Answer(s)

A. Numbers
A. Words
A. Equations, Formulas or Functions
A. 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.

Rate this question:

2

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?

Count
Average
Sum

Correct Answer

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

Rate this question:

1

9.

To select a column the easiest method is to...?

Double click any cell in the column
Drag from the top cell in the column to the last cell in the column
Click the column heading
Click the column label

Correct Answer

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

Rate this question:

10.

If you press _____, the cell accepts your typing as its contents but the focus stays in the cell

ENTER
CTRL + ENTER
TAB
INSERT

Correct Answer

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

Rate this question:

2

Microsoft Excel - Level 1

What is the correct equation you would insert in the cell to solve the following: 2 is what percent of 8?

Quiz Preview

Determine what percentage 6 is of 24 by using the following equation 6/24*100?

What are you trying to achieve by using the following symbol %?

Which do you press to enter the current time in a cell?

Which Excel feature can summarise the data in a large table?

Which option would you select to alter the formatting properties in a cell?

Which of the following things can be entered in a cell?

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?

To select a column the easiest method is to...?

If you press _____, the cell accepts your typing as its contents but the focus stays in the cell