©THEBRIGHT 2024
MIS 111 Midterm Exam Questions With
Correct Answers
What keyboard shortcut creates a new blank workbook in excel? - answer✔✔Ctrl + N
How many worksheets can a workbook have? - answer✔✔A workbook can have many
Would you be able to apply the "watch window" option n multiple sheets at the same time? -
answer✔✔Yes
Which excel element is at the way top left of the document? - answer✔✔Quick Access Toolbar
While comparing two sheets using the "View Side by Side" feature, there is an option which lets
you scroll the two sheets in sync. What is that option called? - answer✔✔Toggle or Synchronous
Scrolling
How do you replicate a text from one cell into other cells? - answer✔✔Ctrl + Enter
What excel element holds the tabs? - answer✔✔Ribbon
What characters are not allowed in sheet names? - answer✔✔[ ]
What ribbon tab does hitting "Alt + H" relate to? - answer✔✔Home
Would you be able to apply the "watch window" option in multiple sheets at the same time? -
answer✔✔Yes
A group of cells is referred to as what? - answer✔✔Range
which type of chart does not allow formate changes to the Plot area? - answer✔✔None
A chart in excel worksheet provides a visual representation of what? - answer✔✔Numeric
Values
What shortcut that "cuts" the current selection of cells to both the windows and office
clippoaords? - answer✔✔Crtl + X
What is not one of the excel functions to determine whether a cell contains an error value? -
answer✔✔Islogical
MIS 111 Midterm Exam Questions With
Correct Answers
What keyboard shortcut creates a new blank workbook in excel? - answer✔✔Ctrl + N
How many worksheets can a workbook have? - answer✔✔A workbook can have many
Would you be able to apply the "watch window" option n multiple sheets at the same time? -
answer✔✔Yes
Which excel element is at the way top left of the document? - answer✔✔Quick Access Toolbar
While comparing two sheets using the "View Side by Side" feature, there is an option which lets
you scroll the two sheets in sync. What is that option called? - answer✔✔Toggle or Synchronous
Scrolling
How do you replicate a text from one cell into other cells? - answer✔✔Ctrl + Enter
What excel element holds the tabs? - answer✔✔Ribbon
What characters are not allowed in sheet names? - answer✔✔[ ]
What ribbon tab does hitting "Alt + H" relate to? - answer✔✔Home
Would you be able to apply the "watch window" option in multiple sheets at the same time? -
answer✔✔Yes
A group of cells is referred to as what? - answer✔✔Range
which type of chart does not allow formate changes to the Plot area? - answer✔✔None
A chart in excel worksheet provides a visual representation of what? - answer✔✔Numeric
Values
What shortcut that "cuts" the current selection of cells to both the windows and office
clippoaords? - answer✔✔Crtl + X
What is not one of the excel functions to determine whether a cell contains an error value? -
answer✔✔Islogical
