Question

1. Excel 2010 allows you to apply 3D format and surface material to both chart area...

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

Homework Answers

Answer #1

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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
9.You want to have $3,000 in 5 years. You invest your money today and earn 10.6%...
9.You want to have $3,000 in 5 years. You invest your money today and earn 10.6% per annum compounding monthly for the first 2 years and 7.9% per annum compounding quarterly thereafter. If there have been no withdrawals, how much do you need to invest today? (answer to two decimal places; no comma separators) 10. The approximate nominal rate of interest on a bond with a real rate of 2.90% p.a. and expected inflation of 0.50% p.a. is closest to:...
1) Which of the following is the Earth located in? (Select all that apply.) a) the...
1) Which of the following is the Earth located in? (Select all that apply.) a) the solar system b) the Milky Way Galaxy c) the Local Group of galaxies d) the Virgo supercluster e) the universe 2) The laws of nature (as determined by scientists) (Select all that apply.) a) are constructed from many observations and hypotheses and experiments b) apply both on Earth and among the stars c) can never change once they are written down in textbooks d)...
1)Which of the following is/are example(s) of paracrine signaling? a. The release of a protein into...
1)Which of the following is/are example(s) of paracrine signaling? a. The release of a protein into interstitial fluid that then binds to a receptor on the surface of another cell. b. The release of a protein into plasma that then binds to a receptor on the surface of another cell. c. The binding of a protein on the surface of cell to a receptor on the surface of another cell. d. both a) and b) are correct, and c) is...
Excel Lab 2: Regression and Goal Seek In this lab, you will use Excel to determine...
Excel Lab 2: Regression and Goal Seek In this lab, you will use Excel to determine the equation of the model which best fits a set of ordered pairs obtained from data sets. You will enter data, graph the data, find the equation for the regression model, and then use that equation to make predictions for the dependent variable. You will use the goal seek to make predictions for the independent variable. Then you will consider how accurate your predictions...
1. The following equation is used to calculate _____________. Select all that apply. ?=X¯−μs /n A....
1. The following equation is used to calculate _____________. Select all that apply. ?=X¯−μs /n A. An obtained t score B. An obtained z score C. An obtained z score for proportions D. A critical t score E. A critical z score 2. The following equation is used to calculate _______________. ?=p^−Pσp^ A. an obtained t score B. an obtained z score C. an obtained z score for proportions D. a critical t score E. a critical z score 3....
1) Which of the following function to increase the ABSORPTIVE surface area of the small intestine?...
1) Which of the following function to increase the ABSORPTIVE surface area of the small intestine? I. Rugae II. Circular folds/plicae circulares III. Gastric pits IV. Microvilli A. II and IV only B. II only C. IV only D. II, III, and IV only E. I and III only 2) In the kidney, material moving from the blood to the kidney tubule occurs during: I. absorption II. filtration III. secretion A. II and III only B. I only C. III...
1. During translation of a gene sequence in prokaryotes, which of the following is/are true A....
1. During translation of a gene sequence in prokaryotes, which of the following is/are true A. Any AUG can serve as a start condon B. Termination uses rho factor or hairpin structures C. Termination requires nonsense codons D. Splicing does NOT need to occur E. The replication fork sets out in both direction F. Sigma factor is required for correct start site selection 2. Select the best answer/answers: Which of the following statements is CORRECT concerning the Genetic code? A....
Hello! I hope you are healthy and well! I am hoping that this message finds you...
Hello! I hope you are healthy and well! I am hoping that this message finds you happy and content! I am having trouble solving this 5-part practice problem. I would greatly appreciate any and all help that you could lend! Thanks in advance! In the following proof, what is the justification for line 7? 1.     [(W ⊃ X) ⊃ Y] ∨ ( P ≡ Q) 2.     ∼X • ∼Y 3.     ∼(P ≡ Q) / ∴ ∼W 4.     ∼X                  2 Simp 5.     ∼Y                  2 Simp 6.     (W ⊃ X)...
21) Which statement is true regarding the urinary system? (1 point) A) The external urinary sphincter...
21) Which statement is true regarding the urinary system? (1 point) A) The external urinary sphincter function is a structure newborns do not control B) The external urinary sphincter has no function in the female body C) The internal urinary sphincter is voluntary muscle D) The internal urinary sphincter plays a major role in urinary function E) The internal urinary sphincter is not fully developed until childhood 24) Diabetes Mellitus can lead to (2 point) A) High levels of sodium...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first day. Step by Step instructions on completing PR1-5B. BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITE ALL BALANCE FORMULAS. To do so do the following in order. Click on Cell D39. In D39 you will write a formula to add rows D37 and D38. To do so do the following: a)    Start in Cell D39 and press = sign b)    Highlight cell...