MS Excel Quiz 11-20
MS Excel Quiz 21-30
MS Excel Quiz 21-30
MS Excel Quiz 31-40
MS Excel Quiz 41-50
MS Excel Quiz 51-60
MS Excel Quiz 61-70
MS Excel Quiz 71-80
MS Excel Quiz 81-90
MS Excel Quiz 91-100
MS Excel Quiz 101-110
Computer Skill Quiz
MS Word Quiz and Answer
Adobe Photoshop Quiz and Answer
Adobe Illustrator Quiz and Answer
Logo Design Quiz and Answer
HTML Quiz and Answer
|
Question 1. Imported data appears entirely in column A. How do you separate the data into individual columns?
a. Unwrap text
b. Data Validation
c. Ungroup
d. Text to Column
Answer : d
Question 2. Which function calculates your monthly mortage payment?
a. PV (present value)
b. NPER (number of period)
c. PMT (payment)
d. All of these
Answer : c
Question 3. There are three worksheets with every new workbook. You can change that automatic number if you want to.
a. True
b. False
Answer : a
Question 4. The SUMIF function is very useful for single-criterion sum formulas. The SUMIF function takes three arguments NOT
including :
a. Sum_range
b. Point
c. Criteria
d. Range
Answer : b
Question 5. When a cell containing a formula is copied and then pasted into a new cell, Excel:
a. Doesn't adjust relative cell references
b. Edits cell references in the newly copied formula
c. Only adjusts absolute cell references
d. Erases the original copy of the formula
Answer : b
Question 6. Which formula extract the first name out of a cell(A2) with first and last names in it like "David Hawley"
a. =Right(A2,FIND("",A2))
b. =LEFT(A2,FIND("",A2))
c. =DEL(A@,"")
d. =Collect(A2,"")
Answer : b
Question 7. The function =VLOOKUP("Widget",D4:E9,2,False) is correct format
a. True
b. False
Answer : a
Question 8. A________is a predefined set of colors, fonts, chart styles, cell styles and fill effects that can be applied to an
entire workbook.
a. Layout
b. Format painter
c. Format
d. Theme
Answer : d
Question 9. A formula with brackets such as {sum((C2:C1)*(D2:D11))} is called:
a. A statical function
b. An array formula
c. The geometric mean
d. A pivot formula
Answer : b
Question 10. A name can be applied to a single cell or a range of cells.
a. True
b. False
Answer : a
|
|