Microsoft Excel - Level 1
10 Questions
| Total Attempts: 1395
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.
Questions and Answers
- 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
- 2.Determine what percentage 6 is of 24 by using the following equation 6/24*100?
- A.
30%
- B.
24%
- C.
25%
- D.
6%
- 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?
- 4.Which do you press to enter the current time in a cell?
- A.
CTRL+SHIFT+: (colon)
- B.
CTRL+; (semicolon)
- C.
CTRL+F10
- 5.Which Excel feature can summarise the data in a large table?
- A.
Data Validation
- B.
Conditonal Formatting
- C.
Autoformat
- D.
Pivot Table
- 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
- 7.Which of the following things can be entered in a cell?
- A.
Numbers
- B.
Words
- C.
Equations, Formulas or Functions
- D.
Fill Colour
- 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
- 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
- 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
A Basic Microsoft excel quiz! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it...
Questions: 20 | Attempts: 100541 | Last updated: Jul 27, 2021
-
Sample QuestionA fast way to add up this column of numbers is to click on the cell below the numbers and then:
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 61338 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 59571 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
What is The Perfect Gift for Your Best Friend Quiz
What is The Perfect Gift for Your Best Friend Quiz
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Back to top