Question
I need help writing the sub/function named show question which shows each question for this program please help? test questions and data Excel Exam Name___________________________________
I need help writing the sub/function named show question which shows each question for this program please help?
test questions and data
Excel Exam
Name___________________________________
TRUE/FALSE. Circle 'T' if the statement is true and 'F' if the statement
is false.
1) A formula is a built-in program that would be used to find the average
of a series of numbers. T or F
2) When using a what-if analysis, you change values in spreadsheet cells
to see the effects on calculated values of interest. T or F
3) When collecting data in a spreadsheet, each row contains a field.
T or F
4) A worksheet is a file containing at least one workbook. T or F
5) The default time interval for automatically saving Excel files is
every five minutes. T or F
6) The active worksheet has a white tab with bold letters and a thick
bottom border. T or F
7) To make a different worksheet active, you click Change Worksheet in
the Selection group on the HOME tab. T or F
8) To make a different worksheet active, you right-click the worksheet
scroll arrows and select the worksheet in the Activate dialog box. T or F
9) A cell reference is a combination of a row number and a column letter
such as 12C. T or F
10) To move up one screen, you use the Ctrl + Page Up keyboard shortcut.
T or F
11) When using a touch screen, the Excel 2013 the commands on the Ribbon
and in shortcut menus are rearranged to accommodate the use of a
fingertip. T or F
12) A comment is added to an individual cell. T or F
13) Information such as the modification history of a workbook would be
found in a separate documentation worksheet. T or F
14) Clicking a cell and then right-clicking in the formula bar, displays
the insertion point in the formula bar. T or F
15) The dollar sign ($) and comma (,) are stored as part of a numeric
cell value. T or F
16) In Excel, date and time data are a special forms of numeric data.
T or F
17) By default, Excel places all information in a single line in a cell.
T or F
18) A contiguous cell range consists of multiple cells, where at least
one cell is not directly adjacent to other cells. T or F
19) When cutting a pasting the contents of a cell, everything in the
cell, including formatting is moved. T or F
20) When copying and pasting the contents of one cell into another, the
destination cell has a dashed border. T or F
21) Dragging and dropping is an effective method for moving the contents
of a cell or a range of cells to others cells. T or F
22) To edit the contents of a cell, you right-click the cell to enter
edit mode. T or F
23) Merge & Center can only be applied to horizontal cell ranges. T or F
24) To select a column, click the letter in the header. T or F
25) The width of columns is defined in points. T or F
ANSWER KEY
1) FALSE
2) TRUE
3) TRUE
4) FALSE
5) FALSE
6) TRUE
7) FALSE
8) TRUE
9) FALSE
10) FALSE
11) FALSE
12) TRUE
13) TRUE
14) FALSE
15) FALSE
16) TRUE
17) TRUE
18) FALSE
19) TRUE
20) FALSE
21) TRUE
22) FALSE
23) FALSE
24) TRUE
25) FALSE
For this assignment, you will use Visual Basic to implement a test generator to replace a traditional hardcopy test. This project will involve a module and three forms: An opening form, in which you will read the data from the file An intermediate form, in which users use a DropDownList ComboBox to select the number of questions (5-25 A form that presents the questions, records users' responses, and displays a summary report. View Test Your project will Use FileGet to read the questions (in this assignment there are 25) and correct answers from a file called ExcelTest.dat into the structured array test defined below (Copy and paste this code into your module.) Structure testQuestionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started