Excel assesment test


Home - Contact Us - Courses - Learn online free - Assessment - Manuals - Sitemap - Articles - Company profile - Newsletters - Tips


Test your basic excel knowledge 1) Where do you find the quick access bar? a) You have to insert it under the data toolbar b) Under customize when you go into excel options c) At the top left corner of the screen in excel d) Right click on a cell and go to format cells 2) What is the main purpose of the formula bar? a) This is the place where you type the content of cells into b) It gives you another view of you cells content c) It give you a tool to better analize your formulas d) When you are scrolling down, it helps you to see what is in the cell you have currently selected 3) Where do you go to make the sheet name a colour? a) In the home toolbar, click on tab colour b) Right click on the sheet name and go to tab colour c) It is not possible d) Go to format cells, sheets and select tab colour 4) Where can you find the spell checker on excel? a) Home toolbar b) View toolbar c) Data toolbar d) Review toolbar 5) What can you not do when you do printing page set-up? a) Print all your content to one page b) Input the file you are printing from c) Print errors only as <blank> d) Change the colour of the text you are printing 6) You are standing in cell A1,which one of the following is not a correct formula for sum? a) =a1+b1 b) =b1+c1 c) =sum(a2:a3) d) +b1+c1 7) Which action best describes how you would copy a cell and paste all the content to a new cell: a) Copy>Paste special>Values b) Copy>Paste c) Copy>Paste special>Formats d) Copy>Paste special>Formulas 8) Which chart cannot be done in excel? a) Scatter chart b) Pie chart c) Bar chart d) All of the above can be done 9) Take a look at the below picture. How do you generate the sum amount of 25? a) It is an add-in which you can add to your spreadsheets b) You have to get a newer version of excel c) It is automatically generated when you select more than one amount d) It is not possible 10) What does format painter do? a) You can paint different colours on your screen b) It copies formatting which you paste somewhere else to paste only the formatting c) It deletes formatting which currently exists c) It colours in your cells
Home \| Testimonials \| Terms & Conditions \| Contact Us \| Courses \| Manuals \| Sitemap \| Articles