Mis 112 - Study guides, Class notes & Summaries

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 argume...

MIS 112 Test Questions with All Correct Answers

MIS 112 Midterm Exam Questions with Correct Answers What is a VALID way to get into cell edit mode? - Answer-selecting the cell that you want to edit, and then clicking in the formula bar Which of the following types of data may NOT be contained in a cell in an Excel worksheet - Answer-objects In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______ - Answer-select a column Examine the attached file. if you copy the whole cell "B8" (not only its formula) and paste it into...

MIS 112 Test Questions with Correct Answers Updated Which of the following is TRUE about sorting a table? - Answer-Sorting a table re-arranges the rows based on the contents of a particular column. To display the Total Row in a Table: choose Table Tools / Design -> Table Style Options (command group) and put a check mark next to Total Row. Selecting a cell in the Total Row and clicking on the drop-down arrow that appears in that cell will NOT allow you to select which of the following sum...

MIS 112 FINAL EXAM

BIO 181 In our MIS 112 lecture videos and readings, we discussed how to passwordprotect a BIO 181 In our MIS 112 lecture videos and readings, we discussed how to passwordprotect a workbook. Suppose your supervisor at work, Tina Clark, has noticed Excel has fields fortwo passwords, one to open and one to modify.Password Protection in ExcelExcel provides two types of password protection options:1.Password to Open: This password is required to open the workbook. If you don't know the password, y...

MIS 112 Exam Questions With Correct Answers. You ask your customers to provide you with inventory usage data to help you plan your production schedule. which of the following file formats will you ask them to provide in (so that data can be easily immported into Excel?) a) Microsoft Word b) XML c) microsoft power point d) PDF - answerXML When importing a text file into Excel, the ______ helps specify how the data will be imported. a) Text Import Wizard b) External Data Wizard c) CSV ...

TEST BANK FOR BUSINESS DRIVEN INFORMATION SYSTEMS 5TH EDITION BY BALTZAN () Analytics is the science of fact-based decision making. True False 3. At the operational level, employees are continuously evaluating company operations to hone the firm’s abilities to identify, adapt to, and leverage change. True False 4. At the operational level, employees develop, control, and maintain core business activities required to run the day-to-day operations. True False 5. Operational decisions ar...

TEST BANK FOR BUSINESS DRIVEN INFORMATION SYSTEMS 5TH EDITION BY BALTZAN | VERIFIED. One of the most important and challenging questions confronting managers today is how to lay the foundation for tomorrow’s success while competing to win in today’s business environment. True False 2. Analytics is the science of fact-based decision making. True False 3. At the operational level, employees are continuously evaluating company operations to hone the firm’s abilities to identify, adapt ...