1. Excel 2010 allows you to apply 3D format and surface material to both chart area and individual series. Which of the following materials are available in the list of standard materials in Excel 2010?
Select all that apply
a. Plastic
b. Wood
c. Matte
d. Charcol
e. Metal
2. By defeaut, Excel cells are top aligned
a. True
b. False
3. What does following fuction return? =FLOOR (22, 21)
a. 22
b. 21
c. 1
d. 0
e. 42
4. Which of the following image format is not supported when you select Insert > picture?
a. JFIF
b. JPE
c. RLE
d. PSD
e. WMZ
5. Which of the following options is correct regarding the two statement below?
1. Ctrl + Space selects the entire column(s) even if the selection spans more than one column
2. Ctrl + Space select the entire row(s), even if the selection spans more than one row
a. Statement 1 is correct but statement 2 is incorrect
b. Statement 1 is incorrect wheareas statement 2 is correct
c. Both statements are correct
d. Both statement are incorrect
e. Statement 2 is always correct, but statement 1 depends upon the current selection
Dear Student ,
As per the requirement submitted above , kindly find the below solution.
Question 2 :
Answer :b. False
Explanation :By default, Excel cells are bottom aligned
******************************
Question 3 :
Answer :b. 21
Explanation :Floor will round the given number 22 in the specified number that is 21.
******************************
Question 4 :
Answer :d. PSD
Explanation :PSD is photoshop document which is not supported.
******************************
Question 5 :
Answer :a. Statement 1 is correct but statement 2 is incorrect
Explanation :Ctrl + Space selects the entire column(s) even if the selection spans more than one column
******************************
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Get Answers For Free
Most questions answered within 1 hours.