Excel Practice Test 10 Sample Excel Assessment Test ...
[Pages:40]Excel Practice Test 10 Sample Excel Assessment Test
Questions and Answers
Resources
Question 1
Resources
Question:
Excel Assessment Test
Applying AutoSum formulas in the range B12:E12 render wrong results, why is that?
CHOOSE ONE:
A AutoSum formulas exclude last row from results
B AutoSum formulas refer to the column left of their cells
C
AutoSum formulas are referring to their own cells causing error
D
AutoSum formulas, includes header values in the calculation
Resources
Correct Answer
Excel Assessment Test
AutoSum formulas do not exclude last row.
AutoSum formulas are not referring to left row as the data is on the columns.
AutoSum formulas do not refer to the cells they are placed in.
AutoSum
D formulas, includes header values in the calculation
Resources
Question 2
Resources
Question:
Excel Assessment Test
Which function would you choose from below to round up a value to the nearest increment of your choice like for instance up to next 5?
CHOOSE ONE:
A ROUNDUP
B MAX
C CEILING
D ROUND Resources
Correct Answer
Excel Assessment Test
ROUNDUP function rounds the given value upwards to a specified number of digits
MAX function is used for finding maximum value in a given range
ROUND function rounds the given value to specified digits up or down depending upon the value
C CEILING
Resources
Question 3
Resources
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- english assessment practice test online
- sat practice test 10 answers
- assessment practice test for college
- english assessment practice test free
- english assessment test practice esl
- sat practice test 10 pdf
- assessment test practice for employment
- sat practice test 10 answer explanations
- sat practice test 9 sample essay
- sat practice test 10 scoring
- parapro assessment practice test pdf
- sample assessment test for employment