MS Excel Quiz 1-10
MS Excel Quiz 11-20
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
MS PowerPoint Quiz and Answer
Adobe Photoshop Quiz and Answer
Adobe Illustrator Quiz and Answer
Logo Design Quiz and Answer
HTML Quiz and Answer
|
Question 21. 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 22. Identify all the arguments and the correct order of arguments needed to
execute the IF() function.
a. logic test
b. logic test, value if false
c. logic test, value if false, value if true
d. logic test, value if true, value if false
Answer : d
Question 23. How can you remove borders applied in cells?
a. Only by choosing "NONE" on the Border tab of Format cells
b. By going to page set up
c. Both by choosing "NONE" on the Border tab of Format cells AND opening the list on Border on the Formatting toolbar, then choosing "no border"
d. Only by opening the list on Border on the Formatting toolbar, then choosing "no border"
Answer : c
Question 24. Data displays in the ________ as you type.
a. status bar
b. formula bar
c. insert function box
d. name box
Answer : b
Question 25. What type of chart would create in order to present how much each component comprise the whole?
a. Ratio and proportion chart
b. Bubble chart
c. Pie chart
d. Scatter plot
e. Bar chart
Answer : c
Question 26. If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.
a. True
b. False
Answer : b
Question 27. Which worksheet function returns the one-tailed probability of the chi-squared distribution?
a. BETADIST
b. AVERAGE
c. BINOMDIST
d. CHIDIST
E. BETAINV
Answer : d
Question 28. When entering formulas and functions in Excel, the symbols *,/,+ and - are called:
a. Operator
b. Sign
c. Changers
d. Constants
Answer : a
Question 29. What would you use to only view the rows in a spreadsheet that meet the criteria you want?
a. Auto Complete
b. Auto Filter
c. Find
d. Goal Seek
Answer : b
Question 30. When a cell containing a formula is copied and then pasted into a new cell, Excel:
a. Does not adjust relative cell references
b. Erase the original copy of the formula
c. Edits cell references in the newly copied formula
d. Only adjust absolute cell reference
Answer : c
|
|