Microsoft Excel - Level 1
If you feel confident with using MS Excel at Level 1 - Try the quiz and test your knowledge. If not, please return to the tutorials for further support.
- 1.
What is the correct equation you would insert in the cell to solve the following: 2 is what percent of 8?
- A.
(1/8)-100
- B.
(2/8)*100
- C.
(3/12)*100
- D.
(2*8)/100
Correct Answer
B. (2/8)*100Explanation
2 divided by 8 reduces to 1 divided by 4, or one fourth which is 25%Rate this question:
-
- 2.
Determine what percentage 6 is of 24 by using the following equation 6/24*100?
- A.
30%
- B.
24%
- C.
25%
- D.
6%
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.Rate this question:
-
- 3.
What are you trying to achieve by using the following symbol %?
- A.
Create a total?
- B.
Deduct from equation?
- C.
Total up the sum?
- D.
Calculate a percentage?
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.Rate this question:
-
- 4.
Which do you press to enter the current time in a cell?
- A.
CTRL+SHIFT+: (colon)
- B.
CTRL+; (semicolon)
- C.
CTRL+F10
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.Rate this question:
-
- 5.
Which Excel feature can summarise the data in a large table?
- A.
Data Validation
- B.
Conditonal Formatting
- C.
Autoformat
- D.
Pivot Table
Correct Answer
C. AutoformatExplanation
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:
-
- 6.
Which option would you select to alter the formatting properties in a cell?
- A.
Format Cells
- B.
Pick from List
- C.
Insert
- D.
Clear contents
Correct Answer
A. Format CellsExplanation
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?
- A.
Numbers
- B.
Words
- C.
Equations, Formulas or Functions
- D.
Fill Colour
Correct Answer(s)
A. Numbers
B. Words
C. Equations, Formulas or Functions
D. Fill ColourExplanation
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:
-
- 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?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
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:
-
- 9.
To select a column the easiest method is to...?
- A.
Double click any cell in the column
- B.
Drag from the top cell in the column to the last cell in the column
- C.
Click the column heading
- D.
Click the column label
Correct Answer
C. Click the column headingExplanation
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
- A.
ENTER
- B.
CTRL + ENTER
- C.
TAB
- D.
INSERT
Correct Answer
B. CTRL + ENTERExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
May 04, 2010Quiz Created by
Priya1412
Back to top