Preguntas tipo test excel que nos pasó el rpofesor de teoria y conocimientos populares PDF

Preview

Summary

Preguntas tipo test excel que nos pasó el rpofesor de teoria y conocimientos populares...

Description

Agustín Capilla Office 4.0.F07 [email protected]

Next May 17th

Final Exam - Instructions

2

3

4

https://aulavirtual.uc3m.es/

5

You build the agenda for May 10th ● Exercises ● Explanations ● Etc Or another Dry Run Drop me an email and I will compile and prepare all the information. 6

Team Test All questions are part of the slide decks I have posted for you. Some of the questions we didn’t cover during the lectures, due to the simplicity of the content, it is your responsibility to review the decks and practice. This test will help you to review most topics and content. If any part you need to consult, please review the decks in AG. If you need extra help, please drop me an email. Good Luck and test yourself. All answers are at the end.

7

8

9

10

11

12

13

14

15

16

17

18

19

13 - I will NOT use a spreadsheet application to a) To sort and manage information. b) To perform complex operations. c) To create presentations. d) To make a better use of data through meaningful visualizations.

20

14.- I will NOT use a spreadsheet application to a) To sort and manage information. b) To perform complex operations. c) To create presentations. d) To make a better use of data through meaningful visualizations.

21

15 - How can I create a spreadsheet on the cloud? a) All the options are correct. b) Via Google Drive (directly). c) Via uploading an existing file created with a Spreadsheet desktop application. d) With MS Excel 365

22

16.- What is a sheet? a. A set of data organized in cells (rows and columns). b. A set of workbooks. c. A selection of cells. d. The intersection between a row and a column.

23

17.- What is a range? a. A set of workbooks. b. A set of sheets. c. A set of cells selected following some rules. d. a) and b) are correct.

24

18.- What kind of information a cell can store? a.Text b.Formula c.Numbers d.All answers are correct.

25

19.- When creating an Excel formula, what does the cell reference with dollar sign like $C$1 do? a. b. c. d.

Changes the cell format to currency with a dollar sign as the default Allows only number to be input into the cell Generates an error Creates an absolute reference

26

20.- What is a CSV file? A. A CSV is a comma separated values file, which may be use comma or other separator such as semicolon, that allows data to be saved in a table structured format B. C. D.

A specific character in Excel that automatically concatenates cells A function that allows us to create absolute, relative and mixed references A file that we use to build ranges in Excel

27

21.- The Conditional Formatting function in Excel allows you to: A.

Automatically apply formatting based on specific rules or conditions being met B. Automatically apply highlighting selected cell ranges based on specific rules or conditions being met C. Automatically change the Font of selected cell ranges based on specific rules or conditions being met D. All the options listed above are correct

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

Correct answers to test:

C

50...