Excel Module 1, 2,3 Study Guide Questions And Correct Answers

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. _______ {Ans: True}COUNTA function {Ans: A function that tallies how many cells in specified range contain any entries (numbers, dates, or text).}The cell reference for the merged cell is the upper-right cell reference. _________________________ true or false {Ans: false}______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. ⸰ Find ⸰ Average ⸰ Lookup ⸰v? {Ans: ⸰ Lookup}An adjacent range is a collection of separate ranges {Ans: False}Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________ true or false {Ans: T}One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data. {Ans: formatting}true {Ans: A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. true or false?}By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom