20:00

PDF|

Guide for ICDL-ICDL-EXCEL

Quiz ICDL-ICDL-EXCEL

10/88 Questions|Updated on 2022/11/04
Free Test
/ 10

Quiz

1/10
Automatically sort this list so that the highest mark displays at the top of the list. Exam Dumps ICDL-ICDL-EXCEL 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: Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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. Exam Dumps ICDL-ICDL-EXCEL 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? Exam Dumps ICDL-ICDL-EXCEL 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

ICDL-ICDL-EXCEL Practice test unlocks all online simulator questions

Thank you for choosing the free version of the ICDL-ICDL-EXCEL practice test! Further deepen your knowledge on ICDL Simulator; by unlocking the full version of our ICDL-ICDL-EXCEL 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 ICDL-ICDL-EXCEL practice tests and how to prepare for any exam?

The ICDL-ICDL-EXCEL Simulator Practice Tests are part of the ICDL Database and are the best way to prepare for any ICDL-ICDL-EXCEL exam. The ICDL-ICDL-EXCEL 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 ICDL-ICDL-EXCEL database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with ICDL-ICDL-EXCEL Simulator will also give you an idea of the time it will take to complete each section of the ICDL-ICDL-EXCEL practice test . It is important to note that the ICDL-ICDL-EXCEL Simulator does not replace the classic ICDL-ICDL-EXCEL study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the ICDL-ICDL-EXCEL exam.

BUY NOW

ICDL-ICDL-EXCEL Practice test therefore represents an excellent tool to prepare for the actual exam together with our ICDL practice test . Our ICDL-ICDL-EXCEL 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 ICDL-ICDL-EXCEL Simulator and how our unique ICDL-ICDL-EXCEL Database made up of real questions:

Info quiz:

  • Quiz name:ICDL-ICDL-EXCEL
  • Total number of questions:88
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the ICDL-ICDL-EXCEL 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 ICDL-ICDL-EXCEL Simulator.

Use our Mobile App, available for both Android and iOS devices, with our ICDL-ICDL-EXCEL 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 ICDL-ICDL-EXCEL practice tests which consist of 88 questions and also provide study material to pass the final ICDL-ICDL-EXCEL exam with guaranteed success. Our ICDL-ICDL-EXCEL database contain hundreds of questions and ICDL Tests related to ICDL-ICDL-EXCEL Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW