Excel Mastery Quiz: Showcase Your Skills on LinkedIn. EXAM QUESTIONS AND ANSWERS,
RATED A+
About This Quiz:
Ready to demonstrate your Excel skills? This Excel LinkedIn Quiz is designed to test your knowledge of
Excel functions, formulas, data analysis, and formatting, giving you the confidence to showcase your
proficiency on LinkedIn. Whether you're an entry-level user or a seasoned pro, this quiz will help you
gauge your skill level and prepare for LinkedIn certifications, resumes, or job opportunities.
After you adjust the width of column F containing numerical data, these number signs appear. What is
Excel telling you? - ✔✔-The columns are too narrow for the length of the numbers.
Ajaypal has added a couple of shapes and a logo to his worksheet. He holds the shift key down as he
places these items in the location he wants. What does this do? - ✔✔-This makes the item larger or
smaller while maintaining that ratio of height to width.This enables you to change the size of the image
while keeping the content ratio of height to width.
Assume you want all employees to receive a 2.1 percent pay increase. If the value shown in cell H1 is 2.1
percent, what is the correct formula to use in cell F2 and to drag down to the other rows? - ✔✔-When you
copy this formula, Excel will change H1 to H2, which has a zero value, and so on down the column.
Assuming all your worksheet names are color-coded, what action did you just take, or are you taking,
with the East, South, Midwest, and Pacific worksheets? - ✔✔-You have grouped the four sheets.
Carol needs to protect the structure of her Excel file. Which feature should she use? - ✔✔-Protect
Workbook
Darren needs his team to use a standard template for reporting expenses. What advice would you give
him? - ✔✔-Use one of the Microsoft Excel templates that is already built.
Date entries are numbers and by default they _____. - ✔✔-line up on the right side of the cell
Excel's menu system is known as the - ✔✔-ribbon
f you're trying to use VLOOKUP to find an exact match, what value should replace the question mark?
, =VLOOKUP(B2,D:F,3,?) - ✔✔-0
For some reason, such as an interruption, you selected Delete in the warning pop-up for a sheet that you
were not sure you wanted to delete. What have you done? - ✔✔-You have deleted the sheet, and you will
not be able to use Undo to undo the delete.
Germain is creating a worksheet with a master formula =PMT. Which feature is she using? - ✔✔-Data
Table
Hershey has created a macro in a particular workbook to see Visible data with a shortcut, Ctrl V
(Command+V). However, after copying some data, he noticed the Ctrl V (Command+V) to paste the data
did not work. What is the likely cause of this issue? - ✔✔-The shortcut he created for the macro overrides
Excel's shortcut for pasting
How can you access Insights, which takes you outside of Microsoft and into the web? - ✔✔-the Smart
Lookup feature in a drop-down menu on the ribbon
How can you use AutoFill to provide all 12 months in a year across the columns in row 1 of a data set,
starting at column B? - ✔✔-Enter Jan in cell B1, and then drag the fill handle to cell M1.
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for the
next four months? - ✔✔-Use =C4+B5
If you highlight a column and then click the button to Sort Alphabetically (A-Z), what happens? - ✔✔-
You will be prompted with a dialog box asking how you would like to sort.
If you make the selection shown, what will the result be on your spreadsheet? - ✔✔-There will be a solid
line to the left of the highlighted cells, a dashed line around the full range of cells, and a dashed line
around each of the cells both vertically and horizontally.
If you use the Alt+F1 shortcut to create a chart, which chart type will appear? - ✔✔-a clustered column
chart
RATED A+
About This Quiz:
Ready to demonstrate your Excel skills? This Excel LinkedIn Quiz is designed to test your knowledge of
Excel functions, formulas, data analysis, and formatting, giving you the confidence to showcase your
proficiency on LinkedIn. Whether you're an entry-level user or a seasoned pro, this quiz will help you
gauge your skill level and prepare for LinkedIn certifications, resumes, or job opportunities.
After you adjust the width of column F containing numerical data, these number signs appear. What is
Excel telling you? - ✔✔-The columns are too narrow for the length of the numbers.
Ajaypal has added a couple of shapes and a logo to his worksheet. He holds the shift key down as he
places these items in the location he wants. What does this do? - ✔✔-This makes the item larger or
smaller while maintaining that ratio of height to width.This enables you to change the size of the image
while keeping the content ratio of height to width.
Assume you want all employees to receive a 2.1 percent pay increase. If the value shown in cell H1 is 2.1
percent, what is the correct formula to use in cell F2 and to drag down to the other rows? - ✔✔-When you
copy this formula, Excel will change H1 to H2, which has a zero value, and so on down the column.
Assuming all your worksheet names are color-coded, what action did you just take, or are you taking,
with the East, South, Midwest, and Pacific worksheets? - ✔✔-You have grouped the four sheets.
Carol needs to protect the structure of her Excel file. Which feature should she use? - ✔✔-Protect
Workbook
Darren needs his team to use a standard template for reporting expenses. What advice would you give
him? - ✔✔-Use one of the Microsoft Excel templates that is already built.
Date entries are numbers and by default they _____. - ✔✔-line up on the right side of the cell
Excel's menu system is known as the - ✔✔-ribbon
f you're trying to use VLOOKUP to find an exact match, what value should replace the question mark?
, =VLOOKUP(B2,D:F,3,?) - ✔✔-0
For some reason, such as an interruption, you selected Delete in the warning pop-up for a sheet that you
were not sure you wanted to delete. What have you done? - ✔✔-You have deleted the sheet, and you will
not be able to use Undo to undo the delete.
Germain is creating a worksheet with a master formula =PMT. Which feature is she using? - ✔✔-Data
Table
Hershey has created a macro in a particular workbook to see Visible data with a shortcut, Ctrl V
(Command+V). However, after copying some data, he noticed the Ctrl V (Command+V) to paste the data
did not work. What is the likely cause of this issue? - ✔✔-The shortcut he created for the macro overrides
Excel's shortcut for pasting
How can you access Insights, which takes you outside of Microsoft and into the web? - ✔✔-the Smart
Lookup feature in a drop-down menu on the ribbon
How can you use AutoFill to provide all 12 months in a year across the columns in row 1 of a data set,
starting at column B? - ✔✔-Enter Jan in cell B1, and then drag the fill handle to cell M1.
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for the
next four months? - ✔✔-Use =C4+B5
If you highlight a column and then click the button to Sort Alphabetically (A-Z), what happens? - ✔✔-
You will be prompted with a dialog box asking how you would like to sort.
If you make the selection shown, what will the result be on your spreadsheet? - ✔✔-There will be a solid
line to the left of the highlighted cells, a dashed line around the full range of cells, and a dashed line
around each of the cells both vertically and horizontally.
If you use the Alt+F1 shortcut to create a chart, which chart type will appear? - ✔✔-a clustered column
chart
