USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. Worksheet titles and subtitles should be as wordy as possible.
Detailed explanation-2: -Although it is limited to only one or two variables (one for the row input cell and one for the column input cell), a Data Table can include as many different variable values as you want. A scenario can have a maximum of 32 different values, but you can create as many scenarios as you want.
Detailed explanation-3: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.
Detailed explanation-4: -Import data from ClassSchedule table in the Registration Access database into a new worksheet. On the Data tab, in the Get and Transform group, click the Get Data button. Point to From Database, and click From Microsoft Access Database. Click the Registration database file, and then click the Import button.