MS Excel Quiz 1-10
MS Excel Quiz 11-20
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 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 81. Which of the following cannot be included in a header/footer?
a. Image
b. Formulas that calculate
c. Page Number
d. Dates
Answer : b
Question 82. Where do you change the default font for new workbooks?
a. File > Options > Advanced
b. File > Options >Proofing
c. File > Options >General
d. File > Help
e. File > Info > Permissions
Answer : c
Question 83. The Freeze Pane function allows the user to:
a. drag an existing formula across multiple cells within a range by utilizing the
following
b. lock in all existing formulas and formats within the cells that they currently reside.
c. keep an area of a worksheet visible while you scroll to another area of the worksheet.
d. add a macro which sets size-specific formatting within a worksheet.
Answer : c
Question 84. Which one is NOT a column chart type?
a. Stacked column
b. Stacked pyramid
c. Doughnut
d. Clustered cylinder
Answer : c
Question 85. Does delete button remove cell?
a. Yes it removes cell
b. Deletes entire Row
c. DELETE has no effect on cells
d. Deletes all spreadsheets data
e. No, it clears cell contents
Answer : e
Question 86. What is one easy method to see if your spreadsheet will print on one page?
a. Adjust the Zoom to 100%.
, it will print on one page.
b. Select "landscape" on paper set up.
c. Use Page Break Preview.
d. If it fits onto the scree
Answer : c
Question 87. which is not a lookup function in Excel?
a. HLOOKUP
b. LOOKUP
c. VLOOKUP
d. #LOOKUP
Answer : d
Question 88. Which function repeats text a given number of times
a. LOWER
b. VALUE
c. TEXT
d. REPT
e. PROPER
Answer : d
Question 89. What is a circular reference?
a. A moddeling tool
b. A formula that either directly or indirectly depends on itself
c. An animation tool
d. A cell that points to a drawing object
Answer : b
Question 90. When working in Page Break Preview, we can do which of the following?
a. Only add or remove page breaks
b. Only change the print area
c. change the print area, view exactly where the page break occurs, add or remove page
breaks
d. Only change the print area and add or remove page breaks
Answer : c
|
|