MOS certification exam SG with correct
answers 100% 2026
Which is used to display formulas on a worksheet in Excel? - Correct Answers Show Formulas
button
Which items in the File tab are used to save Excel Workbooks in Various File Formats? Pick 2 -
Correct Answers Export AND Save As
The Compatibilitty Checker in Excel 2019 is useful for locating formats and other items in a
workbook that are not used in older versions of Excel. - Correct Answers True
Which common item causes compatibility issues with older versions of Excel? - Correct Answers
Colors
Which are ways to replace text in an Excel 2019 worksheet? Choose the answers. - Correct
Answers Double-click the cell, Use the formula bar, Simply start typing on the selected cell
If a cell range is already highlighted and the user is holding down the Shift key, they can quickly
change the highlighted area using the ___________________. - Correct Answers Arrow keys
Which is a true statement when copying or cutting and pasting data to a new location in Excel? -
Correct Answers The user does not have to select the entire cell range where the data will be
pasted
Which are paste special options in Excel 2019? Choose two answers. - Correct Answers Past Link
AND Values & Source Formatting
The Flash fill feature in Excel 2019 is located on which tab? - Correct Answers Data
, Cells and cell ranges can be inserted and deleted from the _______________ tab of the ribbon.
- Correct Answers Home
Which are merge options in Excel 2019? Choose three answers. - Correct Answers Merge cells
AND Merge across AND merge & center
Which is a common best practice when wrapping text with cells in Excel? - Correct Answers
Wrap the text for the entire row or column
Users can alter where the ____________ is for any number in Excel 2019. - Correct Answers
Decimal
When applying cell formulas in Excel 2019, users can hold down the ______________ key to
select individual cells they wish to apply formats to. - Correct Answers Ctrl
Which are the three types of sparkles in Excel 2019? - Correct Answers Line AND Column AND
WinLoss
Users can customize sparkles in Excel 2019 using which items? Choose two answers. - Correct
Answers Styles AND Markers
In order to ungroup a cell range, the range will needed to be selected - Correct Answers True
Conditional formatting is performed from which tab in Excel 2019? - Correct Answers Home
The user does not need to highlight data within an Excel worksheet in order to remove
conditional formatting. - Correct Answers True
answers 100% 2026
Which is used to display formulas on a worksheet in Excel? - Correct Answers Show Formulas
button
Which items in the File tab are used to save Excel Workbooks in Various File Formats? Pick 2 -
Correct Answers Export AND Save As
The Compatibilitty Checker in Excel 2019 is useful for locating formats and other items in a
workbook that are not used in older versions of Excel. - Correct Answers True
Which common item causes compatibility issues with older versions of Excel? - Correct Answers
Colors
Which are ways to replace text in an Excel 2019 worksheet? Choose the answers. - Correct
Answers Double-click the cell, Use the formula bar, Simply start typing on the selected cell
If a cell range is already highlighted and the user is holding down the Shift key, they can quickly
change the highlighted area using the ___________________. - Correct Answers Arrow keys
Which is a true statement when copying or cutting and pasting data to a new location in Excel? -
Correct Answers The user does not have to select the entire cell range where the data will be
pasted
Which are paste special options in Excel 2019? Choose two answers. - Correct Answers Past Link
AND Values & Source Formatting
The Flash fill feature in Excel 2019 is located on which tab? - Correct Answers Data
, Cells and cell ranges can be inserted and deleted from the _______________ tab of the ribbon.
- Correct Answers Home
Which are merge options in Excel 2019? Choose three answers. - Correct Answers Merge cells
AND Merge across AND merge & center
Which is a common best practice when wrapping text with cells in Excel? - Correct Answers
Wrap the text for the entire row or column
Users can alter where the ____________ is for any number in Excel 2019. - Correct Answers
Decimal
When applying cell formulas in Excel 2019, users can hold down the ______________ key to
select individual cells they wish to apply formats to. - Correct Answers Ctrl
Which are the three types of sparkles in Excel 2019? - Correct Answers Line AND Column AND
WinLoss
Users can customize sparkles in Excel 2019 using which items? Choose two answers. - Correct
Answers Styles AND Markers
In order to ungroup a cell range, the range will needed to be selected - Correct Answers True
Conditional formatting is performed from which tab in Excel 2019? - Correct Answers Home
The user does not need to highlight data within an Excel worksheet in order to remove
conditional formatting. - Correct Answers True
