MISY-5325 MIDTERM QUESTIONS & ANSWERS | 2026
Where can you see a brief description of a selected function? - Answers - Insert
Function dialog box
Sam wants to count the number of cells between B1 and B20 that contain numbers in
them. Which of the following formula should he use to do so? - Answers -
=COUNT(B1:B20)
What feature inserts a function that totals the cells above or to the left of the selected
cell? - Answers - AutoSum button
Your worksheet appears with a reduced view of each page and blue dividers where new
pages begin. What view are you in? - Answers - Page Break Preview
Which of the following inserts a function into a cell? - Answers - AutoSum button
To print more than one copy of your worksheet, which tab would you go to? - Answers -
File
In the formula =SUM(A6:A9), which of the following best describes A6? - Answers -
Argument
To see a preview of how a pasted value will look, which of the following would you use?
- Answers - Paste List Arrow
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab
would you use? - Answers - Page Layout
When you underline cell content, you are using _____. - Answers - a font style
Which of the following tabs lets you set worksheet print options? - Answers - File
To apply a cell style, you would use the Cell Styles command on the _____ tab. -
Answers - Home
Which of the following is true about adding cell borders? - Answers - A cell border
extends the width of the cell.
Which of the following would you use to create a duplicate of the selected cell when the
CTRL key is pressed? - Answers - Copy Pointer
Which of the following functions inserts the total of a range? - Answers - SUM
, If you discover an error immediately after you have confirmed a cell entry, what of the
following would you use next? - Answers - The Undo button on the Quick Access
toolbar
To enter a range of text based on examples that are already in your worksheet, which of
the following can you use? - Answers - Flash fill
How many actions does the Undo button let you reverse? - Answers - 100
When you double-click a cell's right column border, which of the following occurs? -
Answers - AutoFit resizes the column to the widest cell entry
Which of the following will you select as X in the following series of clicks to change the
chart style: Chart > Chart Style > X > Any Chart Style? - Answers - Style
Which of the following statements is true about COUNT functions? - Answers - The
COUNT function returns the number of calls in a range that contain numeric da
To select a single worksheet cell so you can work with it, which of the following would
you do? - Answers - Click the cell.
Which of the following functions would you use to calculate the arithmetic mean of a
price list? - Answers - AVERAGE
Amanda needs to manually calculate an open worksheet. Which of the following options
should she click on in the Formulas tab in the Calculation group? - Answers - Calculate
Now
Which of the following should be selected as X in the given series of clicks to set
formulas for manual calculation: File < Options < X < Manual - Answers - Formulas
A student wants to round the number 24.7835 entered in cell A2 to two decimal places.
Which of these formulas can she use to do so? - Answers - =ROUND(A5,2)
After you delete a worksheet column, _____. - Answers - the columns to its right shift
left
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks
the cell in the spreadsheet that he wants to change, then selects the "X" button from the
Data tab and selects Goal seek... from the drop down menu. What is X in the
procedure? - Answers - What-if Analysis
Bertie wants to show data labels inside a text bubble shape. Which option can she click
on after clicking on the arrow next to Data labels under Chart Elements? - Answers -
Data Callout
Where can you see a brief description of a selected function? - Answers - Insert
Function dialog box
Sam wants to count the number of cells between B1 and B20 that contain numbers in
them. Which of the following formula should he use to do so? - Answers -
=COUNT(B1:B20)
What feature inserts a function that totals the cells above or to the left of the selected
cell? - Answers - AutoSum button
Your worksheet appears with a reduced view of each page and blue dividers where new
pages begin. What view are you in? - Answers - Page Break Preview
Which of the following inserts a function into a cell? - Answers - AutoSum button
To print more than one copy of your worksheet, which tab would you go to? - Answers -
File
In the formula =SUM(A6:A9), which of the following best describes A6? - Answers -
Argument
To see a preview of how a pasted value will look, which of the following would you use?
- Answers - Paste List Arrow
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab
would you use? - Answers - Page Layout
When you underline cell content, you are using _____. - Answers - a font style
Which of the following tabs lets you set worksheet print options? - Answers - File
To apply a cell style, you would use the Cell Styles command on the _____ tab. -
Answers - Home
Which of the following is true about adding cell borders? - Answers - A cell border
extends the width of the cell.
Which of the following would you use to create a duplicate of the selected cell when the
CTRL key is pressed? - Answers - Copy Pointer
Which of the following functions inserts the total of a range? - Answers - SUM
, If you discover an error immediately after you have confirmed a cell entry, what of the
following would you use next? - Answers - The Undo button on the Quick Access
toolbar
To enter a range of text based on examples that are already in your worksheet, which of
the following can you use? - Answers - Flash fill
How many actions does the Undo button let you reverse? - Answers - 100
When you double-click a cell's right column border, which of the following occurs? -
Answers - AutoFit resizes the column to the widest cell entry
Which of the following will you select as X in the following series of clicks to change the
chart style: Chart > Chart Style > X > Any Chart Style? - Answers - Style
Which of the following statements is true about COUNT functions? - Answers - The
COUNT function returns the number of calls in a range that contain numeric da
To select a single worksheet cell so you can work with it, which of the following would
you do? - Answers - Click the cell.
Which of the following functions would you use to calculate the arithmetic mean of a
price list? - Answers - AVERAGE
Amanda needs to manually calculate an open worksheet. Which of the following options
should she click on in the Formulas tab in the Calculation group? - Answers - Calculate
Now
Which of the following should be selected as X in the given series of clicks to set
formulas for manual calculation: File < Options < X < Manual - Answers - Formulas
A student wants to round the number 24.7835 entered in cell A2 to two decimal places.
Which of these formulas can she use to do so? - Answers - =ROUND(A5,2)
After you delete a worksheet column, _____. - Answers - the columns to its right shift
left
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks
the cell in the spreadsheet that he wants to change, then selects the "X" button from the
Data tab and selects Goal seek... from the drop down menu. What is X in the
procedure? - Answers - What-if Analysis
Bertie wants to show data labels inside a text bubble shape. Which option can she click
on after clicking on the arrow next to Data labels under Chart Elements? - Answers -
Data Callout
