MSIS 2103 Exam Questions and Answers Already Passed Latest Update 2025-2026
Which area in an Excel window allows entering values and formulas? - AnswersFormula Bar
An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A
buttons - AnswersTrue
A fast way to add up this column of numbers is to click in the cell below the numbers and then -
AnswersClick the Autosum button on the Standard toolbar and then press enter
If cells are A1:A5, what will be your formula to average them? - Answers=Average(A1:A5)
What happens when dollar signs $ are entered in this address; $B$2:$B$10? - AnswersThe
range address is absolute
Which of the following is not a valid type in Excel? - AnswersCharacter
The name of the active cell appears in the - AnswersName box
If you have data that runs across five columns from A to E, a way to center a title is to -
AnswersType the data in A1 and merge A1:E1 together and then center the text
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down
to row 10 is - AnswersG10:B1
What is the result of the following formula: =(5-3)^2/1*2 - Answers8
Labels are aligned at the ____ edge of the cell - AnswersLeft
To add a new row, click a cell in the row immediately above where you want the new row, right
click, select insert and press enter - AnswersFalse
Large column that has a mass amount of text can be lost in printing unless you - AnswersWrap
text
An excel workbook is a collection of - AnswersWorksheets
Which is the part of the excel screen where you can find all the commands or buttons,
depending on the tab you selected before? - AnswersRibbon
A range in Microsoft Excel refers to - AnswersA group of cells
A ______ is a grid with labeled columns and rows - AnswersWorksheet
If a formula contains several nested functions, excel starts with the outermost function and
then moves inward - AnswersTrue
Formatting data only changes the appearance of data if does not affect the data itself -
Which area in an Excel window allows entering values and formulas? - AnswersFormula Bar
An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A
buttons - AnswersTrue
A fast way to add up this column of numbers is to click in the cell below the numbers and then -
AnswersClick the Autosum button on the Standard toolbar and then press enter
If cells are A1:A5, what will be your formula to average them? - Answers=Average(A1:A5)
What happens when dollar signs $ are entered in this address; $B$2:$B$10? - AnswersThe
range address is absolute
Which of the following is not a valid type in Excel? - AnswersCharacter
The name of the active cell appears in the - AnswersName box
If you have data that runs across five columns from A to E, a way to center a title is to -
AnswersType the data in A1 and merge A1:E1 together and then center the text
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down
to row 10 is - AnswersG10:B1
What is the result of the following formula: =(5-3)^2/1*2 - Answers8
Labels are aligned at the ____ edge of the cell - AnswersLeft
To add a new row, click a cell in the row immediately above where you want the new row, right
click, select insert and press enter - AnswersFalse
Large column that has a mass amount of text can be lost in printing unless you - AnswersWrap
text
An excel workbook is a collection of - AnswersWorksheets
Which is the part of the excel screen where you can find all the commands or buttons,
depending on the tab you selected before? - AnswersRibbon
A range in Microsoft Excel refers to - AnswersA group of cells
A ______ is a grid with labeled columns and rows - AnswersWorksheet
If a formula contains several nested functions, excel starts with the outermost function and
then moves inward - AnswersTrue
Formatting data only changes the appearance of data if does not affect the data itself -
