Excel Questionnaire: Key Concepts & Functions
Translated by
ScribdTranslationsExcel Questionnaire: Key Concepts & Functions
Translated by
ScribdTranslationsExcel Questionnaire
Questionnaire
1. Briefly describe what you understand by spreadsheet.
Workbook that allows us to perform calculations using predefined formulas or formulae.
2. Describe the calculus book
They are tabular sheets used as if they were accounting books and they consist of columns.
each cell.
3. What is the name of the first spreadsheet invented?
VisiCalc
4. What is the name of the developers who invented the first spreadsheet?
Dan Bricklin and Rob Frankston.
5. What is the intersection between a row and a column in a spreadsheet called?
Cell
6. Write the name of the cell whose intersection is column E with row 12.
Cell E12
7. How many columns and rows make up an Excel 2010 spreadsheet?
Rows 1048576 Columns XFD
8. Define the term Active Cell
Cell that is selected
9. Escribe los nombres de las principales Cintas de Opciones de Excel 2010
File, Home, Insert, Page Layout, Formulas, Data, Review, and View.
10. Write the default row height and column width in a spreadsheet
Ancho 10.71 y Alto 15 pts
11. What are the columns with a width value of 0 called?
Hidden Columns
12. What are the rows with a value of high=0 called?
Hidden Rows
13. Mention two ways to modify the width of Excel columns
1 Give Auto Adjust
2 Write the values manually
14. What is the default extension of an Excel 2010 workbook?
.xlsx
15. Mention at least 4 types of data that can be entered in a cell
Number
Currency
Fraction
Text
16. Identify the type of data it is:
123987: Numeric
345765x: Text
Ventas Mensuales: Textos Mensuales
=SUM(A1:A5): Formula
=5+3-4: Formula
A347.586:Text
Total: Texto
457,983465: Number
NUMBER 34657: Text
=5+345-SUM(A5:A8)*8: Formula
What symbol is used to introduce a formula in Excel?
Equal (=)
18. Explain the precedence of operators in Excel
1 Lo que esta entre parentesis () 2. Divisiones, Multiplicaciones y Potencias 3. Sumas y restas
from left to right
19. How many predefined functions does Microsoft Excel 2010 offer?
400 functions
20. What are the Excel Edit commands used for?
Para editar, modificar y cambiar mediante doble click o F2
21. What command allows you to navigate in the spreadsheet to specific cells or locations?
The Arrows or I position myself in the name box and write the cell where I want to position myself.
22. What key should be held down to select a range of non-contiguous cells?
I press Ctrl and click on the cells I want to select.
23. How many items does the Clipboard store and keep available to be pasted?
Stores up to 24 items
24. In which Options Ribbons can you find the commands that allow you to insert text or images?
In Insert
25. What is the fastest way to fill sequential data, whether numeric or dates, in cells?
With the black cross that allows you to create series.
26. Mention the 4 options included in the Delete command of the Modify group on the Home tab.
["Delete everything","Delete contents","Delete comments","Delete hyperlinks"]
27. What command is used to delete an entire Spreadsheet?
In the home tab, select the Delete option that allows you to delete rows, columns, or the entire sheet.
28. Which icon in the Home Ribbon is used to copy the format from one cell to another?
Copy Format (brush in clipboard)
29. Define los términos Referencia Absoluta y Referencia relativa, da ejemplos
Absolute Reference: One that remains constant is denoted with a dollar sign ($)
Relative Reference: One that can change based on the cell or value.
30. The Protect Sheet command allows you to activate the protection of all cells in a particular sheet.
protection of some cells where data should be entered?
In the home tab, select the Format option, then select the protect sheet option or
Desire, and it will ask you for a password which you must enter to allow you to access and make changes.
31. In which Ribbon of Options can the Spelling command be found?
Review
32. Mention two ways to align the content of a cell and say what the main types of alignment are.
Centered, left-aligned, right-aligned.
33. Describe how to rotate the titles to be read vertically instead of horizontally.
at the beginning, text orientation is provided, and the desired orientation is given
34. Mention 4 categories of number formats that can be assigned to the values of a cell
Accounting
Fractions
Percentages
Scientific Notation
35. What is the default format of Excel cells?
General
36. Mention two tools that facilitate the creation of drawings and diagrams in Excel.
Through predefined forms
The diagrams are inserted in Smart Art either as a pyramid, image matrix, etc.
37. What command can be used to insert titles with special formats and designs into a sheet?
Word Art
38. Which Excel function would you use to sum the values in the range of cells A5:A40?
AutoSum
39. Help on this function of the Insert Function dialog box via the hyperlink
Reference; copy them and paste them
Search
Search H
Search V
Match
Column
Rows
Hyperlink
40. Menciona y describe tres funciones predefinidas de Excel del grupoMatemáticas y Trigonométr
Breast
Cosine
Tangent
Cosecant
Cotangent
Logarithm
41. What function allows several cells to be merged into one?
Merge and center
42. Describe in your own words a Graph
It is used to represent data and information visually.
43. Mention at least three of the most representative graphs in Excel.
Columns, Linear, circular
44. What are pie charts normally used for?
For surveys
45. Briefly describe the steps to insert a bar chart in a spreadsheet.
Tabulate the data, select them, and insert a chart choosing whether we want it to be bar or pie.
46. In a calculus book, on Sheet1 enter the values of circle radii from 1 to 25.
Graph the values by inserting a Clustered Column chart. Place the titles Radio in A1 and Ár.