MOS Practice Exam (100% Correct)
Verified| *Q&A* (100% Correct)
2025/2026 ALREADY PASSED
What formula would you use to calculate the sum of cells A1 to A5 in Excel?
=SUM(A1:A5)
How do you apply bold formatting to the text in cell B2?
Select cell B2, then press "Ctrl + B" or use the ...
MOS Practice Exam (100% Correct)
Verified| *Q&A* (100% Correct)
2025/2026 ALREADY PASSED
What formula would you use to calculate the sum of cells A1 to A5 in Excel?
=SUM(A1:A5)
How do you apply bold formatting to the text in cell B2?
Select cell B2, then press "Ctrl + B" or use the bold icon in the ribbon.
What function would you use to calculate the average of a range of cells from B1 to B10?
=AVERAGE(B1:B10)
To lock a specific cell reference while copying a formula across rows, what would you do?
Add a dollar sign ($) before the column letter and row number (e.g., $A$1).
What is the shortcut to open the "Format Cells" dialog box in Excel?
Press "Ctrl + 1."
In Excel, how can you quickly insert the current date into a cell?
Press "Ctrl + ;" (semicolon).
Which of the following is used to sort data in Excel?
The "Sort" button in the "Data" tab.
How would you remove a hyperlink from a cell in Excel?
Right-click the cell, then select "Remove Hyperlink."
1
, If you want to freeze the top row of a worksheet in Excel, what would you do?
Go to the "View" tab and click "Freeze Panes," then select "Freeze Top Row."
What is the function used to find the largest value in a range of cells?
=MAX(range)
How do you remove duplicate values from a column in Excel?
Select the column, go to the "Data" tab, and click "Remove Duplicates."
What is the purpose of the "IF" function in Excel?
The "IF" function checks a condition and returns one value if true and another if false.
To center text across multiple columns, which option would you use?
Merge & Center from the "Home" tab.
How do you quickly fill a series of numbers (e.g., 1, 2, 3) in a column?
Select the first cell, drag the fill handle (the small square at the bottom-right corner) down the
column.
What does the VLOOKUP function do in Excel?
VLOOKUP searches for a value in the leftmost column of a range and returns a value from
another column in the same row.
In Excel, what does pressing "Ctrl + Z" do?
It undoes the last action.
How would you add a border to a cell in Excel?
2
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StellarGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.75. You're not tied to anything after your purchase.
