Excel assesment test

1) Which of the following describes a functionality of conditional formatting?

a) Format cells a specific colour that has formulas in
b) Input graphs/pictures in cell next to number to show smalles to biggest numbers
c) Copy and paste formatting only
d) Format workbooks based on conditions

2) Which one of the following cannot be done by data validation?

a) Validate that a cell contains only dates in certain range
b) Give a customized alert message when validation error occurs
c) Create a drop down list of data in another sheet
d) Validate the lenght of text in a cell

3) What does transpose do excel?

a) Converts numbers to text
b) Paste data vertical to horizontal
c) Create a date format in a specific cell
d) Automatically calculates the sum of the range you are selecting, and creates a total

4) What is a hyperlink?

a) It is a link to a website
b) It creates an email button to automatically email your spreadsheet to someone
c) It is the shortcut to excel on the desktop
d) It creates a click through link to another location

5) Please look at the below picture. In which cell, row or column do we need to be to freeze the pains like that?

a) Row 2
b) Column B
c) A1
d) B2

freeze-pains

6) What is the best way to create a number as in the format in the picture below and keep it as a number format for calculation purposes?

a) Insert an apostraphe before the number and then the zeros
b) Create a concatenate formula with all the zeros and then the number
c) Just type it like that
d) Go to custom formatting and insert zeros there

format

7) What is a watch window?

a) It is a window to check the result of the calculation
b) It creates a split screen to work of two screen at onces
c) Is it a window to check numbers on other locations
d) It creates a formula window to validate formulas

8) How many spreadsheet can you protect at once?

a) 2
b) 25
c) 1
d) Unlimited

9) Look at the first table below. We want to change the total sales to 10m. What is wrong with our goal seek below the table?

a) You cannot use a formula as your cell to change
b) The set cell has to be a value, and cannot be a link to a cell
c) 10m is to big to hande for goal seek
d) Nothing it wrong, it will work

goal-seek1

goal-seek

10)Why do we you get a circular reference error in spreadsheets?

a) It tells you that there is to much formulas in your spreadsheet
b) It is when you try and calculates something that is impossible for excel to calculate
c) It is when you input formulas in columns that do not agree with each other
c) It is when links between sheets are broken, and therefore no calculations can be done


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


Test your intermediate excel knowledge 1) Which of the following describes a functionality of conditional formatting? a) Format cells a specific colour that has formulas in b) Input graphs/pictures in cell next to number to show smalles to biggest numbers c) Copy and paste formatting only d) Format workbooks based on conditions 2) Which one of the following cannot be done by data validation? a) Validate that a cell contains only dates in certain range b) Give a customized alert message when validation error occurs c) Create a drop down list of data in another sheet d) Validate the lenght of text in a cell 3) What does transpose do excel? a) Converts numbers to text b) Paste data vertical to horizontal c) Create a date format in a specific cell d) Automatically calculates the sum of the range you are selecting, and creates a total 4) What is a hyperlink? a) It is a link to a website b) It creates an email button to automatically email your spreadsheet to someone c) It is the shortcut to excel on the desktop d) It creates a click through link to another location 5) Please look at the below picture. In which cell, row or column do we need to be to freeze the pains like that? a) Row 2 b) Column B c) A1 d) B2 6) What is the best way to create a number as in the format in the picture below and keep it as a number format for calculation purposes? a) Insert an apostraphe before the number and then the zeros b) Create a concatenate formula with all the zeros and then the number c) Just type it like that d) Go to custom formatting and insert zeros there 7) What is a watch window? a) It is a window to check the result of the calculation b) It creates a split screen to work of two screen at onces c) Is it a window to check numbers on other locations d) It creates a formula window to validate formulas 8) How many spreadsheet can you protect at once? a) 2 b) 25 c) 1 d) Unlimited 9) Look at the first table below. We want to change the total sales to 10m. What is wrong with our goal seek below the table? a) You cannot use a formula as your cell to change b) The set cell has to be a value, and cannot be a link to a cell c) 10m is to big to hande for goal seek d) Nothing it wrong, it will work 10)Why do we you get a circular reference error in spreadsheets? a) It tells you that there is to much formulas in your spreadsheet b) It is when you try and calculates something that is impossible for excel to calculate c) It is when you input formulas in columns that do not agree with each other c) It is when links between sheets are broken, and therefore no calculations can be done
Home \| Testimonials \| Terms & Conditions \| Contact Us \| Courses \| Manuals \| Sitemap \| Articles