©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
EXCEL LINKED-IN Exam Questions and
Answers 100% Solved
Excel's menu system is known as the - ✔✔ribbon
some of the buttons in the ribbon have a small arrow in the bottom right
corner. What are these arrows? - ✔✔dialog box launchers
You would like to add commands to the Quick Access Toolbar that you use
frequently. Where on a drop-down menu can you access the full list of
available commands? - ✔✔in All Commands
Ramesh is entering text into a worksheet, but everything he types is in
capital letters. Which indicator in Excel lets him know this? - ✔✔The
status bar will read "Caps Lock" in the lower left corner.
Suppose you highlight a column of data in an Excel worksheet. In the
status bar below, you'll see all of the following by default, except: _____. -
✔✔Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen.
Where is it located? - ✔✔status bar at bottom of screen
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
You are using your mouse (or cursor) within your Excel sheet. If you slide
leftward and put it on a boundary between rows, what does your cursor
look like? - ✔✔a two-way up-down arrow
You have three workbooks open that you are working on. How can you
most easily navigate from one workbook to another? - ✔✔Select Switch
Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar? - ✔✔It is a limited-feature bar that contains
many of the features contained on the Home tab of the toolbar.
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.
What is Excel? - ✔✔all of these answers
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
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
You intended to enter 110 in a series of 10 values, but you inadvertently
typed 11O. How will Excel tell you that you made a data entry error? -
✔✔11O will be left-aligned, while the other values will be right-aligned.
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.
When will you use Save rather than Save As? - ✔✔when you make
changes to an existing workbook
Date entries are numbers and by default they _____. - ✔✔line up on the
right side of the cell
While Undo is a valuable feature to avoid losing important data, what
limitation does it have? - ✔✔You can only undo actions consecutively
and cannot select an action, for example, from 10 entries earlier.
You are working on a spreadsheet and have entered several lines of data
and text. You need to adjust the two lines you just entered. Which action is
the best to take? - ✔✔Undo the lines.
You have received a worksheet from a coworker who told you there are a
number of comments you need to review. How do you first know there are
EXCEL LINKED-IN Exam Questions and
Answers 100% Solved
Excel's menu system is known as the - ✔✔ribbon
some of the buttons in the ribbon have a small arrow in the bottom right
corner. What are these arrows? - ✔✔dialog box launchers
You would like to add commands to the Quick Access Toolbar that you use
frequently. Where on a drop-down menu can you access the full list of
available commands? - ✔✔in All Commands
Ramesh is entering text into a worksheet, but everything he types is in
capital letters. Which indicator in Excel lets him know this? - ✔✔The
status bar will read "Caps Lock" in the lower left corner.
Suppose you highlight a column of data in an Excel worksheet. In the
status bar below, you'll see all of the following by default, except: _____. -
✔✔Minimum and Maximum Values
The zoom slider bar lets you enlarge or shrink the data shown on screen.
Where is it located? - ✔✔status bar at bottom of screen
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
You are using your mouse (or cursor) within your Excel sheet. If you slide
leftward and put it on a boundary between rows, what does your cursor
look like? - ✔✔a two-way up-down arrow
You have three workbooks open that you are working on. How can you
most easily navigate from one workbook to another? - ✔✔Select Switch
Windows in the View tab on the ribbon.
Feedback
What is the Mini-Toolbar? - ✔✔It is a limited-feature bar that contains
many of the features contained on the Home tab of the toolbar.
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.
What is Excel? - ✔✔all of these answers
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
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
You intended to enter 110 in a series of 10 values, but you inadvertently
typed 11O. How will Excel tell you that you made a data entry error? -
✔✔11O will be left-aligned, while the other values will be right-aligned.
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.
When will you use Save rather than Save As? - ✔✔when you make
changes to an existing workbook
Date entries are numbers and by default they _____. - ✔✔line up on the
right side of the cell
While Undo is a valuable feature to avoid losing important data, what
limitation does it have? - ✔✔You can only undo actions consecutively
and cannot select an action, for example, from 10 entries earlier.
You are working on a spreadsheet and have entered several lines of data
and text. You need to adjust the two lines you just entered. Which action is
the best to take? - ✔✔Undo the lines.
You have received a worksheet from a coworker who told you there are a
number of comments you need to review. How do you first know there are
