MISY 5325 MS Excel Midterm Exam| Study Guide| Excel Test| With Verified Answers 2024

MISY 5325 MS Excel Midterm Exam| Study Guide| Excel Test| With Verified Answers 2024 An Excel ____ allows data to be summarized and charted easily. Worksheet Workflow Document Presentation Correct Answer worksheet The first step in creating an effective worksheet is to make sure you ____. Apply font formatting Understand what is required Insert a chart Enter the data Correct Answer understand what is required To enter data in a cell, you must first select the ____. Row Worksheet Column Cell Correct Answer cell ____ is/are used to place worksheet, column, and row titles on a worksheet. Color Text Links Tabs Correct Answer text By default, text is ____ in a cell. Left-aligned Centered Justified Right-aligned Correct Answer left-aligned In Excel, a number can contain the characters ____. 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e All of the above Correct Answer all of the above The range of cells receiving copied content is called the ____ area. Fill Range Location Paste Correct Answer paste You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. Semi-colon (;)