BASIC EXCEL - 1

Phase of the methodology given by the enumeration, which requires a clear and precise definition of the problem.

• Coding

• Maintenance

• Problem definition

• Tests

It is the operation of writing the solution of the problem in a series of detailed instructions, depending on the algorithm or flow diagram.

• Problem analysis

• Coding

• Documentation

• Depuration

The documentation on the methodology for problem solving is a written guide in its various forms: procedures, diagrams or drawings. Which is divided into ...

• Internal, external and technical manual

• Internal, user manual and technical manual

• Internal, external and user manual

• None of the above

It is a finite group of logically ordered actions or steps to solve a given problem.

• Algorithms

• Flowcharts

• Seudocode

• Analysis

We can see in the following figure, the process of the steps are correct for an algorithm.

• True

• False

Which of these four algorithms is correct?

• Input: View report card grades

  Process: Add your grades and divide the result by the number of subjects you took

  Output: The result you got from adding and dividing operations

• Start

  Input: View report card grades

  Process: Add your grades from your subjects that you took

  Output: The result you got from adding and dividing operations

  The end

• Start

  Input: View report card grades

  Process: Add your grades and divide the result by the number of subjects you took

  Output: Add and divide your results

  The end

• Start

  Input: View report card grades

  Process: Add your grades and divide the result by the number of subjects you took

  Output: The result you got from adding and dividing operations

  The end

Describes a process, system or algorithm, they are widely used in many fields to document often complex processes.

• Algorithms

• Seucode

• Flowchart

• None of the above

From the following figure, in the symbology of the flowcharts it serves to represent ...

• Process

• Documentation

• Decision

• Data

From the following figure, in the symbology of the flowcharts it serves to represent ...

• Decision

• Terminal

• Database

• Conector

In the following figure, it allows us to move through the different sheets of the workbook.

• Tag bar

• Scrollbar

• Status bar

• Access bar