EXCEL IKM END OF COURSE QUESTIONS AND
ANSWERS SET A+
✔✔Pic 10. How can you ensure the column C [Email] in below screen print is visible
and not cut off?
A) You need to un-hide Column C
B) You need to make Column D smaller and this will increase size of the Column C.
C) You can double-click the line on the between column labels C and D to automatically
increase the column width to fit the longest Email in the column.
D) None of the options listed above are correct. - ✔✔C
✔✔Pic 11. Below listed formula will extract user id from the email address (User ID is
the part of the email located before @ symbol)?=LEFT(C2,FIND("@",C2)-1) (T/F) -
✔✔T
✔✔Pic 12. What happens if user selects cell D3 and clicks Wrap Text button in the
ribbon?
A. It will create a heading for above the cell D3
B. It will expand height of column D to the maximum size of the text
C. It will capitalize all the text in the cell.
D. It will wrap a border around the cell - ✔✔b
✔✔Where on the Ribbon can you find options to Delete Cells, Delete Sheet Rows,
Delete SheetColumns and Delete Sheet?
a) These options are not available on the Ribbon and the only way to delete cells or
their contents is to press the Delete button on your keyboard when correspondent cell,
row or sheet is selected.
b) These options can be found under the Formulas tab on the Ribbon in the Formula
Auditing group.
c) These options can be found under the Review tab on the Ribbon in the Delete group.
d) These options are found under the Home tab on the Ribbon in the Cells group. - ✔✔d
, ✔✔How can you ensure that all the rows in an address list you created in Excel are the
same height?
a) To ensure that all the rows in the worksheet are the same height, use the Excel ruler
to set row and column tab stops.
b) It is not possible to make all rows in an Excel worksheet the same height.
c) Select all the rows or the whole worksheet and drag the row label line of any of the
selected rows downwards or upwards to adjust the row height.
d) In the Format group on the Ribbon select the Set Table Height option to ensure the
worksheet rows are the same height. - ✔✔c
✔✔What is the order of operations used to evaluate formulas in Excel?
a) Multiplication, Parentheses, Exponents, Division, Addition, Subtraction
b) Exponents, Parentheses, Multiplication, Division, Addition, Subtraction
c) Parentheses, Exponents, Multiplication, Division, Addition, Subtraction
d) Division, Exponents, Parentheses, Multiplication, Addition, Subtraction
e) Exponents, Multiplication, Parentheses, Division, Addition, Subtraction - ✔✔c
(PEMDAS)
✔✔Select which of the following lists most accurately represent functions found in the
Backstage View in Excel (Backstage view is displayed when you click File tab on the
Ribbon):
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and
Access.
c) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print
and Options.
d) None of the above lists are entirely correct. - ✔✔b
✔✔Selecting multiple columns, especially if they run into the hundreds or thousands,
can take a long time if you do this the manual way by using your mouse. What is a
shortcut for quickly selecting a range of contiguous columns?
a) Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
b) Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
c) Select the first column. Hold down Shift and press the right arrow on the keyboard.
d) All of the above options are correct. - ✔✔c
✔✔Which of the following functions are you likely to find under the Insert tab on the
Ribbon?
a) Insert a page break.
b) Insert a formula.
c) Insert a table.
d) Insert track changes. - ✔✔c
ANSWERS SET A+
✔✔Pic 10. How can you ensure the column C [Email] in below screen print is visible
and not cut off?
A) You need to un-hide Column C
B) You need to make Column D smaller and this will increase size of the Column C.
C) You can double-click the line on the between column labels C and D to automatically
increase the column width to fit the longest Email in the column.
D) None of the options listed above are correct. - ✔✔C
✔✔Pic 11. Below listed formula will extract user id from the email address (User ID is
the part of the email located before @ symbol)?=LEFT(C2,FIND("@",C2)-1) (T/F) -
✔✔T
✔✔Pic 12. What happens if user selects cell D3 and clicks Wrap Text button in the
ribbon?
A. It will create a heading for above the cell D3
B. It will expand height of column D to the maximum size of the text
C. It will capitalize all the text in the cell.
D. It will wrap a border around the cell - ✔✔b
✔✔Where on the Ribbon can you find options to Delete Cells, Delete Sheet Rows,
Delete SheetColumns and Delete Sheet?
a) These options are not available on the Ribbon and the only way to delete cells or
their contents is to press the Delete button on your keyboard when correspondent cell,
row or sheet is selected.
b) These options can be found under the Formulas tab on the Ribbon in the Formula
Auditing group.
c) These options can be found under the Review tab on the Ribbon in the Delete group.
d) These options are found under the Home tab on the Ribbon in the Cells group. - ✔✔d
, ✔✔How can you ensure that all the rows in an address list you created in Excel are the
same height?
a) To ensure that all the rows in the worksheet are the same height, use the Excel ruler
to set row and column tab stops.
b) It is not possible to make all rows in an Excel worksheet the same height.
c) Select all the rows or the whole worksheet and drag the row label line of any of the
selected rows downwards or upwards to adjust the row height.
d) In the Format group on the Ribbon select the Set Table Height option to ensure the
worksheet rows are the same height. - ✔✔c
✔✔What is the order of operations used to evaluate formulas in Excel?
a) Multiplication, Parentheses, Exponents, Division, Addition, Subtraction
b) Exponents, Parentheses, Multiplication, Division, Addition, Subtraction
c) Parentheses, Exponents, Multiplication, Division, Addition, Subtraction
d) Division, Exponents, Parentheses, Multiplication, Addition, Subtraction
e) Exponents, Multiplication, Parentheses, Division, Addition, Subtraction - ✔✔c
(PEMDAS)
✔✔Select which of the following lists most accurately represent functions found in the
Backstage View in Excel (Backstage view is displayed when you click File tab on the
Ribbon):
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and
Access.
c) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print
and Options.
d) None of the above lists are entirely correct. - ✔✔b
✔✔Selecting multiple columns, especially if they run into the hundreds or thousands,
can take a long time if you do this the manual way by using your mouse. What is a
shortcut for quickly selecting a range of contiguous columns?
a) Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
b) Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
c) Select the first column. Hold down Shift and press the right arrow on the keyboard.
d) All of the above options are correct. - ✔✔c
✔✔Which of the following functions are you likely to find under the Insert tab on the
Ribbon?
a) Insert a page break.
b) Insert a formula.
c) Insert a table.
d) Insert track changes. - ✔✔c
