Quiz
Untitled
This quiz has a time limit, so it opens in the usual player.
Questions in this 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
Information
- Description
- Quiz on Untitled, created by Lorica Tanoc on 31/07/2015.
- Author
- Lorica Tanoc
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz