MIS 112 EXAM QUESTIONS AND
ANSWERS 2024 NEW UPDATE
Which of the following is an advantage of using Excel tables? - Answer-Using table and
column names in formulas provides greater flexibility as extending a table does not
require re-writing of formulas
When you apply currency formatting to a Table column and then add a new row to the
table, what happens to data entered in the new cell? - Answer-Excel applies currency
formatting to the new value in that column cell.
Examine the 6th argument in the formula below. What kind of argument is it?=SUM(B1,
5, 6, 7, SQRT(4), A1:A5, TRUE) - Answer-a range reference
Examine the attached image. What will the result of the following formula be?
="Section " &mysection - Answer-Section B
The Excel function: ISERR() returns TRUE if the cell contains any error value except
which of the following? - Answer-#N/A
Examine the attached worksheet. We want to display in cells H2 to H8 the names of the
items whose quantity purchased is greater than the Average quantity reported in cell
B10. If the quantity purchased is equal or lower, we want to display 0. Which formula,
entered in H2 and extended to H8, will achieve this?
Formulas_Test_v2.xlsx - Answer-=IF(B2>$B$10, A2,0)
Which operator in Excel combines multiple range references into a single reference
(e.g., if I want to sum up the values in non-contiguous cell-ranges across the
worksheet)? - Answer-"," (comma)
In Excel, what does the MODE function in a range return? - Answer-most frequently
occurring value in a range
Please select the Excel function which allows us to answer the question: "How many
days of stock data do I have?" You may refer to the image in the question. - Answer-
COUNT()
What does the Excel keyboard shortcut Ctrl+Alt+F9 do? - Answer-forces a complete
recalculation of all formulas in all open workbooks.
, What type of cell reference does the formula in E2 use? (refer to the attached image,
the formula is highlighted) - Answer-absolute
rng_range_names.xlsx Please see the attached workbook. What is the scope of the
range name 'months'? - Answer-sheet 1
Which of the following function(s) can be used to count error values in a range? -
Answer-all of the provided choices are valid
The formula in the attached image shows an example of which of the following? -
Answer-a circular reference warning
formulas_cell_references.xlsx Examine the attached Excel file. When the formula in
"D2" is copied to the cells below it, cell "D3" will contain what formula? - Answer-
=(B3*C3)*$B$7
A formula in Excel can consist of which of the following? - Answer-all of the choices
provided are valid
The =SUM() function does which of the following in Excel? - Answer-Allows you to total
up numbers in a specified range of cells
Which of the following does the function =NOW() return? - Answer-current date and
time
What is the purpose of the Text to Columns command? - Answer-It parses strings into
their component parts.
What function removes leading and trailing spaces from a cell? - Answer-TRIM
external_ex1.xlsx Please use the attached workbook as an external data source. The
workbook has a table called 'Employee'. When you import data, after selecting all the
columns from the table using the query wizard (Data(tab) -> Get External Data (group) -
> From Other Sources -> From Microsoft Query), how will you filter the records to
retrieve those that have a value greater than 21 for 'Age' column. - Answer-From the
Column to Filter list, select Age. In the right panel, select 'is greater than' from the first
drop-down list and then select '21.0' from the second drop-down list
The HYPERLINK function syntax has two arguments. Which argument has the path and
file name to the document to be opened? - Answer-Link_location
If you place the link target in cell C1 on the same worksheet, how will you use an
absolute reference to that cell as the link_location in the HYPERLINK formulas? -
Answer-=HYPERLINK($C$1)
ANSWERS 2024 NEW UPDATE
Which of the following is an advantage of using Excel tables? - Answer-Using table and
column names in formulas provides greater flexibility as extending a table does not
require re-writing of formulas
When you apply currency formatting to a Table column and then add a new row to the
table, what happens to data entered in the new cell? - Answer-Excel applies currency
formatting to the new value in that column cell.
Examine the 6th argument in the formula below. What kind of argument is it?=SUM(B1,
5, 6, 7, SQRT(4), A1:A5, TRUE) - Answer-a range reference
Examine the attached image. What will the result of the following formula be?
="Section " &mysection - Answer-Section B
The Excel function: ISERR() returns TRUE if the cell contains any error value except
which of the following? - Answer-#N/A
Examine the attached worksheet. We want to display in cells H2 to H8 the names of the
items whose quantity purchased is greater than the Average quantity reported in cell
B10. If the quantity purchased is equal or lower, we want to display 0. Which formula,
entered in H2 and extended to H8, will achieve this?
Formulas_Test_v2.xlsx - Answer-=IF(B2>$B$10, A2,0)
Which operator in Excel combines multiple range references into a single reference
(e.g., if I want to sum up the values in non-contiguous cell-ranges across the
worksheet)? - Answer-"," (comma)
In Excel, what does the MODE function in a range return? - Answer-most frequently
occurring value in a range
Please select the Excel function which allows us to answer the question: "How many
days of stock data do I have?" You may refer to the image in the question. - Answer-
COUNT()
What does the Excel keyboard shortcut Ctrl+Alt+F9 do? - Answer-forces a complete
recalculation of all formulas in all open workbooks.
, What type of cell reference does the formula in E2 use? (refer to the attached image,
the formula is highlighted) - Answer-absolute
rng_range_names.xlsx Please see the attached workbook. What is the scope of the
range name 'months'? - Answer-sheet 1
Which of the following function(s) can be used to count error values in a range? -
Answer-all of the provided choices are valid
The formula in the attached image shows an example of which of the following? -
Answer-a circular reference warning
formulas_cell_references.xlsx Examine the attached Excel file. When the formula in
"D2" is copied to the cells below it, cell "D3" will contain what formula? - Answer-
=(B3*C3)*$B$7
A formula in Excel can consist of which of the following? - Answer-all of the choices
provided are valid
The =SUM() function does which of the following in Excel? - Answer-Allows you to total
up numbers in a specified range of cells
Which of the following does the function =NOW() return? - Answer-current date and
time
What is the purpose of the Text to Columns command? - Answer-It parses strings into
their component parts.
What function removes leading and trailing spaces from a cell? - Answer-TRIM
external_ex1.xlsx Please use the attached workbook as an external data source. The
workbook has a table called 'Employee'. When you import data, after selecting all the
columns from the table using the query wizard (Data(tab) -> Get External Data (group) -
> From Other Sources -> From Microsoft Query), how will you filter the records to
retrieve those that have a value greater than 21 for 'Age' column. - Answer-From the
Column to Filter list, select Age. In the right panel, select 'is greater than' from the first
drop-down list and then select '21.0' from the second drop-down list
The HYPERLINK function syntax has two arguments. Which argument has the path and
file name to the document to be opened? - Answer-Link_location
If you place the link target in cell C1 on the same worksheet, how will you use an
absolute reference to that cell as the link_location in the HYPERLINK formulas? -
Answer-=HYPERLINK($C$1)
