221. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets ✅ The correct answer is option C.
222. You can use the format painter multiple times before you turn it off by A. You can use the format painter button on ly one time when you click it B. Double clicking the format painter button C. Pressing the Ctrl key and clicking the format painter button D. Pressing the Alt key and clicking the format painter button ✅ The correct answer is option B.
223. Excel probably considers the cell entry January 1, 2020 to be a A. Label B. Value C. Formula D. Text string ✅ The correct answer is option B.
224. Which of the following is a popular DOS based spreadsheet package? A. Word B. Smart cell C. Excel D. Lotus 1-2-3 ✅ The correct answer is option D.
225. Tab scrolling button A. Allow you to view a different worksheet B. Allow you to view additional worksheet rows down C. Allow you to view additional worksheet columns to the right D. Allow you to view additional sheets tabs ✅ The correct answer is option D.
226. How many characters can be typed in a single cell in Excel? A. 256 B. 1024 C. 32767 D. 65535 ✅ The correct answer is option C.
227. Which menu option can be used to split windows into two A. Format > window B. View > window > split C. Window > split D. View > split ✅ The correct answer is option B.
228. Which of the following is the oldest spreadsheet package? A. VisiCalc B. Lotus 1-2-3 C. Excel D. StarCalc ✅ The correct answer is option A.
229. Which of the following formulas will Excel not be able to calculate? A. =SUM(Sales)-A3 B. =SUM(A1:A5)*.5 C. =SUM(A1:A5)/(10-10) D. =SUM(A1:A5)-10 ✅ The correct answer is option A.
230. The autofill feature A. Extends a sequential series of data B. Automatically adds range of cell values C. Applies a boarder around the selected cells D. All of the above ✅ The correct answer is option D.