MS Excel Quiz 1-10
MS Excel Quiz 11-20
MS Excel Quiz 21-30
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 31. What function for calculating variance?
a. VARI
b. STANDARDDEVROOT
c. VARIANCE
d. VAR
Answer : d
Question 32. The best way to automate a complex, repetitive task within a worksheet, is to create:
a. a hyperlink
b. a macro
c. a bar chart
d. a pivot table
e. a page break
Answer : b
Question 33. What can be protected from accidental modification?
a. Objects and scenarios
b. Contents and objects
c. Only objects
d. Only contents
e. Contents objects and scenarios
Answer : e
Question 34. When the string 1234567890 is contained in Cell B3, which formula below returns the last 5 digits of the string?
a. RIGHT(B3,5)
b. LEFT(B3,5,7)
c. RIGHT(B3,7)
d. LEFT(B3,7)
Answer : a
Question 35. How do you make a long sentence fit into the column size?
a. Text Edit
b. Wrap Text
c. Increase the size of the column
d. Shrink To Fit
e. Sentence Wrap
Answer : b
Question 36. You want to lock rows 1:2 and column A in place as you scroll through a large spreadsheet. Which command should you use?
a. Arrange
b. Freeze Top Row
c. View side by side
d. Split
e. Freeze Panes
Answer : e
Question 37. The login for the formula in cell B2: =IF(A2>5,,2,0) is expressed as:
a. 2 in cell B2 if the value in cell A2 is less than 5; otherwise return 0
b. 2 in cell B2 if the value in cell A2 is greater than 5; otherwise return 0
c. 0 in cell B2 if the value in cellA2 is greater than or equal to 5; otherwise return 2
Answer : b
Question 38. What is the difference between a workbook and a worksheet?
a. They are the same
b. Workbooks are Access databases and worksheets are Excel
c. A worksheet contains workbooks
d. A workbooks contains worksheets
Answer : d
Question 39. A macro is defined as:
a. a feature that allows the user to see how a new font or font size will look before actually applied.
b. a recording of commands that can be played back at any time.
c. the prevention of unauthorized use.
d. an anchor which holds that value of a referenced component unchanged.
Answer : b
Question 40. If you place the cursor in cell A2 which contains text and press the keystrokes CTRL-B/CTRL-I/CTRL-U the result will be:
a. Text is copied up to cells B1 and I1
b. All cells in worksheet are Book Antiqua font, in italics and underlined
c. Text in cell A2 is bold, in italics and underlined
d. Cell A2 and all cells under it are made bold and italic
Answer : c
|
|