EXCEL TRAINING EXAM QUESTIONS
AND ANSWERS
There is a button on the ribbon, and you are interested in learning more about its
functionality. How can you access "Tell me more"? - Answer-Hover over the button,
then click "Tell me more" at the bottom of the information displayed.
You are working in your company's "2018 Sales" Workbook with each column
widened and a color graph. When you add a worksheet "2018 Profit," how will the
new worksheet appear? - Answer-with the same formatting as "2018 Sales" before
you made any changes
What does it mean that the right mouse button is "context-sensitive"? - Answer-The
menu items available will differ depending on the context of what you are right-
clicking .
You would like to add some frequently used buttons to the Quick Access Toolbar.
How can you do this? - Answer-Right-click the button on the ribbon and select Add.
You are working in the most recent version of Excel provided by your company. Why
would you use the "Save as type" pulldown menu? - Answer-You are saving the file
for someone with an older version of Excel.
As you are entering sales data into a new worksheet, you inadvertently type
6/31/2019. Which action will Excel take with this? - Answer-Excel will display it as
6/31/2019 but left-justified and as only a set of numbers and dashes, and not an
actual date.
You are entering Sales data for each month in 2018. How can you quickly enter all
12 months in columns? - Answer-Type in January, point to the lower right-hand
corner of the cell, hold down the left mouse button, and drag across the next eleven
rows.
You have numerical data across 12 rows and 4 columns. When you highlight this
range of cells, and then press Average under AutoSum in the Formula ribbon, which
outcome occurs? - Answer-The averages will display in the column at the end of
each row and below the bottom row of each column.
To use AutoSum with a row of four values, where must your cursor be to have the
sum appear in the row if you have not highlighted the cells? - Answer-on the first
empty cell to the right of the last cell containing a value
One of the number cells in your worksheet shows as ###. What does this mean? -
Answer-The content in the cell is wider than the cell width.
AND ANSWERS
There is a button on the ribbon, and you are interested in learning more about its
functionality. How can you access "Tell me more"? - Answer-Hover over the button,
then click "Tell me more" at the bottom of the information displayed.
You are working in your company's "2018 Sales" Workbook with each column
widened and a color graph. When you add a worksheet "2018 Profit," how will the
new worksheet appear? - Answer-with the same formatting as "2018 Sales" before
you made any changes
What does it mean that the right mouse button is "context-sensitive"? - Answer-The
menu items available will differ depending on the context of what you are right-
clicking .
You would like to add some frequently used buttons to the Quick Access Toolbar.
How can you do this? - Answer-Right-click the button on the ribbon and select Add.
You are working in the most recent version of Excel provided by your company. Why
would you use the "Save as type" pulldown menu? - Answer-You are saving the file
for someone with an older version of Excel.
As you are entering sales data into a new worksheet, you inadvertently type
6/31/2019. Which action will Excel take with this? - Answer-Excel will display it as
6/31/2019 but left-justified and as only a set of numbers and dashes, and not an
actual date.
You are entering Sales data for each month in 2018. How can you quickly enter all
12 months in columns? - Answer-Type in January, point to the lower right-hand
corner of the cell, hold down the left mouse button, and drag across the next eleven
rows.
You have numerical data across 12 rows and 4 columns. When you highlight this
range of cells, and then press Average under AutoSum in the Formula ribbon, which
outcome occurs? - Answer-The averages will display in the column at the end of
each row and below the bottom row of each column.
To use AutoSum with a row of four values, where must your cursor be to have the
sum appear in the row if you have not highlighted the cells? - Answer-on the first
empty cell to the right of the last cell containing a value
One of the number cells in your worksheet shows as ###. What does this mean? -
Answer-The content in the cell is wider than the cell width.
