Quiz
Sem título
Este quiz tem tempo limite, por isso abre no player de sempre.
Perguntas do quiz (12)
1To let Excel know that you want to enter a formula, what is the symbol to type?
- AEquals
- B=
2What is the function or formula to type to calculate the sum of the range A1 to A2?
- A=A1+A2
- B=SUM(A1:A2)
- C=SUM(A1+A2)
3In the formula =A1*(A2+A3) where the value of cell A1 is 2, A2 is 3, and A3 is 1, what is the result?
- A8
- BEight
4To give a result of 11, where the value of cell A1 is 3, A2 is 4, and A3 is 2; give the right formula.
- A=A1+A2*A3
- B=A1+(A2*A3)
5To add the values in cells B2, B5, & B7, what is the function or formula to type?
- A=SUM(B2,B5,B7)
- B=B2+B5+B7
- C=SUM(B2+B5+B7)
6To add the values in cells B2 to B4, & the value in cell B6, what is the function or formula to type?
- A=SUM(B2:B4,B6)
- B=B2+B3+B4+B6
- C=SUM(B2+B3+B4+B6)
7What is the symbol used to identify a range of cells?
- ACOLON
- B:
8What should be done to correct an error showing these #####?
- AIncrease column width
- BShrink contents to fit the column
9What is the function or formula to type, to make the computer automatically enter in the current or today's date?
- A=TODAY()
- B=ctrl+;
- C=ctrl;
10What is the syntax for the ROUND Function?
- A=ROUND(Number,Num_digits)
- Bhhh
11 What is the function to type to add the current time and date to a spreadsheet? Give the syntax.
- A=NOW()
- B=CTRL+SHIFT: space CTRL+;
12What is the symbol used to connect two strings of text?
- A&
- Bampersand
Informações
- Descrição
- Quiz sobre Sem título, criado por Lorica Tanoc em 31-07-2015.
- Autor
- Lorica Tanoc
- Idioma
- English
- Visualizações
- 1
- Avaliação
- Ainda sem avaliações Avalie este quiz