20:00

PDF|

Guide for The ICDL L4 excel exam

Quiz The ICDL L4 excel exam

Free Test
/ 10

Quiz

1/10
Automatically sort this list so that the highest mark displays at the top of the list.

Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 2-1484848648
Select the answer
1 correct answer
Option A
Click the sort descending tool from the standard tool bar

Quiz

2/10
If the Enter key was pressed to accept the formula in cell E9, which of the following would be
the result:


Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 3-3183808313
Select the answer
1 correct answer
A.
A #REF! error message.
B.
A #VALUE! error message.
C.
A #NAME! error message.
D.
A Circular Reference error message

Quiz

3/10
Change this column chart to a Bar Chart.


Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 5-628746574
Select the answer
1 correct answer
Option A
Click on the arrow in the chart type tool in the chart tool bar -> select bar chart

Quiz

4/10
Clear the contents of cell B3 without deleting the actual cell.






Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 7-2670614322
Select the answer
1 correct answer
Option A
Select cell B3 -> press delete from the keyboard

Quiz

5/10
Insert a new worksheet into this workbook.


Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 8-2004135312
Select the answer
1 correct answer
Option A
Right click on the sales worksheet -> select insert -> ok

Quiz

6/10
Automatically adjust the height of Row 2 to fit its tallest contents.






Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 10-950852276
Select the answer
1 correct answer
Option A
Double click on the gray area between Row 2 and Row 3

Quiz

7/10
Which formula would display 7% in cell D8 if the customer's order value is over 10,000 and
would display 0% if not.






Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 12-1770868414
Select the answer
1 correct answer
A.
=IF (D7=10,000,7%,0%)
B.
=IF (D8>10000,7%,0%)
C.
=IF (D7>10000,7%,0%)
D.
=IF(D7<10000, 7%, 0%)

Quiz

8/10
Change the user name for this application to Carla Banks.






Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 14-1566315433
Select the answer
1 correct answer
Option A
Tool -> options -> select General tab -> in user name type Carla Banks

Quiz

9/10
Copy all of the formatting from cell B3 and automatically apply it to cell D3.






Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 16-2296969247
Select the answer
1 correct answer
Option A
Click the format painter tool from the standard tool bar -> click on cell D3

Quiz

10/10
Which of the following formulas would calculate the Net Sales for January in this worksheet?


Certification Exam The ICDL L4 excel exam ICDL ICDL-ICDL-EXCEL 17-3670280044
Select the answer
1 correct answer
A.
=SUM(B2:B11)
B.
=B6 + B11
C.
=B6 - B11
D.
=SUM(B6:D6)-SUM(B11:D11)
Looking for more questions?Buy now

The ICDL L4 excel exam Practice test unlocks all online simulator questions

Thank you for choosing the free version of the The ICDL L4 excel exam practice test! Further deepen your knowledge on ICDL Simulator; by unlocking the full version of our The ICDL L4 excel exam Simulator you will be able to take tests with over 88 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 88 questions.

BUY NOW

What to expect from our The ICDL L4 excel exam practice tests and how to prepare for any exam?

The The ICDL L4 excel exam Simulator Practice Tests are part of the ICDL Database and are the best way to prepare for any The ICDL L4 excel exam exam. The The ICDL L4 excel exam practice tests consist of 88 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The The ICDL L4 excel exam database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with The ICDL L4 excel exam Simulator will also give you an idea of the time it will take to complete each section of the The ICDL L4 excel exam practice test . It is important to note that the The ICDL L4 excel exam Simulator does not replace the classic The ICDL L4 excel exam study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the The ICDL L4 excel exam exam.

BUY NOW

The ICDL L4 excel exam Practice test therefore represents an excellent tool to prepare for the actual exam together with our ICDL practice test . Our The ICDL L4 excel exam Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our The ICDL L4 excel exam Simulator and how our unique The ICDL L4 excel exam Database made up of real questions:

Info quiz:

  • Quiz name:The ICDL L4 excel exam
  • Total number of questions:88
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the The ICDL L4 excel exam exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our The ICDL L4 excel exam Simulator.

Use our Mobile App, available for both Android and iOS devices, with our The ICDL L4 excel exam Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all The ICDL L4 excel exam practice tests which consist of 88 questions and also provide study material to pass the final The ICDL L4 excel exam exam with guaranteed success. Our The ICDL L4 excel exam database contain hundreds of questions and ICDL Tests related to The ICDL L4 excel exam Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW