Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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 testQuestion

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

What is an activity cost pool?

Answered: 1 week ago