EXCEL IKM COMPREHENSIVE QUESTIONS AND
ANSWERS SET A+
✔✔A SmartArt graphic provides an audible representation of information. (T/F) - ✔✔F
✔✔The "Fill handle" is a small square in the lower-left corner of a selected cell or range
of cells. (T/F) - ✔✔T
✔✔Entering =A7+A9 into cell will subtract the two cells? (T/F) - ✔✔F
✔✔When you have selected a range of cells and then you press CTRL+P. Excel will
automaticallyprint the selected range. (T/F) - ✔✔T
✔✔Excel offers the "Spell Check" function? (T/F) - ✔✔T
✔✔You can move a chart in a workbook from one sheet to another. (T/F) - ✔✔T
✔✔One method you can use to change a worksheet name is to go to the cells group on
the Format tab, click Format and choose Rename Sheet. (T/F) - ✔✔T
✔✔To delete a worksheet all you have to do is close the current workbook and it is then
deleted (T/F) - ✔✔F
✔✔Before printing a worksheet, you should preview it and check for spelling errors.
Completing these tasks before you print can save time and paper. (T/F) - ✔✔T
✔✔You cannot copy a formula using "AutoFill". (T/F) - ✔✔F
✔✔you can modify the size of an image in Excel (T/F) - ✔✔T
✔✔Which of the following statements about the Print Preview is true?
, a) It allows you to view what your document will look like before you physically print the
pages.
b) You access the Print Preview area of the by pressing: Control + P.
c) You access the Print Preview area by clicking on the File tab (Backstage View) to go
to the andthen on the Print button.
d) All of the above statements are correct. - ✔✔D
✔✔What is the correct name of the area outlined in red on the screen print below (Pic 2)
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box - ✔✔e
✔✔What will happened if you select column C and press icon outlined in red? (Pic 4)
a) It is the Select Center Column button.
b) It is the content Center alignment button.
c) It is the Delete Cell Contents button.
d) It is a content Middle Align button. - ✔✔b
✔✔Which function can you use to capture the contents of an open windows application
and insert it into Excel?
A) Click on "Insert tab then select "Icon Set"
B) Click on "Insert tab" then click on "Clip Art"
C) Click on "Home" Tab and then click on "Copy as Picture"
D) Click on "Insert" tab then click on "Screenshot" - ✔✔d
✔✔What is the name best describes area outlined in red in Pic 5
a) Styles Tab
b) Styles Section
c) Styles Group
d) Conditional Formatting group
e) Format as Table group - ✔✔c
✔✔What is the name of area, highlighted in red, in pic 6?
a) Excel Ribbon
b) Excel Ribbon tabs
c) Excel Worksheets tabs
d) Excel Workbook tabs
e) Excel Quick Access Toolbar - ✔✔b
✔✔What is the name of the area, highlighted in red, in the Pic 7:
a) Excel Name Box.
b) Excel Title Bar
c) Excel Formula Bar
ANSWERS SET A+
✔✔A SmartArt graphic provides an audible representation of information. (T/F) - ✔✔F
✔✔The "Fill handle" is a small square in the lower-left corner of a selected cell or range
of cells. (T/F) - ✔✔T
✔✔Entering =A7+A9 into cell will subtract the two cells? (T/F) - ✔✔F
✔✔When you have selected a range of cells and then you press CTRL+P. Excel will
automaticallyprint the selected range. (T/F) - ✔✔T
✔✔Excel offers the "Spell Check" function? (T/F) - ✔✔T
✔✔You can move a chart in a workbook from one sheet to another. (T/F) - ✔✔T
✔✔One method you can use to change a worksheet name is to go to the cells group on
the Format tab, click Format and choose Rename Sheet. (T/F) - ✔✔T
✔✔To delete a worksheet all you have to do is close the current workbook and it is then
deleted (T/F) - ✔✔F
✔✔Before printing a worksheet, you should preview it and check for spelling errors.
Completing these tasks before you print can save time and paper. (T/F) - ✔✔T
✔✔You cannot copy a formula using "AutoFill". (T/F) - ✔✔F
✔✔you can modify the size of an image in Excel (T/F) - ✔✔T
✔✔Which of the following statements about the Print Preview is true?
, a) It allows you to view what your document will look like before you physically print the
pages.
b) You access the Print Preview area of the by pressing: Control + P.
c) You access the Print Preview area by clicking on the File tab (Backstage View) to go
to the andthen on the Print button.
d) All of the above statements are correct. - ✔✔D
✔✔What is the correct name of the area outlined in red on the screen print below (Pic 2)
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box - ✔✔e
✔✔What will happened if you select column C and press icon outlined in red? (Pic 4)
a) It is the Select Center Column button.
b) It is the content Center alignment button.
c) It is the Delete Cell Contents button.
d) It is a content Middle Align button. - ✔✔b
✔✔Which function can you use to capture the contents of an open windows application
and insert it into Excel?
A) Click on "Insert tab then select "Icon Set"
B) Click on "Insert tab" then click on "Clip Art"
C) Click on "Home" Tab and then click on "Copy as Picture"
D) Click on "Insert" tab then click on "Screenshot" - ✔✔d
✔✔What is the name best describes area outlined in red in Pic 5
a) Styles Tab
b) Styles Section
c) Styles Group
d) Conditional Formatting group
e) Format as Table group - ✔✔c
✔✔What is the name of area, highlighted in red, in pic 6?
a) Excel Ribbon
b) Excel Ribbon tabs
c) Excel Worksheets tabs
d) Excel Workbook tabs
e) Excel Quick Access Toolbar - ✔✔b
✔✔What is the name of the area, highlighted in red, in the Pic 7:
a) Excel Name Box.
b) Excel Title Bar
c) Excel Formula Bar
